How to configure Visual Integrator to import Cost Code data

Description

How to configure Visual Integrator to import Cost Code data

Resolution

Regardless of how many characters the Cost Code has been defined as in Job Cost Options, when using Visual Integrator to import Cost Code data, VI pads with zero the value provided up to 10 digits. This is not taking into account the dashes.

So, for example, if the data source file contains a Cost Code of 8 characters, VI might error out stating “Not on File” since even though the cost code provided is the correct one, when the import is being processed, it is been imported as 12345678900, ergo the “Not on File” message.

One way to get around this issue is to use Temp Fields in VI, to bring each segment and then doing a Calculated field for the Cost Code, in which you would concatenate those temp fields to form the proper string. It might be required to add the zeros to the end of that calculation.

Below is an example:

{TEMP01}+{TEMP2}+{TEMP3}+”0″

Support

If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.