Forum Replies Created
-
kishore.k_84
Participant6 years, 7 months ago in reply to: Salesforce-Quickbooks Error Code 4000 – Validation Rule #5735Hi 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 Supportkishore.k_84
Participant7 years, 2 months ago in reply to: Syncing issue again #5719Jay,
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
Participant7 years, 2 months ago in reply to: QB error : The web connector is freezing up the system and not allowing our team to change books #5716Derek,
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
Participant7 years, 5 months ago in reply to: Response Received =0x80040400:QuickBooks found an error when parsing the provided XML text stream…….. #5708John,
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,
Kishkishore.k_84
Participant7 years, 6 months ago in reply to: QuickBooks Error Sync Assistance #5703Zuri,
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
Participant7 years, 8 months ago in reply to: batch insert failed #5687I 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
Participant7 years, 8 months ago in reply to: Aging Summary in GP #5680Yes 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 CSVkishore.k_84
Participant8 years, 11 months ago in reply to: Salesforce users receive error when trying to use QBOE button #5664Hi 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
Participant9 years, 1 month ago in reply to: Update Quickbooks transaction address error #5660with 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
in this format so when we tried to enter , we are getting that error.
Company
Person Name
1234 Main St
Los Angeles, CA 90745
US
To resolve this moving forward you can enter city,state postal code and country map separately and it will sync.
kishore.k_84
Participant9 years, 1 month ago in reply to: 500 error code #5656Receiving “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
Participant9 years, 1 month ago in reply to: QB Error field says “Invalid reference to Customer” #5654“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
Participant9 years, 6 months ago in reply to: Unable to complete first step in connecting to SalesForce Acc #5642There 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
Participant10 years, 3 months ago in reply to: Change in Special Character Value in Oracle database #5637Please use the query, SELECT * FROM V$NLS_PARAMETERS;
to find the parameter NLS_CHARACTERSETNLS_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.