Hi @alis21 

Can you export the file and share here to see the issue which is overlapping?https://community.acumatica.com/import-and-export-scenarios-117/how-to-mass-update-sales-price-expiration-date-12361

Thanks

Please check the Inventory ID’s, which are configured on the 1/1/2012 as Effective Date (Price - 500 recoding is overlapping), and modify the dates accordingly, which will solve this problem.

Thank You @Naveen Boga , issue resolved, i changed the effective date of some of the inventory id’s. and now i can configure new sale prices for inventory!

Great, and thanks for sharing the update!  @alis21 

Here is how I was able to get this to work on the Vendor Prices screen which that screen is pretty much designed the same way as the Sales Prices screen.  In my example below I did not want the old price record, I just wanted to replace it with the current effective date and new price.

Hi all, just a little bit more info for people on this one. I have found that the “Effective As Of:” date filter at the top can cause not all the effective prices to come up. Clearing this filter (and making sure it is cleared whilst looking for that duplicate price) seems to show EVERY price and as such you can then work out which one is causing the duplicate error.

Hope this helps,

Cheers
JG