Sage 100

Does anyone have a VI job importing into SO Invoice D/E that has both regular items (with lot distributions) and misc. items? Mostly, it's the Record tab that is causing trouble. I can't identify Skip records or assign the line type without messing with the invoice number (all lines go to one invoice number instead of multiple invoices which I am trying to replace from the source file). Every time I conquer one issue, another arises. I know this is brief but I am banging my head against the wall with this one and would appreciate seeing a successful job. (V 4.40.8) TIA!

I don't.

Thanks for sharing @RobertWood. I've written imports like this before but it seems 4.4 throws a whole lot of variables out there that I can't account for.

I'm working with another reseller on a similar issue. Once we get it working, I'll share (if they permit).

As an update, while @JeffSchwenk was very helpful - thanks again, Jeff! - the issue comes down to the fact that this customer has ACS's multi-bin enhancement. Ron Chompf sent me a new file to help fix one problem but that then broke another piece. BTW, this is for a customer who did NOT choose @haroldwestover's POS solution. Don't forget our webinar which starts in about 15 minutes. Click here to avoid the headaches I've experienced with a different POS system. https://www3.gotomeeting.com/register/770527262

Hate enhancements for that very reason!