VBScript to convert a negative number to a positive number by using Integration Manager for Microsoft Dynamics GP


Introduction


This article discusses how to add a script to an integration to convert negative numbers to positive numbers in Integration Manager for Microsoft Dynamics GP or for Microsoft Business Solutions – Great Plains.

Summary


This article discusses how to add a VBscript to a field item to convert a negative number to a positive number.

More Information


When you import data through Integration Manager for Microsoft Dynamics GP or for Microsoft Business Solutions – Great Plains, you may have to convert a number from a negative value or amount to a positive value or amount. To do this, follow these steps:
  1. Start Integration Manager. To do this, follow the steps for your version of the program.

    Integration Manager for Microsoft Dynamics GP
    1. Click Start.
    2. Click All Programs.
    3. Click Microsoft Dynamics.
    4. Click Integration Manager.
    5. Click Integration Manager.
    Integration Manager for Microsoft Business Solutions – Great Plains 8.0
    1. Click Start.
    2. Click All Programs.
    3. Click Microsoft Business Solution 8.0.
    4. Click Integration Manager (the folder).
    5. Click Integration Manager (the shortcut).
  2. Open the integration to which you want to add the script. To do this, follow these steps:
    1. Click Open Integration on the toolbar.
    2. On the list, select the integration that you want.
    3. Click Open.
  3. Add the script to the Integration field. To do this, follow these steps:
    1. Click Mapping on the toolbar.
    2. Select the folder or the cube that has the field that you want to add the script.
    3. Locate the field that you want to add the script.
    4. In the Rule column, click the list, and then click Use Script.
    5. Open the Script Editor window. To do this, locate the Value column in the lower-left corner of the Integration Mapping window. Then, click the ellipsis button.
    6. Copy the following script into the Script Editor window.
      'Converts a value from a negative to positive
      DIM Variable
      Variable = Abs(SourceFields("Queryname.Columnname"))
      CurrentField.Value = Variable
      Notes
      • Variable can be defined as anything. However, it must be consistent throughout the script.
      • Replace Queryname with the name of the Integration Manager Source Name from which this field is mapped.
      • Replace Columnname with the name of the column that is displayed when you preview the source in Integration Manager.
    7. On the File menu, click Save and Close.