This topic contains 9 replies, has 3 voices, and was last updated by susnick 3 years, 8 months ago.
Has anyone had luck inserting a bill and its payment at the same time? My issue is I print checks outside of quickbooks, so they are collated with other documents. I need to be able to update quickbooks with the bill and payment and mark it as printed.
Which version of OpenSync and QuickBooks are you using?
Opensync 3 and Quickbooks 2016
Perfect. On OpenSync main windows go to File-Options and check “Trace Updates” option. Then run the task. After that, can you send me the log files and the xml file that will be generated with he table name please. To send the log files, go to Help-Send Diagnostics, this will do it.
Thanks
Sent
did you do all the steps above?
Yes.
Here are the queries I ran. And the error message When I sync
INSERT INTO bill (txnid, vendorref_listid, apaccountref_listid, txndate, amountdue, refnumber, memo, ispaid, status) VALUES (‘1234’, ‘80000003-1533827038’, ‘80000021-1533827196’, ‘2018-08-09’, 151.00, NULL, ‘12345678’, ‘true’, ‘ADD’);
INSERT INTO txnexpenselinedetail (idkey, accountref_listid, amount) VALUES (‘1234’, ‘8000000F-1533824914’, 151.00);
INSERT INTO appliedtotxndetail (txnid, idkey, amount) VALUES (‘1234’, ‘1234’, 151.00);
INSERT INTO billpaymentcheck (txnid, apaccountref_listid, payeeentityref_listid, bankaccountref_listid, txndate, amount, refnumber, istobeprinted, status) VALUES (‘1234’, ‘80000021-1533827196’, ‘80000003-1533827038’, ‘80000022-1533829342’, ‘2018-08-09’, 151.00, ‘569’, ‘false’, ‘ADD’);
Error:
-2147220965 billpayment:appliedtotxndetail idkey 1234 The bill selected for payment was not found in QuickBooks. 8/20/2018 3:51:57 PM
Have you found a solution to this, as I’ve run into this issue as well. Thanks!
I have not heard back from them yet.
The forum ‘OpenSync’ is closed to new topics and replies.
Copyright © 2013 Synergration Inc