DMR Check Boxes Question

[A.Baeisa (Al)]

Hi @Craig
you might find this thread useful for what you are trying to achieve

BAQ to Calculate Aging DMRs (Open/Close)

I’m currently working up a BAQ where one of the requirements is to track when DMRs are open and closed (primarily for a “DMR Aging” report [i.e. - “how many days open”]). I see that there is no “open date” or “closed date” fields within the [Erp.DMRHead] table (and records are written to this table precisely when a DMR is “initiated”). The [Erp.DMRActn] table is merely a tracking of records that illustrate what actions are taken on a specific DMR; and those actions have nothing to do with “ope…