web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

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
I have the same question (0)
  • Suggested answer
    John Ray Patajo Profile Picture
    John Ray Patajo 837 on at

    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.

  • Ezen Profile Picture
    Ezen 20 on at

    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

    Hi Ezen,

    Try using Debit and Credit instead of AMount.

    Thanks.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

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

  • Ezen Profile Picture
    Ezen 20 on at

    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.

  • Community Member Profile Picture
    Community Member on at

    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

    I will check on the total & try uploading again

  • rnbergren Profile Picture
    rnbergren 7 on at
    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,098

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,556 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,108 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans