Manage pooling commissions
Commissions are the rewards an agent or trading company earns when handling and selling a product on behalf of a group of vendors. It is usually calculated as a percentage based on the revenue generated when the products are sold to customers. For more information, see Understand commissions calculation.
The system checks per existing commission group to see if a commission setup line exists for the specific combination of item, item category, vendor, or global lot attributes. If no matching record is found, the system selects a commission line defined for all vendors.
On the Pooling Commissions page, you can view the pooling commission line with the following fields:
NoteOn the action bar, select Edit List to edit the commission details on the pooling commission lines.
Field Description Quantity Specifies the number of units of the item ordered in the settlement lines associated with this pooling commission line. Quantity Received Specifies the number of units of the item that have been posted as received in the settlement lines associated with this pooling commission line. Proposed Quantity Specifies how many units of the item on the line are suggested to be put on the pooling, defined in the settlement UOM. This value is calculated based on all sales transactions linked to the lot number(s) received and all production output used as consumption. Pooling Quantity Specifies the quantity that will be reported to the grower(s) within this settlement Pooling Gross Revenue Specifies the amount of gross revenue that is to be reported to the vendor(s). This value is derived from the pooling revenue line. Pooling Discount Value Specifies the granted sales discount that is to be reported to the vendor(s) based on all sales transactions in the settlement lines for this pooling line. Pooling Net Revenue Specifies the amount of net revenue to be reported to the vendor(s) based on all sales transactions in the settlement lines for this pooling line. This value is derived from the pooling revenue line. Pooling Net Net Revenue Specifies the amount of net net revenue to be reported to the vendor(s). The amount is the pooling net revenue subtracted from the sum of pooling costs with the Deduction Method set as Net Revenue. Commission Type Specifies the commission type associated with the commission setup line. The value can be either of the following: - Percentage: The Proposed Commission Value field is calculated as a percentage of either Pooling Gross Revenue, Pooling Net Revenue, or Pooling Net Net Revenue field value.
- Amount per Purchase Unit: The Proposed Commission Value field is calculated by multiplying the Pooling Quantity field value with the Proposed Commission Value per field value.
Commission Calculation Base Specifies over which value (Pooling Gross Revenue, Pooling Net Revenue, or Pooling Net Net Revenue) the Proposed Commission Value is calculated with, when the Commission type field is set to Percentage. Proposed Commission % Specifies the commission percentage that was retrieved from the Commissions page. The value is only inclusive of commissions with the Commission type field set to Percentage. Proposed Commission Value Specifies the commission value calculated by applying the Proposed Commission % to either Pooling Gross Revenue, Pooling Net Revenue, or Pooling Net Net Revenue.
The value is only inclusive of commissions with the the Commission type field set to Percentage.Proposed Commission Value per Specifies the commission value per purchase unit set up on the Commissions page for the combination of vendor(s), item, and commission group for the settlement line of this pooling commission line. The value is only inclusive of commissions with the commission type set to Amount per Purchase Unit. Pooling Commission Value % Specifies the percentage of commission to be reported to the vendor(s). This field value inherits the Proposed Commission % field value initially, you can edit this value as required. After modification, the pooling commission value is recalculated, and the Modified checkbox is selected. Pooling Commission Value per Specifies the commission value per purchase unit to be reported to the vendor(s). This field value inherits the Proposed Commission Value per field value initially, you can edit this value as required. Pooling Commission Value Specifies the total commission value (regardless of the commission type) to be reported to the vendor(s). This value can be changed only by changing the Pooling Commission Value % or the Pooling Commission Value per field. Modified Specifies whether manual changes have been made to the pooling commission line. Commission Group Specifies the commission group associated with the commission setup line. Pay-to Specifies if the commission value on this pooling commission line is to be paid out to a third-party vendor after finalizing the pooling.
The purchase invoices generated upon posting the settlement are grouped together based on the pay-to vendor. This helps to minimize the number of purchase invoices and related documents created for third-party agents.Unit of Measure Specifies the UOM applied to the pooling line. On the action bar, select Commission Details to open the Commission Detail Lines page and understand how the summarized commission information on the selected pooling commission line was calculated.
You can view the following fields on the Commission Detail Lines page.Field Description Actual Quantity Specifies the total pooling quantity of the pooling line associated with this commission detail line. Gross Revenue Specifies the gross revenue of the pooling line associated with this commission detail line. Discount Value Specifies the discount of the pooling line associated with this commission detail line. Net Revenue Specifies the net revenue of the pooling line associated with this commission detail line. Net Net Revenue Specifies the net net revenue of the pooling line associated with this commission detail line. Settlement Line Quantity to Settle Specifies the quantity of the settlement line associated with this commission detail line. Settlement Line Quantity Factor Specifies the relational factor between the settlement line quantity to settle this commission detail line and the same field on other commission detail lines linked to the same pooling line, expressed in a value between zero and one. Commission Type Specifies the commission type associated with the commission detail line and originates from the setup on the Commissions page. Commission Calculation Base Specifies the commission calculation associated with the commission detail line and originates from the setup on the Commissions page. Proposed Commission Value Specifies the proposed commission value calculated per commission detail line. Proposed Commission % Specifies the commission value percentage as set up on the Commissions page. This value is only inclusive of commissions of the Type field value set to Percentage. Proposed Commission Value per Specifies the commission value per purchase unit set up on the Commissions page. This value is only inclusive of commissions with the Type set to Amount per Purchase Unit. Commission Value % Specifies the commission value % as set up on the Commissions page. This value is only inclusive of commissions with the Type* field value set to Percentage. Commission Value per Specifies the commission value per purchase unit set up on the Commissions page. This value is inclusive of commissions with the Type* field value set to Amount per Purchase Unit. Commission Value Specifies the commission value calculated for this commission detail line. This value is used to calculate the Proposed Commission Value field on the Pooling Commission page. Commission Group Specifies the commission group as set up on the Commissions page. Pay-to Specifies if the commission value on this pooling commission line is to be paid out to a third-party vendor after finalizing the pooling. Unit of Measure Specifies the UOM code applied to the pooling line. This value is derived from the settlement unit of measure defined on the Grower Return Setup page.