Hello,

We have a problem with our bank balances whereby the figure given when entering tfcmg2101s000 is incorrect.

We believe that this figure should match our closing balance on our Bank Account in the ledger history.

Can anybodyt tell me how the figure in Maintain Bank Balances is calculated ?

I have tried running tfgld3203m000 to rebuild the history in the suspect period but that has no effect.

Thanks
Neal Matthews
Intier Automotive - IT Support Analyst

Solved my own problem I think.

I think I'm right in saying that the Bank Balance is calculated from
tfgld201 and tfgld203.

The problem appears to be occuring due to the missing value being posted in another currency when the account in question should be reserved for the home currency.

You may be correct in your situation.

I have observed another situation where inconsistencies in
Amount roundings due to customized updates of Amount fields
cause this situation.Very rare though.

No the difference is very minor and I've tracked down the problem transactions.

Finance just need to post a credit about the bank ledger code to get the bank balance correct again.

Cheers
Neal

Hi Neal

The problem relates to the fact that the actual Ledger Account Balance is probably made up of different currencies whilst the Opening Bank Balance on the Cash Transaction purely relates to the currency connected to that bank account.

If you print out the report Trial Balance by currency for the ledger account you should see the amounts in the different currencies and the balance being selected for the Cash Transaction.

Unfortunately there is not a solution to this.

Regards

Colin