Sage 100

I am working on a VI job for Sage 4.5 that will import serial numbers into Inventory transactions. I receive an error when I have the same item listed multiple times with different serial numbers on each line. The error is ""HS Record Invalid or write failed. Line number 1 has not been distributed."" Does anyone have a V/I job or experience with a V/I job to import IM trx with serialized items?

In my experience you have 3 options. A) change the item detail record to show quantity of all of that item. B) separate the item code with a different one between two similar ones. C) have each item detail as a separate transaction number. I usually go with option C for simplicity.

And if I misunderstood the point of the problem of course you need to check separate line from header on the first page of the vi job tab

You are using the LL record for serial, right? Can you break it into two jobs, the second that handles the distribution?

Hmm, Robert's option C or Moira's 2 jobs idea may work. I'll work with this information and let you know the outcome. Thank you both!

Do you have L.TransactionQty and LL.TransactionQty both mapped in your import job? If you have multiple serial numbers for the same item, make sure L.TransactionQty is mapped to a column showing the total for that item for the entire file and the LL.TransactionQty is the quantity of just that serial number. If that isn't feasible then I've also used Robert's option C!

I've created a VI import that will import the serial numbers into Transaction Entry using a single import job. In my import file, I list the item number and serial number on each line and therefore, do not check the ""Header Separate from Line Record"" on the Configuration tab. This has worked for me.