Manage document costs

Grower Return  •  Article  •  8/27/2025  • 

For settlements with the Accounting Method field value set to Account Sale or Pooling, the system automatically calculates document costs based on the cost template setup. For more information, see Set up document calculations for cost template lines.

To view and edit the document costs from the Settlement page, follow these steps:

  1. Select any of the following field values:

    • Document Costs
    • Document Costs (LCY)
    • Proposed Document Costs
    • Proposed Document Costs (LY)

    The system opens the Document Costs page and displays information about the document costs applied to each settlement line in the following fields:

    FieldDescription
    Trade Plan CodeSpecifies the code of the trade plan associated with the settlement line.
    Trade Plan DescriptionSpecifies the description of the trade plan associated with the settlement line.
    Item Charge No.Specifies the item charge number associated with the settlement line or the document cost line.
    Item Charge DescriptionSpecifies the description of the item charge associated with the settlement line or the document cost line.
    You can select this field value to view details of the item charge on the Item Charges page.
    Deduction MethodSpecifies the deduction method associated with the cost template setup.
    Cost Application MethodSpecifies the cost application method associated with the cost template setup.
    Cost Amount (Expected)Specifies the expected cost amount associated with the settlement line.
    You can select this field value to view the Pooling Details or Accounting Sales Details page, based on the accounting method of the settlement.
    Cost Amount (Actual)Specifies the actual cost amount calculated associated with the settlement line.
    You can select this field value and view the Pooling Details page or Accounting Sales Details page, based on the accounting method of the settlement.
    Cost Amount (Proposed)Specifies the proposed cost amount calculated based on the cost template setup. For more information, see Understand document cost calculation.

  2. In the Cost Amount (Document) field, you can manually enter a document cost amount if required.

    The system selects the Modified checkbox to indicate that the document cost has been updated.

  3. On the action bar, select Cost Details to view the Pooling Details page. For more information, see View pooling details.

Understand document cost calculation

To populate the Cost Amount (Proposed) field value on the Document Costs page, the system applies the most specific line on the Cost Template Line Document Calculations page based on the following hierarchy:

  1. The Assign-to Type field value is set to Vendor, the Product Type field value is set to Item, and the global lot attributes (1 to 8) field values match.
  2. The Assign-to Type field value is set to Vendor and the Product Type field value is set to Item.
  3. The Assign-to Type field value is set to Vendor and the Product Type field value is set to All Items.
  4. The Assign-to Type field value is set to All Vendors and the Product Type field value is set to All Items.

After identifying the cost template document calculation line to apply, the system calculates the document cost based on the Calculation Type field value on the Cost Template Line Document Calculations page as follows:

  • Percentage: The system applies the value entered in the Calculation Value field as a percentage of the Amount to Settle field value on the Settlement page.
  • Amount per Purchase Unit: The system applies the value entered in the Calculation Value field as a product of the amount and the Qty. to Settle field value on the Settlement page.