Automatic creation next Serial Number in Customer Equipment Card
We are looking for the right query so that the Serial Number in Customer Equipment Card (OINS - InternalSN) automaticly increases by 1.
We always create our own Serial Numbers and do not use Serial Number Management. The Serial Numbers are also the unique numbers (under General Settings - Stock - Items - Unique Serial Numbers by).
We already found this query on the forum: SELECT MAX(T0.CardCode)1 FROM [dbo].[OCRD] T0 and altered this to: SELECT MAX(T0.InternalSN)1 FROM [dbo].[OINS] T0
We put the Customer Equipment Card in create (not Find). After that we put a Formatted Search in the field OINS - InternalSN with the query above, selected Auto Refresh When Field Changes, selected the field Item No. and selected Refresh Regularly.
What do we have to change to get it work.