Sage Line 500 Aged Debtors/Creditors report

Sage Line 500 Aged Debtors/Creditors report

Didn't find your answer?

Can anyone tell me how to get these reports at the month end that agree to the nominal ledger control accounts?

We are closing the periods on, say, the 4th working day of the following month but transactions are being entered into the new period. As far as I can tell transactions such as a customer receipt in the next period removes that invoice from the aged debtors report. What am I missing?

Many thanks
Colin Dungey

Replies (3)

Please login or register to join the discussion.

avatar
By gradow
07th Apr 2006 11:28

Dump into exel
Hi
Thsi is messy but it does work and a slong as you have a reconciliation, should be acceptabel to auditors.
I used to dump the transactins into Excel and sort on "Date Entered" and "Account Type". This allowed me to work backwards to the month end NL balance.

Thanks (0)
avatar
By Bloater
07th Apr 2006 13:59

SAGE Aged Debtor Report
When preparing the report, enter your period end date, then tick the box which says "exclude later transactions" then you will have the correct details on the report.

HTH

Thanks (0)
avatar
By User deleted
10th Apr 2006 12:27

Thanks guys
Graeme

How do you pick up transactions that are no longer appearing ie paid at the beginning of the following month?

Benjamin

What version of Line 500 are you running? "exclude later transactions" is not an option in v5.60.1.6

Cheers

Thanks (0)