How to change Inventory Price in batches

[rachel_xiao]

I tried to change one material value it's ok for me, but if I need to change Inventory Values in batches, what can I do about it? 

[rachel_xiao · Accepted solution]

Please use APP Manage Material Valuations, you can choose button Upload Material Inventory Prices to change Inventory Price in batches.

To do this, you need to download a template and change the inventory price and then upload the new price.

Attachment is the screenshot of button Upload Material Inventory Prices.

[finhead1 · Accepted solution]

Note that there is a limit of 100 rows in the excel file, although the latest version allows up to 500 rows.