I am trying to pull a list of open invoices with amount remaining for the bank. my challenge is that I need to show the credits as negative, in a saved search.
- I have to do this is a saved search to pull in the internal ID of the transactions
- The transaction internal ID is NOT available in the AR Aging Detail.
- The external ID is all ready being used to reference transactions from our legacy systems that are imported.
Anyone got any suggestions formula wise?
Thanks