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.

...

The Query for unsorted order:Image Removed


Code Block
titleQuery
:
SELECT {!.},Account.Id,(SELECT {!OpportunityLineItems/records} FROM OpportunityLineItems) FROM Opportunity
where 
 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.


Image RemovedImage Added

  • Select the Sort Products button.  

  • Drag the products into the order you want and save.

...

The Query for sorted order:
Image Removed

Query:

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



...