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_reportProblem 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'
| |
|
Comments (0)