OpenSync

Home Forums OpenSync Error sync ShippAddress in invoice

This topic contains 5 replies, has 2 voices, and was last updated by  jcdelacruz 1 year, 5 months ago.

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #62432

    jcdelacruz
    Participant

    Hi, i synchronize ShipAddress_Addr1 field with opensync 3.0.16 and the field change to null, the ShipAddress_City and ShipAddress_State set the value of ShipAddress_Addr1.
    this process happens on the invoice.

    For example:
    ShipAddress_Addr1 = “CUSTOMER SA DE CV”
    ShipAddress_City = NULL
    ShipAddress_State = NULL
    I synchronize opensync software and field values change to:
    ShipAddress_Addr1 = NULL
    ShipAddress_City = “CUTOMER SA”
    ShipAddress_State = “DE”
    I do not know the “CV” text value.
    can you help me??

    #62438

    Yudel Rosales
    Keymaster

    Can you be more specific please? are you trying to update your database or QuickBooks?

    #62439

    jcdelacruz
    Participant

    i trying to update Quickbooks. but
    when I synchronize from quickbooks to mysql the field ShipAddress_Addr1 is null and ShipAddress_City = “CUTOMER SA” ShipAddress_State = “DE”

    #62442

    Yudel Rosales
    Keymaster

    You will have to populate the table first. After, go to the database add the shipaddress fields that you want to update. Set the “Status” field to “UPDATE” and run an update to QuickBooks. But before to do these steps; on the main windows go to File->Options and check “Trace Update”.

    #62444

    jcdelacruz
    Participant

    It did not work, perform the indicated steps.

    I add images of the problem.

    Attachments:
    You must be logged in to view attached files.
    #62447

    jcdelacruz
    Participant

    this is XML trama
    <ShipAddress>
    <City>ZUCARMEX SA</City>
    <State>DE</State>
    </ShipAddress>
    <ShipAddressBlock>
    <Addr1>ZUCARMEX SA DE CV</Addr1>
    </ShipAddressBlock>

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

You must be logged in to reply to this topic.