Does anyone have any finance documentation on reconciling subsidiary ledgers.

Currently I am trying to reconcile A/P control Balance (from Control Account Checklist, tfacp2415) with Supplier aging summary, tfacp3425) and the two are significantly off.

Any suggestions?

you are looking at the right sessions for the reconciliation.

from my experience i can say that the gld figures should be taken as the base for corrections.

the errors are generally in the assignment type of transactions in the tfacp / acr 200 tables.

also the checklist report may show some errors even if everthing is alright. for ex. changing the FSG, FCG and hence the discrepancy in the report.

try to mirror the gld entries in tfacp / acr 200 tables.

then you can run rebuild supplier / customer balances session to correct the open amounts.

I ran session tfacp2245, a report generated, but I don't know what it means.

I reran my earlier reports and nothing changed.

What do you mean by "the errors are generally in the assignment type of transactions in the tfacp / acr 200 tables."


What is FSG, FCG, and how do I change them.

Hi Jack -

FSG is Financial Supplier Group - it is the one that would pertain to your AP balancing.

FCG is Financial Customer Group - it would apply to AR balancing.

These provide the ability to drive your transactions to different control accounts.

What version of Baan are you running?

Regards,

Linda

BaaN 4c2 with Supply chain.

The implementors of customers and venders never informed me of FSG or FCG.

Hi Jack -

We are on version 4c2, but no Supply Chain.

To view your financial customer group setup, go to Accounts Payable - Master Data - Inquiries - Display Financial Supplier Groups. If you then select one, go to Application, and then select Display Ledger Accounts by Supplier Groups, you can see what the control account is for each, if you have more than one.

The financial supplier group is on each supplier, I believe near the bottom of form 3.

Hope this gives you some insight!

Regards,
Linda

How do I resolve my prior problem?

What do you suggest.

i hope you meant report tfacp2415m000. This report lists difference between gld102, 106 v/s acp200 data. This report can identify transactions which have not been updated correctly in these tables.

Based on the output of the report you can start verfiying the tables and take corrective action.

One of the major reasons of differences between supplier balances as reflected by ledger accounts in the trial balance and the balances as reported by the acp reports are assignment type of transactions. These transaction type (tfacp200.tpay) refer to assigning open advances / unallocated sums to open invoices.

Nextly one should also take care of FSG / FCG changes because the tfacp2415m000 report may show differences which actually may not exist. So first tally the total difference shown by the tfacp2415m000 report v/s trial balance figures and then decide the course of action

Try reconciling with the detail aging (tfacr2420m000) . There have been several solutions toboth detail and summary aging report.

I tried, that doesn't even tie to its own summary report.