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: )”
Best answer by Naveen Boga
View original
+12
Hi
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
+17
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
+17
Great, and thanks for sharing the update!
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.