Manage account sale calculations

Article • 7/3/2024 • 3 min read

The account sale accounting method involves a settlement process with self-billing. In contrast to the Grade Out and Pack Out methods, the purchase price is dynamically determined per purchase transaction. It is calculated based on the revenue received and the costs paid by the trading company when selling the acquired lot number. Unlike Grade Out and Pack Out, where the price is predetermined by the vendor and trading company, the account sale method allows for dynamic pricing.

Initiate account sale calculation from the settlement page

  1. Select the Search icon , enter Settlements and then choose the related link.
    The Settlements list page opens.

  2. Select the required record.
    The Settlement page opens.

  3. On the action bar, select Calculate.

  4. On the Calculate Settlement page, in the Accounting Method field, select Account Sale. This method will act as a filter when retrieving the purchase line.

  5. On the Account Sale FastTab, in the Document No. field, select the document number to create a settlement.

  6. In the Cost Template Code field, select the cost template code for the settlement. To create a Cost Calculation Template, see, Set up cost calculation templates.

    Document No., and Cost Template Code fields must be specified for generating settlement Lines and line Traces.

  7. Click OK.

  8. On the Settlement page, click Account Sale action.

The Sales, Commission, and Costs categories provide information information per purchase line shown as columns. You can access the Account Sale page from the action bar of this page. The Account Sale page provides insights into how the system proposes settling with the vendor based on all revenue and costs, including commission, traced for the specific purchase line. The Purchase Invoice Amount is calculated based on the Sales, Commission, and Costs. The following sections explain how these will be filled in when calculating the settlement for a purchase order with the Accounting Method set as Account Sale.

Account Sale line

The Account Sale accounting method allows you to register prepayment invoices explicitly for purchase orders. The details of the advance payments made either seasonally or per purchase order are provided on the Advance Payment Allocations page. To view this page, click the value, e.g., “2000”, displayed in the Outstanding Advance Payments field in the line level of the Account Sale page.

Overview of Advance Payment Allocations

The Advance Payment Allocations page provides insights into existing advance payments for this vendor, detailing the remaining amounts in both the local and vendor currencies. The following fields are available on the page.

FieldDescription
Advance Payment TypeThis indicates whether the advance payment type is seasonal or per purchase order.
DescriptionThis indicates the description inherited from the posted purchase invoice that is used to register the advance payment.
Description 2This indicated the additional description that was inherited from the posted purchase invoice used to register the advance payment.
Remaining BalanceThis indicates the amount that is outstanding or not yet allocated from the advance payment. By clicking the value in this field, you can access the Advance Payment Allocation Details page. It gives an overview of the document lines related to the prepayments, including the initial payment and any allocations or corrections through credit memos, with specific dates and amounts leading up to this total.
Note that the amount shown in this field is in the currency of the current account sale.
Amount to ApplyThis indicates the amount that should be allocated as advance payment to this specific account sale. Note that for the Per Purchase Order type, the value in this field is automatically applied and cannot be modified. The amount registered/shown in this field is in the currency of the current account sale.