Author Topic: Transaction Query returns 0 records with Ordinary Expenses as AccountTypeFilter  (Read 2303 times)

mikekurm@wienerminder.com

  • Member
  • *
  • Posts: 13
I know my Quickbooks has "Ordinary Expenses" because the filter works in QBs Custom Detailed Report. The following is what return no records.

PCQB_ZExecute( "" ;
"<TransactionQueryRq>
     <TransactionDateRangeFilter>
          <DateMacro>ThisFiscalYear</DateMacro>
     </TransactionDateRangeFilter>
     <TransactionAccountFilter>
           <AccountTypeFilter>OrdinaryExpense</AccountTypeFilter>
     </TransactionAccountFilter>
</TransactionQueryRq>"
)

What is returned is:
CODE: 1
SEVERITY: Info
MESSAGE: A query request did not find a matching object in QuickBooks

It returns data with using CostOfSales and a bunch more but not expense AccountTypes. ANY HELP IS GREATLY APPRECIATED.

Chris

  • God
  • Member
  • *****
  • Posts: 83
Perhaps there are no transactions that meet the query criteria?