I am trying to write a formula to pull all the open invoices for a vendor if they have a credit amount in the Open Amount field. (basically exclude a vendor if they do not have an open credit on their account) So far all I have gotten my formula to do is pull only the credits for that vendor. here is my formula so far
if {Accounts_Payable_Ledger.AmountOpen}<0 then {Accounts_Payable_Ledger.AddressNumber}
then I have this linked in the record selection to address #
Can some one please help me with this