The parameter and values detail for the Sales By Customer Detail Report lists the parameter value LastFiscalQuarterToDate as valid for the parameter DateMacro. Yet when I used the stored procedure with the following syntax:
sp_report SalesByCustomerDetail show TxnType, Date, RefNumber, Memo, Name, Item, Quantity, UnitPrice, Amount, RunningBalance parameters DateMacro = 'LastFiscalQuarterToDate'
.. in either VBDemo or VBScript connecting to QuickBooks via QODBC Version 7.00.00.204 I get the following error:
[QODBC] Expected lexical element not found: LastFiscalQuarterToDate
Is LastFiscalQuarterToDate not a valid parameter value? Is this a data issue? Please advise.
|