We need to do a revaluation for about 1k + different released products that are in stock. Normally you can use the open in excel functionality to do mass updates however i noticed when i clicked the office icon on the top left, the revaluation screen only gives the option o export the data to excel. Is there a way to to a mass revaluation to product prices in the below forum ? The other mass update i can think of that can be done in excel is to to a stock adjustment journal, and write off all current stock, then book it back in at the correct price it needs to be in at.
Out of the box, there is no support for Open in Excel for this page as the data is presented on this form using a temporary table. There are some calculations supported via the Adjustment menu. Are you able to use those for your updates?
If not, you can consider a customization for your requirement.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.