4 posts / 0 new
Last post
Salesforce-Quickbooks Error Code 4000 - Validation Rule
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 <Fault type="ValidationFault"> <Error code="4000"> <Message>Error parsing query</Message> <Detail>QueryParserError: Encountered &quot;&lt;EOF&gt;&quot; at line 1, column 46.Was expecting one of: &quot;false&quot; ... &quot;true&quot; ... &lt;DATETIME&gt; ... &lt;ID&gt; ... &lt;STRING&gt; ... </Detail> </Error> Even though I am using same fields during Invoice creation. Which I had no problems with.
Tags: 
QuickBooks & Salesforce
Total votes: 956

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

You voted 3. Total votes: 974

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,

You voted 5. Total votes: 997

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,

You voted 2. Total votes: 930