Add Pre-fix to Sales Order Number thru VI Import

SOLVED

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