Get records next sequential number in record producer

Dan Belostotsk1
Mega Expert

Hi Guys, need your help.
 I have a custom table(u_numbers_test) and a custom field (u_number) to manage record numbering.
 Set as follows: 
find_real_file.png

 u_number dictionary default value set as follows:
find_real_file.png

 

This works fine, and each time I insert a new record from the list I get the next sequential number (ex: NT0001001, NT0001002, ....) , as expected.

Next, I have a record producer on top of this table, I defined a custom variable to get the next sequential number 
as follows:

find_real_file.png

 

 It works, and it generates the next number, but it jumps 9 numbers each time the script runs (ex from this record producer I'll get NT0001001, NT0001010, NT0001019 etc) each time i "Try it".

 

How can I get the next sequential number from my Record Producer? 

 

Thanks.

2 REPLIES 2

vinothkumar
Tera Guru
Right click and configure dictionary, you will find a script include for the default value and you can use the same

tvani
Tera Contributor

Number gets auto inserted with the default value set on the custom Table. You need not have a number mapping variable on your record producer. 

Capture any other details that are required for the custom table, number gets autopopulated.

 

Thanks & Regards,

V