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?
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 .
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
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
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.
will the above job suffice my req?
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (