Report Designer: Aged Debtors

[samij]

Hi there,

Does anyone know if its possible to add 150 Days and 180 Days to an Aged Debtors report.
Basically I need an Aged Debtors report with aging periods 30 / 60 / 90 / 120 / 150 / 180 / Older

Thankyou.

[brucedenney]

The aged function is done using a variable provided.

You can change the date ranges, but the number of ageing groups are fixed.

You can also write reports that can calculate the age of a debt and group them.

I recently did a report for someone who wanted to know not the age of the debt but the age of the debt beyond the agreed credit terms.

[samij]

So there is no way to add 150 & 180 days to the default ageing report in Sage which already has 30 - 60 - 90 - 120+ Days?

[brucedenney]

You can change the ageing periods.
So the first one could be 0 - 120 the second 120-160 and so on.
You can not add extra periods.
You can calculate ageing in variables in reports "manually"

[samij]

I'm trying to create a variable to calculate 150 days, been trying a few calculations but so far haven't managed to get one working.
Have you got an example ? or is that too much to ask for ?

Thankyou

[brucedenney]

Bit hard without knowing what sort of report it is, perhaps you might like to post what you have done so far, you can attach reports to postings using the upload attachment options.

This is the sort of thing you want...

(Now() - AUDIT_HEADER.DATE) >= 150 ?(Now() - AUDIT_HEADER.DATE) < 180?AUDIT_HEADER.OUTSTANDING:0:0

English translation:-

(Now() - AUDIT_HEADER.DATE) is the "age of debt"

If the "age of debt" is greater than or equal to 150 then if the age of debt is less than 180 then set the value to the outstanding amount on this transaction else set to zero else set to 0