Skip to main content

Notifications

Announcements

Forum Structure Changes on 11/8 – Update Your Subscriptions!
News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Set Journal number acc...
Finance | Project Operations, Human Resources, ...
Suggested answer

Set Journal number accordingly to the previously generated number

(1) ShareShare
ReportReport
Posted on by M Saravanan 263
Dear Member,
 
It would be greatly appreciated if you could guide me to attain a solution to the issue that I am currently facing. Consider that I am posting an entry in the General Journal (or any journal). In order to create an entry, I select the /New/ button, and a new journal with the journal number (for eg. GJ-0002) gets created. Due to some reasons, I am deleting the journal and creating a new one. Now a new journal entry with the journal number (GJ-0003) gets created. Also, sometimes when pressing the down arrow to navigate to the previously created journals, the journal number for the newly created journal is automatically incremented.
 
I require that, If I am creating an entry, the entry number should follow the number sequence in order (i.e. After GJ-0001, GJ-0002, GJ-0003..). But in my case, if I delete the journal and create a new one, the journal number for the deleted journal is skipped and the number next to the deleted journal number is assigned.
 
Is there any way to resolve it? If so, please help me to resolve the current issue that I am facing.
 
Thanks in advance,
Saravanan
  • Suggested answer
    Sukrut Parab Profile Picture
    Sukrut Parab 71,645 Moderator on at
    Set Journal number accordingly to the previously generated number
    What you are trying to achieve can be achieved using continuous number sequences however numbers which are lost will be re used later once you recover those using clean up process. Not necessary your next record is going to get immediate number which was lost.
    There is performance improvement done   in 10.0.34 if you set number sequence as continuous with pre allocation logic if you are setting up number sequence as continuous. Look for feature "Enable Continuous number sequence performance improvement". 
     Also read about continuous and noncontinuous number sequences on below link to understand how OOB feature works. 
     
  • Suggested answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 15,075 Most Valuable Professional on at
    Set Journal number accordingly to the previously generated number
    You need to setup the number sequnce as continious.
  • Martin Dráb Profile Picture
    Martin Dráb 229,275 Most Valuable Professional on at
    Set Journal number accordingly to the previously generated number
    Avoid continuous number sequence whenever you can. They're bad for performance and can cause other problems as well.
  • Suggested answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Set Journal number accordingly to the previously generated number
    Hi,
    I went to the test environment to test it, and the problem you mentioned does exist. You can check this blog: dynamics-tips.com which mentions the manual cleanup function, as it is mentioned in the article: also when you have the “Continuous” flag checked the “Cleanup” functionality is used to find any unused number and return it to the list of usable number sequence values. This can happen in cases where you may have an on-premises deployment and you have an unscheduled power outage or infrastructure failure. But unfortunately this does not work for me. I can only make the deleted number re-used by manually modifying the next number.
    Best regards,
    Kevin
  • Martin Dráb Profile Picture
    Martin Dráb 229,275 Most Valuable Professional on at
    Set Journal number accordingly to the previously generated number
    My recommendation is not to worry about it. What problem do you see with it?

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

News and Announcements

Forum Structure Changes on 11/8 – Update Your Subscriptions!

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,900 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,275 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans