Author Topic: Transaction Query returns No records- Ordinary Expenses as AccountTypeFilter  (Read 1549 times)

mikekurm@wienerminder.com

  • Member
  • *
  • Posts: 13
Last Posted incorrectly. 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.

Geoffrey Gerhard

  • Guru
  • Member
  • ****
  • Posts: 468
Are there any restrictions on the User account you're using in QB? If so, try it with a full access account and see if that works. Random thought: Is the Company on a Cash or Accrual basis?

HTH!


Geoffrey Gerhard
Creative Solutions Incorporated
14000 Creekside Drive
Matthews, NC  28105
704) 814-6852