Cannot post my entries!!! What to do?

Not Answered This post has 0 verified solutions | 5,258 Views | 17 Replies | 1 Follower

Female
46 Posts
403 Points
Joined: 2011-1-20
Last Online:
2011-5-16 11:35
Location: Limassol, Cyprus
Tatiana posted on 2011-4-27 9:16 rated by 0 users

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?

All Replies

70 Posts
577 Points
Joined: 2011-3-14
Last Online:
2013-1-15 9:06
Location: Sydney

Simply means your opening entries doesn't balance on CR and DR sides. 

Cheers,

Rics newbie in NAV

  • | Post Points: 7
Male
914 Posts
10,620 Points
Joined: 2000-10-26
Last Online:
2016-2-8 10:19
Location: Faroe Islands

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.

  • | Post Points: 5
Female
46 Posts
403 Points
Joined: 2011-1-20
Last Online:
2011-5-16 11:35
Location: Limassol, Cyprus

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 =(

  • | Post Points: 5
Female
46 Posts
403 Points
Joined: 2011-1-20
Last Online:
2011-5-16 11:35
Location: Limassol, Cyprus

Anfinnur, thank you. I dont clearly understood where to find this sorting in order to change it?

  • | Post Points: 6
Male
113 Posts
1,295 Points
Joined: 2006-7-9
Last Online:
2015-3-12 11:53
Location: Riyadh, Saudi Arabia

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)

  • | Post Points: 6
Female
46 Posts
403 Points
Joined: 2011-1-20
Last Online:
2011-5-16 11:35
Location: Limassol, Cyprus

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.... =((((

  • | Post Points: 6
Female
46 Posts
403 Points
Joined: 2011-1-20
Last Online:
2011-5-16 11:35
Location: Limassol, Cyprus

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?

  • | Post Points: 6
70 Posts
577 Points
Joined: 2011-3-14
Last Online:
2013-1-15 9:06
Location: Sydney

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.... @_@ .. 

Cheers,

Rics newbie in NAV

  • | Post Points: 6
Male
1,432 Posts
32,546 Points
Joined: 2007-3-2
Last Online:
2014-5-13 19:42
Location: Houston, TX, USA
DynamicsMVP

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.

  • | Post Points: 6
Female
46 Posts
403 Points
Joined: 2011-1-20
Last Online:
2011-5-16 11:35
Location: Limassol, Cyprus

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

  • | Post Points: 6
5,129 Posts
117,398 Points
Joined: 2009-2-17
Last Online:
2016-2-10 9:45
Location: Hyderabad, India
DynamicsMVP
ModeratorDynamicsNAV

Was the document no same in both the lines?

 

  • | Post Points: 6
Male
914 Posts
10,620 Points
Joined: 2000-10-26
Last Online:
2016-2-8 10:19
Location: Faroe Islands

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.

  • | Post Points: 7
Male
914 Posts
10,620 Points
Joined: 2000-10-26
Last Online:
2016-2-8 10:19
Location: Faroe Islands

...

Tatiana:
go to the View-> Sort->
...

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.

  • | Post Points: 6
70 Posts
577 Points
Joined: 2011-3-14
Last Online:
2013-1-15 9:06
Location: Sydney

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. 

Cheers,

Rics newbie in NAV

  • | Post Points: 6
Page 1 of 2 (18 items) 1 2 Next > | Get this RSS feed