I have an integration that has been running fine for quite a while for several customers. I am trying to impliment this integration for a new customer. When I try to add a Bill, I get an error.
INSERT INTO BillExpenseLine(VendorRefFullName,ExpenseLineAmount,ExpenseLineAccountRefFullName,ExpenseLineMemo,FQSaveToCache) VALUES ( 'QUA001', 451.89,'Accounts Payable:AP - MAX','700000920000',1)
INSERT INTO Bill(VendorRefFullName,TxnDate,RefNumber,TermsRefFullName,Memo) VALUES ( 'QUA001',{d'2008-09-02'},'25661-70000092','NET 30','AP00003 1000')
[QODBC] Error: 3180 - There was an error when saving a Bill. QuickBooks error message: Only one a/r or a/p account allowed per transaction.
This routine works great for all previous customers. Maybe there is a setting in Quick Books that needs to be changed?
Thanks for your time,
Dennis |