| Equate Balance of Receipts with Inventory Level (tdipu0201m000) |  |
| Use this session to equate the cumulative receipts with the inventory on hand to ensure the calculation of realistic average purchase prices for the specified item types and items. You must only execute this session periodically if the Method of Calculating Average Purchase Price parameter is set to Purchases (Cum.) in the Purchase Order Parameters (tdpur0100m400) session. The cost price can be calculated on the basis of the average purchase price, as set in the Price Calculation Codes (ticpr1100m000) session. The average purchase price (Avg. PP) is calculated as follows:

                                  Cum.Receipts * Old Avg.PP + Qty Received * Order Price
    ------------------------------------------------------
                 Cum.Receipts + Qty Received

                                        Avg.PP
                                        New average purchase price

                                        Cum.Receipts
                                        Cumulative receipts

                                        Qty Received
                                        Quantity received or approved

                                        Old Avg.PP
                                        Old average purchase price
In case of a high value of the cumulative receipts, the influence of the order price on the average purchase price is very small. If this influence becomes too small, you can decrease the value of the cumulative receipts by equating it to the inventory on hand. You can start this session from the Items - Purchase (tdipu0101m000) session. Related topics Price calculation code Cost price calculation
Fields | Description
Item Type | A classification of items used to identify if the item is, for example, a purchased item, a manufactured item, or an equipment item. Depending on the item's type, certain functions will only apply to that item. Note ERP LN only takes into account the item's default item type, as set in the Item Type field of the Item - General (tcibd0101s000) session. The item type that is displayed in the Actual Item Type field of the Item - General (tcibd0101s000) session, is ignored. For instance, if you set this field to Manufactured, ERP LN does not equate the cumulative receipts with the inventory on hand for items whose Actual Item Type reads Manufactured, but whose (default) Item Type is set to Purchased in the Item - General (tcibd0101s000) session.
Item Type | A classification of items used to identify if the item is, for example, a purchased item, a manufactured item, or an equipment item. Depending on the item's type, certain functions will only apply to that item. Note ERP LN only takes into account the item's default item type, as set in the Item Type field of the Item - General (tcibd0101s000) session. The item type that is displayed in the Actual Item Type field of the Item - General (tcibd0101s000) session, is ignored. For instance, if you set this field to Manufactured, ERP LN does not equate the cumulative receipts with the inventory on hand for items whose Actual Item Type reads Manufactured, but whose (default) Item Type is set to Purchased in the Item - General (tcibd0101s000) session.
Test Run | If this check box is selected, a report is printed that displays the simulated equation of the cumulative receipts with the inventory on hand.
Print Report | If this check box is selected, a report is printed that displays the equation of the cumulative receipts with the inventory on hand.