Knowledgebase
[QODBC-Desktop] Troubleshooting - How do I run a Collections Report?
Posted by Jack - QODBC Support on 04 January 2017 11:04 AM

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'

(0 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).