Discussions
Generate formatted running number
Dear all,
does anyone have experience with generating formatted running number, for example sales order name in format SO/201310/0001
I am having script that will generate formatted running number in User Event - Before submit.
I am facing problem if 2 user submit on the same time then :
1st user will get SO/201310/0001
2nd user will also get SO/201310/0001
after save
1st user will get SO/201310/0001
2nd user will get 101
which 101 is the default running number from netsuite for sales order transaction.
is there a best practice way to handle this?
or
does netsuite has return error that indicate that the number is already exist so we could generate new number for it.