Salesforce-Quickbooks Error Code 4000 – Validation Rule

[mina.michel@cloudastick.com]

4 years, 8 months ago #5469

I am trying to update the Invoice on Quickbooks from Salesforce. In the mapping page for the rule I added the Quickbooks Id and the value for the new field to update.
However when I run it, it is giving me the following error


Error parsing query
QueryParserError: Encountered "<EOF>" at line 1, column 46.Was expecting one of: "false" … "true" … <DATETIME> … <ID> … <STRING> …

Even though I am using same fields during Invoice creation. Which I had no problems with.

[kishore.k_84]

4 years, 8 months ago #5735

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

[mina.michel@cloudastick.com]

4 years, 8 months ago #5736

Hello Kishore,

Here is the username:
mina.michel@cloudastick.com

Here is the query:
Select Id, Name, Amount, Course_Start_Date__c, Booked_Date__c, CurrencyIsoCode, SalesInvoiceNumber__c, AVSFQB__Quickbooks_Id__c, AVSFQB__QB_Error__c, QBCustomerId__c, QBCustomer__c, QBCustomerEmail__c, QBCustomerPhone__c, QBCustomerBillStreet__c, QBCustomerBillCity__c, QBCustomerState__c, QBCustomerBillCountry__c, QBCustomerPCode__c , (SELECT Quantity,TotalPrice,UnitPrice,Description,Opportunity.owner.FirstName,Opportunity.owner.LastName,Opportunity.Id,Opportunity.CloseDate,PricebookEntry.Name,PricebookEntry.Product2.ProductCode,PricebookEntry.Product2.Name,PricebookEntry.Product2.Description,PricebookEntry.Product2.Id,PricebookEntry.UnitPrice,PricebookEntry.Product2.AVSFQB__QuickBooks_ItemType__c FROM OpportunityLineItems) from Opportunity where AVSFQB__Generate_Object__c=’Update Invoice’

Thank you,

[mina.michel@cloudastick.com]

4 years, 8 months ago #5737

Hello Kishore,

Here is the username:
mina.michel@cloudastick.com

Here is the query:
Select Id, Name, Amount, Course_Start_Date__c, Booked_Date__c, CurrencyIsoCode, SalesInvoiceNumber__c, AVSFQB__Quickbooks_Id__c, AVSFQB__QB_Error__c, QBCustomerId__c, QBCustomer__c, QBCustomerEmail__c, QBCustomerPhone__c, QBCustomerBillStreet__c, QBCustomerBillCity__c, QBCustomerState__c, QBCustomerBillCountry__c, QBCustomerPCode__c , (SELECT Quantity,TotalPrice,UnitPrice,Description,Opportunity.owner.FirstName,Opportunity.owner.LastName,Opportunity.Id,Opportunity.CloseDate,PricebookEntry.Name,PricebookEntry.Product2.ProductCode,PricebookEntry.Product2.Name,PricebookEntry.Product2.Description,PricebookEntry.Product2.Id,PricebookEntry.UnitPrice,PricebookEntry.Product2.AVSFQB__QuickBooks_ItemType__c FROM OpportunityLineItems) from Opportunity where AVSFQB__Generate_Object__c=’Update Invoice’

Thank you,