We need a multi company Aging Report and want to create it in Sage Intelligence reporting.  I am assuming I cannot use the A/R Aging work file as it only works when run in Providex. Right?  I did try that file in SI and came up with no data.  I am not surprised, but was hoping it would work.

I am thinking this is going to be an advanced skills report, needing several tables.   I know I need the Customer Table, the Open Invoice Table, and the Payment Transaction file.   It sounds fairly complicated and the CFO may just want to use the canned Crystal report.  

Any ideas?

Thanks!

Paula