We need to know the amounts owing by expense - main line is false -
One version
The other version
both versions need main line is false i believe.
The issues i have:-
Bill Credit - date closed - means it has been applied
But i need the amt remaining on the bill line…
but having problems
case when {type} = 'Bill' then {amountremaining} else (nvl({amountremaining}*-1,0) end
keeps erroring out!!