AR Aging Data

[mdewis]

I am looking to produce an AR Aging Report for our entire company which consists of many Accpac (v5.4) databases and many different companies set up on many different servers. I am thinking the approach to do this is to query the ARAGED table using an ADO / ODBC connection which I have been able to set up.

It appears the ARAGED table populates once someone runs an AR Aging Report. Is this correct? If so, I guess this would mean someone would have to run the AR Aging Report for each Accpac Company prior to accessing the data...correct?

Are there no other tables that have the AR Aging data readily available without the need for running reports?

I just want to be clear that I am looking in the right direction.

 

[Jay Converse]

You need the Insight Consolidations add-on product.

 

[mdewis]

I don't really have a budget for this project so I have to code it myself. Can anyone confirm if the statements in my approach are correct.

Much Appreciated,
Mike

 

[Jay Converse]

You're looking in the right direction, but you're also being penny-wise and pound-foolish.

 

[mdewis]

I am using our Upstream Weblink program and grabbing this data and bringing it into HFM. I modified our GL Pull script and was able to do it relatively easily (I am surprised too).

 

[DjangMan]

Record a macro while you generate the aging report and then study the cashflow.avb macro. The cashflow macro will show you how to run the aging routine and dump the results to an external file. Then you can do your consolidation manually after that.

 

[mdewis]

Thanks Djangman. So no matter what, I have to run the report in Accpac prior to accessing the data as running the report is what populates the table...correct?

Thanks.

 

[DjangMan]

Not necessarily. The AR aging view has an option whereby it can export the results of the aging to a temporary file. Once the file is generated you can ask the view what the file name is and then you can grab the file and process it as you need (import into Excel, send to another program, etc). So you aren't running the report but instead you'll want to run the view that generates the data that the report looks at.

 

[mdewis]

Ok...I understand. So an action has to be taken in Accpac to process the data before an external pull can be done in order for the data to be there?