You’re offline. This is a read only version of the page.
1,745
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
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
i just kept in braces for your better understanding
in actual code there is no braces
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;
}
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (