[QODBC-Desktop] SP_REPORT ProfitAndLossBudgetPerformance is returning no rows.
Posted by Jack - QODBC Support on 05 August 2014 01:45 PM
Troubleshooting: SP_REPORT ProfitAndLossBudgetPerformance is returning no rows.
Problem Description 1:
I am running ProfitAndLossBudgetPerformance through MS Query & It is returning no rows. But using QuickBooks UI I am able to get records from ProfitAndLossBudgetPerformance report. I am executing below query:
<?xml version="1.0" encoding="ISO-8859-1"?>
Problem Description 2:
Is there any way to have a date prompt in this stored procedure instead of a fixed fiscal year? I am running the query into Excel using Microsoft Query. It appears to give me information regarding the current month (i.e. February info since this is the month of February) for the fiscal year identified in the parameters. Is there any way I can replace FiscalYear with a FromDate and ToDate parameter?
As per QuickBooks SDK the parameter "FiscalYear" is required in ProfitAndLossBudgetPerformance report. So there is the parameter "FiscalYear" missing in SQL statement. After including required parameter you can get all records from ProfitAndLossBudgetPerformance report. Please refer below query: