I am trying to write a GI that shows when there is time activities that are not included in a Time card that is released.
If a timecard is corrected, I need to eliminate the old card.
There appears to be nothing on the header EPTimeCard that can help me to do this.
The old timecard has a TimecardType or Normal and no reference.
The New timecard has a TimecardType of Correction and a reference to the old time card
A non-corrected type card is the same as the old one.
I tried to create a join using TypecardType to elimate refs where it is “Correction” but I get an error message Error: The virtual field TimecardType cannot be used in a condition expression.
Is my only method to look at the PMTimeActivity field IsCorrected and then just create a grouping?