Community Forum

Forum Replies Created

  • kishore.k_84
    Participant

    Hi Michel,

    Could you please send us the query you used to fetch the record from SF also please share your dbsync username, which really helps us to debug this issue faster.

    Thanks,
    DBSync Support

    kishore.k_84
    Participant
    7 years, 2 months ago in reply to: Syncing issue again #5719

    Jay,

    Thanks for your post on dbsync community.
    “Close connection failed error may comes in 2 scenarios:
    1. If your QB application was not opend and in background your is in progress.
    2. Might be dbsync server may down for some times or some small glitches in server. so for better response please reach out dbsync support for the earliest solution.

    kishore.k_84
    Participant

    Derek,

    Looks like you may have 1 or more QB files and when your switching the company file, please make sure that there is no sync in progress on web connector.
    Also if you set the sync to run automatically for every 5or 10 mins to run, then please set it to every 20 mins or more as we and Intuit recommended for the same.
    Because that also may freez your web connector and QB application if you set your time interval to run every 5 or 10 mins..

    Thanks

    kishore.k_84
    Participant

    John,

    Response Received =0x80040400:QuickBooks found an error when parsing the provided XML text stream……..

    The above error message will appears when your data was incorrect.
    some of the required vales are not set in your SF or QB, kindly go through all required field values and set accordingly, then try for the sync.
    In your case : In SF product, Bundle field was don’t have the values, so Quotes which are having the lineitems, do not have the Bundle value.
    because for this reason, sync not working and you are getting the that error message.

    Thanks,
    Kish

    kishore.k_84
    Participant
    7 years, 6 months ago in reply to: QuickBooks Error Sync Assistance #5703

    Zuri,

    Thanks for reaching here,
    An issue looks like, the required fields are not mapped or required field does not have the values, when you trying to sync the payment record.
    Kindly cross verify the data in SF and the mappings in DBSync.

    Kishore

    kishore.k_84
    Participant
    7 years, 8 months ago in reply to: batch insert failed #5687

    I would assume your row is not 1908435 bytes long so it would have to be the batch size in total. If your rows were smaller you could have the same number of rows, but I would assume it easier to reduce the number of rows in your batch, or do what it suggests which is to increase the limit. Or Reduce the Reader batch size and try out the sync .

    kishore.k_84
    Participant
    7 years, 8 months ago in reply to: Aging Summary in GP #5680

    Yes it is possible to get the AR aging as of specific date.
    Goto Reports–> sales–> trial balance. In the Reports list , select Historic Trial Balance.
    In this option, you have the facility to enter the age as of date.
    This can be exported to Excel from the destination button. Select File and save either as Tab delimited or CSV

    kishore.k_84
    Participant

    Hi Tamsin,

    In their user profiles, set the DBSync credentials(DBsync username & password ) along with you need to set the Profile/Project name of Dbsync and URL to be Point and they need not be an admin user.

    Below are the list of fileds need to be set with information.

    DBSync Id : < DBSync username>
    DBSync Passwd : < DBsync pwd >

    DBSync Server URL : < https://dbsync01.appmashups.com/qboev3 > or < https://app04.mydbsync.com/DBSync >
    Note : this info can be view on address bar when you hit on development studio button from DBsync Home page after logging in.

    DBSync Profile : < Profile/Project name of Dbsync > example like : SalesforceQuickBooksOnlineBiDirectional

    kishore.k_84
    Participant
    9 years, 1 month ago in reply to: Update Quickbooks transaction address error #5660

    with respect to above question please see below

    The address you are passing in type-1

    Company
    Person Name
    1234 Main St
    Los Angeles, CA 90745
    US

    As you are entering the city,state postal code and country in the Address 4 and Address 5 you are getting this The first version gives the error: “The "address" field has an invalid value "". QuickBooks error message: The parameter is incorrect.” error.

    That address 4 and 5 is reserved for street address.

    In the mappings we have separate fields to map for city,state postal code and country,you can map ,provide value there.

    The second error you are getting because in QuickBooks the Address is already entered in
    Company
    Person Name
    1234 Main St
    Los Angeles, CA 90745
    US
    in this format so when we tried to enter , we are getting that error.

    To resolve this moving forward you can enter city,state postal code and country map separately and it will sync.

    kishore.k_84
    Participant
    9 years, 1 month ago in reply to: 500 error code #5656

    Receiving “500 error” occurs due to some DBsync related field values are missing / incorrect at Users page layout of SalesForce.
    Select the user as System Administrator in Salesforce under User page, then check the following fields and their values.

    a. DBSync Id :
    b. DBSync Passwd :

    c. DBSync Server URL : < https://dbsync01.appmashups.com/qboev3 > or <https://app04.mydbsync.com/DBSync/>
    d. DBSync Profile : < Project name of DBsync profile >

    kishore.k_84
    Participant

    “Invalid reference to Customer” tends to Customer is not existing or or it may be inactive at Quickbooks.
    While creating an invoice, the transaction is always refers to the Customer. So check whether respective customer is existing in QB or not.

    kishore.k_84
    Participant

    There are 2 ways to connect the Salesforce in DBSync account.

    1.Using Connect to Salesforce button. [or]

    2. Other way, using ” Advance properties Tab” under Salesforce Connectors page.

    Provide the Security Token which is generated by SF along with the Salesforce credentials ( username & password) then save the entire properties, later try to validate the Salesforce connection under DBSync account.

    kishore.k_84
    Participant
    10 years, 3 months ago in reply to: Change in Special Character Value in Oracle database #5637

    Please use the query, SELECT * FROM V$NLS_PARAMETERS;
    to find the parameter NLS_CHARACTERSET

    NLS_CHARACTERSET value is set to something else on your Oracle database instance i.e, something like NLS_CHARACTERSET = US7ASCII. Please use a different value that is suitable like NLS_CHARACTERSET = AL3UTF8. This will resolve the issue.

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