Sage 100

I am trying to do a VI Import where there are lines that are straight GL and some have Job No and Cost Code.  The field coming in for the cost code is not formatting as in the system 000-00 so the import is not recognizing the data.  I tried to do a temp field then do the left and right command with a dash but that continues to throw a syntex 26 error.  I have tried to do a if then else statement to for the GL number to pull either the data from the import or from the cost code detail table that does not seem to work either.  So if anyone has a sample VI import for AP with Job cost that would great ..thanks in advance for any assistance.

------------------------------
Venessa Griffin
Senior Business Analyst / Team Lead
Net at Work
------------------------------

The attached VI job has the source file as tab delimited so change it if necessary.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
------------------------------

Here's another version that imports the cost code correctly.  Also attached to this post is a 1 record sample file with data from the   EEC company code.  You still may have an issue with the GL number depending on the configuration your client has.

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
------------------------------

The cost code in the data file doesn't contain the hyphens and is zero filled on the back end to the field length.  Try formatting the source data like that and maybe that will help.

------------------------------
Bernie Lehman
Lehman Wesley & Associates
------------------------------