web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

number series

(0) ShareShare
ReportReport
Posted on by 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)
  • Suggested answer
    Community Member Profile Picture
    on at
    RE: number series

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

  • mmv Profile Picture
    11,471 on at
    RE: number series

    Hi,

    Could you paste the code?

  • Suggested answer
    Tharanga Chandrasekara Profile Picture
    23,118 on at
    RE: number series

    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.

  • Tharanga Chandrasekara Profile Picture
    23,118 on at
    RE: number series

    Did you found a solution?

  • javedakhtar Profile Picture
    1,751 on at
    RE: number series

    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;

    }

  • mmv Profile Picture
    11,471 on at
    RE: number series

    Hi,

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

  • javedakhtar Profile Picture
    1,751 on at
    RE: number series

    i just kept in braces for your better understanding

    in actual code there is no braces

  • mmv Profile Picture
    11,471 on at
    RE: number series

    Hi,

    Could you check whether your Product Setup contains any record?

  • javedakhtar Profile Picture
    1,751 on at
    RE: number series

    Hi Mahesh Sir

    I contain only one record ,i.e

    primary key         Product Nos

    1                            Product

  • Community Member Profile Picture
    on at
    RE: number series

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans