PSA: Put this formula in your Customer Deposits Status Deposited Saved Search to match with the value from the Customer Deposits Register: CASE WHEN {mainline} = '*' THEN {amount} ELSE CASE WHEN {applyingtransaction} IS NOT NULL THEN {applyingtransaction.amount} ELSE 0 END END