Manage account sale commissions

Article • 10/30/2024 • 5 min read

Commission can be defined as the reward an agent or trading company earns when handling and selling a product on behalf of a vendor. In most cases, the commission is calculated as a percentage based on the revenue generated when the products are sold to customers. For more information, see Understand commissions calculation.

The Account sale page gives insights into which commission is applicable to this specific purchase order and for which values. For more information, see Commission and commission groups setup. The green highlighted Commission section displays the total commission value for the specific purchase line. Expanding this section lets you access details of the total commission value into different commission groups. The system checks per existing commission group; if a commission setup line exists for the specific combination of vendor, item, or global lot attributes. If no matching record is found, the system will then select a commission line defined for All vendors, if available. Each commission group can have a maximum of one selected commission line in the account sale commission lines.

When opening the Account Sale Commission page, the following fields available:

FieldDescription
QuantitySpecifies the quantity from the settlement line, which should be based on the original purchase order quantity.
Quantity ReceivedSpecifies the number of units of the item received on the line, as defined in the purchase unit of measure.
Proposed QuantitySpecifies how many units of the item on the line are suggested to be put on the account sale, defined in the settlement quantity unit of measure. The proposed quantity is calculated based on all sales transactions linked to lot number(s) received under this settlement line or production output from which lot number(s) received under this settlement line were used as consumption.
Account Sale QuantitySpecifies how many units of the item on the line are registered on the account sale, expressed in the settlement quantity unit of measure.
Account Sale Gross RevenueSpecifies the gross revenue to be reported back to the vendor. This amount is calculated by subtracting Account sales claim value gross from the account sale claim line and Account sales gross revenue from the account sales revenue line for the specified settlement line.
Account Sale Discount ValueSpecifies the granted sales discount that is to be reported back to the vendor. This amount is calculated by subtracting Account sale discount value from the account sale revenue line and Account sale claim discount value from the account sale claim line for the specified settlement line.
Account Sale Net RevenueSpecifies the amount of net revenue to be reported back to the vendor. This amount is calculated by subtracting Account sale Net revenue value from the account sale revenue line and Account sale claim discount value from the account sale claim value net for the specified settlement line.
Account Sale Net Net RevenueSpecifies the net net revenue to be reported back to the vendor. This amount is derived by subtracting the sum of account sale costs set to the deduction method ‘Net revenue’ from the account sale net revenue.
Commission TypeSpecifies the type of commission. The available options are:
  • Percentage: The proposed commission value in an account sale is calculated as a percentage over either the Account Sale Gross Revenue, Account Sale Net Revenue, or Account Sale Net Net Revenue field values.
  • Amount per Purchase Unit: The proposed commission value in an account sale is calculated by multiplying the Account Sale Quantity field value with the Proposed Commission Value per field value.
Commission Calculation BaseSpecifies the basis (gross, net, or net net revenue) for calculating the proposed commission value when the commission type is set to Percentage.
Proposed Commission %Specifies the commission percentage that was retrieved from the commission setup table for the combination of vendor, item, and commission group for the settlement line of this account sale commission line. This field value is visible only when the Commission Type field is set to Percentage.
Proposed Commission ValueSpecifies the commission value per purchase unit that was retrieved from the commission setup table for the combination of vendor, item, and commission group for the settlement line of this account sale commission line.
This field value is visible only when the Commission Type field is set to Amount per Purchase Unit.
Proposed Commission Value PerSpecifies the commission value calculated by applying the proposed commission percentage to gross, net, or net revenue. This value is only filled when the Commission Type is set to Percentage.
Account Sale Commission Value %Specifies the percentage of commission to be reported back to the vendor. Initially, this value is the same as the Proposed Commission % field value, but you can manually change it.
After modification, the Account Sale Commission Value field value is recalculated, and the Modified checkbox is selected.
Account Sale Commission Value perSpecifies the commission value per purchase unit to be reported back to the vendor. Initially, this value is the same as the Proposed Commission Value per field value, but you can manually change it.
After modification, the Account Sale Commission Value field value is recalculated, and the Modified checkbox is selected.
Account Sale Commission ValueSpecifies the total commission value (regardless of commission type) to be reported back to the vendor. This value can be changed by changing the Account Sale Commission Value % or Account Sale Commission Value per field values.
ModifiedSpecifies whether there have been any changes to the initially proposed Account Sale Commission Value percentage or the Account Sale Commission Value Per.
Commission GroupSpecifies the value of the commission group type.
Pay-ToSpecifies whether the commission value on this account sale commission line is intended to be paid to a third-party vendor after the account sale is finalized.