This third and last post on GL journal imports with the help of Electronic Reporting focuses on the import of so-called split postings where one debit account and multiple credit accounts (or vice versa) are imported in MSDyn365FO GL journals.
Electronic Reporting: Import of GL Excel Journals (Part 3)
10 Sunday Feb 2019
Posted in General Ledger
Dynamics 365FO/AX Finance & Controlling 
Pingback: Electronic Reporting: Import of GL Excel Journals (Part 3) - Finance and Operations Community
Hi Ludwig,
first of all, thank you very much for your posts!
I try to import some supplier-transactions. In general it is working, but some supplier account numbers have some leading zeros in my case „0000452“ –> This is changed in the „MODEL TO DATASOURCE MAPPING“ to „452“, and of course this supplier is not existing in the system and the import is failing.
Do you have an idea, how to solve this?
Thank you, Reto
LikeLike
Hello, have you defined the number as text field in the model and the configuration of your electronic report?
LikeLike
Yes, I did.
It’s working when I add an ugly code like:
IF(
LEN(@.XL7_AcctDR) = 1,
CONCATENATE(“00000”, @.XL7_AcctDR),
IF(
LEN(@.XL7_AcctDR) = 2,
CONCATENATE(“0000”, @.XL7_AcctDR),
IF(
LEN(@.XL7_AcctDR) = 3,
CONCATENATE(“000”, @.XL7_AcctDR),
IF(
LEN(@.XL7_AcctDR) = 4,
CONCATENATE(“00”, @.XL7_AcctDR),
IF(
LEN(@.XL7_AcctDR) = 5,
CONCATENATE(“0”, @.XL7_AcctDR),
@.XL7_AcctDR
)))))
LikeLike
or much nicer:
PADLEFT(@.XL7_AcctDR,6,”0″)
LikeLike
Many thanks for sharing this shortcut with the community! Much appreciated
LikeLike