Typical A/R Aging Summary Report in QuickBooks

Note: It's easy to get confused here. QODBC Today often means your system date, while 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

Report Displayed in QODBC

Stored Procedure Command

      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'

Display in QODBC