Make a formula for A/R ageing

[jmd0252]

OK guys,, I am using Crystal XI, release 2. It has functions for the standard A/R ageing,, I need the syntax, on how to use them. I need to create several formulas and add the invoice amount into the correct field, based on the ageing,, pretty standard stuff,, but I do not know how to use the function.. Any help is appreiciated..

 

[DataDog]

You might understand what "A/R" is but that accronym means nothing to me. But since you say "It has functions for the standard A/R ageing", I would suggest that you hit F1 and poke around the on-line help files

DataDog
If God wanted us to count in Hexadecimal, then why did he only give us A fingers?

 

[dgillz]

To age a record, you would write a formula like this:

If {Documentdate} In Aged0to30Days then {Amount} else 0

Write similar formulas for all the aging buckets you need.

The problem with an AR Aging report is that there are typically 2 records, an invoice and a payment. The invoice may be 45 days old, and the payment 1 day old. So when you age the transactions, you have to group the transactions and age both of them on the invoice date. This is going to require the use of variables, and a very seasoned crystal report designer.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[jmd0252]

OK been there done that,,, I am getting an error,,, the formula checker highlights Aged0to30Days,, and says
A string is required here.????

See below:
If {AR_TRANSDETAIL.INVOICE_DATE} In Aged0To30Days
then {@due} else 0

@due is a formaula based on the addition of original amt due, and payment amounts.

Suggestions?????

 

[lbass]

You are in the wrong forum. Please post in forum149 or forum767. You also will need to identify the datatype of your date field,, and show the content of {@due}.

-LB