Insert Bill along with Bill Payment

[susnickParticipant]

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.

[Yudel RosalesStaff]

Which version of OpenSync and QuickBooks are you using?

[susnickParticipant]

Opensync 3 and Quickbooks 2016

[Yudel RosalesStaff]

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

[susnickParticipant]

Sent

[Yudel RosalesStaff]

did you do all the steps above?

[susnickParticipant]

Yes.

[susnickParticipant]

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

[cfullerParticipant]

Have you found a solution to this, as I’ve run into this issue as well. Thanks!

[susnickParticipant]

I have not heard back from them yet.

[Author]

Posts