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
Your CREDIT script will look like this:
if _amount < 0 then
return _amount * -1
You need to replace _amount in the script with the actual name of the column that contains your debits and credits.