--- In vantage@y..., "innerpac_il" <mark_smith@i...> wrote:
company configuration module. I believe there are 6 fields that you
can define. For example I use -1 in the first field to indicate
future monies, then 0 in the second field to indicate current $, then
9 to indicate 10 days old in the third field, then 19 to indicate 20
days old, etc. The only restriction is that the parameters you enter
into the fields must increase in value from left to right. You would
create the ranges by the previous field and the next field entries.
Since you only want three ranges you probably could use large
negative numbers to keep the first three fields empty. These settings
can be changed as many times as you want. There is one final note:
you would also need to decide how you will be viewing the report
(aged as of invoice date, or aged as of due date) as that will define
what value your parameter is. My example assumes that the report
views the aging by due date.
Hope this helps.
Chris Figures
Eck Plastic Arts Inc
> Does anyone have a aged receivables report that outputs receivablessimilar
> in 1-30, 30-60 and 60-90 days? I am trying to write a report
> to the canned progress aged receivables that comes with Vantage.Hi, you can change the canned report that comes with vantage in the
>
> Thanks
company configuration module. I believe there are 6 fields that you
can define. For example I use -1 in the first field to indicate
future monies, then 0 in the second field to indicate current $, then
9 to indicate 10 days old in the third field, then 19 to indicate 20
days old, etc. The only restriction is that the parameters you enter
into the fields must increase in value from left to right. You would
create the ranges by the previous field and the next field entries.
Since you only want three ranges you probably could use large
negative numbers to keep the first three fields empty. These settings
can be changed as many times as you want. There is one final note:
you would also need to decide how you will be viewing the report
(aged as of invoice date, or aged as of due date) as that will define
what value your parameter is. My example assumes that the report
views the aging by due date.
Hope this helps.
Chris Figures
Eck Plastic Arts Inc