Skip to Content
Author's profile photo Mike Taylor

Tips & Tricks: Last Price Report in Sales Documents

I have had the request from several SAP Business One customers to view the last price given to a specific customer for a specific item.  Well the only real solution I could come up with would be to make an FMS on the price with a query.  This is an OK solution but I came across a much slicker solution when searching the SAP help file for something completely unrelated.

Turns out there is a secret “Last Prices Report” which is build in (I’m testing on SBO 9.0 PL07, but I verified it on 8.82 PL13 as well).  This report is not apparent but is easy enough to get to.

When you are adding a row to a document all you need to do is click in the field for price for the item you want and click CTRL + TAB.

The report looks like this:


It has all sorts of nifty options as well.

So if you ever get this request remember CTRL + TAB!

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Great tip!  Thanks!

      Author's profile photo Former Member
      Former Member

      Thanks Mike.  I have shared this with people here that may be helped with this easy to use tip.