Unable to balance by Document Type in Journals

roland

Hi all,

My client ran into a problem in their Cash Receipt Journal and just wanna know if anyone else here has encountered the same thing and if any solutions are offered .


They created a cash receipt journal batch and the document number is the same for all the journal lines.

Customer A Payment -100
Customer B Payment -200
Customer C Payment -300
Customer D Payment -400
Customer E Refund +200
Bank F Payment +800

However when they ran the test report in Navision it came out something like this:-

Customer A Payment -100
Customer B Payment -200
Customer C Payment -300
Customer D Payment -400
Warning! Payment "Doc. No." is out of balance by -1000
Customer E Refund +200
Warning! Refund "Doc. No." is out of balance by 200
Bank F Payment +800
Warning! Payment "Doc. No." is out of balance by 800


When I try to simulate it at Cash Receipt Journal, I don't get any warnings and I managed to post succesfully! But when I tried to do the same at Payment Journal as below, I get a similiar problem as my client.

Vendor A Payment +100
Vendor B Payment +200
Vendor C Payment +300
Vendor D Payment +400
Vendor E Refund -200
Bank F Payment -800

Any idea what's wrong? Thanks in advance!

Rgds

diptish.naskar

Try to delete the Journal and recreate it again...then run the test report.

Sapphire123

Hi All,

I ran into a similar problem described by this earlier post. Deleting the journal and recreating it did not solve the problem:

On the cash receipt journal, the following entries are made:
line 1: payment docnum1 customer10000 -100.00 applied to an invoice
line 2: payment docnum1 customer20000 -200.00 applied to an invoice
line 3: refund docnum1 customer10000 +50.00 applied to credit memo
line 4: payment docnum1 bankGIRO +250.00

In test report the following errors are received:
line 1: ----
line 2: ----
Warning! Payment docnum1 is out of balance by -300.00
line 3: ----
Warning! Refund docnum1 is out of balance b -50.00
line 4: ----
Warning! Payment docnum1 is out of balance by 250.00

How can you enter refunds & payments together in one cash receipt journal, and also have a single bank balancing line?

Thanks!

ara3n

You can temporary uncheck in Gen. Journal Template table the field "Force Doc. Balance"