To Post Sales Order for Ship and Invoice
While posting the Sales Order of a Catch Weight item for Ship and invoice, the following data are updated:
- The Sales Amount (Actual) field on the Item Ledger Entry for the Sales Shipment
- The Weight Quantity Invoiced (KG) field on the Item Weight Ledger Entry for the Sales Shipment
- The Weight Quantity (KG) and Weight Quantity Invoiced (KG) fields on the Posted Sales Shipment and Posted Document Weight Lines
- The Weight Quantity (KG) field on the Posted Sales Invoice and Posted Document Weight Lines
You can only post the Sales Order for Ship and Invoice when the Qty. to Ship field is equal to Qty. to Invoice field.
To Post Sales Shipments and Sales Invoices with Corrected Expected Costs
For catch weight items with the Costing by Weight toggle on the Item Card page turned on, the system updates the value on the Valued Quantity (Catch weight UoM) field.
The catch weight UoM in the field name is dynamically displayed based on the value in the Unit of Measure Code field on the Catch Weight Setup page.
A sales invoice can be posted only with the exact weight quantity that was shipped earlier. If a different quantity is entered, the system displays an error message.
On the Value Entries page, the Valued Quantity (Catch weight UoM) field value records the actual weight quantity in catch weight UoM, such as KG, which is used to calculate the Cost Amount (Expected) field value during shipment and the Cost Amount (Actual) field value during invoicing. This ensures inventory is valued based on the shipped or invoiced weight.
For example, if you ship 110 KG of a catch weight item, and the standard cost per weight is $0.8/KG, then the system updates the field values as follows:
- Cost Amount (Expected) = 0.8 X 110 = $88
- Cost Amount (Actuals) = 0.8 X 110 = $88
- Valued Quantity (KG) = 110
If a partial quantity is invoiced for a shipment where the shipped quantity is less than the expected quantity, the system prevents posting the invoice. This error occurs only when the weight is derived from multiple item ledger entries or item weight ledger entries. For example, if 20 quantities are expected and 10 are shipped, attempting to post an invoice for only 6 quantities results in an error.