Show TOC

Function documentationPrice Lists: Last Purchase Price Locate this document in the navigation structure

 

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 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.

    End of the note.
  • 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 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.

    End of the note.
  • 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 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.

End of the note.

Note 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

End of the note.

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.

Country-Specific: Czech Republic, Hungary, Poland, Slovakia

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.

Country-Specific: Chile, Costa Rica, Guatemala, Mexico

The prices in the Last Purchase Price price list are also updated when you enter an A/P debit memo.

Note 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

End of the note.