Community Forum

Forum Replies Created

  • 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,

    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)