Create corrective catch weight worksheet

Catch Weight  •  Article  •  10/22/2025  • 

You can use the Catch Weight Correction Worksheet page to identify and correct inconsistencies between quantity-based and weight-based inventory records.

To correct remaining weight when quantity is zero

This scenario corrects imbalances where all items are consumed but weight quantity remains.

  1. Select the Search icon , enter Catch Weight Correction Worksheet, and then choose the related link.
    The Catch Weight Correction Worksheet page opens.
  2. On the action bar, select Actions > Calculate Inventory Weight.
  3. On the Calculate Inventory Weight page, turn on the Only Show Remaining Qty Zero toggle.
  4. Set any required filters and select OK.
    The system displays lines where:
    • Quantity = 0
    • Weight Quantity = 0
  5. Review the lines and select the Post checkbox for entries you want to correct.
  6. In the New Weight Qty field, the system automatically calculates the Amount field value to show the cost adjustment needed.
  7. On the action bar, select Actions > Post Weight Correction.
    The system,
    • Updates the Weight Corrected checkbox on item ledger entries
    • Clears the Weight Open checkbox when weight is fully balanced


The system validates that all related item ledger entries are fully invoiced before allowing correction posting.

To correct generic weight discrepancies

To correct any weight quantity regardless of the transaction type or remaining quantity status, follow these steps:

  1. On the Catch Weight Correction Worksheet page, select Actions > Calculate Inventory Weight.
  2. Turn off the Only Show Remaining Qty Zero toggle.
  3. Set filters for the specific item, lot, or location you want to correct.
  4. Select OK.
  5. In the New Weight Qty field, enter the corrected weight quantity.
    The system calculates:
    • Amount = (New Weight Qty - Weight Qty) × (Inventory Value (Calculated) ÷ Weight Qty)
    • Inventory Value (Corrected) = Inventory Value (Calculated) + Amount
  6. Select the Post checkbox and post the correction.


The system date is automatically updated as the posting date for all correction entries. The related item weight ledger entry and value entry are created using the system date.