Skip to main content
Answer

Timecard generic inquiry

  • December 18, 2023
  • 3 replies
  • 175 views

lbarker
Semi-Pro II
Forum|alt.badge.img+3

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?

Best answer by lbarker

I managed to do it using the PMTimeActivity joined in - condition where IsCorrected equals false, and then with grouping so all good now, but thanks for your response

3 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • December 18, 2023

@lbarker  Can you please attach your GI here?


lbarker
Semi-Pro II
Forum|alt.badge.img+3
  • Author
  • Semi-Pro II
  • Answer
  • December 18, 2023

I managed to do it using the PMTimeActivity joined in - condition where IsCorrected equals false, and then with grouping so all good now, but thanks for your response


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • December 18, 2023

@lbarker Great!! Thanks for sharing the update.