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: )”
Solved
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.
+16Hi
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
Translate
+20Please 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.
Translate
Thank You
Translate
+20Great, and thanks for sharing the update!
Translate
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.
Translate
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
Translate
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.