Sorting records prior to mapping?
Mike asked 5 years ago
I have a map that uses the Microsoft CRM Change Data Source and the Sales Order/Sales Order Processing Microsoft Dynamics GP destination type. I am looking for a way to sort by a custom CRM field, GP Line Item Number, performing the integration into GP through the Add line item node.
Is there a way that I can do this at the Data Source level via an “Order By” statement in SQL or through the destination map level somehow?
Currently line items are defaulting to the order of the records in CRM, which is not always ideal.
Is there a way that I can do this at the Data Source level via an “Order By” statement in SQL or through the destination map level somehow?
Currently line items are defaulting to the order of the records in CRM, which is not always ideal.
Answers
Mark Anderson Staff answered 5 years ago
When you set the Key fields on the source definition, that also adds an inferred order by. If you add the GP Line Item Number as the last key field, this should solve your issue.