Hello,
I have a question regarding a custom report that our users have requested. They want to be able to select a payment batch number from a check run, and get a report telling them the following information: check number, amount, supplier, ledger account. They need to know where each check amount was applied, such as inventory, fixed assets, insurance, commissions, leases, taxes, etc.

My question is this: Is there a link between the check master and the tfgld tables that keep the ledger account information?
I'm having trouble finding a way to pull all of this data out of Baan.

Thanks for any help.
I'm pulling my hair out over this one.

Hi Sandy,

you might want to check the relation between the tfcmg110 and the tfgld106 tables.
this should give you most of the data you are looking for.

Cheers
Little John