Question:  Order Product – description field – currently the start of the description is displayed in combination with the item id. Shouldn’t the full description be in the description field?

This is functioning as designed. Changes can be made to this DTS by the consultant to just show the product description or the SKU. This is because in CRM 1.2 you could not search the Grid by SKU. We have kept this naming convention; however, it is easy to change. 

The SOL2CRMInventory DTS currently uses this formula to populate the NAME field on products:

Trim(SOLOMON_INV_ID) & " - " &Upper(Trim(SOLOMON_INV_DESC))

The SOLOMON_INV_ID is 30 characters max, and the SOLOMON_INV_DESC is 66 characters max. The NAME field in CRM is 100 characters, so it has enough room for the data that is being placed in it.