2018 Import into Job Posting Entry - Error

SOLVED

Having an issue with Cost Codes in an import into Job Posting Entry.  The cost codes, with "-", are longer than 9 characters, and I do have the Skip Source Data Transaction checked.  It still did not like the Cost Code, so I did a calculated field where I took out the dashes.  It then seemed to calculate the cost code correctly, but said it was not on file (which it clearly is).  I changed the Job Cost Options to do no validation, and still cannot get it to accept the cost codes.

I have a cost type (valid, although it shows as invalid since there is no valid cost CODE) and a job number (valid).

Parents Reply
  • +1 in reply to bethbowers
    verified answer

    One caveat of the GetNextEntry method is that because it is a calculated field, VI does not compare its value between the last record and the current record. So make sure you are setting something to a Header field from your source file using the Replace operation.

    Using these settings.

    With this source.

    Gave me these results.

Children