Small and medium business | Business Central, N...

Ideal way to import Opening Balances of G/L account in fresh Company.

(0) Share

Report

Posted on by Inkey Solutions

2,100

Hi all,

I'm trying to import op. Balances of G/L account , but when I'm trying to post the entries it gives me an error with says, that this " Document no. is out of balance please check posting date, document no. document types and amounts are correct"

Please note I'm not inserting any G/L balance account no.

Can anyone help me with the same.

Reference links will be appreciated.

Thanks in advance.

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

Hi Inkey Solutions ,

I will recommend please create any Dummy GL account No. to import the opening balances and put that in Balance Account No. while posting, without this I dont think system will allow you to post the data.

Thanks.

Was this reply helpful? Yes No
Suggested answer

divyeshchitte 968 on at

Like (0)

Report

Hi Inkey Solutions,

You Might be doing dual entry with two lines for the uploading the Balance.

Please try to enter Journal in same line

Where you can use Account Type , Account No., Bal Account Type and Bal. Account No.

I have attached one demo entry in below screen shot

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (1)

Report

I disagree with Nitin about setting up a dummy balancing account, though his method will work, it’s just not necessary and makes double the number of general ledger entries that you need and will never be used. The error you’re getting is because you have to have document numbers balanced by date. If you make your document number something like BEGBAL for all the entries they will post just fine.

Was this reply helpful? Yes No