Personalized Community is here!
Quickly customize your community to find the content you seek.
Check out the latest Sales updates!Learn about the key capabilities and features of Dynamics 365 Sales and experience some of the new features.
Download overview guide | Watch Sales video
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
I need to do a price adjustment to products in multiple price lists that is not consistent as a dollar value or percentage across all products. I believe there is a way to adjust all products by a fixed percentage or value, but that isn't the solution I need.
I have struggled to find a way to export out the necessary data from price lists to be able to edit it in Excel and then reimport.
Is there an easy way?
You can first click Export Price List Items:
Select Static Worksheet to export data:
The exported data looks like this:
Change the data you want, here is Percentage.
Click Settings, select Data Management:
Click import data:
Select the Excel you want to import, click Next, until it is finished
You can observe the successful import
The percentage data has been successfully changed:
If you only want to change some of the specified data, you only need to check the check box in front of the data.
If this helped you, I'd appreciate it if you'd mark this as a Verified Answer, which may in turn help others as well.
That gives me a clear process, although it seems like i can only do one price list at a time that way? We have about 30 price lists I need to update.
Is there a way to get more data into the export (for instance product code, price list name columns etc) so that it is easier to identify which data you are working with in Excel?
You can find Price List Item in Table:
Then click Data:
Click here to export data:
Business Applications communities