D365 Finance & Operations and Dynamics AX Forum

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

1::n (One-to-Many)

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

Original Message:
Sent: Jun 30, 2022 02:04 PM
From: Najeem JanatAli
Subject: Number of lines to upload via Data management

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

We have uploaded 10s of thousands of lines.

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

Original Message:
Sent: Jun 30, 2022 02:04 PM
From: Najeem JanatAli
Subject: Number of lines to upload via Data management

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

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
------------------------------

Original Message:
Sent: Jul 04, 2022 10:52 AM
From: Esther Paradoski
Subject: Number of lines to upload via Data management

We have uploaded 10s of thousands of lines.

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

Original Message:
Sent: Jun 30, 2022 02:04 PM
From: Najeem JanatAli
Subject: Number of lines to upload via Data management

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

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
------------------------------

Original Message:
Sent: Jul 05, 2022 12:19 PM
From: Karl Arensdorf
Subject: Number of lines to upload via Data management

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

Original Message:
Sent: Jul 04, 2022 10:52 AM
From: Esther Paradoski
Subject: Number of lines to upload via Data management

We have uploaded 10s of thousands of lines.

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

Original Message:
Sent: Jun 30, 2022 02:04 PM
From: Najeem JanatAli
Subject: Number of lines to upload via Data management

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

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

Original Message:
Sent: Jun 30, 2022 02:04 PM
From: Najeem JanatAli
Subject: Number of lines to upload via Data management

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