Hi Acumatica Community,
I'm working on a Generic Inquiry (GI) to identify instances where employees have no time recorded on a given day within their time cards. This is crucial for us to ensure accurate time tracking and address any missing entries.
I'm using the EPTimeCard, EPTimeCardSummary, and EPTimeCardDetails tables, and I'm looking for the best way to achieve the following:
Goal: Display employee time card details, specifically highlighting days where no time was entered at all.
Challenge: The standard joins between EPTimeCard and EPTimeCardDetails typically show days with entries. I need to effectively identify and display the "gaps."
How can I achieve this?
