A typical A/R Aging Summary Report looks like this:
Note: It's easy to get confused here, in QODBC Today often means your system date, while in QuickBooks Today means the QuickBooks date. So when looking at the QuickBooks sample files, or company files that use a QuickBooks date and not the system date, or report dates other than the system date, you often need to use ReportEndDate
With QODBC the same report can be generated using stored procedure reports like this with AgingAsOf = 'ReportEndDate' to match the future aging date of December 17, 2007:
sp_report ARAgingSummary show Text, Label, Current, Amount_1 as "1 - 30", Amount_2 as "31 - 60", Amount_3 as "61 - 90", Amount_4 as "> 90", Amount_5 as TOTAL parameters DateMacro = 'Today', AgingAsOf = 'ReportEndDate'
|