Unable to balance by Document Type in Journals

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