Hi,
We are importing orders from a third party into SO Entry via Visual Integrator. Is it possible to use the "Next" SO number but drop the first digit and add a letter. For example, if the next available SO number is 0123456, I would like my imported sales order numbers to be 'N123456', 'N123457','N123458' and so on. Can't figure this out if it possible.
Thanks for any advice.
Kathy
In a script, you would use another SetKey method with the new sales order number.
My VI idea works in v2018.3.
That is surprising! But will it work for orders with more than one line? Or will it create a new SO for each line?
It works for more than one line. VI performs some logic whenever Next is used on the key field. It does something along the lines of either comparing the entire header record or the required fields of…
It works for more than one line. VI performs some logic whenever Next is used on the key field. It does something along the lines of either comparing the entire header record or the required fields of the header record to the previously read record from the source, if they differ, it commits the previous header record and then starts the new header record with the current record from the source.
