Knowledgebase
[QODBC-Desktop] Troubleshooting - How to add multiple Filter on Parameter in sp_report
Posted by Jack - QODBC Support on 23 June 2017 07:35 AM

Troubleshooting - How to add multiple Filter on Parameter in sp_report

Problem Description:

I am using sp_report through QODBC & I have noticed that using QuickBooks UI, we can add multiple TxnFilterTypes like 'Invoice,' 'CreditMemo,' and 'SalesReciept,' etc.

How can I add the same using sp_report through QODBC?

Solution:

You can use multiple TxnFilterTypes as below:

TxnFilterTypes='Check', 'Invoice,' 'CreditMemo'

For Example:

sp_report ARAgingDetail show Text, Blank, TxnType, Date, RefNumber, PONumber, Name, Terms, DueDate, Aging, OpenBalance parameters DateMacro = 'Today,' TxnFilterTypes='Check,' 'Invoice,' 'CreditMemo,' AgingAsOf = 'Today.'

 

 

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