Error in posting payment journal in relation to Bank Reconci

preethishaji

while doing the Bank reconciliation, I adjust the statement lines and transfer some new entries which are presented only in Bank Statement and not present in our ledger. When I try to post the payment journal with these new entries , an error saying "Document No. BPDD111950 is out of balance by -86,980. Please check that Posting Date, Document Type, Document No. and Amount are correct for each line." is displaying . can any body tell a solution for this...

Thanks in Advance..................

mohana_cse06

Sum of amouts should be zero in document wise in journals..
so as per the error message sum of amounts is not zero in Docuemnt BPDD111950.

Please check debit and credt values and bal.account type

preethishaji

Thanks...

This amount came to the payment journal through Bank reconciliation--Transfer to General Journal. This -86980 is the total of -26,750.00,-20,000.00,-12,300.00,-21,796.00,-6,134.00 entered in the statement amount column of Bank reconciliation form.So in the Gen. Journal Line table the amount column and Balance amount column shows the above amounts and the debit column is blank and the credit amount column shows the +ve of the above amounts. Balance account type is 'G/L Account'.

So what i have to do .........

ssingla

Transfer to General option does not select/define "Bal. Account No." and user needs to select the same. Ask the accountant to enter the required accounts.

preethishaji

Thanks...

It's working fine now......Thanks a lot...

preethishaji

Is there any easy method in Navision to compare the values in the statement received from the bank and the system's bank account.Does it needs manual checking by tick marking each entry.

can any body help me.....

ssingla

You can customize the automatic application.