I’ve got debtor transactions in a general ledger table where the system doesn’t show that a transaction has been cleared. It does, but it is not usable.
I’ve highlighted the amounts that are not cleared, but is there a way to create a calculated column that would indicate that these are “Unpaid” and mark the other transactions as “Paid”.
I want to created an aged debtors report from the data.
Thanks in advance.