[QODBC-Desktop] SP_REPORT BalanceSheetStandard report error "[QODBC] At least one field requested requires DateFrom to be set".
Posted by Jack - QODBC Support on 05 August 2014 01:38 PM
|
|
Troubleshooting: SP_REPORT BalanceSheetStandard report error "[QODBC] At least one field requested requires DateFrom to be set".Problem Description: I am running BalanceSheetStandard through VB Demo & It is returning below error. Solutions: I would like to inform you that as per QuickBooks you can't use “DateMacro = 'All'” and the field “AmountPreviousYear” same time. If you want to display the field “AmountPreviousYear” the parameter “DateMacro = 'All'” is not appropriate.
But when you choose the Dates as others expect “All”, the field “Previous Year” is enabled.
To resolve this issue either you have to remove field “AmountPreviousYear” from a query or you have to change the parameter “DateMacro” to others except “All”, such as “This month”. Please refer below query: | |
|