Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

NAV2016 CU1: Posting Performance of large Gen. Journals

Posted on by

In NAV2016 the posting of large Gen. Journals (>5.000 Lines) is nearly unpossible.

Line Check, Balance Check an the posting itselfs is fast als allways, but deleting the gen. Journal lines is terrible slow.

I found the Problem in 2 Subscriber Functions in Codeunit 1535 and 1550, which are called at every delete.

After deleting this functions the posting process performs normally.

Hopefully in future CUs the event-functions are more performant.

*This post is locked for comments

  • Andri Wianto Profile Picture
    Andri Wianto 385 on at
    RE: NAV2016 CU1: Posting Performance of large Gen. Journals

    Thanks, Johanes.

    Your solution is work. While others are not.

    I tried to remark the code, but still bad performance.

    Try to delete this function, or change it to non event, could work.

    I delete 3 functions:

    COD 1550
    RemoveGenJournalLineRestrictionsBeforeDelete
    COD 1535
    DeleteApprovalEntriesAfterDeleteGenJournalLine
    DeleteApprovalCommentsAfterDeleteGenJournalLine

  • Suggested answer
    Jens Glathe Profile Picture
    Jens Glathe 6,092 on at
    RE: NAV2016 CU1: Posting Performance of large Gen. Journals

    There is a performance fix for this now:

    markbrummel.wordpress.com/.../performance-issue-with-workflow-solution

  • Peter D. Jorgensen Profile Picture
    Peter D. Jorgensen 110 on at
    RE: NAV2016 CU1: Posting Performance of large Gen. Journals

    Had the same problem, and solved it by deleting a bunch of event subscribers in codeunit 1535 and 1550.

    For details: forum.mibuso.com/.../nav2016-long-wait-after-having-reached-100-when-posting-g-l-journal

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV2016 CU1: Posting Performance of large Gen. Journals

    If you are not using Workflows in General Journal Lines, Try commenting below line in Table 81 and see if it helps.

    Table 81 - OnDelete() Trigger

    //ApprovalsMgmt.OnCancelGeneralJournalLineApprovalRequest(Rec);

    Pl. do thorough testing in test environment prior implementing solution in Live.

  • M. Ionescu Profile Picture
    M. Ionescu 10 on at
    RE: NAV2016 CU1: Posting Performance of large Gen. Journals

    Hi Johannes,

    I have the same issue but in CU8.

    Please, can you give me more details about what you changed?

    Kind regards

  • RE: NAV2016 CU1: Posting Performance of large Gen. Journals

    Hi,

    yes - in CU3 it is the same Problem.

  • Roberto Stefanetti Profile Picture
    Roberto Stefanetti 12,998 on at
    RE: NAV2016 CU1: Posting Performance of large Gen. Journals

    hi,

    can you test posting with NAV 2016 CU3 ?

    NAV 2016 CU3 released today

    community.dynamics.com/.../cumulative-update-3-for-microsoft-dynamics-nav-2016-has-been-released

  • 4BzSoftware Profile Picture
    4BzSoftware 6,071 on at
    RE: NAV2016 CU1: Posting Performance of large Gen. Journals

    Thank you Johannes!

  • Jens Glathe Profile Picture
    Jens Glathe 6,092 on at
    RE: NAV2016 CU1: Posting Performance of large Gen. Journals

    Hi Johannes,

    thank's for sharing this.

    with best regards

    Jens

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,963 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans