Yes — you can bulk update costs, but the right approach depends on the costing method:
Config Package → Use Table 27 – Item and include No. plus the relevant cost field (Unit Cost, Last Direct Cost, Standard Cost, or Average Cost).
No.
Standard Cost → Don’t just import numbers — you need to run the Standard Cost Worksheet and Implement so Business Central posts the changes and handles revaluations properly.
FIFO / Average Cost → Changing the Unit Cost on the Item card won’t update on-hand value. For that, you need to use the Revaluation Journal.
Edit in Excel → On the Item list or journals, you can open in Excel, bulk edit costs, and publish back — quick and user-friendly for larger updates.
Useful docs:
https://learn.microsoft.com/en-us/dynamics365/business-central/inventory-how-revalue-inventory
Please mark it as verified if it helps
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Sohail Ahmed 2,737 Super User 2025 Season 2
Sumit Singh 2,577
Jeffrey Bulanadi 2,251
