2022

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Issue:

The order of the products under the opportunity wouldn’t be synced in the same order to invoice unless the changes are made in the advanced query builder of the DBSync.

...


Code Block
titleQuery
SELECT {!.},Account.Id,(SELECT {!OpportunityLineItems/records} FROM OpportunityLineItems) FROM Opportunity where  Opportunity.AVSFQB__Generate_Object__c= 'Invoice' and AVSFQB__Products_Count__c > 0


Solution  :

Step 1:

  • Navigate to products under opportunity.  

  • Click on the dropdown present on the rightmost top corner.


...