aaron0531
24th May 2007, 07:15
Hi,
in this report ,there is a field 'Open Item Bal.'.
Can anybody teach me what's the field means?

john1998
29th May 2007, 05:34
Open Item Balance is the balance of either the A/R (tfacr200) or A/P (tfacp 200) subledger. Some people call it either the creditors balance or the debtors balance.

You are comparing it to the balance in the G/L (tfgld106 and tfgld102) to ensure that there are no differences as the they should always be in synch.

mkannegu
30th April 2010, 15:58
Hi,
What to do to correct it, if they are not equal.
I did ran the Print control account checklist for a ledger account, and i see that there exists an open invoice in tfacp200 (in fact that invoice is already deleted (tfgld018 shows it as deleted) but the amount 255 has already posted to control account.
How to correct this.
Moreover, the open Item balance shown in this report is not equal to the opening balance in the print supplier balances by company for this financial supplier group.

Regards
Mahesh

Hitesh Shah
1st May 2010, 13:02
As indiacated earlier , this report shows difference between GL (tfgld102/6, acp/r005) on one hand and subledger (tfacp/r200) on the other hand.

U need to correct the records manually to eliminate inconsistency which led this differences like
1. run tfacp/r2245m000
2. change /delete of records (ledger,dates , period , amount,d/c,groups etc) in table through gtm