hi,

i am facing problem in Account payable of mismatching of Amount.

Actually in trial balance , AP is coming greater then AP thru Aging analysis (Supplier). There is very big difference in amount. trial balance is showing larger amount outstanding in Account payable in comparison to Supplier Aging Analysis Report.

Can someboy help me in Checking & rectifing the problem. How i can rectify it. It is very urgent as i am stuck here and auditers are after my life.

veyant:(

Try running your control account checklist, this could indicate where the problem is, report code is tfacp2415m000.

It is showing only appox. 3 lacs rs. difference in one ledger acc. of account payable but according to aging analysis, it is coming appox. 64 lacs.

Can somebody help in how i can check the differernce.

veyant

Hi,

I had faced this kind of problem previously. I had run the following sessions: Rebuild ledger History (tfgld3203m000) and the Recalculate open entries (tfcor0260m000) and I was able to solve the problem. I am not sure if this will solve your problem also. If your problem is nt solved after running the 2 sessions then the only way is to look at the individual transactions in tfgld106 and tfacp200. (generally the problem is in tfacp200 - the 'Amount', Amount in Invoice currency' and 'Amount in home currency' fields). Run a query to dump the data of tfacp200 as a report for analysis.

Note: Rebuild ledger history takes quite a lot of time to run and resets opening balances to zero if you havnt closed the last financial year finally. You have to run the session Close year (provisional) to get back the opening balances for teh current year.

Hope this is of help to you.

Regards

RA

Sorry, its not working. still same mismatch.

Aging Analysis is showing rs. 2.8 crore as balance Account payable where as trial balanec is showing 3.4 crore in account payable ledger accs.

can anybody help me in undertanding why mismatch is coming. i rebuild the history. i tried for recalculate Supplier Balance but no solution. Can somebody let me . Againg analysis is based on which tables and trial balance on which tables.

its very urgent.

veyant

The aging is based on table tfacp200 and the TB on tfgld201 etc. Try printing finalised transaction for your control account and comparing the transactions to your aging to make sure everything is the same.

Make sure that all batches for the period are finalized.

still not able to find the mismatech. Checked the control account list, it is showing a diffrence of Rs. 3.8 lacs only which is almost 7 % of the whole difference amount. Aslso tried to rebuild history and Recalculate Supplier Balances but still no differnce.

Also checked the tfacp Home currency & INV currency fields, no problem found.

Can somebody has anyother solution.
I have auditors & management both on my head.

will somebody help me. MY IBTR account is also +ve which generally should be negative. is there any relation in ITBR & this problem.

Waiting for a quickest response..

veyant

still not able to find the mismatech. Checked the control account list, it is showing a diffrence of Rs. 3.8 lacs only which is almost 7 % of the whole difference amount. Aslso tried to rebuild history and Recalculate Supplier Balances but still no differnce.

Also checked the tfacp Home currency & INV currency fields, no problem found.

Can somebody has anyother solution.
I have auditors & management both on my head.

will somebody help me. MY IBTR account is also +ve which generally should be negative. is there any relation in ITBR & this problem.

Waiting for a quickest response..

veyant

Hi,

Did you check Baan Online Support for solutions?
For example: solution 121629.
Or has this one been installed aleady?

GN

Have you checked all the simple things

Like all transactions being finalised
Any stuck batches etc.

In the chart of accounts does the parent have the correct children and are "families" nested correctly. If these are set up incorrectly the total of a parent account will be wrong.

These may not be the answer but sometime we look for the solution in a dark corner when it was in broad daylight all along.

P

Hi,

Pls let me know if Ur problem is solved. Otherwise try this:

1) Print the check list for each financial supplier group

2) Check whether the finalised / non finalised balances tally with ur trial balance

3) If they dont reconcile for each supplier group

4) If they do check whether the acp balances tally.

5) If it doesnt then take the print out of the session tfacp2434m000 (print supplier total balances) and reconcile by supplier group

6) Once U tally these two then U can tally this report with the aging analysis

There could be other ways of solving this problem but this approach has helped me.

Regards

Sai Krishna

Hi,

I think you are taking a too technical approach to the problem Yes, all these steps will certainly help you find out the difference. Trial balance is the summation of all finalized transactions + Opening balance. And the real comparision lie between the tables tfacp200 & tfgld106. This is what the control account checklist does.

But did you check out for the most common 'accountant's mistake'? ie, Journal vouchers in the creditors control accounts? It is quite possible that the users could have tried to reverse some transactions by passing a JV instead of Debit/credit note which populates both GLD & ACP. But a JV has a single sided effect. It does not populate the ACP tables, and not shown in the control account checklist, either.

Also look out for any direct payment in bank (not using check payment route), using 'journal' transaction type instead of "supplier transaction" type. Check for the corresponding debit account being a creditors control account.

Run tfgld1406m000 for the control account, selecting only the above transaction types. This is certainly not there in your aging report.

Please do let me know this helped you.

Regards