Community Forum

Forum Replies Created

  • mina.michel@cloudastick.com
    Participant
    4 years, 6 months ago in reply to: Salesforce-Quickbooks Error Code 4000 – Validation Rule #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,

    mina.michel@cloudastick.com
    Participant
    4 years, 6 months ago in reply to: Salesforce-Quickbooks Error Code 4000 – Validation Rule #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,

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