How to separate Debits and Credit when the source file has only 1 column

Using a SmartConnect script to separate debits and credits when your source file only contains 1 column that has positive and negative values.You need to create 2 calculated fields. One called DEBIT and the other called CREDIT. Your DEBIT script will look like this: if _amount > 0 then return _amount else return 0 end … Continue reading How to separate Debits and Credit when the source file has only 1 column