Cannot post my entries!!! What to do?

Get our Free Newletter

Don't you have the time to be online here at DUG every day? So how do you follow what is going on in the Dynamics industry and community?
If you subscribe to the DUG Newsletter then you can relax! We will make sure that you don't miss the big news!

Check out our
Newsletter Subscription Center
page a complete list of our different newsletters.

Not Answered This post has 0 verified solutions | 17 Replies | 1 Follower

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

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
786 Points
Joined: 2011-3-14
Last Online:
2013-1-15 9:06
Location: Sydney
Rics replied on 2011-4-27 9:19

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

Cheers,

Rics newbie in NAV

Male
847 Posts
12,413 Points
Joined: 2000-10-26
Last Online:
2014-8-25 9:23
Location: Faroe Islands
Anfinnur replied on 2011-4-27 9:33

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.

Female
46 Posts
1,058 Points
Joined: 2011-1-20
Last Online:
2011-5-16 11:35
Location: Limassol, Cyprus
Tatiana replied on 2011-4-27 9:41

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

Female
46 Posts
1,058 Points
Joined: 2011-1-20
Last Online:
2011-5-16 11:35
Location: Limassol, Cyprus
Tatiana replied on 2011-4-27 9:47

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

Male
112 Posts
1,885 Points
Joined: 2006-7-9
Last Online:
2013-11-30 14:31
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)

Female
46 Posts
1,058 Points
Joined: 2011-1-20
Last Online:
2011-5-16 11:35
Location: Limassol, Cyprus
Tatiana replied on 2011-4-27 10:25

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

Female
46 Posts
1,058 Points
Joined: 2011-1-20
Last Online:
2011-5-16 11:35
Location: Limassol, Cyprus
Tatiana replied on 2011-4-27 10:45

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?

70 Posts
786 Points
Joined: 2011-3-14
Last Online:
2013-1-15 9:06
Location: Sydney
Rics replied on 2011-4-27 12:28

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

Male
1,432 Posts
38,765 Points
Joined: 2007-3-2
Last Online:
2014-5-13 19:42
Location: Houston, TX, USA
DynamicsNAVMVP
Moderator
Matt Traxinger replied on 2011-4-27 14:40

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.

Female
46 Posts
1,058 Points
Joined: 2011-1-20
Last Online:
2011-5-16 11:35
Location: Limassol, Cyprus
Tatiana replied on 2011-4-27 14:53

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

4,905 Posts
125,453 Points
Joined: 2009-2-17
Last Online:
2014-9-2 18:51
Location: Hyderabad, India
DynamicsNAVMVP
Moderator
Mohana replied on 2011-4-28 7:45

Was the document no same in both the lines?

 

Male
847 Posts
12,413 Points
Joined: 2000-10-26
Last Online:
2014-8-25 9:23
Location: Faroe Islands
Anfinnur replied on 2011-4-28 9:42

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.

Male
847 Posts
12,413 Points
Joined: 2000-10-26
Last Online:
2014-8-25 9:23
Location: Faroe Islands
Anfinnur replied on 2011-4-28 10:07

...

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.

70 Posts
786 Points
Joined: 2011-3-14
Last Online:
2013-1-15 9:06
Location: Sydney
Rics replied on 2011-4-28 14:41

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

Page 1 of 2 (18 items) 1 2 Next > | Get this RSS feed | Bookmark and Share