Troubleshooting - How do I run a Collections Report?

Problem Description:

How do I run a Collections Report?

Solution:

A typical Collections Report in QuickBooks looks like this:

With QODBC, the same report can be generated using stored procedure reports like this:

sp_report CollectionsReport show Text, Blank, TxnType, Date, RefNumber, PONumber, Terms, DueDate, Aging, OpenBalance parameters DateMacro = 'Today,' AgingAsOf = 'ReportEndDate.'