+2
Where can I define on how a new engineering part part number should look like ?
It should be 10 digits long with zero leading .. like 0000000001, 0000000002 etc.
Also where can the next free “number” be defined (we are already at the number 0000054321) ?
We are at ifs cloud 23.1.6
Thanks, Roger
+7
You can use Workflows to validate if it is 10 digits long and gives a message if not saying it should be 10 digits long and preceded by zeros. But unless there is an API to get it I’m not sure if Workflows can be used to generate the next number in a sequence.
+7
Hi Roger - I suspect that if the workflow would work for you as outlined by Lahirumala, you could probable add some SQL code to the work flow to identify the next appropriate number - something like:
(I’m not sure on the table names and I have not tested the nesting of the sql functions)
select lpad((max trunc(part_no))+1,10,0) from master_part
+7
You cannot use SQL in workflows. Only projections/APIs.
+15
Everytime a new Engineering Part is created and the eng part no is left blank, the system will get the next number from this sequence.
+2
Hi Marcel,
I tried to query ENG_PART_MASTER_SEQ and PART_NUMBER_ID_SEQ but both tables were not reachable with quick report .. are those tables in Aurena too ?
+15
Here is a link to shed some light on how these would work:
+21
I've not checked any coding if a cross check is done between the sequences when a new part number request is done.
+15
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
