Hi! In Time and Expense Entry → Time → Work Hours tab, there is a screen that shows “Work Hours” (which is the scheduled work hours), the Booked Hours and the Difference. Does anybody know where the “Work Hours” is coming from on this screen? I cannot figure it out, and I am usually pretty good at figuring these things out. I thought ShopCap, however, ShopCap only has data going back 30 days and we can go back further than 30 days on this screen. I need to use these scheduled hours per day going back 6 months in a report, but i cannot figure out where it is pulling from. Any ideas at all would be so appreciated. (Side note, i did try asking this via and Epicor Support Ticket, but that was not helpful). Thanks!
Unfortunately they appear to be ‘External Fields’ so not something you can really query against in my experience. I know I have seen some references as to how you can manipulate them before but it was a long time ago now. I generally just give up when I run into this type of thing that Epicor is doing behind the scenes/in the DLL.
Thank you for taking the time to reply. I wish i could just give up on this one :)… I need to figure out where it is or how it is being calculated. Hopefully I can get it without too much wasted time. Appreciate the response.
I’m looking at a Kinetic screen, but assuming the functionality is consistent (may be a horribly bad assumption)…
These fields are being populated on the screen via rest call to LaborSvc.GetRowsTimeEntry
There is a dataset that is returned called TimeWeeklyViewRow
That data is going into dataview called TimeWeeklyView.
Do you use shifts? If so are those shifts 12 hours like what is shown in your screenshot, that would be my go to though for what is driving this. That or your production calendar, or both together.
Thank you. Yes we do. We use shifts and production calendars in very great detail. I believe this data was being generated from the employee production calendar. I am trying to figure out exactly where the day by day information is stored or how it is calculated for the historical information. ShopCap does have the daily information and i can use that able, HOWEVER for some unknown reason it only has data going back 30 days (even though we never delete shop caps when we run this). Our production calendars are very complex due to our rotating shifts schedules.
Thank you for that information. I will see if i can figure out how to get it from that to use in a BAQ. I am not familiar yet with accessing data that is not in one of the standard epicor tables.