How to Show All EPTimecardDetail Records in GI but Only When EPTimeCard is Pending Approval or Approved

Hi Acumatica Community,

I'm creating a Generic Inquiry (GI) that joins EPTimeCard and EPTimecardDetail using the TimeCardCD field. The goal is to display all EPTimecardDetail records, but only for Time Cards that are either:

• Pending Approval, or

• Approved

Currently, when I join these two tables in the GI and filter by status, I only see records where EPTimeCard.Status = 'A' (Approved). I want to also include records where the status is 'P' (Pending Approval), and exclude On Hold and Rejected records.

My join is based on:

EPTimecardDetail.TimeCardCD = EPTimeCard.TimeCardCD

However, the GI still seems to only return approved records.

Has anyone successfully configured a GI to include both approved and pending approval time cards? Am I missing something in the join or filtering setup?

Thanks in advance for your help!

— Tharindu