Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Best Regards,

Tim

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question