Sage 100

Visual Integrator - Trying to import sales orders using the NEXT order number. The source file contains both Header and Detail info but the Header info for each order is only on the first line. Subsequent lines of the order only have a matching Customer PO# and the details for that line. VI is only importing the Header and the Detail from the first line. It see's the other lines as another order with no headers. Tried different things with VI but unable to get it to work. Any help would be appreciated. Attached is a sample of the file layout

when you use the NEXT feature, Then Sage looks at header data and if ANY header field changes then Sage assumes this is a new order. For example in your case, since your ship address changes from ""Ship 1"" to a blank field then a new order is started for the second line. I think you may need to reformat your source data if you want to use NEXT functionality

I'd try putting column 2 & 3 into temp fields using the Key Assigns Only option (then passing the values through to the fields using a calculation when not blank) to see if that works. In theory those columns wouldn't be considered Header fields then...

I like @KevinMoyes idea, let us know if that works.

Thanks guys. They are exploring the option of having the vendor that provides the file do a little modification to give us repetitive headers. If that doesn't work I'll test Kevin's idea and post back. Thanks again

I also like @KevinMoyes idea, but the other route could be a 'data-cleansing' PowerShell script. It's pretty easy to work with CSVs with PowerShell, and then you could have it call the V/I job.