This post extends the previous one and shows you how to create and import GL journals in MSDyn365FO that make use of different account types for importing customer, vendor and bank transactions.
Electronic Reporting: Import of GL Excel Journals (Part 2)
01 Friday Feb 2019
kalyani sriramiah said:
Thanks a lot for the tutorial. Wondering if the 2 points below are achievable:
1. Can we create multiple journals with a single excel import file?
2. We want the journal batch number also to be manually specified in the excel to be imported. If we setup the Number sequence for the Journal name as ‘Manual’ , can we include the journal name also in the import file?
Ludwig Reinhard said:
For No 1: You can but the configuration of the ER will become different and more complex
For No 2: You can do that as well by making use of a user input parameter. Also here, the configuration of the ER will need to be modified and get more complex.
Absolutely top notch – Nice going 🙂 Very good!