A column set column is used within SmartConnect when one of the following messages is to be called by SmartConnect:
| • | Convert a quote to a sales order |
| • | Convert a sales order to an invoice |
| • | Generate an invoice from an opportunity |
| • | Generate a quote from an opportunity |
| • | Generate a sales order from an opportunity |
To create a Dynamics CRM column set column:
| 1. | Open Map >> Setup, or select the Maps Quick Link and double click on the map to be edited. |
| 2. | If creating a new map enter the map id and description. |
| 3. | If creating a new map enter the data source and key field information. |
| 4. | If creating a new map select CRM as the destination, then double click on the entity type required. |
| 5. | Select Additional Columns from the toolbar at the top of the mapping window. |
| 6. | Select Columns >> Mapped Column Set Column from the toolbar at the top of the mapping window, or double click the column to be edited. |
| 7. | Enter a name for the column set column. Names must be unique within a map. |
| 8. | Select the source entity that is to be processed. |
| 9. | Select the target object for processing. |
| 10. | The fields mapped between the two entities should now appear in the mapped fields window. |
| 11. | Select OK to save the column changes. |
| 12. | Select OK to close the column window. The new column set column should now appear in the left grid of the matching window. |
| 13. | Drag the lookup field to the required spot in the destination grid or select column set as the Column Type and the column name as the Column Name in the destination grid. |
