Maintain settlements

You can calculate the price you must pay a vendor based on the criteria you define, such as grade-out quantities, pack-out quantities, revenues, margin splits, etc.

Prerequisites

The following are the prerequisites for the settlement calculation.

• Purchase order lines with appropriate accounting methods.
• Production orders with the appropriate production order type.

Create and run a settlement

The following procedure outlines how to create a new settlement, run the settlement, and generate settlement lines.

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

2. On the action bar, select New.
   The Settlement card page opens.

3. On the General FastTab, enter the required information in the following fields:

   Field	Description
   Document Date	Select or enter the date when the related document was created. By default, the work date is set as the document date.
   Posting Date	Select or enter the date when the related document was posted. By default, the work date is set as the posting date.
   Last Calculated Date	Specifies the date on which this settlement was recently calculated.
   Accounting Method	Specifies the accounting method applied when this settlement was recently calculated.
   Responsible Person Code	Select a user who is responsible for this settlement.
   Responsible Person Name	Specifies the name of the user responsible for this settlement.
   Status	Specifies the status of this settlement record. The available options are New, Open, Calculated, Released, To Invoice, and Invoiced.

   Note

   The system assigns the settlement number based on the number series setup. For more information, see Set up grower returns.

4. On the action bar, select Calculate to define the filters and calculate the settlement.
   The Calculate Settlement page opens.

5. In the Accounting Method field, select any of the following options and perform the corresponding actions. For more information, see Understand accounting methods.

   • Grade Out: On the Attributes and Filter: Purchase Line FastTab, select the filters you want to apply to the calculation.

   • Pack Out: On the Attributes and Filter: Purchase Line FastTab, select the filters you want to apply to the calculation.

   • Account Sale:

     Field	Description
     Account Sale FastTab
     Document No.	Select a relevant document number.
     Cost Template FastTab
     Cost Template Code	Specifies the Cost Template Code field value associated with the related vendor, or if the Invoice Grouping Type field value is set as Per Pay-to-Vendor, the system inherits the appropriate cost template from the respective Vendor Card page. Otherwise, the system inherits the cost template code set up in the Grower Return Setup page. Additionally, you can select a cost template code manually.
     Filter: Purchase Line FastTab	Select the filters you want to apply to the calculation.

   • Pooling:

     Field	Description
     Pooling FastTab
     Pooling Template Code	Select a pooling template code. For more information, see Set up pooling templates.
     Proposed Pool Quantity Source	Specifies whether the pooling quantity is based on the sales or received quantity. This value is derived from the pooling lot aggregation template, or the default value defined on the Grower Return Setup page. You can select or change this value manually if required.
     Pool by	Specifies the grouping method to group the pooling lines accordingly. This value is derived from the Pool by field value associated with the pooling template or the default value defined on the Grower Return Setup page. You can select or change this value manually if required.
     Lot Aggregation Template Code	Specifies the lot aggregation template code. This field is editable if you have set the Pool by field as Lot Attributes. This value is derived from the pooling template or the default value defined on the Grower Return Setup page. You can select or change this value manually if required.
     Cost Template FastTab
     Cost Template Code	Specifies the Cost Template Code field value associated with the selected pooling template or the default value defined on the Grower Return Setup page. You can select or change this value manually if required.
     Attributes and Filter: Purchase Line FastTab	Select the filters you want to apply to the calculation.

   Note

   • The filters defined on the selected pooling template are applied to the calculation by default.
   • The filters set on the Calculate Settlement page are applied to the calculation in addition to the filters defined on the Pooling Template page. This can result in unexpected outcomes. Hence, we recommend defining the filters in the pooling template instead of applying them manually on the Calculate Settlement page.

6. Select OK.
   The system calculates the settlement, updates the Status field value to Calculated, and generates settlement lines on the Lines FastTab.

7. You can view details of the settlement lines in the following fields:

   Field	Description
   Buy-from Vendor No.	Specifies the vendor who supplied the item for which you must settle the payment.
   Buy-from Vendor Name	Specifies the vendor’s name who supplied the item for which you must settle the payment.
   Pay-to Vendor No.	Specifies the vendor with whom you need to settle a payment.
   Pay-to Vendor Name	Specifies the name of the vendor with whom you need to settle a payment.
   Source Document Type	Specifies from which source document type the settlement line originates.
   Source Document No.	Specifies from which source document number the settlement line originates.
   Source Line No.	Specifies from which source document line number this settlement line originates.
   Item No.	Specifies for which purchased item you are creating a settlement quantity with direct unit cost.
   Item Category Code	Specifies the item category of the item on this settlement line.
   Description	Describes why you are creating a settlement. In most cases, it describes the item procured.
   Global Lot Attributes	Specifies the global lot attributes (one to eight) with their corresponding values.
   Quantity	Specifies the quantity originally ordered when creating the source document line from which this settlement line originates.
   Unit of Measure Code	Specifies how each item is measured, such as in pieces, kilograms, or tons.
   Quantity Received	Specifies how many units of the item on the line have been posted as received.
   Quantity Invoiced	Specifies how many units of the item on the line have been invoiced.
   Quantity to Settle	Specifies the quantity to settle, expressed in the Unit of Measure (UOM) of the source document from which this settlement line originates. This quantity is calculated based on the sum of the Quantity to Settle field for all settlement lines linked to this settlement line.
   Amount to Settle	Specifies the amount to be settled with the vendor. It is calculated based on the sum of the Amount to Settle field for all settlement lines linked to this settlement line.
   Amount to Settle (LCY)	Specifies the value of the Amount to Settle field calculated to local currency based on the exchange rate applicable on the posting date of the settlement.
   Direct Unit Cost per Quantity Received	Specifies the direct unit cost to settle expressed in the UOM of the source document from which this settlement line originates. It is calculated by the settlement line’s Amount to Settle field value divided by the Quantity Received field value of the settlement line.
   Currency Code	Specifies the currency code of the purchase line from which the settlement line originates.
   Quantity	Specifies the quantity originally ordered when creating the source document line from which this settlement line originates.
   Grower Return Grouping No.	Specifies the grouping number assigned to this settlement line based on the Settlement Grouping Type field value of the vendor. Settlement lines with identical grower return grouping numbers are typically reported within the same grower return document.
   Invoice Grouping No.	Specifies the grouping number assigned to this settlement line, based on the Invoice Grouping Type field value of the vendor. Settlement lines with identical invoice grouping numbers will be added to the same purchase invoice when posting the settlement.
   Posted Invoice No.	Specifies the posted purchase invoice number to which the settlement line was added.

Settlement page actions

The following actions are available on the Settlement page.