Skip to main content
Dynamics 365 Community / Forums / Finance forum / Set Journal number acc...
Finance forum
Suggested answer

Set Journal number accordingly to the previously generated number

editSubscribe (1) ShareShare
ReportReport
Posted on by 204
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
Categories:
Attachments
  • Suggested answer
    Sukrut Parab Profile Picture
    Sukrut Parab 71,633 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 13,138 Super User 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 222,689 Super User 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 222,689 Super User 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?

Helpful resources

Quick Links

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,130 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,689 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Featured topics

Product updates

Dynamics 365 release plans