90
Some timecards in the Timecard Status screen showing as missing for a specific week ending date, however these timecards has been completed and/or approved but the status still show missing. Any idea why the statuses are not matching timecards?
Thank You
*This post is locked for comments
Hello Nick,
It could be that the timecard was entered and saved and then the information in Week Maintenance was changed. For instance, for one of the timecards showing incorrectly as missing in the screen, note the week ending date and see what week number that is for the period. Then run the statement below in SQL Server Management Studio and see what value is in the week_num field.
If, for example, the timecard showing as missing in the Timecard Status screen says it's for week 4, but the week_num in the table below indicates it is week number 5, then that is why it shows as missing. The status screen looks for an exact match on week number and week ending date. If it doesn't find one..it's listed as missing.
Select week_num, period_num, pe_date , * from pjlabhdr where docnbr = 'xxxxxxxxx'
Let me know what you find.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (