Create Purchase Invoice

You can create a Purchase Invoice for a Catch Weight Item manually without the Purchase Order. The Weight Quantity (KG) field in the Purchase Invoice page is calculated from the Document Weight Lines.

The Weight Quantity (KG) is updated based on the Net Weight when the value of Quantity (Base) is changed on the Purchase Invoice.

To Get Receipt Lines

1. Select the Search icon , enter Purchase Invoices, and then choose the related link.
   The Purchase Invoices page opens.

2. Select and click the required No. to open the Purchase Invoice page.

3. On the Lines FastTab, on the action bar, select Line > Functions > Get Receipt Lines to open the Get Receipt Lines page.
   On the Get Receipt Lines page, the Weight Quantity (KG), Weight Quantity Invoiced (KG) and Weight Qty. Rcd. Not Invoiced (KG) fields are updated automatically.

4. Select the required Receipt No.
   The Document Weight Lines are created for the pulled receipt Lines for each Item Tracking Line.
   The Weight Quantity (KG) field on the Purchase Invoice line is updated with the sum of the Weight Quantity (KG) from the Item Tracking Lines.

   
   For the Purchase Invoice created manually, system will create Document Weight Lines when the Item Tracking Lines are defined.

Item charge assignment

You can allocate item charges based on the weight quantity across multiple transaction types. Follow the below steps to perform the item charge assignment using weight quantity.

1. Open the Purchase Invoice page.
2. Fill in the required fields.
3. On the Lines FastTab, in the Type field, select Charge (Item).
4. In the No., Location Code, Quantity, and Direct Unit Cost Incl. VAT fields, enter the required information.
5. On the Lines FastTab, on the action bar, select Line > Related Information > Item Charge Assignment.
   The Item Charge Assignment (Purch) page opens.
6. On the action bar, select Get Receipt Lines.
   The Purch. Receipt Lines page opens.

You can also select other actions, such as Get Sales Shipment Lines, Get Transfer Receipt Lines, Get Return Receipt Lines, and Get Return Shipment Lines, as required. This functionality works only when the Applied-to Doc type field value is set to Order, Invoice, Credit Memo, or Return Order.

7. Select the required line for which you want to allocate charges based on weight quantity and then select OK. You can continue adding multiple lines one at a time using the same process. The selected line is updated in the Item Charge Assignment (Purch) page. You can view related weight information in the fields such as Weight Qty. to Receive, Weight Qty. Received, Weight Qty. to Ship, and Weight Qty. Shipped.
8. On the action bar, select Suggest Item Charge Assignment.
   The dialog box appears.

This functionality works only when there are multiple lines.

9. Select the By Weight Quantity option and select OK.

When the By Weight Quantity option is selected, the ItemChrgAssignByWeightQty58FDW table field value is set to Yes for the related line on the Purchase Invoice page.

10. Select Close on the Item Charge Assignment (Purch) page.
11. On the Purchase Invoice page, on the action bar, select Home > Post to post the purchase invoice.

The system calculates and distributes the item charges based on the following formula: (Receipt line Quantity / Total Quantity of all receipt lines) X Total Item Charge Amount For example,

• Direct Unit Cost Incl. VAT = 200
• First receipt line quantity = 40
• Second receipt line quantity = 70
• Total quantity = 40 + 70 = 110

Then the system applies the formula as follows:

• Cost Amount (Actual) for the first receipt line = (40/110) X 200 = 72.73
• Cost Amount (Actual) for the second receipt line = (70/110) X 200 = 127.27

These calculated values are reflected in the Cost Amount (Actual) field on the relevant value entries.

If the same line includes multiple lots, the system performs the same calculation based on the weight quantity of each lot and sums the amounts for the complete line.

If only one line exists and it is a catch weight item, the system assigns the entire item charge to that line. If that line includes multiple lots, the system calculates and distributes the charge across lots using the same weight-based calculation.

This functionality works similarly for the purchase credit memos.