Microsoft Dynamics NAV (Archived)

number series

(0) Share

Report

Posted on by javedakhtar

1,751

i want to generate number series using different setup table

i have two table ,

table:product setup

field name:

Primary Key

Product Nos.

table:Product

field name:

No.

Product Name.

Number series :97

butt when i try to run a page to generate number series

it throw error:

The Product Setup does not exist .identification field and values Primary Key="

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (0)

Suggested answer

Community Member on at

Like (1)

Report
Copy link

Link copied!

You should debug the code for above error it'll clear what is missing in your setup.

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Could you paste the code?

Was this reply helpful? Yes No
Suggested answer

Tharanga Chandrasekara 23,118 on at

Like (1)

Report
Copy link

Link copied!

Please post the code in here so that we can check, or else start the debugger and run your code. Debugger will stop at the point of the error.

Was this reply helpful? Yes No
Tharanga Chandrasekara 23,118 on at

Like (0)

Report
Copy link

Link copied!

Did you found a solution?

Was this reply helpful? Yes No
javedakhtar 1,751 on at

Like (0)

Report
Copy link

Link copied!

OnInsert(){

IF "No." = '' THEN BEGIN

ProductSetup.GET;

ProductSetup.TESTFIELD("Product Nos.");

NoSeriesMgt.InitSeries(ProductSetup."Product Nos.",xRec."No. Series",0D,"No.","No. Series");

END;

}

No. - OnValidate(){

IF "No." <> xRec."No." THEN BEGIN

ProductSetup.GET;

NoSeriesMgt.TestManual(ProductSetup."Product Nos.");

"No. Series" := '';

END;

}

AssistEdit() : Boolean{

ProductSetup.GET;

ProductSetup.TESTFIELD("Product Nos.");

IF NoSeriesMgt.SelectSeries(ProductSetup."Product Nos.",xRec."No. Series","No. Series") THEN BEGIN

NoSeriesMgt.SetSeries("No.");

EXIT(TRUE);

END;

}

Product Page code:

No. - OnAssistEdit(){

IF AssistEdit THEN

CurrPage.UPDATE;

}

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report
Copy link

Link copied!

Hi,

From the above code, it seems that everything is commented. Are you sure this is the code where you are getting the error?

Was this reply helpful? Yes No
javedakhtar 1,751 on at

Like (0)

Report
Copy link

Link copied!

i just kept in braces for your better understanding

in actual code there is no braces

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Could you check whether your Product Setup contains any record?

Was this reply helpful? Yes No
javedakhtar 1,751 on at

Like (0)

Report
Copy link

Link copied!

Hi Mahesh Sir

I contain only one record ,i.e

primary key Product Nos

1 Product

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I thinks you should add one more field "No. Series" to table:product setup

Was this reply helpful? Yes No