Hi Everyone,
I am trying to run a recurring transaction batch in AR but I am experiencing an error. I have it set to run on the 27th day of each month (today) but it will not run until the 29th. Notice “GL Error: The next generation date for this task is greater than the current business date.” I realize I could change the business date to the 29th but I would like all the invoices to date on the 27th. Is there something I am doing wrong here?
Thanks
Best answer by meganfriesen37
Hello, the interesting thing that I noticed is that the “last executed date” is 1/30/2024 and the “next execution date” is printed as 2/29/2024. Do you change the execution date each month (i.e. it might make more sense to change your series to execute on the last Tuesday over every month)?
Unless you’ve got someone who can do a SQL update in the background to change that “next execution” date you might be stuck running them on the 29th and then editing the batches before you release them.
+12Hello, the interesting thing that I noticed is that the “last executed date” is 1/30/2024 and the “next execution date” is printed as 2/29/2024. Do you change the execution date each month (i.e. it might make more sense to change your series to execute on the last Tuesday over every month)?
Unless you’ve got someone who can do a SQL update in the background to change that “next execution” date you might be stuck running them on the 29th and then editing the batches before you release them.
Hello, the interesting thing that I noticed is that the “last executed date” is 1/30/2024 and the “next execution date” is printed as 2/29/2024. Do you change the execution date each month (i.e. it might make more sense to change your series to execute on the last Tuesday over every month)?
Unless you’ve got someone who can do a SQL update in the background to change that “next execution” date you might be stuck running them on the 29th and then editing the batches before you release them.
It looks like they run it manually on a certain day instead of using the generate transactions screen. We just did an upgrade from 2021R2 which might be one of the reasons for the errors. I was thinking the same thing, change the business date, and then create a quick import scenario to change the doc date to the 27th on all of them.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
