Announcements
Hello i have about 400 invoices in "import journal" and i need to change the posting date to October , is there any way i can change them all at once instead of going one by one?
Have you tried 'Edit in Excel' feature? Then it's just a copy/paste.
Try using Edit in Excel or Configuration Packages.
Hi, just adding some info.
Edit in Excel: https://learn.microsoft.com/en-us/dynamics365/business-central/across-work-with-excel#edit-in-excel
Configuration Package:
https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/set-up-standard-company-configuration-packages
https://yzhums.com/4286/
Or, you can customize a small tool.
Hope this helps as well.
Thanks.
ZHU
Thanks! but how did you get the "edit in excel" button there, mine looks like this
Really appreciate the help im getting thanks to everyone :)!
Hi, this looks like a custom feature.
Edit in Excel can also be used in the Worksheet page.
So please check if you have the following permissions?
Hope this 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…
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. OussamaSabbouh 2,068 Super User 2026 Season 1
Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Dhiren Nagar 1,194 Super User 2026 Season 1
Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. YUN ZHU 1,123 Super User 2026 Season 1