I'm wanting to get orders imported started with a J and have them increment for every new order that comes in.

I managed to get the J in there, but with using the "NEXT" order number.

Is there a way to have the vi job check for the last order, then start the count and add 1 for every new import?

Can vi pull a variable in from csv sheet and use that number and start incrementing from there?