Skip to main content

Notifications

Microsoft Dynamics AX forum
Suggested answer

NumberSequence-Finanical Year End

Posted on by 487

Hi,

I want to update the Number sequence  from 19 20 to 20-21

What is the best way to update the same.

Am planning to write the below job

statuic void job(Args_args)

{NUmberSequencetabel t;

while select for update t

{if(strcontains(t.format,"1920")

{ t.format=strreaplce(t.format,"1920",2020");

t.annotatedformat=strreaplce(t.annoatatedformat,"1920","2021");

t.nextrec=1;

t.doupdate();

}

Will this job suffice my requiremnt or i need to update it manually? 

  • Thomas Tian Profile Picture
    Thomas Tian on at
    RE: NumberSequence-Finanical Year End

    Hi NDingankar22,

    I suggest you create a new numbersquense use the format 2020, add apple the numbersqeuse to the Journal you want change. 

    by the way, I suggest you test you job at UAT environment .

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: NumberSequence-Finanical Year End

    Good Morning NDingankar22,

    Have you been able to get this issue resolved in the meantime?

    Would be great if you could keep us informed whether there is something else the community can help you with.

    Many thanks and best regards,

    Ludwig

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: NumberSequence-Finanical Year End

    Hi NDingankar22,

    I think running the job should fix your issue.

    You can basically run it multiple times until you achieve the required outcome.

    I would recommend that you run it in a demo/test system first to check and prepare for the run that you will do tomorrow.

    Best regards,

    Ludwig

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: NumberSequence-Finanical Year End

    You can find out by testing your job. Another approach would be to create a new number sequence for the next month. 

    But why do you need to change the nr format every month? What is the business requirement here? You should use voucher date to find records that are created in some month/date.

  • NDingankar22 Profile Picture
    NDingankar22 487 on at
    RE: NumberSequence-Finanical Year End

    will the above job suffice my req?

  • NDingankar22 Profile Picture
    NDingankar22 487 on at
    RE: NumberSequence-Finanical Year End

    Thank you Dr Ludwig. I will run this job on 31st march at 12. So on 1st april they get the new number series. My senior recommend me to update manually and change the format. I am not changing any existing records. Just from 1st april they need the number sequence to be like--TEST/CR-2021 instead of TEST/CR-1920

    Manually is hectic process so was planning to write the above job.

    they just need the number sequences updation

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: NumberSequence-Finanical Year End

    Hi,

    There is no option to update the number sequence for the voucher created.

    What you can do is running a new year end closing process where you specify the number for the voucher that you want to use.

    This does require any code adjustment.

    By the way: You cannot simply manipulate a posted transaction from a legal/accounting perspective. For that reason, rerunning the year end close process seems to be the only viable option for me.

    Best regards,

    Ludwig

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

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,867 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,173 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans