[Feature Improvement] Item Price

ERPNext
, ,
2

Would be nice to have a Item Price History on where to store old prices and validity

5 Likes
3

The improved Item Price would already show history of prices based on the Valid From and Valid To dates. A validation will be prepared to not allow duplicates or overlap of the validity dates with the same Pricelist, Customer, QTY and UOM. We can add a report to view Item Price History better.

4

A report for Item Price history could work perfectly :+1:

2 Likes
5

Cool. Thanks @JoEz, i’ll note this one as additional feature as this will be very helpful for everybody.

6

So you’re going to keep all old prices in Item Price?

7

For this design, yes. We will be adding “Disable” button as well for insanity check.

8

Humm …probably would be better to item price history in another table.

If you that 10k+ product and price variation weekly the Item Price table will grow a lot, what you think?

9

Yes we are open with this idea as well. Though we need to have a proper design on how we archive invalid prices :wink:

1 Like
10

I think you could overwrite Item Price and before_save store it on history price …so you’ll have active price in Item Price and disabled/old price in history price table.

Could work?

1 Like
11

Yeah I think it could. Let see, I have to discuss this with the team and let you know. Thanks for the suggestion!

1 Like
12

Any news on this?

13

Please let us know if there is any help needed to make progress with this feature.

14

Hi @strixaluco! Thanks for the interest! We will be sending PR within the week. I will post here link so you can take a look. You can help in creating test case or fixing bugs if there are. Thanks! :smiley:

4 Likes
15

Are you going to add price history as well?

Can I suggest:

  • add info about supplier_part_no for the selected Supplier?

  • set item-price per warehouse

1 Like
16

Hi @JoEz! The priority for initial PR is just having all the basic proposed function. The Price History will be an addition later on. I have sent a PR https://github.com/frappe/erpnext/pull/11464 . You guys might want to take a look or might be interested in testing! We might missed out on something. Thanks!

17

:+1: I’ll have a look and will try to send a PR for Price History

1 Like
18

Cool! I will try to play around with it. Thanks.

1 Like
19

Hi @JoEz, did you run a price history PR at the end?

Thanks!

20

Nope, sorry

21

I guess this has never been implemented or decomissioned. It is mentioned here:
https://docs.frappe.io/erpnext/v14/user/manual/en/stock/item-price