Dear All,
Please help to solve the problem.
I prepared my enries for Opening Balance and I did all settings (accounting periods, joarnal, etc…). Unfortunately when I click POST, I have a mistake: “Doc N xxxx is out of the balance by xxxx . Please , check that posting date, Document type, Doc No and amount are correct for rach line.”
What should I do in order to have my entries succesfully posted?
Simply means your opening entries doesn’t balance on CR and DR sides.
Before you press Post, change the sorting of the journal to standard key “Journal Template Name,Journal Batch Name,Posting Date,Document No.” - perhaps this will sove your problem.
Total sum of my entries equals zero. Ofcourse its not double entry, its single entry as I must first post the opening balances … I dont why I cant post it =(
Anfinnur, thank you. I dont clearly understood where to find this sorting in order to change it?
You can find it under view menu or simply look amoung the tab button u have on the toolbar…once u press it, you will get list of keys…select the suggestion key ( in simple terms, the order of columns to be sorted)
Yes, I go to the View-> Sort-> I choose one of the options “Journal Template Name,Journal Batch Name,Posting Date,Document No.” → I press OK…
Then I tryed to post my entries and again the same mistake… =((((
Just to try I decided to put some accounts into Balance Account (double entry)… And I managed to post.
But what to do if I want just to open accounts and make single entry? Why Navision doesnt let me to do that?
Because by accounting standard, every entry needs to be balance at all time.
It keeps G/L nice and balance from the very beginning.
So we don’t have to trace the balance error at the end of the year. ( and that will be mission impossible ) .
Think about all the human error in the old days… @_@ …
As stated, NAV is a double entry accounting system and the G/L must always balance. There is a special function that is called whenever anything posts to the G/L to make sure that all of the entries are consistent. You may occasionally see an error that says something like “The entries were not posted because they will cause inconsistencies in the G/L Entry table.” Usually in these cases it is a rounding issue that needs to be corrected, but it can be much harder to figure out.
Well, quite clear… But I dont understand why (doing the bookeeping of one small company in Navision) in one case it s possible to make single entry, and now I cant… I guess the problems is in the settings… probably I must choose some option like ALLOW ALL POSTINGS or something like that.
F.E.
I did before and I managed to do that…
Account No, Desription Amount Bal.Account N
1001 Exapmle 100 (I left it empty)
1001 Examle -100 (I left it empty)
And I was able to post without any mistakes… But now Navision refuses to do that…
Was the document no same in both the lines?
In NAV a journal must balance pr. posting date (the total balance pr. posting date must be 0.00). At least!
Optionally NAV may be set up to demand balance by “Document No.” as well.
Check your Journal Template in “Financial Management” → Setup → General → “Journal Templates”.
In that window you’ll find column “Force Doc. Balance”; if checked, NAV demands balance by DocNo.
But balance by Posting Date - you cannot avoid it.
…
…
Reason for changing that sorting is this:
When NAV posts a journal, the lines are read using the current sorting (default JoruanlTemplate, -Batch and LineNo).
And the balance is checked in that order; when Posting Date in Journal Line changes, NAV checks whether balance by date equals zero. NAV does not check whether any other journal lines with same Posting Date do exist later in the journal.
By changing the sort-order, this issue is solved.
I am close to call this a bug, that has been there for quite some years now.
Account No, Desription Amount Bal.Account N
1001 Exapmle 100 (I left it empty)
1001 Examle -100 (I left it empty)
This IS a double entry already , by the way. +DR -DR = 0
Honestly, there’re ways to get around it. But your accountant will not like it.
eg. create a dummy “opening account” in COA
Throw all the DR CR remaining amount into it.
After all opening are inputed, this dummy account should be ZERO.
(if not, it means HEADACHE OR REDO )
Please consult accountants for advice.
Does every line have the same document no.? Is every line the same currency?
Andrew
I followed your advice. and did that setting n the jounal template. I managed to make my psoting… unfortunately I dont see the numbers in the chart of accounts… why?
I followed your advice. and did that setting n the jounal template. I managed to make my psoting… unfortunately I dont see the numbers in the chart of accounts… why?