CMTrxType for transfer is 7. How to get negative amounts for transfer to and positive amounts for transfer from
Toni replied 2 weeks ago
Still working to get a Smartlist for Bank Transactions with Smartlist Builder. By using the CMTrxType’s 1 to 6 and 101 to 104, I am able to get the correct amounts debit or credit by using CASE in calculations and multiply the outgoing amounts by -1. The problem still are transfers, because there is the same type 7 for in’s or out’s.
If you would like to submit an answer or comment, please sign in to the eOne portal.
Still working to get a Smartlist for Bank Transactions with Smartlist Builder. By using the CMTrxType’s 1 to 6 and 101 to 104, I am able to get the correct amounts debit or credit by using CASE in calculations and multiply the outgoing amounts by -1. The problem still are transfers, because there is the same type 7 for in’s or out’s.