I am trying to create a GI for unreconciled assets as follows:
All fixed assets, with a left join to FATran, only for TranType = “R+” (Reconciliation). I’m assuming that the assets that have no FATran record will be the ones that were never reconciled.
How do I add a condition statement that allows only fixed assets with no reconciliation transactions?