Journal Entry out of balance error when posting

cveale

I am using NAV 5.0 SP1

I imported in, using a dataport, a year's worth of GL history, a lot of line, and this error message comes up.

Document No. 2370 is out of balance by -7,148.09. Please check that the posting date, document type, document no. and amount are correct for each line.

Here are the lines.

post date doc no. acct type debit credit

10/31/03 2370 gl 7,148.09
11/01/03 2370 gl 7,148.09
10/31/03 2370 gl 14,320.55
11/01/03 2370 gl 14,320.55
10/31/03 2370 gl 7,172.46
11/01/03 2370 gl 7,172.46

Everything nets out to zero, I don't know why this error message is coming up. any ideas?

kapil4dynamics

On particular date against a document no.'s, if amount do not balance then u will get this message. Check that on same date, same document no. amounts are balancing or not.

cveale

They are balancing, but I found out the solution.

By default, NAV wants to balance by document number, i changed the sort to Posting Date and the journal posted fine.

dimus

There's a field "Force Doc. Balance" on the Gen. Journal Template table that is used to balance template by document no. and type.

kmcleod

Navision 4 SP1. I am getting this exact error, but sorting doesn't resolve the issue. The issue appears to be a credit memo which is being ignored. The user was able to print the check for the correct amount, but the batch will not post.

Payment Journals, selected Suggested Vendor Payments and printed checks (post & print) all checks printed. Only this one did not post, and is out by the amount of the credit memo.

Post Date Doc Type Doc No. Acc Type Description Dbt Amount Cred Amount
09/16/10 Payment 32922 Vendor Payment 140.00
09/16/10 Payment 32922 Vendor Payment 84.46
09/16/10 Payment 32922 Vendor Payment 168.60
09/16/10 Payment 32922 Vendor Payment 3,145.62
09/16/10 Payment 32922 Vendor Payment 13,632.21
09/16/10 Payment 32922 Vendor Payment 176.46
09/16/10 Refund 32922 Vendor Payment 228.00
09/16/10 Payment 32922 Bank Acc Check for ... 17,119.35

As you can see, both debit and credit columns total the same and do balance.

Can't change anything because the check is printed.

How to fix this one?

Thx,
Ken