Knowledgebase
[QODBC-Desktop] How to run an ARAging Summary Report in QODBC
Posted by brad waddell on 12 March 2009 05:21 PM

Typical A/R Aging Summary Report in QuickBooks

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

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

(208 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).