Accpac Daily AR Totals

[Greggpb88]

I was wondering if anyone could help me,

I am to get the daily AR Balance for a customer for the past year, I have looked at building query from AROBL but is has turned our quite complex, if there a function or shortcut ?

Kind regards
Gregg

 

[ettienne]

Nope, you need to do it the old fashioned way.

Sage 300 ERP Certified Consultant

http://www.adssglobal.net

 

[Greggpb88]

Thanks will keep hammering on, is AROBL the right table to be quering ?

 

[ettienne]

That be the one and only table to query.

Sage 300 ERP Certified Consultant

http://www.adssglobal.net

 

[DjangMan]

I use AROBP in my calculations. I ran SQL traces when generating the AR aged trial balance to see what Sage was doing. That allowed me to re-create the aging engine.

Another option is to run the aging view via automation and then read the contents of the ARAGED table. Then you don't have to re-create anything and you'll always match up with Sage's report.