This webcast shows you one can create and import GL journals in MSDyn365FO with the help of Electronic Reporting. A major advantage of those imports are that they run faster than the standard Excel GL journal import functionality. In addition, journal headers and journal lines can be created in a single run without having to create the journal headers before. Finally, users have more flexibility in the way how they create their Excel import templates and there is no limitation in the number of templates and ER import configurations that can be made.
Electronic Reporting: Import of GL Excel Journals (Part 1)
24 Thursday Jan 2019
Posted in General Ledger
Dynamics 365FO/AX Finance & Controlling 
Pingback: Electronic Reporting: Import of GL Excel Journals (Part 1) - Finance and Operations Community
Very interesting video.
Have you compared the time used for import if you use Data management and the entity General Journal?
LikeLike
Hello Jette,
I used also the GJ templates and data management to compare it against the electronic reporting GJ import.
The outcome of that will be a chapter in my next book that will be released in the next couple of days.
Best regards,
Ludwig
LikeLike
A new book? A must buy. Best d365 financial consultant
LikeLike
Great video, have been following these steps and I get as far as adding the Destination to the Data model. When I filter the Data entities I do not see the LedgerJournalEntity, only the LedgerEntity. Is there something else I should do first to get this DE to appear here ?
LikeLike
Hi, It might be the system version that you operate. What D365FO version do you operate? Is it an older one? Best regards, Ludwig
LikeLike
It’s a VM running Version 10.0 (Platform 24)
LikeLike
Hi,
When I open the destination, I can still see it in my 10 PU24 machine.
Can you double check that to see that there is no filter or something alike?
LikeLike
No filter applied at all I’m afraid
LikeLike
Ok. Let’s take this offline. I will send you a screenprint from my 10.0 PU24 machine. In case you see a different selection, please get in touch with a developer and/or the MS support. Best regards, Ludwig
LikeLike
Ok, many thanks Ludwig.
LikeLike
Hello, thank you for the excellent tutorial. I am stuck at time 12:38. When in the designer mode for the Excel file, On the page “Edit Group by parameters”, the section “What to group” is blank and I cannot move forward. Please advise. Thank you.
LikeLike
Hi, I can send you the template and the demo data that I used if this would help and if you provide me your email. Best regards, Ludwig
LikeLiked by 1 person
Hi Ludwig, I am trying to extend my model to include options for reversing entries. The selection on the journal is a Ys/No and is set to an Enum. When I create my data model I have set this to Enum but cannot bind it to the data model (which is also stated as Enum). With Enums is there something else I need to do to allow me to complete this ?
LikeLike
Hi Andy, Handling enums is a bit tricky because – as you mentioned – you cannot directly bind them. What I am regularly using is a string field that I bind to the enum by making use of the case functionality. Something like… Case(D365FOField, Enum1, “String1”, Enum2, “String2) etc. I used this a couple of times on various blog posts. Best regards, Ludwig
LikeLike
Thanks Ludwig, I’ve completed this in my data model, do I need to also add it to the configuration ?
LikeLike
Right. Model and configuration need to be connected; for imports vice versa. Otherwise the import won’t work. Best regards, Ludwig
LikeLike
Hello Ludwig thanks a lot for your explanation it is great -> would you know why just the first line of my excel tab is imported as GL Entry ?
I have no blocking message “operation complete” , but get only the first line as imported .
regards
Julien
LikeLike
Hello Julien,
Most of the time this is because of a wrong binding of the record list element. Can you please double check your model and configuration and check especially those elements and their bindings?
Best regards,
Ludwig
LikeLike
Thanks Ludwig problem has been fixed , indeed wrong binding as you mentioned
LikeLike
Hi Ludwig, Thank you for your explanation on Electronic reporting , I am able to setup the general ledger import as per your explanation but I am not sure why I am getting error when I try to run the excel spreadsheet with the account number and offset account number .I am able to run the journal without the account number and offset account number .I have checked the setup but not able to identify the issue , do you know what could be possible missing setup. The issue is with both Account Number and Offset Account number.
LikeLike
Hi,
Can you create a new question in the community forum and share details of the setup that has been made?
Many thanks,
Ludwig
LikeLike
Hi
After several trials I finally succeded in following your link. Some of the time consuming errors was the template (Table style AND that the cells below the header was the ones to be named cells).
Looking foreward to getting a look at the next video 🙂
LikeLike