Data Management - DR CR Split on a Delimited Data File

Summary

Data load using a DRCR Split

Content

Hi All,

I'm attempting to import this data file using the DRCRSplit functionality within the Import Format :

IS_7420,Opening Balance,,1000.00
IS_7510,Fixed Asset Cost  B/F,1615414.00,
IS_7430,Fixed Asset Cost Additions,,792114.54
IS_7440,Fixed Asset Cost Disposals,,822299.46

File fields: Account, Description, Debits, Credits

In my initial attempts I have only been able to load the single DR amount using this configuration in the Import Format (image attached).

I'm not sure whether this is possible in a delimited file or whether this is the best approach - I also want both DR / CRs to be loaded as positive values.