Productive Computing, Inc. Support Forum

Plug-ins => FM Books Connector => Topic started by: mikekurm@wienerminder.com on November 18, 2012, 09:13:10 PM

Title: Transaction Query returns No records- Ordinary Expenses as AccountTypeFilter
Post by: mikekurm@wienerminder.com on November 18, 2012, 09:13:10 PM
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.
Title: Re: Transaction Query returns No records- Ordinary Expenses as AccountTypeFilter
Post by: Geoffrey Gerhard on November 19, 2012, 07:50:12 AM
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