Matched In-Transit in Custom Report
Summary:
I am trying to build a custom report for pulling status information similar as Balance Report Transactions. In the first column of this system report, it contains 'Status' column.
Is there anyway to query this information is in Custom Report Query? In the Table and View guide, the only table contains this info is TM_BALANCE_SUMMARY column Balance Type but this table only provide information as summary per profile.
Status | Transaction ID | Transaction Date | Amount | Match Process Name |
|---|---|---|---|---|
Matched In Transit | 1743241 | 31-Oct-23 | 43 | Offset Match GL |
Unmatched Supported | 1743207 | 24-Oct-23 | -51 | GL to Halcion Match |
Unmatched Supported | 1743211 | 24-Oct-23 | -7 | GL to Halcion Match |
0