On the left click “Report” (opens a report screen)
On the report screen, click on Menu
Click on "Pick Columns"
I suggest you pick these columns:
Date
ID
Item Code
Price List Rate
You can then filter by specific Item Code or export results as you wish.
Limitations:
Price list rate will show independent of the purchase unit! In my case, I have a stockpeeking unit called “Pellet”. However, the seller quotes in “Can”. Each can for this item, contains 5,000 pellets. One purchase order was listed as buying qty: 5,000 UOM: Pellet Price: $0.10
A different purchase order was listed as buying: qty: 1 UOM: Can Price: $500.00
Sure, I can certainly go ahead and convert on my own, but If we now that we are going to be converting back and forth, I think ERPNext should be configured for such a report.
Features desired and proposed:
Using existing Purchase Order data, find a way to express Price List Rate in terms of user-selectable UOM for particular item. Give the user these options when reporting prices and purchase dates: a. Use default stock UOM b. Allow user to select UOM manifested in Item>Purchase details>Unit of Measure Conversion.
Enable a graph setup, similar to a Gantt chart, where items are listed in one leftmost column, following column contains a drop down to select the UOM for that item, and then the right hand side of the graph displays time periods (selectable too), so that each price point can be graphed. Ideally, these should be points joined by a line. This graph can then be “filtered” to select one, or more items, so that price behavior can be compared.