Skip to main content
Question

GI for Unreconciled Assets

  • July 9, 2025
  • 0 replies
  • 20 views

Forum|alt.badge.img

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?