Duplicate a sales order, item's Rate not follow Rate in original sales order, but price list

ERPNext
1

Let’s say ITEM-A, has a sales Item Price = 500, in default price list

  1. Create a Sales Order #1, select ITEM-A, the price is fetched to 500 (in both Rate and Price List Rate)
  2. Change Rate = 400 (the Price List Rate still 500)
  3. Submit Sales Order #1

Now, I expect that, if I copy Sales Order #1 I should get the Rate = 400, but what I got is Rate = 500 !!!
It seems that, this is because, the Price List Rate in original SO is still 500 and 500 is used.

This question was raised here - Item Price changed when duplicate Sales Order - #2 by kittiu and by looking at the code, I still can’t find the way out except fixing the code, on duplication, the price list shouldn’t be used.

This is opposite of common sense, but I found no where to config for the right behavior. Or this is a bug?

2

I believe you are looking to change the stock settings (Update Existing Price List Rate). You’ll need to enable “Auto Insert Item Price If Missing” before the above option is visible.

Screenshot 2025-01-20 at 4.20.40 PM
Screenshot 2025-01-20 at 4.20.40 PM1480×617 55.8 KB

Other settings to be aware of:

Screenshot 2025-01-20 at 4.24.19 PM
Screenshot 2025-01-20 at 4.24.19 PM1394×681 71.7 KB

3

Thanks, I tested it as per suggestion.

  1. Stock Settings is for Purchase Receipt, and if Update Existing Price List Rule is true, it will be updated Item Price everytime Purchase Receipt change price (which make sense to me).

  2. Selling Settings’s Maintain Same Rate Throughout Sales Cycle, is meant for all documents SO, DN, INV will be maintaining the same rate. Not about updating the Item Price as in Purchase Cycle.

In my opinion, the way system handle the price list change is already make sense.

But when Duplicate SO, the intention is to disregard the Item Price, but just use the previous SO’s price (the reason to copy).

Thanks!