By using this website, you agree to our Terms of Use (click here)
I'm looking to write a GI that shows all timecards where materials have been entered but not a time entry.
I thought I had this linking PX.Objects.EP.EPTimeCard to PX.Objects.EP.EPTimeCardItem (inner join on timecardCD) with PX.Objects.EP.EPTimeCard to PX.Objects.EP.TimeCardMaint+EPTimeCardDetail (left join timecardCD). Then I filter out lines with a date value from the PX.Objects.EP.TimeCardMaint+EPTimeCardDetail table.
However, it appears that when timecards are not submitted, the time entry in PX.Objects.EP.TimeCardMaint+EPTimeCardDetail does not have a timecardCD and so doesn't link. I've tried linking this table using WeekID and EmployeeID but I can't get it to work.
How do unsubmitted time entries in time cards link to the EPTimeCard table?
thank you
You can find unsubmitted time activities in PMTimeActivities, all time will be reflected there. We have a customer that doesn't use Time Cards, to that is what we are using for their base point. As for inventory items, it links with Labor items and Overtime Items, I'm looking at how it would connect with an Inventory Item.