The prices in the Last Purchase Price price list are updated automatically when you perform any of the following tasks:
Entering an A/P invoice or A/P reserve invoice
Note
If the invoice contains freight charges, and if the Last Purchase Price checkbox in the settings windows of the freights is selected, then the freights affect the last purchase prices. In a perpetual inventory system, however, the last purchase prices of drop-ship items (items that are received into drop-ship warehouses) and non-inventory items are not affected by freights. For more information, see Managing Freight Charges.
If the invoice is based on a goods receipt PO (GRPO) for which you have recorded landed costs, the A/P invoice does not update the last purchase prices of items that are included in the landed costs document.
Cancellation of the invoice does not affect last purchase prices, that is, adding a cancellation document neither updates nor reverts the Last Purchase Price list. For more information, see Canceling Sales and Purchasing Documents.
Entering a goods receipt
Entering a positive opening balance for an item
Entering a positive inventory taking result (inventory posting) that triggers a goods receipt
Entering a landed costs document
Note
If you have recorded landed costs for a GRPO, recording landed costs for an A/P invoice based on the GRPO updates last purchase prices only for items that are NOT included in the existing landed costs document.
Entering a receipt from production based on standard or special production orders:
FIFO or MAP product in a perpetual inventory system: Its last purchase price is updated with the sum of the product components' item costs.
Standard-priced product in a non-perpetual inventory system: Its last purchase price is updated with the product's predefined item cost (displayed as the unit price in the receipt from production). If you does not define a cost for the BOM item, its last purchase price is never updated.
Product in a non-perpetual inventory system: Its last purchase price is updated with the product's unit price defined in the receipt from production.
If none of the above transactions occurs, an item's last purchase price is not updated
Note
When you post one of the documents mentioned above using a date prior to the last update date of a certain item, the item's last purchase price is not updated.
Zero prices never update the Last Purchase Price price list even if freight charges or landed costs exist.
Note
Last purchase price is calculated for all of an item's different UoMs, if those were defined for the item, but only in the primary currency. For more information about the item UoM prices, see [Price Lists Name] - UoM Prices Window
You cannot change the prices in the Last Purchase Price price list manually. That is, as long as an item has not been entered into the warehouse in one of the ways mentioned above, it will not have a last purchase price.
The last purchase price can be used as a base price for other price lists. You can refer other price lists to the Last Purchase Price price list using a defined factor.
The prices in the Last Purchase Price price list are also updated when you enter an A/P correction invoice with a price change. However, if the A/P correction invoice has triggered the last update of the price list and is then copied to an A/P correction invoice reversal, the last purchase prices are reverted to the last updated prices before you add the correction invoice.
The prices in the Last Purchase Price price list are also updated when you enter an A/P debit memo.
Note
Cancellation of the debit memo does not affect last purchase prices, that is, adding a cancellation document neither updates nor reverts the Last Purchase Price list. For more information, see Canceling Sales and Purchasing Documents