SageForum for UK versions of Sage 50- Help and support.

Hello Newbie here, well with sage reporting

My manager would like to export age debtors analysis to Microsoft Excel via odbc, i'm done the odbc bit but don't understand the accounting terms can anyone offer any assistance.

Regards

Barry

The analysis is a summary of a whole load of transactions.

If you look in the Audit Header table you will find a bunch of fields AGED_CURRENT, AGED_30, AGED_60, AGED_90, AGED_OLDER, these are added together for each ACCOUNT_REF to summarise the data into the aged debtors report.

Hope this helps