OpenSync

Home Forums OpenSync Pushing data back into Quickbooks

This topic contains 24 replies, has 2 voices, and was last updated by  Mike Sutton 6 days, 2 hours ago.

Viewing 15 posts - 1 through 15 (of 25 total)
  • Author
    Posts
  • #66057

    Mike Sutton
    Participant

    Hopefully you can give us some help here. I’ve tried emailing Yudel without reply so far…??

    We’ve got Opensync and quickbooks running. We can “Populate from Quickbooks” and “Refresh from Quickbooks” into an access database with no problems. This has been running for a few years now. We did have a lot of trouble originally doing refresh jobs, and I’m pretty sure that turned out to be a date formatting related problem. Here in NZ our date format is DD-MM-YYYY, OS appears a bit confused on this topic when you look at the interface…:(

    Now we want to try and get some updates from ms access back into quickbooks. Item Receipt is the table we are trying to an update from.

    I’ve been getting errors when I try and do an UPDATE task.

    I’ve turned on the Trace Logging for all tasks. When the populate job runs, I get an xml log file. If I run an Update Task, I don’t get any XML Log file, but I get errors reported in the OpenSync.Log.

    And I get this error in the error table:

    error_table
    Error_Num Error_Table Error_Field Error_Desc TIME_DATE IDKEY
    -2147219496 itemreceipt:txnitemline validateitemchilddependencies This property is not valid for current transaction type 11/10/2019 2:52:36 PM 3DC326-1570752046:3DC328-1570752046

    Any clues as to what might be causing this.

    If I run a “Refresh and Update” task for the same table, I get this in the trace log.

    <Trace>
    <OUTGOING>
    <!DOCTYPE QBXML PUBLIC ‘-//INTUIT//DTD QBXML QBD 6.1//EN’ ><QBXML><QBXMLMsgsRq onError = “continueOnError”><ItemReceiptQueryRq><ModifiedDateRangeFilter><FromModifiedDate>2019-10-11T14:10:00+12:00</FromModifiedDate><ToModifiedDate>2019-10-11T14:34:45+12:00</ToModifiedDate></ModifiedDateRangeFilter><IncludeLineItems>1</IncludeLineItems><IncludeLinkedTxns>1</IncludeLinkedTxns><OwnerID>0</OwnerID></ItemReceiptQueryRq></QBXMLMsgsRq></QBXML>
    </OUTGOING>
    <RETURNS>

    <QBXML>
    <QBXMLMsgsRs>
    <ItemReceiptQueryRs statusCode=”1″ statusSeverity=”Info” statusMessage=”A query request did not find a matching object in QuickBooks” />
    </QBXMLMsgsRs>
    </QBXML>

    </RETURNS>
    </Trace>

    This might be date related, see the FromModifiedDate and ToModifiedDates

    Tried doing update tasks on other tables no with success either.
    I was however successfully able to “ADD” a record into the Account table, by using an UPDATE task.

    Thanks
    Mike

    #66066

    Yudel Rosales
    Keymaster

    Hello Mike
    I haven’t gotten your email. I will into this issue and go back to you.

    #66071

    Mike Sutton
    Participant

    Hi Yudel

    Thank you, looking forward to it.

    #66088

    Yudel Rosales
    Keymaster

    it looks like you are having a problem linking the child table. are you linking an expenseline, itemline or both?

    #66471

    Mike Sutton
    Participant

    Yes, we are trying to update itemlinedetail. Keep getting errors though.
    Error log shows:
    itemreceipt:txnitemline
    validateitemchilddependencies
    This property is not valid for current transaction type.

    Did some other testing, managed to update a vendor record successfully.
    Also tried to update sales order and purchase order records but got mixed results.

    One question – if we want to update a table that has parent and child records, eg Sales Order and Sales Order items, if the child record has been updated and we want to push that update back into QB, do we need to set status=update against the child record, and the parent record, or just the parent record ?

    I’ve turned on the logging, and when I try to update a sales order I see an “updatesalesorder.xml” file created in the opensync logs folder, but when I try to update an item receipt it doesn’t get that far, no xml log file gets created called “updateitemreceipt.xml”, so its failing before that point.
    OpenSync.log gives me no more info than what I’m seeing in the error table.

    Any suggestions on what I can try next ?

    #66554

    Yudel Rosales
    Keymaster

    No, you don’t have to put “update” on the child record. As long the table supports the update of the child record. The only thing that you need is to have them linked. Parent ListId or TxnId has to be on the IDKEY field of the child record. Make sure to have this done.

    #66809

    Mike Sutton
    Participant

    Hi

    Yes we have linked the Parent and Child records but we still get this error.

    itemreceipt:txnitemline
    validateitemchilddependencies
    This property is not valid for current transaction type.

    Can you give us some more information to help us with the update, we still can’t get it to work.

    #66839

    Yudel Rosales
    Keymaster

    Can I see the error that you are getting, please?

    #66860

    Mike Sutton
    Participant

    Can I see the error that you are getting, please?

    YES I did this right from the beginning in my FIRST (above) post.

    #66884

    Mike Sutton
    Participant

    Can I see the error that you are getting, please?

    YES I did this right from the beginning in my FIRST (above) post.

    Hello Yudel, can we get a reply please?

    #66898

    Yudel Rosales
    Keymaster

    I need to see all your log files?

    #66912

    Mike Sutton
    Participant

    Hi

    Here are the lines from the Logs

    CoreObjx.Log
    2020-03-16 15:28:56 0 QBConnection.Connect Connect from: OpenSync : Company path: D:\Quickbooks\Reckon_live_data\Pushtest.qbw
    2020-03-16 15:29:03 0 QBConnection.Connect Got versions
    2020-03-16 15:29:03 0 QBConnection.Connect GetProductInfo:GotDOM
    2020-03-16 15:29:03 0 QBConnection.Connect GetProductInfo:FromDOM
    2020-03-16 15:29:03 0 QBConnection.Connect Got product info
    2020-03-16 15:29:03 0 QBConnection.Connect Got company record

    OpenSync.Log
    2020-03-16 15:28:56 0 OpenSync:Runner Runner: Start task PUSHTEST
    2020-03-16 15:28:56 0 WorkTracker Init
    2020-03-16 15:28:56 0 WorkTracker Starting task: PUSHTEST
    2020-03-16 15:28:56 0 BackWorker ExecuteBackground Begin
    2020-03-16 15:29:03 0 BackWorker MakeQbConnection: Connection Opened
    2020-03-16 15:29:03 0 BackWorker FullSynch
    2020-03-16 15:29:03 0 BackWorker Update table Item Receipt
    2020-03-16 15:29:04 0 BackWorker Refresh table Item Receipt
    2020-03-16 15:29:04 -1 WorkTracker Update detected 1 errors. Check error table for details.
    2020-03-16 15:29:05 0 BackWorker CloseQbConnection: Close Connection
    2020-03-16 15:29:06 0 BackWorker ExecuteBackground Complete
    2020-03-16 15:29:06 0 OpenSync:Runner ErrorExit: Update detected 1 errors. Check error table for details.

    qbsdklog.txt
    20200316.152856 I 7644 RequestProcessor ========= Started Connection =========
    20200316.152856 I 7644 RequestProcessor Request Processor, QBXMLRP2 v6.1
    20200316.152856 I 7644 RequestProcessor Connection opened by app named ‘OpenSync’
    20200316.152856 I 7644 CertVerifier The Authenticode signature is not within its validity period.
    20200316.152900 I 7644 RequestProcessor Opening the file in the DoNotCare mode.
    20200316.152903 I 7232 QBSDKProcessRequest Application named ‘OpenSync’ starting requests (process 7644).
    20200316.152903 I 7232 SpecVersion Current version of qbXML in use: 6.1
    20200316.152903 I 7232 QBSDKMsgSetHandler QUERY: Host
    20200316.152903 I 7232 QBSDKMsgSetHandler Request 1 completed successfully.
    20200316.152903 I 7232 MsgSetHandler Finished.
    20200316.152903 I 7232 QBSDKProcessRequest Application named ‘OpenSync’ finishing requests (process 7644), ret = 0.
    20200316.152903 I 7232 QBSDKProcessRequest Application named ‘OpenSync’ starting requests (process 7644).
    20200316.152903 I 7232 SpecVersion Current version of qbXML in use: 6.1
    20200316.152903 I 7232 QBSDKMsgSetHandler QUERY: Company
    20200316.152903 E 7232 CompanyStorage::BuildTheRetObject Failed to convert the tax form named ‘Company Income Tax Return’ to a qbXML value
    20200316.152903 I 7232 QBSDKMsgSetHandler Request completed successfully.
    20200316.152903 I 7232 MsgSetHandler Finished.
    20200316.152903 I 7232 QBSDKProcessRequest Application named ‘OpenSync’ finishing requests (process 7644), ret = 0.
    20200316.152903 I 7232 QBSDKProcessRequest Application named ‘OpenSync’ starting requests (process 7644).
    20200316.152903 I 7232 SpecVersion Current version of qbXML in use: 6.1
    20200316.152903 I 7232 QBSDKMsgSetHandler QUERY: Preferences
    20200316.152903 I 7232 QBSDKMsgSetHandler Request 1 completed successfully.
    20200316.152903 I 7232 MsgSetHandler Finished.
    20200316.152903 I 7232 QBSDKProcessRequest Application named ‘OpenSync’ finishing requests (process 7644), ret = 0.
    20200316.152903 I 7232 QBSDKProcessRequest Application named ‘OpenSync’ starting requests (process 7644).
    20200316.152903 I 7232 SpecVersion Current version of qbXML in use: 6.1
    20200316.152903 I 7232 QBSDKMsgSetHandler QUERY: DataExtension Definition
    20200316.152903 I 7232 QBSDKMsgSetHandler Request completed successfully.
    20200316.152903 I 7232 MsgSetHandler Finished.
    20200316.152903 I 7232 QBSDKProcessRequest Application named ‘OpenSync’ finishing requests (process 7644), ret = 0.
    20200316.152903 I 7232 QBSDKProcessRequest Application named ‘OpenSync’ starting requests (process 7644).
    20200316.152903 I 7232 SpecVersion Current version of qbXML in use: 6.1
    20200316.152903 I 7232 QBSDKMsgSetHandler QUERY: Item Receipt
    20200316.152904 I 7232 QBSDKMsgSetHandler Request completed successfully.
    20200316.152904 I 7232 MsgSetHandler Finished.
    20200316.152904 I 7232 QBSDKProcessRequest Application named ‘OpenSync’ finishing requests (process 7644), ret = 0.
    20200316.152904 I 7232 QBSDKProcessRequest Application named ‘OpenSync’ starting requests (process 7644).
    20200316.152904 I 7232 SpecVersion Current version of qbXML in use: 6.1
    20200316.152904 I 7232 QBSDKMsgSetHandler QUERY: Vendor
    20200316.152904 I 7232 QBSDKMsgSetHandler Request completed successfully.
    20200316.152904 I 7232 MsgSetHandler Finished.
    20200316.152904 I 7232 QBSDKProcessRequest Application named ‘OpenSync’ finishing requests (process 7644), ret = 0.
    20200316.152904 I 7232 QBSDKProcessRequest Application named ‘OpenSync’ starting requests (process 7644).
    20200316.152904 I 7232 SpecVersion Current version of qbXML in use: 6.1
    20200316.152904 I 7232 QBSDKMsgSetHandler QUERY: Account
    20200316.152904 I 7232 QBSDKMsgSetHandler Request 1 completed successfully.
    20200316.152904 I 7232 MsgSetHandler Finished.
    20200316.152904 I 7232 QBSDKProcessRequest Application named ‘OpenSync’ finishing requests (process 7644), ret = 0.
    20200316.152904 I 7232 QBSDKProcessRequest Application named ‘OpenSync’ starting requests (process 7644).
    20200316.152904 I 7232 SpecVersion Current version of qbXML in use: 6.1
    20200316.152904 I 7232 QBSDKMsgSetHandler QUERY: Item
    20200316.152904 I 7232 QBSDKMsgSetHandler Request completed successfully.
    20200316.152904 I 7232 MsgSetHandler Finished.
    20200316.152904 I 7232 QBSDKProcessRequest Application named ‘OpenSync’ finishing requests (process 7644), ret = 0.
    20200316.152904 I 7232 QBSDKProcessRequest Application named ‘OpenSync’ starting requests (process 7644).
    20200316.152904 I 7232 SpecVersion Current version of qbXML in use: 6.1
    20200316.152904 I 7232 QBSDKMsgSetHandler QUERY: Sales Tax Code
    20200316.152904 I 7232 QBSDKMsgSetHandler Request 1 completed successfully.
    20200316.152904 I 7232 MsgSetHandler Finished.
    20200316.152904 I 7232 QBSDKProcessRequest Application named ‘OpenSync’ finishing requests (process 7644), ret = 0.
    20200316.152904 I 7232 QBSDKProcessRequest Application named ‘OpenSync’ starting requests (process 7644).
    20200316.152904 I 7232 SpecVersion Current version of qbXML in use: 6.1
    20200316.152904 I 7232 QBSDKMsgSetHandler QUERY: Item Receipt
    20200316.152904 I 7232 QBSDKMsgSetHandler Request completed successfully.
    20200316.152904 I 7232 MsgSetHandler Finished.
    20200316.152904 I 7232 QBSDKProcessRequest Application named ‘OpenSync’ finishing requests (process 7644), ret = 0.
    20200316.152904 I 7232 QBSDKProcessRequest Application named ‘OpenSync’ starting requests (process 7644).
    20200316.152904 I 7232 SpecVersion Current version of qbXML in use: 6.1
    20200316.152904 I 7232 QBSDKMsgSetHandler QUERY: Transaction Delete
    20200316.152904 I 7232 QBSDKMsgSetHandler Request completed successfully.
    20200316.152904 I 7232 MsgSetHandler Finished.
    20200316.152904 I 7232 QBSDKProcessRequest Application named ‘OpenSync’ finishing requests (process 7644), ret = 0.
    20200316.152905 I 7644 RequestProcessor Connection closed by app named ‘OpenSync’
    20200316.152905 I 7644 RequestProcessor ========== Ended Connection ==========

    And the error we get in the error table is as follows:

    Error_Num Error_Table Error_Field Error_Desc TIME_DATE IDKEY
    -2147219496 itemreceipt:txnitemline validateitemchilddependencies This property is not valid for current transaction type 16/03/2020 3:29:04 PM 3AC591-1550798222:3AC594-1550798222

    If you want to see the trace log XML its in the start of this thread.

    Thanks
    Mike

    #66917

    Yudel Rosales
    Keymaster

    It seems like you are using an old version of OpenSync. Make sure that you are running OpenSync v3.0.28.

    #66920

    Mike Sutton
    Participant

    Are you saying our problem exists because of the old version….?

    I have tried upgrading once before and we got into a complete pickle, which was not hepled by delayed support from you guys. So, before I attempt this I want to know we have a very good chance and that you are close by should we need you.

    #66923

    Mike Sutton
    Participant

    It seems like you are using an old version of OpenSync. Make sure that you are running OpenSync v3.0.28.

    Ok, so I downloaded the trial of 3.0.28 and it say my registration has expired 5 August 2018. I recall trialing this version?? and it all went wrong and we failed to get it going so we reverted back to 2.0.84.

    We are using Reckon Accounts Premier 2013, before I spend time trialing 3.0.28, can you confirm 100% it will work please?

Viewing 15 posts - 1 through 15 (of 25 total)

You must be logged in to reply to this topic.