Numbering by pressing F3

tiagofrancis

Hi Folks,

I've built a form based on a table of my one.
Generaly, when i feed the table with some process i look for the last entry number and +=1.

But, when i hit F3 on the form the record does not increment..
What is the best easy way to handle this...?

Thanks in advance..

Savatage

search the forum about setting up your own number series.

David_Singleton

Actually in this case I don't think you need a number series. Either

a/ use a primary key of type BigInteger with the property Autoincrement set (see table 405 for an example) OR

b/you need to find the last record and use code to increment it. (see table 32 for an example)

Note that in a/ above the numbers may not be sequential and some numbers may be skipped. So if you need a contiguous series then use B/

arindom

You have to write code on insert of table .and call No. series managment codeunit. see any master table oninsert .

nunomaia

David Singleton wrote:

Actually in this case I don't think you need a number series. Either

a/ use a primary key of type BigInteger with the property Autoincrement set (see table 405 for an example) OR

b/you need to find the last record and use code to increment it. (see table 32 for an example)

Note that in a/ above the numbers may not be sequential and some numbers may be skipped. So if you need a contiguous series then use B/

If are using option b given by david then you could use this std code.

  IF JobLedgEntry."Entry No." = 0 THEN BEGIN
    JobLedgEntry.LOCKTABLE;
    IF JobLedgEntry.FIND('+') THEN
      NextEntryNo := JobLedgEntry."Entry No.";
    NextEntryNo := NextEntryNo + 1;
  END;

tiagofrancis

In what trigger do i have to put the code?

nunomaia

I miss understood your question. I thought that you wanted to auto increment using a codeunit. You will increment in insert the easiest way will be increment using auto increment property.

najlamth

Hi,,,,
donot forget to set property "NotBlank" to false.
If your data type is integer for this field you should to write code to increment tthis field like below:

YourTable.RESET;
YourTable.SETFILTER("No.","No.");
IF YourTable.FIND('+') THEN
"No. Series":= YourTable."No. Series" + 1
ELSE
"No. Series":=1;

Note: there is autoincrement property in NAVISION for the integer fields

najlamth

Hi,,,,
donot forget to set property "NotBlank" to false.
If your data type is integer for this field you should to write code to increment tthis field like below:

YourTable.RESET;
YourTable.SETFILTER("No.","No.");
IF YourTable.FIND('+') THEN
"No. Series":= YourTable."No. Series" + 1
ELSE
"No. Series":=1;

Note: there is autoincrement property in NAVISION for the integer fields