Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Maximum Journal Lines? Business Central on cloud

(0) ShareShare
ReportReport
Posted on by 180

interested to know the maximum journal lines they know of a customer processing using General journal in Business Central on cloud? is it anywhere near the 300,000 lines mark?

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 74,115 Super User 2024 Season 2 on at
    RE: Maximum Journal Lines? Business Central on cloud

    Hi, As far as I know, theoretically there is no upper limit, but I'm not sure if SaaS can support posting 300,000 lines at once.

    The following is the data given by Microsoft in a lecture last year, please note "3300 lines on one sales order"......

    pastedimage1675990592389v1.png

    Hope this info helps as well.

    Thanks.

    ZHU

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Maximum Journal Lines? Business Central on cloud

    As long as you have acquired  the needed database space there is no real limit.

    But I would not recommend having as large journal as this because it will take a very long time to post them, and if there are an error in your journal it will take a long time to roll back the posting.

    So I would recommend you split it in to smaler chucks and process posting in smaller batch.

    Typically I would not have more than around 10000-15000 lines in a journal before i posted it. And I would really aim for lower numbers if i could.

    When it comes to posted transactions I would not worry about the number of records.  The system is able to handle lots of transaction, but you have to chose a good approach if you have a lot of lines you need to post.

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans