Display SOP Type to Text in SmartFill


Explains the steps to use field mapping to display the SOP Type as text in SmartFill.


In order to see text instead of the value for SOP Type, you can use Field Mapping on a Calculated Field. Below are the steps to create the Calculated Field.

  1. Open the SmartFill Object where you want to map the field.
  2. In the Lookup Fields section, create a new line and from the Table column drop-down, click <Calculated Field>.
  3. In the Field Name column, click <New Calculated Field>.
  4. In the SmartFill Object Calculated Fields Window, enter a Calculated Field Name.
  5. Leave the Display Name as it defaults or change it to the Name you wish to display in the SmartFill windows.
  6. In the Type field, select Table Field.
  7. Select SOP_HDR_WORK for the Table Name.
  8. In the Field Name field, select SOP Type.
  9. Mark Use Mapping.
  10. Click Mapping.
  11. Enter the mapping for the SOP Types.

  1. Click OK to both windows.
  2. Mark Display to see this field.

Note: Field Mapping is available only for table fields (i.e., it is not available for constant values). The only types of fields that can be mapped are ones that have a string datatype, or a numeric datatype that is not a Currency type. For instance, Integers and Drop-down List fields can use Field Mapping; Date fields and Currency fields cannot.

Related Content

How to Maximize Your Investment in Microsoft Dynamics GP

You’ve invested a lot into Microsoft Dynamics GP, and it serves you well, but did you know it likely can do so much more for you? Even if you’ve been using GP for years, it’s possible you don’t know how much more GP can do for you. Want to improve the bottom line? It might be time to invest in your own investment and get more ROI out of the rich system features that might be right under your nose.