Visual Integrator: records read not equal to records passed, but no records failed or were skipped

SOLVED

We are importing SO  invoice records using VI. There are 445 lines in the file.  The summary says that none of them failed or were skipped, yes the number "passed" is not equal to the number read.  

What causes this to happen?  

From looking at the summary, we can see that some lines were indeed silently skipped.

Parents Reply Children
  • 0 in reply to bradvido

    More info on this. We've found that moving the line that is skipped to a different position in the import file (usually down a few lines in the invoice) will cause everything to work w/o skipping any lines. We, however, cannot determine what is causing this! Any ideas what would cause this?

    Update: This problem seems to occur when two lines that are very similar are next to each other in the import, namely the Item Code and Item Type are the same on the two lines.  I still don't understand why the line gets skipped, especially since moving it to a different position fixes the problem.

  • 0 in reply to bradvido
    L.LotSerialFullyDistributed pertains to items with the Lot or Serial valuation. (There is no documentation for things like this, outside of the help files).

    What you describe sounds exactly as I suspected. The subsequent line is updating the previous row instead of adding a new one. I don't know what to suggest other than playing with the job settings to see if you can get something to work. Something odd like L.LineKey set to column 100 (i.e. something not in your data source) might do the trick.