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
Hi Javed, you must set a primary key. I'm also with Jaideep.
Let us know if you solve your issue.
Regards,
Hi,
I agree with Jaideep. Please check his solution on this.
Hi
If your product Setup table contains value of primary Key: 1 then you need to "Get" that value. But since it is a setup table it should be blank.
The error is specifying that there is no primary key in the table where the value is "" which is causing the error.
I thinks you should add one more field "No. Series" to table:product setup
Hi Mahesh Sir
I contain only one record ,i.e
primary key Product Nos
1 Product
Hi,
Could you check whether your Product Setup contains any record?
i just kept in braces for your better understanding
in actual code there is no braces
Hi,
From the above code, it seems that everything is commented. Are you sure this is the code where you are getting the error?
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;
}
Did you found a solution?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,232 Super User 2024 Season 2
Martin Dráb 230,064 Most Valuable Professional
nmaenpaa 101,156