News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Fixed Assets number Se...

Finance | Project Operations, Human Resources, ...

Suggested answer

Fixed Assets number Sequence Exceeded

(0) Share

Report

Report

Posted on by Raj_P85

59

When our Fixed asset transfer number sequence was set up. It was done with the range 1 - 999.

We have now hit the 999 and the next number is 1000

However when editing the sequence i get the below error:

I added the Alphanumberic to contain a length of 4. but I still get the error.

Any ideas?

All responses Img

All responses (5)

Answers Img

Answers (0)

Raj_P85 59 on at

Like (0)

Report

Fixed Assets number Sequence Exceeded

Hi @Frank:
Frank Hamelly | MVP... 46,270 Super User 2025 Season 1 on at

Like (1)

Report

Fixed Assets number Sequence Exceeded

D365 allows a number sequence with up to 20 characters, with a max of 9 characters in the numeric segment. As soon as you attempt to exceed that, it screams with the following error. I still think the error message is related to the Reference section.
Suggested answer

Kevin Xia Microsoft Employee on at

Like (1)

Report

Fixed Assets number Sequence Exceeded

Hi,

According to your description, The error message suggests that there are references using the current number sequence that don't have sufficient length to accommodate numbers from the updated We created new number sequences based on the screenshot you provided, and the warning message in your screenshot did not appear. The screenshot we created is as follows:

We recommend that you:

1. Check related entities: Ensure that you have considered all the related entities or tables that might be using the Fixed Asset transfer number sequence. These could include transaction records, journals, or any other entity where the number sequence is being utilized. Update the number field length in those related entities to match the new alphanumeric format with a length of 4.

2. Consider database constraints: Double-check if there are any database constraints set on the number sequence field in the relevant table. If so, you may need to modify or update those constraints to allow for longer alphanumeric values.

PS: From the perspective of error type, this is a warning type, not an error type that will block the process. Does it affect your normal processes?
JamesT 341 on at

Like (1)

Report

Fixed Assets number Sequence Exceeded

Howdy Raj,

You are trying to have an 11 digit number sequence, D365FO doesn't like that.

Options

1) Create a new number sequence with less digits

2) Try and change the existing number sequence by removing part of the "Constant" section.

Regards

James
Frank Hamelly | MVP... 46,270 Super User 2025 Season 1 on at

Like (1)

Report

Fixed Assets number Sequence Exceeded

Please open the References Fasttab, take a screenshot and post here. There error message refers to references.

Helpful resources

News and Announcements

Announcing Our 2025 Season 1 Super Users!

Announcing Forum Attachment Improvements!

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,074 Super User 2025 Season 1

#2

Martin Dráb 230,900 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans