Sage 100

Working on a VI import into SO_InvoiceHeader (pulling from Sales Orders); the basic purpose of this is to import the quantities and lot numbers for items that have shipped. We can't import into Sales Order itself - long story, don't ask. A few items on the import are NOT lot items. I have a conditional formula on the LL.LotSerialNo looking at CI_Item.Valuation; and it is supposed to only assigns the lot number if the valuation = 5. BUT it fails the records that are not lot - saying the lot number is invalid. It is possible to skip over the lot assignment altogether in this situation?

Can you have 2 VI jobs chained together - one that imports the lot items and another that imports the others?

Possibly, getting a lot of resistance from the client saying the process needs to be as simple as possible. They are using a 3rd party warehouse to do their shipping and they send over a file. The strange thing that I need to get to the bottom of, is the shipping warehouse assigns a lot number to the FIFO parts. Not sure where the lot numbers are coming from, but they are populated on the spreadsheet. So to do a chain I either need to have the spreadsheet revised or figure out how to do a skip record when the field is populated anyway.