Bulk Price List Updates

Leigh Diskin on 11/27/2018 9:01:51 PM

I need to apply a 15% price increase to over 5,000 items in my Business Central database. My consultant just informed me that I am unable to use the "Edit in Excel" feature because "Unit Price" is a Read-Only field. So apparently, I will have to go into all 5,000 items to perform a simple 15% price increase. What would have taken me hours to calculate in Excel and Publish will now take me days to do.

Seems like allowing Unit Price to be editable in Excel would be a simple fix. Please help.

Thanks in advance for your speedy response.
Leigh Diskin

STATUS DETAILS

Completed

Ivan Koletic (administrator)

Thank you for your feedback. We released this feature as part of the functionality in Sales Price Worksheets.

Please refer to the following link for more information:

https://docs.microsoft.com/en-us/dynamics365/business-central/sales-how-record-sales-price-discount-payment-agreements#to-copy-sales-prices

Simply run Sales Price Worksheet. Get current prices clicking on Suggest Item Price or Suggest Sales Price. There you'll have the chance to enter adjustment factor for prices you want to change. Once you have them in the worksheet, simply click Implement price change and that's it.

FYI, your best bet on getting quick answers for questions like this is to post them on Business Central Community site.

This site is used for product suggestions only.

https://community.dynamics.com/business/f/758

Sincerely,

Ivan Koletic

PM, Microsoft