Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Najeem JanatAli]

Hi

How many number of lines (voucher lines) can be uploaded in GL module via Data management in D 365 F&O

any suggestion

Thanks

[Bob Coward]

1::n (One-to-Many)

——————————
Bob Coward
Dynamics AX/F&O Developer
DSG
Grayson GA
——————————
——————————————-

[Esther Paradoski]

We have uploaded 10s of thousands of lines.

——————————
Esther Paradoski
Ducks Unlimited Canada
Stonewall MB
——————————
——————————————-

[Karl Arensdorf]

We load all of our large journals this way but I am currently in discussion with Microsoft (via a support ticket) because it takes way longer than I think it should when we try to import journals that are 10K-20K lines. It is taking 4+ hours for a 19K line journal, for example. The response I received from MS support initially was that we should break down the imports into smaller batches but I pushed back that this was not a solution, rather it was a workaround and not at all acceptable. 

If anyone has a different experience with this functionality, please let me know. While 20K lines is a lot of data, my expectation is that Dynamics should be able to handle in minutes, not hours.

——————————
Karl Arensdorf
Corporate Controller
Mansfield Oil Company
Gainesville GA
——————————
——————————————-

[Suf Hayes]

Our experience varied somewhat but we’ve definitely loaded in 10k to 20k lines in under an hour. Anecdotally, any file that had a single error line (some of the data was invalid) took significantly longer to load in than a file with no errors. The entity being loaded into also affected that as the more validations required on the data the longer it took for the system to upload.

Which entity did you use?

The other thing that we’ve done at times is adjust the number of threads for the entity import. Stoneridge has an article on this: How to Multi-thread Your Imports in Dynamics 365 for Finance & Operations | Stoneridge Software

——————————
Suf Hayes
Stein Industries, Inc.
Brooklyn Park MN
——————————
——————————————-

[Mark Hangry]

I think 1 to many
——————————
Mark Hangry
DRS Softech
Noida
——————————
——————————————-