We have a company where Timesheet Setup has Reporting Periods set to "Daily" and would like to change it to "Weekly", but it is greyed out. Is it possible to change it? If so, how would you accomplish this?
*This post is locked for comments
Hello,
You would need to do this through SQL, but you would first want to make sure that all transactions are currently posted first. Going forward you would use Weekly periods, but transactions that have been entered and posted previously would still use the old reporting period set up.
Always make sure you have a backup of your database before updating SQL, and I would recommend doing this in a Test company with a copy of live first to make sure you get your desired outcome.
select * from PA41801
I hope this helps!
Isaac Olson
Microsoft Support
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (