Displaying Debit and Credit Columns

The DRCRSplit expression is used to parse split numeric columns. By default, FDM assumes that numeric values in Amount fields are debits. However, you can position debit values on the left and credit values on the right.

ACCOUNT NUMBER	DESCRIPTION	DEBIT	CREDIT
1000-000-00	Cash-Operating Account	68,603.91
1010-000-00	Cash-FANB-AP		177,216.16

DRCRSplit, which enables FDM to interpret left-right positioning and to assign the correct sign, follows the format DRCRSplit=Mid Point of the DR and CR columns.

In the preceding example, the Amount field of the source file begins at column 46 of the fixed-column import file and contains thirty-one characters. Everything left of the midpoint (16) is a debit and everything right of the midpoint (16) is a credit. Therefore, the expression in the import format for Amount is DRCRSplit=16.

The image shows the Import Formats screen with the DRCR split in the Expression column of the Amount row.

When the file is imported, credit amounts are assigned negative signs (and thus interpreted as positive), and debit amounts are unchanged (and thus interpreted as negative).