Sage 100

Has anyone had an issue with importing an inventory adjustment into Sage that is a lotted item and if consecutive lines have the same quantity the import shows that all records are imported but when you go into Transaction Entry you find only half of the records that VI says imported? There are no failures showing in the VI job nor are there any errors. Client is running 2015 SU2

I think I have seen something like that. You may wish to try creating some extra field/piece of data that makes every record unique, e.g. maybe add an additional column to your import source file that contains a sequential # and point a Temp field to it.

Thank you @BrettZimmerman . It worked by using the TEMP field and making it assign on ""Key Assigns Only

Glad to hear it; good to know. I just remembered that the last time I had to address this (SO Invoice import), I actually created a new line UDF to store the extra piece of unique data. I guess at the time I didn't consider using a Temp field.

We've seen this a few places and are in the habit of making sure something changes with each line (using the Temp field trick). I think Sage sees it as the same line unless an input value changes. Good to know about the third level (cost tiers) needing the Temp field as Key Assigns Only.