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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

When creating a statement in AX2012 R3 - HQ error 'Number sequence does not exist'.

(0) ShareShare
ReportReport
Posted on by 3

After doing a migration from AX2012R2 RTM (plain, no CU's)  to AX2012R3CU9  we encoutered the same issue as indicated in the next linkedin post : 

When posting a statement in AX2012 R2 - HQ I get an error 'Number sequence does not exist'.  From <https://www.linkedin.com/grp/post/3726956-230770796

 

After testing all the options we had to debug, and found that the datatype definition for the statementid was wrong in the numbersequence tables  NumberSequenceDataType and NumberSequenceDataTypeParameterType.

 

for statement datatypeid  17358 (retailstatementid)  we had to chage the Scopetype to be 4 (operating unit) on the NumberSequenceDataType,  and   for the related record in NumberSequenceDataTypeParameterType  we changed  the parametertype field to be "Operating Unit"

 

After doing this and generating the number sequences back again, the system allowed to create the statements.

 

don't know if this is and issue in the upgrade script.

 

would appreciate other comments to identify if this situation is happening also in possible upgrade scenarios from AX2009,AX2012FP, AX2012R2  to AX2012R3cu9.

 

 

 

 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Camilo Virguez Profile Picture
    3 on at

    this solved it for me

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Sagar Suman Profile Picture

Sagar Suman 2 Super User 2026 Season 1

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans