Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
AR Aged Trial Balance Report
- Thread starter Didagk
- Start date
Jay Converse
Programmer
AROBL, AROBLO, AROBP. Join them with their keys.
- Thread starter
- #3
Jay Converse
Programmer
AROBLJO? You have optionals on your detail lines? That's unusual, you must be running the Job Cost module, too. So yes, those will work.
- Thread starter
- #5
Jay Converse
Programmer
Maybe ARCUS. But I don't have the customer's requirements in front of me. You haven't said why the stock aging doesn't work.
FWIW, you're in for a complicated bit of Crystal to do this, you have to do a left-outer join to AROBP in case there are no payments, and exclude them when they are past the cut-off date.
FWIW, you're in for a complicated bit of Crystal to do this, you have to do a left-outer join to AROBP in case there are no payments, and exclude them when they are past the cut-off date.
- Thread starter
- #8
Jay Converse
Programmer
There is no table. You have to do the math yourself.
Here's what I do for special AR aged reports:
I run a macro to generate the aging in the ARAGED table (easy to record). I then run an SQL update query to copy the relevant data (optional field or any other field) into the SORTVALUE1 field. My macro then prints the AR aged report sorted on field 1... voila! Friggin easy as pie, no need to reinvent the wheel thingy.
I run a macro to generate the aging in the ARAGED table (easy to record). I then run an SQL update query to copy the relevant data (optional field or any other field) into the SORTVALUE1 field. My macro then prints the AR aged report sorted on field 1... voila! Friggin easy as pie, no need to reinvent the wheel thingy.
- Status