Skip to main content
Post a question

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Error in Number Sequence

Posted on 19 Mar 2016 04:43:20 by Microsoft Employee

Hi,

When I open new form to create new vendor, I am getting error as:

"Default scope cannot be implicitly determined by the number sequence framework for the given datatype. Please provide scope information explicitly"

 

Note:

1. When I go to Number Sequences in module parameters, Number Sequences are not listed.

3. When I generate number sequence it is giving info as "Application already has required Number Sequence"

 

*This post is locked for comments

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,269 Super User 2024 Season 2 on 20 Mar 2016 at 13:02:06
    RE: Error in Number Sequence

    I do agree with Martin. If you don't have transactions yet it might be attractive to rebuild all nimber sequences, but some sequences are internally used for e.g. global address book records and locations. You might get duplicate key exceptions if you rebuild from scratch. So it is recommended to use a backup database to restore the table contents.

  • Martin Dráb Profile Picture
    Martin Dráb 230,198 Most Valuable Professional on 20 Mar 2016 at 09:13:05
    RE: Error in Number Sequence

    Probably. I can't be 100% sure without making an analysis.

    Again, restoring your database is easier and safer.

  • Community Member Profile Picture
    Community Member Microsoft Employee on 19 Mar 2016 at 08:38:37
    RE: Error in Number Sequence

    If I delete all NumberSequenceScope, NumberSequenceReference and all tables which is prefixed with NumberSequence will it allow to run Number Sequence wizard to generate number sequence?

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 230,198 Most Valuable Professional on 19 Mar 2016 at 07:47:34
    RE: Error in Number Sequence

    That's the problem. By removing and reimporting data in NumberSequenceDatatype, you've broken references in the number sequence system.

    To go back, restore your database from a backup.

    Alternatively you can manually fix the data, i.e. update broken Rec ID references and who knows what else is broken.

    You could also clean up number sequence tables before generating default ones again. But it may not be feasible if you already numbers generated from number sequences.

    The restore from backup is the best solution, in my opinion.

  • Community Member Profile Picture
    Community Member Microsoft Employee on 19 Mar 2016 at 06:57:31
    RE: Error in Number Sequence

    I did deleted data of NumberSequenceDatatype table by exporting table. After that this problem occured.

    So again I imported table with all data but still problem is there.

    It is not fresh installation it is having all company configuration.

    Is it possible to restore whole number sequences to default or previous?

  • Martin Dráb Profile Picture
    Martin Dráb 230,198 Most Valuable Professional on 19 Mar 2016 at 06:16:41
    RE: Error in Number Sequence

    Please tell us what happened before you got into this problem. Is it a new installation, or did it work before and number sequences disappeared? Didn't you import data or modelstore from another environment?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans