D365 Finance & Operations and Dynamics AX Forum

 View Only
  • 1.  Number of lines to upload via Data management

    TOP CONTRIBUTOR
    Posted Jun 30, 2022 02:05 PM
    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


  • 2.  RE: Number of lines to upload via Data management

    Posted Jul 01, 2022 09:30 AM
    1::n (One-to-Many)

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



  • 3.  RE: Number of lines to upload via Data management

    SILVER CONTRIBUTOR
    Posted Jul 04, 2022 10:52 AM
    We have uploaded 10s of thousands of lines.

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



  • 4.  RE: Number of lines to upload via Data management

    SILVER CONTRIBUTOR
    Posted Jul 05, 2022 12:19 PM
    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
    ------------------------------



  • 5.  RE: Number of lines to upload via Data management

    Posted Jul 06, 2022 09:11 AM
    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
    ------------------------------



  • 6.  RE: Number of lines to upload via Data management

    Posted Aug 01, 2022 06:30 AM
    Edited by Mark Hangry Aug 01, 2022 06:47 AM
    I think 1 to many
    ------------------------------
    Mark Hangry
    DRS Softech
    Noida
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role