Manage standard costs by weight

Catch Weight  •  Article  •  10/22/2025  • 

You can manage weight-based standard costs using the Standard Cost Worksheet page. The worksheet includes dedicated fields for calculating and implementing standard costs based on weight quantities.

To update standard cost per weight

You can update the standard cost of a catch weight item based on its weight to ensure accurate cost valuation and reporting.

  1. Select the Search icon , enter Standard Cost Worksheet, and then choose the related link.
    The Standard Cost Worksheet page opens.
  2. Select the worksheet name you want to use or create a new one.
  3. On the action bar, select Actions > Functions > Suggest Item Standard Cost or Roll Up Standard Cost.
    The system calculates and populates the following fields:
    • Standard Cost per Weight UOM = Standard Cost ÷ Net Weight
    • New Standard Cost per Weight UOM = New Standard Cost ÷ Net Weight
  4. Review the calculated values and make manual adjustments if needed.
  5. On the Item Card page, select Actions > Functions > Implement Standard Cost Changes.
    The Implement Standard Cost Changes page opens.
  6. On the Implement Standard Cost Changes page, enter the posting date and any other required settings.
  7. Select OK.
    The Standard Cost and Standard Cost per Weight UOM field values are updated on the Item Card page.


The field captions display the catch weight unit of measure configured on the Catch Weight Setup page (for example, Standard Cost per KG when kilogram is the catch weight unit of measure).

To calculate inventory value per item ledger entry

You can use the Item Revaluation Journal page to adjust inventory values based on new cost per weight values or to correct historical costs. This method creates a separate revaluation line for each item ledger entry, providing precise control over individual receipt or adjustment revaluations.

  1. Select the Search icon , enter Item Revaluation Journals, and then select the related link.
    The Item Revaluation Journals page opens.
  2. On the action bar, select Actions > Functions > Calculate Inventory Value incl. Weight.
    The Calculate Inventory Value incl. Weight page opens.

  3. On the Calculate Inventory Value incl. Weight page, enter the required information in the following fields:

    FieldDescription
    Posting DateEnter the date to use for the revaluation entries.
    Calculate PerSelect the Item Ledger Entry option to create individual lines for each entry.

  4. Select OK.
    The system creates revaluation lines with the following fields populated:

    • Weight Quantity: From the item weight ledger entry.
    • Unit Cost per Weight UOM (Calculated): Current cost per weight unit.
    • Inventory Value (Calculated): Current total value.
    • Applies-to Entry: Specific item ledger entry number.
  5. In the Unit Cost per Weight UOM (Revalued) field, enter the new cost per weight unit.
    The system automatically calculates as follows:
    • Unit Cost (Revalued) = Inventory Value (Revalued)/ Quantity.
    • Inventory Value (Revalued) = Weight Quantity × Unit Cost per Weight UOM (Revalued).
    • Amount = Inventory Value (Revalued) - Inventory Value (Calculated).
  6. Review the calculated values and post the journal.


You cannot directly update the Unit Cost (Revalued) field value for catch weight items with costing by weight toggle turned on. However, you can update the Unit Cost per Weight UOM (Revalued) field value instead.

To calculate inventory value per item

This method creates a single revaluation line per item, combining all applicable item ledger entries. To calculate inventory value per item, follow these steps:

  1. On the Calculate Inventory Value incl. Weight page, in the Calculate Per field, select Item .
  2. Fill in the required fields as needed and select OK.
    The system creates a single line per item with aggregated weight quantities and costs.
  3. In the Unit Cost per Weight UOM (Revalued) field, enter the new cost per weight unit.
  4. Post the journal.

The system applies the revaluation proportionally across all open item ledger entries for the item.

To create revaluation manually

You can manually create revaluation lines for specific item ledger entries.

  1. On the Item Revaluation Journal page, create a new line.
  2. In the Applies-to Entry field, select the item ledger entry number.
    The system automatically populates:
    • Weight Quantity: From the item weight ledger entry.
    • Unit Cost per Weight UOM (Calculated): Current cost per weight.
    • Inventory Value (Calculated): Current total value.
    • Posting Date: From the selected item ledger entry.
  3. Enter the new cost in the Unit Cost per Weight UOM (Revalued) field.
  4. Post the journal.