Announcements
No record found.
Hello All,I am facing an error while using feature of Edit in excel as " All rows in a table are in an error state, so no error formats are applied" while publishing it from excel to business central.
What table in Business Central are you working on?
It seems that the journal template name you have in Excel is not present in Business Central.
So try to change the template name or create the template in Business Central.
Hi,
From which page you are doing that?
I'm working on sales Journal.
I'm doing from Sales Journal page .
The same applies there. You will have to give the system the correct value for journal template name.
So when you are doing Edit in Excel, you have provide all those three fields along with other data
journal Template Name
Journal Batch Name
Line No.
Adding info-:
https://learn.microsoft.com/en-us/dynamics365/business-central/across-work-with-excel
https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/configuring-excel-addin
Regards
Amit Sharma
www.erpconsultors.com
Thank you.
My Journal Batch Name was missing.
Just for the confirmation, do we need to provide details in those fields even though the "Edit in excel" is opened from the same Journal Template page?
Yes, if those are coming blank in excel file.
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 2,002 Super User 2026 Season 1
YUN ZHU 1,255 Super User 2026 Season 1
AndrewThomas81 1,217
