It is my understanding that this is a limitation of PDM/SQL. PDM cannot look at one variable and decided how a serial number issued in another variable behaves.
I can think of two options here:
- Make the serial number variable writeable and allow the user to simply write in whatever they want, thus disallowing the increment.
- Use different folders for primary and secondary machining types. You can then have a card for the primary folder that does issues a serial number and a card for the secondary machining types not issues a serial number.
If we consider the Option 1)
Then Even if we insert the new file, then It will show the new number.
For eg from the above image, let say the new serial is 64, and i rewrite it as 63. my job is done. BUT if i enter a new file it will take it as 65 serial number.
Option 2 )
We cannot go for that since it will complicate the folder system for the users.
for option 1 you would stop using PDM serial numbers all together.
for option 2, folder structure should not matter to users - they should be finding files with the search tool.
How and when does the serial number get created?
- Is it done by the user running a template or by a dispatch?
- Is it created during check in or at some random point in or right after the inputs are selected?
Serial number gets created when ever new drawing is getting created from SOLIDWORKS/ AUTOCAD. (by the user using SOLIDWORKS, For now no dispatch and template, But using data card)