Sage 100

What is the trick in Visual Integrator to get a file without a Sales Order Number to pull in all lines on one order number now that the Change on Next function has been removed in 4.40 and above.

All of the header fields have to have the same value.

Well, at the risk of misinterpreting your question and having @ShawnSlavin say I am talking about bowling balls, I've just checked v4.4, v4.5 and v2013 and all three versions have a VI for SO header that allows the SO number field to be defined as a next operation. I point to a field that only changes when the SO changes (e.g. customer name). This has worked reliably for me.

@JeffSchwenk I was just teasing! Sorry if that wasn't clear. However, I have to admit that I didn't get the connection with Moira's challenge and using KnowledgeSync. You were obviously approaching the issue from an angle I wasn't considering. Well done. On your recommendation above, that's exactly what we did for an import into SO in version 4.5 for a client. Peace out.

@ShawnSlavin - And so was I......

Thanks guys, you rock! I checked Sage City and the question has been out there for several years with no resolution. Nothing on Sage Knowledgebase (no shock there). 90 Minds is the answer!