I am trying to import a pipe delimited file in FDMEE (v11.1.2.4) that has separate amount columns for debits and credits. I need to subtract the credit column from the debit column to get the amount in the proper trial balance format. A sample set of records is illustrated below:
Acct | Desc | Debit | Credit
1000 | Cash in Bank | 5,000.00 |
1005 | Petty Cash | 100.00 |
2000 | Accounts Payable | | 1,250.00
I want to use a jython import script to split the record, then use column 3 and 4 to create the net balance for use in FDM. I am able to split the record and pull the appropriate columns using the split function. This issue I am having is when I attempt to subtract column 3 from column 4. It appears as though the script is interpreting the fields as strings instead of numbers. I have tried various ways of stripping out spaces/commas, etc., and converting it using the decimal and int functions but nothing seems to work.
Is there a simple way to accomplish this?
Thanks for any assistance.