Manage pooling calculations
You can view the summary of the settlement lines using the pooling accounting method. For more information, see Understand accounting methods. Additionally, you can view and edit the revenue, claims, commissions, and cost details calculated for the pooling lines.
The following procedure outlines how to view the pooling lines.
-
Calculate a settlement with the pooling accounting method. For more information, see Create and run a settlement.
-
On the action bar, select Pooling.
The Pooling page opens. -
You can view the details of the pooling lines in the following fields.
- The fields visible on the Pooling page depend on the selection made in the Pool by field on the Calculate Settlement page. Additionally, the fields visible depend on the type of view you have selected. On the action bar, you can select Simple View or Advanced View to display fewer or more fields, respectively.
- You can also select Settings > Personalize to add fields as required.
- You can expand the pooling line to view the details of the related purchase order and sales documents and the revenue information per pooling line.
Field Description Item No. Specifies the item number.
This field is visible only when the Pool by field is set as Item on the Calculate Settlement page.Item Description Specifies the description of the item.
This field is visible only when the Pool by field is set as Item on the Calculate Settlement page.Item Category Code Specifies the category code of the item.
This field is visible only when the Pool by field is set as Item or Item Category on the Calculate Settlement page.Item Category Description Specifies the description of the item category.
This field is visible only when the Pool by field is set as Item or Item Category on the Calculate Settlement page.Buy-from Vendor No. Specifies the vendor who supplied the item for which you must settle the payment.
This field is visible only when the Pool by field is set as Vendor on the Calculate Settlement page.Buy-from Vendor Name Specifies the name of the vendor who supplied the item for which you must settle the payment.
This field is visible only when the Pool by field is set as Vendor on the Calculate Settlement page.Global Lot Attributes Specifies the value of global lot attributes (one to eight) with their corresponding values, which were set up on the Advanced Attribute Setup page.
These fields are visible only when the Pool by field is set as Lot Attributes on the Calculate Settlement page.Settlement Quantity Unit of Measure Code Specifies the settlement quantity unit of measure derived from the settlement unit of measure template applied to the settlement calculation, or if the value does not exist, the system uses the default Settlement Unit of Measure field value defined on the General FastTab of the Grower Return Setup page. Settlement Price Unit of Measure Code Specifies the settlement price unit of measure derived from the settlement unit of measure template applied to the settlement calculation, or if the value does not exist, the system uses the default Settlement Unit of Measure field value defined on the General FastTab of the Grower Return Setup page. Gross Revenue Specifies the gross revenue that is to be reported to the vendor(s). This value is derived from the pooling revenue.
You can select this value to view the pooling details.Discount Specifies the sales discount value to be reported to the vendor(s). This value is derived from the pooling revenue.
You can select this value to view the pooling details.Net Revenue Specifies the net revenue to be reported to the vendor(s). This value is calculated by subtracting the Discount field value from the Gross Revenue field value.
You can select this value to view the pooling details.Net Claims Value Specifies the net claims to be reported to the vendor(s). This value is derived from the pooling claims.
You can select this value to view pooling details.Costs (Deducted Revenue) Specifies the costs to be reported to the vendor(s). This value is derived from the pooling costs, with the Deduction Method field set as Account Sale Amount.
You can select this value to view the pooling details.Net Net Revenue Specifies the net net revenue to be reported to the vendor(s). This value is calculated by subtracting Net Claims Value and Costs (Deducted Revenue) field values from the Net Revenue field value. Commission Specifies the total commission value to be reported to the vendor(s). This value is derived from the pooling commissions.
You can select this value to view the pooling details.Costs Specifies the total cost value to be reported to the vendor(s). This value is derived from the pooling costs.
You can select this value to view the pooling details.Purch. Inv. Amount (LCY) Specifies the total purchase amount to be reported to the vendor(s). This value is calculated as follows:
Net Revenue - Net Claims Value - [Costs (Deducted Revenue) + Costs] - CommissionProposed Pooling Quantity Specifies the proposed pooling quantity. This quantity can be calculated on sales or received quantity depending upon the selection made in the Proposed Pool Quantity Source field on the Calculate Settlement page.
The sales quantity is calculated by subtracting the pooling claims’ Pooling Quantity field value from the pooling revenue’s Pooling Quantity field value.
The UOM used for the quantity is displayed next to the field name in parentheses.Quantity Specifies the quantity to be reported to the vendor(s), expressed in the settlement unit of measure. This quantity can be calculated on sales or received quantity depending upon the selection made in the Proposed Pool Quantity Source field on the Calculate Settlement page.
The sales quantity is calculated by subtracting the Pooling Quantity field values of the pooling claim and the pooling revenue lines.Quantity (SQU) Specifies the Quantity field value, expressed in the settlement quantity unit of measure. Quantity (SPU) Specifies the Quantity field value, expressed in settlement price unit of measure. Quantity Received (SQU) Specifies the quantity received on the settlement line defined in the settlement quantity unit of measure of the pooling line. Proposed Sales Quantity (SQU) Specifies the sales quantity on settlement lines, expressed in the settlement quantity unit of measure. Quantity Received (SPU) Specifies the sales quantity on settlement lines, expressed in the settlement price unit of measure. Quantity Returned (SU) Specifies how many items on the line have been returned to the vendor in purchase return orders, expressed in the settlement unit of measure. Negative Adjustment (SU) Specifies how many items on the line have been negatively adjusted, expressed in the settlement unit of measure. Inventory (SU) Specifies the total quantity of the item remaining in the inventory, expressed in the settlement unit of measure. Both inventory values of the received lot number(s) and any production lot number(s) are considered. Proposed Pooling Quantity (SU) Specifies the proposed pooling quantity, expressed in the settlement unit of measure. This quantity can be calculated on sales or received quantity depending upon the selection made in the Proposed Pool Quantity Source field on the Calculate Settlement page.
The sales quantity is calculated by subtracting the Pooling Quantity field values of the pooling claim and the pooling revenue lines.Source Document Type Specifies the type of source document. This can either be a purchase order or a sales document. You can further expand the sales document to view the associated sales order, shipment, invoice, return order, receipt, or credit memo. Source Document No. Specifies the number of the source document. Source Type Specifies the type of source. This can either be customer or vendor. Source No. Specifies the number of the source. Source Quantity (SU) Specifies the quantity of an item in the source document, expressed in the settlement unit of measure. Level Specifies the level of the line. The level is used to indicate the type of the pooling line (for example, level 0 implies the pooling type). Parent Line No. Specifies the parent line number of the line. This information is used to link pooling lines of different types together when the Pooling page is expanded. Root Line No. Specifies the type of the line. This can be Pooling, Purchase, Sales, or Claim. Source Base Unit of Measure Specifies the base unit of measure of the item of the specific pooling line.
For pooling lines, the value is derived from a purchase item. For sales order lines, this value can also be derived from a production item.Source Unit of Measure Code Specifies the unit of measure registered in the source document from which this pooling detail line was created. Source Quantity (Base) Specifies the quantity of the item in the source document, expressed in its base unit of measure. Qty. per Source Unit of Measure Specifies how many base units of measure quantities are in one source quantity of the item. Source Quantity (Direct) Specifies the quantity registered in the source document from which this pooling detail line was created. Source Unit Price (Gross) Specifies the direct unit price in the unit of measure of the sales document from which this pooling line was created. This value is visible only for pooling lines with the Type field set as Sales or Claim. Source Unit Discount Value Specifies the unit discount granted in the source document from which this pooling detail line was created. Source Unit Price (Net) Specifies the direct unit price minus the discount in the unit of measure of the sales document from which this account sale line is created.
This value is visible only for pooling lines with the Type field set as Sales or Claim.Source Base Unit Price (Gross) Specifies the direct unit price in the base unit of measure of the item. The value originates from the sales document from which this pooling detail line was created.
This value is visible only for pooling lines with the Type field set as Sales or Claim.Source Base Unit Price (Net) Specifies the value of the direct unit price minus discounts in the base unit of measure of the item. This value originates from the sales document from which this pooling detail line was created.
This value is visible only for pooling lines with the Type field set as Sales or Claim.Proposed Unit Cost Specifies the proposed unit cost calculated by dividing the Proposed Purch Inv. Amount (LCY) field value by the Proposed Pooling Quantity field value. Unit Cost Specifies the unit cost to be reported to the vendor(s).
On the action bar, select Edit List to edit this value.- The UoM used for the quantity is displayed next to the field name in parentheses.
- As this is a higher-level calculation result, if you edit this field, you cannot edit the related revenue, claims, commissions, and cost fields.
- The revenue, claims, commissions, and cost field values are locked based on the latest calculation, as the system cannot trace back and make changes at the revenue, claims, commission, and cost levels.
Proposed Unit Cost (SPU) Specifies the Proposed Unit Cost field value, expressed in the settlement price unit of measure. Unit Cost (SPU) Specifies the unit cost that will be reported back to the vendor(s) defined per settlement price unit of measure. Proposed Purch Inv. Amount (LCY) Specifies the proposed purchase amount to be reported to the vendor(s). This value is calculated as follows:
Proposed Net Revenue - Proposed Net Claims Value [Proposed Costs (Deducted Revenue) + Proposed Costs] - Proposed CommissionMargin Specifies the profit the company makes on the specific pooling line, calculated as follows:
Proposed Purchase Invoice Amount – (Quantity x Unit Cost). This value is increased with all commissions not paid out to third-party commissioners.Margin % Specifies the margin as a percentage of the proposed net net revenue. This value is calculated as follows:
Margin ÷ Net Net Revenue.Modified Specifies whether manual changes have been made to the pooling line. -
The following actions are available on the Pooling page.
Action Description Revenue Open the Pooling Revenue page to view and edit details of the revenue calculation. For more information, see Manage pooling revenue calculation. Claims Open the Pooling Claims page to view and edit details of the claim’s calculation. For more information, see Manage pooling claims. Commissions Open the Pooling Commissions page to view and edit details of the commissions’ calculations. For more information, see Manage pooling commissions. Costs Open the Pooling Costs page to view and edit details of the cost calculation. For more information, see Manage pooling costs. Show Documents Open the document that the selected line exists on.
This action cannot be used when the Type field is set as Pooling on the selected line.Group Lines Group the selected pooling lines to one pooling line. For more information, see Group pooling lines. Undo Manual Changes Undo all manual changes to revenue, claims, costs, commissions, and/or the unit price for this pooling line. -
The following fields display the summary of the margin calculation.
Field Description Total Pooling Margin Specifies the total pooling margin, calculated as the sum of the Margin field value of all the pooling lines. Total Pooling Margin % Specifies the total pooling margin percentage, calculated as the sum of the Margin % field value of all the pooling lines. These fields are visible only when the Hide Summary toggle on the Grower Return Setup page is turned off. For more information, see Set up grower returns.