Journal Entry out of balance error when posting

Business Central/NAV User Forum
1

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?

2

Hi Craig,

Where did you import the data into? Have you checked for different currencies?

3

I imported the data into the General Jouranl Line Table.

All of the currencies are the same.

I can’t see why the error is coming up.

4

Hi Craig,

Nav is expecting that the document to balance on a posting date. It look for balancing line sequencially so if you sort your import/journal by posting date it should post.

5

Hi Craig,

You can also filter by date and it should post for you.

6

DaveT, thank you very much. I sorted the journal by posting date and it worked perfect !!! Thank you for your help.

7

Gald to Help [:D]

8

Hi Dave

In continuation with the email thread, i am facing the same issue on a General Journal line. This came from LS Retail ICT process. There are only 3 lines of the same document number, date and line no is sequential.

But when i try to post, the system says that Document is out of balance by 736. check the posting date, document type etc…

Microsoft Dynamics NAV Classic

Document No. S02-MZ-P01-347593 is out of balance by 736. Please check that Posting Date, Document Type, Document No. and Amount are correct for each line.

OK

When i try to enter the same rows manually on the Gen. Jnl line with the same values, its posting correctly.

Thanks

Gen. Jnl Line.jpg
Gen. Jnl Line.jpg1167×87 51.7 KB

9

The err msg says clearly:

DocType is different in your lines…

10

Dear Chaig,

Please Check Posting Date.

Your Posting dates are different.

Posting date should one particular date for the one Document No.

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

Thanks & Regards

Swati Chauhan