Manage account sale sales
When a purchase (or production) lot is sold, sales revenue is generated, which is used for settlement calculations in the account sale accounting method. For more information, see Understand sales revenue calculation.
The account sale calculation provides a proposal for the account sale. However, you can modify the proposed account sale by making changes. On the Account Sale page, the Sales headline, highlighted in green, represents the overall total net revenue derived from the underlying sales sections. To obtain detailed information on how the system calculated the total gross or net revenue displayed on the Account Sale page, select the values within the sales headline.
-
The following fields are available on the Account Sale Revenue list page:
Field Description Quantity Specifies the originally ordered quantity when creating the source document from which this account sale revenue line originates. Quantity Received Specifies the number of units of the item received on the line, as defined in the purchase unit of measure. Proposed Quantity (Base) Specifies the proposed quantity, in the base unit of measure, to be included in the account sale based on all linked sales transactions for this settlement line. Proposed Quantity (SQU) Specifies the quantity that the settlement calculation proposes to allocate to the account sale, expressed in the settlement quantity unit of measure, based on all sales transactions linked to this settlement line. Account Sale Quantity (Base) Specifies the value, which is calculated and displayed in the base unit of measure. Account Sale Quantity (SQU) Specifies the quantity to be reported back to the vendor, expressed in the settlement quantity unit of measure. Initially, this value is the same as the Proposed Quantity (SQU) field, but you can manually change it.
This value impacts calculated commission values for commissions with the Commission Type field set to Amount per Purchase Unit. This value determines the Purchase Cost per Unit field value on the Account Sale page.Proposed Quantity (PU) Specifies the quantity that the settlement calculation proposes to allocate to the account sale, expressed in the purchase unit of measure, based on all sales transactions linked to this settlement line. Account Sale Quantity (PU) Specifies the quantity to be reported back to the vendor as sold, expressed in the purchase unit of measure. Initially, this value is the same as the Proposed Quantity (PU) field value, but you can manually change it.
This value determines the Purchase Cost per Unit field value on the Account Sale page.Unit of Measure Code Specifies the unit of measure that is defined on the settlement line. Proposed Gross Revenue Specifies the total gross revenue calculated by the settlement calculation for all transactions linked to this settlement line. The Proposed Gross revenue is the sum of all Account Sale detail lines of type “Revenue” in the Gross Revenue (indirect) field. Proposed Sales Discount Value Specifies the total discount granted in sales, calculated by the settlement calculation for all sales transactions linked to this settlement line.
This value is calculated as the sum of all the Discount Value (Indirect) field values of account sale detail lines with the Type field set to Revenue.Proposed Net Revenue Specifies the total net revenue calculated by the settlement calculation for all transactions linked to this settlement line. The Proposed Net Revenue is the sum of all Account Sale detail lines of type “Revenue” in the Net Revenue (indirect) field. Account Sale Gross Revenue Specifies the gross revenue that is to be reported back to the vendor. Initially, this value is the same as the Proposed Gross Revenue field value, but you can manually change it.
This value impacts the Account Sale Net Revenue field value and the calculated commission for commissions with the Commission Type field set to Percentage. This value determines the Purchase Invoice Amount (LCY) field value on the Account Sale page.Account Sale Discount Value Specifies the sales discount value that is to be reported back to the vendor. Initially, this value is the same as the Proposed Sales Discount Value field value, but you can manually change it.
This value impacts the Account Sale Net Revenue field value and the calculated commission values for commissions with the Commission Type field set to Percentage. This value determines the Purchase Invoice Amount (LCY) field on the Account Sale page.Account Sale Net Revenue Specifies the net revenue that is to be reported back to the vendor. Initially, this
value is the same as the Proposed Net Revenue field value, but you can manually change it directly or by changing the values in the Account Sale Gross Revenue and/or Account Sale Discount Value fields.
This value impacts the calculated commission values for commissions with the Commission Type field set to Percentage. This value determines the Purchase Invoice Amount (LCY) on the Account Sale page.Modified Specifies whether there have been any changes to the initially proposed Account Sale Commission Value percentage or the Account Sale Commission Value Per. Settlement Quantity Unit of Measure Code Specifies the settlement quantity unit of measure that is used for this item. The value originates from the settlement unit of measure template used in this settlement. If no unit of measure is found there, the settlement unit of measure is used. Qty. per Settlement Quantity Unit of Measure Specifies how many base unit of measure quantities are contained in one settlement quantity unit of the item. To understand how discounts are calculated, see Understand discounts calculation.
-
On the Account Sale page, you can select the values in the Not Shipped/Shipped sub-header lines to view the Account Sale Detail Lines. For more information, see View account sale details.
-
The account sale page shows the total of all Account Sale detail lines grouped under “Group Revenue.” For instance, the subsection “Not Shipped” on the Account Sale page displays the sum of Account Sale revenue detail lines with a subtype of “Expected” and a source of “Sales Order.” Similarly, the subsections “Shipped” and “Invoiced” show their respective sums of Account Sale revenue detail lines. The Net revenue is visible for each subsection as well as a grand total, indicated by the green-highlighted Sales line.