Hello Guys, I am trying to configure new sales price for the inventory item on the sales price form and the following error is comming on the screen. “AR Error: Duplicate Sales Price. This line overlaps with another Sales Price (Price: 500.000000, Effective Date: 1/1/2012, Expiration Date: )”
Answer
How to Resolve the "Duplicate Sales Price" error on the Sales Price Form?
Best answer by Naveen Boga
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.
+15Hi
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
Acumatica Functional Consultant & Customer Experience Supervisor
+19Please 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.
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
Thank You
+19Great, and thanks for sharing the update!
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
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.
Chris Rutz
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.