Last Purchase Price in Item Price Report not showing values

ERPNext Stock/Inventory
, ,
1

I have done purchase invoices and sales invoices of some stockable products but the report of item Price is not showing the last Purchase Price value .

Please see the attached screenshot

Last purchase price
Last purchase price1349×571 15.9 KB

Is there some thing Im missing or is it a bug?

2

@Savad_Ibrahim

Did you created purchase receipt against the purchase invoices? System update the last purchase rate in the item master on submission of purchase order and purchase receipt.

3

I do Purchase Invoice with Update Stock checked . So ,no PO or PR made.

Will it not update Last Purchase Rate in this case ?

4

@Savad_Ibrahim

Currently it’s not, can you please create github issue, we’ll add this feature for purchase invoice too.

5

Thanks Rohit for quick reply . I have created a github issue .Hope to get this fixed soon

6

Hi @Savad_Ibrahim, can you send the link to the github issue so I may track it. I need this feature as well.

Thanks
Nathan

7

https://github.com/frappe/erpnext/issues/12162

8

Hi @Savad_Ibrahim @rohit_w,

Does this work for you? I’ve created a sales invoice and choosen update stock, but when I look at the item price report my last purchase price is still empty.

I have the latest build and update.

Thanks
Nathan

9

Did you created purchase invoice?

10

Hi @rohit_w, yes, sorry. I mistyped. I created a purchase invoice.

11

Hi @rohit_w, I’ve included screenshots

Purchase Invoice:

image
image1852×1346 208 KB

Item Price Report (I did a refresh and a reload)

image
image1842×316 35.7 KB

Thanks

12

Hi @rohit_w,

Is this a bug? Is there something I can provide that would be useful?

Nathan

13

Is there any solutions?