We are using Dynamics 365 Business Central. I am working specifically on the Sale Prices table, where we have hundreds of customers that have custom prices for specific item numbers. A new year has rolled around, and we need to increase pricing across the board on these Sales Prices, so I export into Excel the table which shows Item Number, Customer Number, and Unit Price among other things. I use the v-lookup and / or Index-Match functions in Excel to find the old prices and update them to the new prices. Some Sales Prices are left untouched, because they have been more recently updated.
Then I go back into configuration packages, and upload the Excel sheet and apply the data. It appears to simply Append the data, and now I have two Sale Prices for the customer and Item number (and it picks the earlier start date to use, unfortunately).
How can I prevent these duplicates from forming?
Thanks in advance