Page History

...

• Open workflow OpportunityToInvoice, replace the reader query in the Advanced Query Builder with the the following query and click on Save & Close button.
  
  

  Code Block

  SELECT Opportunity.Id,Opportunity.AVSFQB__Primary_Contact__r.FirstName,Opportunity.AVSFQB__Primary_Contact__r.LastName,Opportunity.Owner.QB_SalesRep_ID__c, Opportunity.AVSFQB__Primary_Contact__r.Email,Opportunity.AVSFQB__QuickbooksQuickBooks_Id__c,Opportunity.AccountId,LastModifiedDate,Opportunity.Account.Id, Opportunity.Account.CurrencyIsoCode,Opportunity.Account.Name,Opportunity.Account.BillingStreet,Opportunity.Account.BillingCity, Opportunity.Account.BillingState,Opportunity.Account.BillingPostalCode,Opportunity.Account.BillingCountry,Opportunity.Account.ShippingStreet, Opportunity.Account.ShippingCity,Opportunity.Account.ShippingState,Opportunity.Account.ShippingPostalCode,Opportunity.Account.ShippingCountry, Opportunity.Account.Fax,Opportunity.Account.Phone,Name,Description,CloseDate ,(SELECT Quantity,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) ,Opportunity.Account.AVSFQB__QuickbooksQuickBooks_Id__c,Opportunity.AVSFQB__Generate_Object__c FROM Opportunity where Opportunity.AVSFQB__Generate_Object__c = 'Invoice'

...