web
You’re offline. This is a read only version of the page.
close
Skip to main content
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
    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.

  • 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,

    Try using Debit and Credit instead of AMount.

    Thanks.

  • 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.

  • 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.

  • 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

    I will check on the total & try uploading again

  • 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.

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,308

#2
Sumit Singh Profile Picture

Sumit Singh 2,798

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,793

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans