Hi.
I have imported a set of vendors with Data Management and a few had errors. The thing is DM consumed a sequence number for each of the vendor that had an error.
Question is. How can I use does numbers? If I set the Next Number for the one I need, It rises a message telling me that that number cannot be stablished because already exists an equal or higher in the number sequence list.
Is there a way to for Next Number?
Thanks.
Hi Claudio Dell Acqua,
The easiest way is to go to number sequence, make it manual, update the Vendors, and then change it back to the original setup. If it is continuous you can also enable "allow the user to changes" for a lower number.
Hi Claudio,
Could you please share a screenshot of the number sequence setup for vendors?
If it is only set to Continuous, you should be able to change the Next number. It will ask for a confirmation as this change might create inconsistency.
Hi. Vinit.
If I do that. Will I be able to import the vendor with DM?
For example. Next valid number is 144. If I set to Yes the Allow user changes To a lower number. This will let me import a vendor with the number 143 (skipped number)?
This is how it's configured now.
Hi. Gunjan.
This is how it is configured:
If I set Next to the number I need I get this message:
Can you try doing a Manual cleanup with the option shown below and try?
Hi,
Can you please check the Status list and check if the missing number is in the list?
Please run manual clean up if you don't see it on the list.
For Vendor import are you giving the Vendor id in a file or it is auto-generated?
If you are giving the id in the file then import should work by enabling the 'to lower number'. If this doesn't work go make it manual and import, which will work 100%.
Yes. I give de Vendor ID number in the excel that I import with DM.
Here is the status list.
I inserted several vendors with DM and those 4 sequence numbers in the red rectangle are the ones that got skipped.
I suppose that Feed in the Action column means that that number got used(?)
But there are lot of previous numbers. The ones in the red rectangle are the ones I want to use. And the ones in the blue rectangle are the ones "Freed" by other User.
The question is. If I do the Manual Clean Up. This will make all the numbers in this list available again?.
I only need to recover the numbers 95, 112, 131 and 143.
I hope I was clear.
Manual Clean Up will recover everything.
Status Free means available for use. Did you try importing the vendor already? You shouldn't get any error. You don't need to make any changes.
The action status "Freed" happens in case there was a crash or any unexpected issues. Please go through this blog for more details -
community.dynamics.com/.../number-sequence-clean-up-function-in-microsoft-dynamics-365-for-finance-and-operations
You can run the manual cleanup again, but I think it will make the other numbers available again for entry. If you are looking to use only these 4 numbers again, I think you can set the number sequence to manual and import the vendor records, as Vinit suggested.
Post your import, you may want to switch the settings back to "Continuous".
Success. But I had to change to Manual. I you left it in Continuos. You will get an error.
Thank fot the help.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 1,882
André Arnaud de Cal... 794 Super User 2025 Season 2
Sohaib Cheema 525 User Group Leader
