Skip to main content

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Journal posting error...
Small and medium business | Business Central, N...
Answered

Journal posting error message out of balance

(0) ShareShare
ReportReport
Posted on by Ezen 20

Hi 

I was posting Opening balance for a new company setup.

However, error message popped up: 

Document No. GLOB2019 is out of balance by 3,587,431.59. Please check that Posting Date, Document Type, Document No. and Amount are correct for each line.

Attached please find the journal excel template for upload use.

GL-OB-81-revised.xlsx

Categories:
Dynamics 365 Business Central
  • rnbergren Profile Picture
    rnbergren 7 on at
    Journal posting error message out of balance
    Just had this same error.  Needed to fill out the Balancing GL account for the initial load to put the values into. We created one dummy account just for that purpose for the initial load and put that into there.
     
    It all worked out.
  • Ezen Profile Picture
    Ezen 20 on at
    RE: Journal posting error message out of balance

    I will check on the total & try uploading again

  • Community Member Profile Picture
    Community Member on at
    RE: Journal posting error message out of balance

    Hi,

    All journal must be balance. I think you better check with your accountant, they should be able to explain it to you.

  • Ezen Profile Picture
    Ezen 20 on at
    RE: Journal posting error message out of balance

    Hi

    Thanks for your input.

    However this journal is about uploading of opening balances, not double entries.

    Henceforth the Amount & Amount (LCY) field will not zerorised.

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Journal posting error message out of balance

    Your Opening Balance is not balance. The sum of Amount and Amount (LCY) field must be zero.

  • Suggested answer
    John Ray Patajo Profile Picture
    John Ray Patajo 837 on at
    RE: Journal posting error message out of balance

    Hi Ezen,

    Try using Debit and Credit instead of AMount.

    Thanks.

  • Ezen Profile Picture
    Ezen 20 on at
    RE: Journal posting error message out of balance

    Hi John

    Appreciate your prompt support.

    Yes, SGD is LCY under GL set up.

    I did try your suggestions by removing both Currency code and Amount (LCY) column in my template.

    However, "Amount (LCY)" gets automatically populated in the Journal Batch.

    Kindly advise.

    Thanks a lot.

    Regards

    Ezen

  • Suggested answer
    John Ray Patajo Profile Picture
    John Ray Patajo 837 on at
    RE: Journal posting error message out of balance

    Hi Ezen,

    Is SGD is your LCY under General Ledger Set-up?

    Just remove the Currency Code and try to post.

    Also, you can remove the Amount (LCY) column on your template.

    Please click Yes if it resolves your issue.

    Thanks.

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

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,157 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,938 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans