Hi @m.arif ,

Please refer the link given below.

I created something like that before.

I created a custom event and it will read the latest value from the custom field and I added 1 to the next value. You can play with the PLSQL code. When you create a custom field in a LU IFS automatically create a API which end with CFP. The best way to see the process is Open your Debug Console and try to add a value to the custom field and you will see what is the procedure used by IFS. You need to call the same procedure when you build your PLSQL code. I hope this help!.

i want this sequence number to reset back to 1 once the new transaction is created. i saw both the solutions and found out that is is like a running serial number. for example every business opportunity line  must start with new number 1 as sequence or serial number at opportunity level. please share your custom event.

@m.arif  Unfortunately, I made the custom event in my previous work place.

Share an screenshot about what you are trying to do.

Let see if I can build it in my environment.

what is the logic in the custom field? what are you trying to display?. Each line in the Opportunity Lines has their own Lines No. 

can we have a small meeting @ZTC ZTC JGOTA  , I can walk you through the steps. share your email id , will send you an invite.

Thank you so much @ZTC ZTC JGOTA . 

@ZTC ZTC JGOTA Hi Can you please tell us what you did for creating autonumbering custom field?