Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Amy Axness]

We are having some issues with scheduling orders where 2013 dates are showing up.  In test, I have run the Calendar Cleanup (under Organization Administration -> Periodic -> Calendar cleanup) and it might help with our issue.  I can’t find much when I search regarding what is actually being cleaned up during this process.
1) Does anyone know what tables are affected?
2) Is it truly just the calendars being deleted, or is it deleting transactional data?
3) Is it okay to do a calendar cleanup through yesterday, or will that affect something else?
Thanks!

——————————
Amy Axness
Controller
J&D Manufacturing
Eau Claire WI
——————————

[Archive User]

I took a quick peek at the class (WorkCalendarDelete) and it is deleting information from the WorkCalendarDate Table [AX 2012].

This is the query it runs – 

delete_from workCalendarDate

where workCalendarDate.CalendarId == workCalendarTable.CalendarId &&

workCalendarDate.TransDate  <  toDate;

——————————
Josh Lee
Stoneridge Software Inc.
ND
——————————
——————————————-

[Amy Axness]

Thanks Josh!  That was exactly what we were looking for.

——————————
Amy Axness
Controller
J&D Manufacturing
Eau Claire WI
——————————
——————————————-