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:

/wp-content/uploads/2015/01/price_list_626455.png

It has all sorts of nifty options as well.

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

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply