Finance | Project Operations, Human Resources, ...

NumberSequence-Finanical Year End

(0) Share

Report

Posted on by NDingankar22

515

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?

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
NDingankar22 515 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
NDingankar22 515 on at

Like (0)

Report
Copy link

Link copied!

will the above job suffice my req?

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Thomas Tian on at

Like (0)

Report
Copy link

Link copied!

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 .

Was this reply helpful? Yes No