Any help with this would be really appreciated. I know that FDM interpret numbers followed by DR as positive and those followed by CT as negative but it doesn't make the distinction whether this number relates to an Expense (natural debit account) or Revenue (natural credit) Account ... I need FDM to interpret a natural credit type of account (Revenue) as a positive always and its Debit as a negative. For a natural debit account (Expense), I need the debit balances to be always positive and the credit balances to be always negative.
How can we do this in FDM ? is there a built functionality or do we have to script it ? ideally i need to do this during the mapping phase and not the import .. Thx !