Error: Document No. DOCUMENT is out of balance by 0.01. Please check that Posting Date, Document No. and Amount are correct for each line.

Most of Dynamics NAV functionality is built on top of journals. Whenever you post something (i.e. sales order, purchase invoice) the system in the lowest level will be posting General Journal for you (this was extremely well explained in a book “Microsoft Dynamics NAV 2009 Application Designer” by Mark Brummel which improved my understanding of underlying Dynamics NAV functionality, but… this is already a completely different topic). Therefore, the place where you would least expect to get any error messages, would be General Journals.

But, once in a while (this is how helpdesk stories could start… instead of saying “once upon a time”, you could say “once in a while”) I get a glimpse of this Dynamics NAV error message: Document No. DOCUMENT is out of balance by 0.01. Please check that Posting Date, Document No. and Amount are correct for each line.

General Journal Error - Document No is out of balance by 0.01

And then… depending on who you will ask for help, you might get different answers:

  • developer: general journals need to balance to 0. It’s not. Why? Let’s try to debug…
  • consultant (who doesn’t know): let’s try to define “Bal. Account Type” and “Bal. Account No.” fields and try to post the journal again (this would obviously work, but… what if we need to have only one entry for Bank Account?
  • consultant (who knows): general journals need to balance to 0. Click Functions > Insert Conv. LCY Rndg. Lines to balance the journal.

Functions > Insert Conv. LCY Rndg. Lines
General Journal Error - Functions - Insert Conv. LCY Rndg. Lines

Excerpt from Dynamics NAV Help files:

When you enter foreign currency amounts in a general journal, the program will automatically convert the amounts to LCY. However, even if all the journal lines balance in the foreign currency, when each journal line is converted and rounded to LCY, their LCY sum may not balance. This means that a balanced transaction in foreign currency may not balance in LCY, and can therefore not be posted.

You can use the Insert Conv. LCY Rndg. Lines function to insert a rounding correction line in the general journal. This rounding correction line will balance LCY when the foreign currency amounts also balance. You can then post the journal.

Before you use this function, you must specify the G/L accounts that the program will use for the rounding correction. You specify these accounts in the Conv. LCY Rndg. Debit Acc. and Conv. LCY Rndg. Credit Acc. fields in the Currency table.

So, what happens, after you run Functions > Insert Conv. LCY Rndg. Lines in General Journal? Well, additional lines for LCY roundings (surprise, surprise?) is inserted:
General Journal Error - Rounding Line Inserted

And then you can post the journal.
General Journal Error - Journal Posted

Result!

Have you ever encountered this error message?

Technorati Tags: , , , , ,

This entry was posted in Dynamics NAV / Navision, functionality and tagged , , , , , . Bookmark the permalink.

4 Responses to Error: Document No. DOCUMENT is out of balance by 0.01. Please check that Posting Date, Document No. and Amount are correct for each line.

  1. yogesh jain says:

    thanks, your this blog helped me to solve problem

  2. Sharad Todi says:

    Explained in a simple to understand manner. Thank you.

  3. pugun says:

    thanks this information really helps

  4. Art says:

    Hi, when I create a new rounding entry, dimensions are missing. Is there a way that the process adds dimensions as well?
    Thanks.

Leave a Reply to yogesh jain Cancel reply

Your email address will not be published. Required fields are marked *