OpenSync

Home Forums OpenSync Insert Bill along with Bill Payment

This topic contains 9 replies, has 3 voices, and was last updated by  susnick 1 month, 2 weeks ago.

Viewing 10 posts - 1 through 10 (of 10 total)
  • Author
    Posts
  • #64022

    susnick
    Participant

    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.

    #64101

    Which version of OpenSync and QuickBooks are you using?

    #64103

    susnick
    Participant

    Opensync 3 and Quickbooks 2016

    #64104

    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

    #64105

    susnick
    Participant

    Sent

    #64106

    did you do all the steps above?

    #64107

    susnick
    Participant

    Yes.

    #64108

    susnick
    Participant

    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

    #64164

    cfuller
    Participant

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

    #64165

    susnick
    Participant

    I have not heard back from them yet.

Viewing 10 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic.