Previous Price (history)
Is there a way that I can find out the prices of items for instance as at 31st DEC 2007. Which type of a query construct can i use? and which tables? Thanks.
Kerstin Pauquet replied
the 'Last Prices Report' might be of use to you.
This report displays the last purchasing and sales prices of an item. You can view the last prices of an item for a specific business partner or for all business partners.
To open the report, do one of the following:
From the SAP Business One Main Menu, choose Inventory Inventory Reports Last Prices Report .
In a sales or purchasing document, place the cursor in the Unit Price field and press Ctrl + Tab. The values are copied automatically from the document.
To generate the report, enter the necessary information and choose Refresh.
This topic includes explanations of some of the fields and other elements in this window.
End of the note.
Last Prices Report Fields
BP Code Displays the last prices for a specific business partner.
Deselect to display the last prices for all customers.
Display ... Last Prices Enter the number of previous prices to display.
Special Price In addition to last prices, displays the Special Prices defined for the selected item.
This selection is optional.
Date Enter a date to display Special Prices for that specific date.
Quantity Enter a quantity to display Special Prices for that specific quantity.
So in your case, enter the date of 31.12.2007 & pick a BP & item & document type.
All the best,