Knowledgebase: TroubleShooting
[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.

When I run this query as the following in VB Demo, it will report error "[QODBC] At least one field requested requires DateFrom to be set" sp_report BalanceSheetStandard show Text, Label, Amount, AmountPreviousYear parameters DateMacro = 'All', SummarizeColumnsBy = 'Day', ReturnColumns = 'All'  

http://support.flexquarters.com/esupport/newimages/BalanceSheetStandard/Step1.png

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.

You can verify the same by running the same report through QuickBooks & choose DateMacro to All and you will notice that Previous Year options are disabled.

 

http://support.flexquarters.com/esupport/newimages/BalanceSheetStandard/Step2.png

 

But when you choose the Dates as others expect “All”, the field “Previous Year” is enabled.   

http://support.flexquarters.com/esupport/newimages/BalanceSheetStandard/Step3.png

 

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:

sp_report BalanceSheetStandard show Text, Label, Amount parameters DateMacro = 'All', SummarizeColumnsBy = 'Day', ReturnColumns = 'All'

sp_report BalanceSheetStandard show Text, Label, Amount, AmountPreviousYear parameters DateMacro = 'ThisMonth', SummarizeColumnsBy = 'Day', ReturnColumns = 'All'

Please refer below mentioned article. You can get detailed information about how to execute sp_report in QODBC:

How to use the QuickBooks Reporting Engine with QODBC

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