Manage pooling commissions

Article07/05/20246 min read

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:

    Note

    On the action bar, select Edit List to edit the commission details on the pooling commission lines.

    FieldDescription
    QuantitySpecifies the number of units of the item ordered in the settlement lines associated with this pooling commission line.
    Quantity ReceivedSpecifies the number of units of the item that have been posted as received in the settlement lines associated with this pooling commission line.
    Proposed QuantitySpecifies 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 QuantitySpecifies the quantity that will be reported to the grower(s) within this settlement
    Pooling Gross RevenueSpecifies 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 ValueSpecifies 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 RevenueSpecifies 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 RevenueSpecifies 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 TypeSpecifies 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 BaseSpecifies 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 ValueSpecifies 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 perSpecifies 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 perSpecifies 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 ValueSpecifies 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.
    ModifiedSpecifies whether manual changes have been made to the pooling commission line.
    Commission GroupSpecifies the commission group associated with the commission setup line.
    Pay-toSpecifies 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 MeasureSpecifies 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.

    FieldDescription
    Actual QuantitySpecifies the total pooling quantity of the pooling line associated with this commission detail line.
    Gross RevenueSpecifies the gross revenue of the pooling line associated with this commission detail line.
    Discount ValueSpecifies the discount of the pooling line associated with this commission detail line.
    Net RevenueSpecifies the net revenue of the pooling line associated with this commission detail line.
    Net Net RevenueSpecifies the net net revenue of the pooling line associated with this commission detail line.
    Settlement Line Quantity to SettleSpecifies the quantity of the settlement line associated with this commission detail line.
    Settlement Line Quantity FactorSpecifies 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 TypeSpecifies the commission type associated with the commission detail line and originates from the setup on the Commissions page.
    Commission Calculation BaseSpecifies the commission calculation associated with the commission detail line and originates from the setup on the Commissions page.
    Proposed Commission ValueSpecifies 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 perSpecifies 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 perSpecifies 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 ValueSpecifies 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 GroupSpecifies the commission group as set up on the Commissions page.
    Pay-toSpecifies 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 MeasureSpecifies 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.