SBOhub Search

Last Purchase Price: Understanding SAP Business One Price Lists

SAP Business One comes installed with a series of default price lists, one of which is called "Last Purchase Price". This price list is used for recording the price of the item the last time it was purchased. It is automatically updated by SAP when an item undergoes any purchasing side inventory transactions. You can never manually change the prices in this price list.

You can find this price list on the main menu following:

Inventory -> Price Lists -> Price Lists


Find the grayed out list called "Last Purchase Price" and double click the blank cell under the # column to see the prices contained in it.

Marketing Documents That Affect Last Purchase Price

The last purchase price price list is updated when the following documents are added to the system:

  • A/P invoice or A/P reserve invoice
  • Good receipt
  • Opening balance
  • Landed costs
  • Receipt from production orders
  • Any other action with a positive inventory result

Zero prices on a document will not update this price list, nor will cancellation documents reverse it.  If you have never performed one of the above transactions on an item it's entry in the price list will be zero or blank. The price list will be a gray color which means that it cannot be updated manually.

Including Freight in Last Purchase Price List

If any purchasing document contains freight charges you can decide if you want to factor freight into the last purchase price list. To set this up navigate to:

Administration -> Setup -> General -> Freight

On the far right of the table you will see a check box to select "Last Purchase Price". This check box will only be available if you have set your company to "Manage Freight in Documents" on the general tab of the Document Settings window.

Final Thoughts

You can use the "Last Purchase Price" price list to base other price lists on it if your company decides to base pricing on your latest cost. To use this price list as a base price just select it from the "Base Price List" drop down list. This can be a good way to set margins on your product that reflect the most up-to-date changes in your current cost of inventory.

Author Info

Peter Canale
Peter Canale Follow Connect

Co-founder of SBOhub, starter, experienced executive, and probably having the best day ever.