Managing Nonstandard Numeric Sign Conventions

The Sign expression is used to mange nonstandard numeric sign conventions. FDM interprets numbers with leading and trailing minus signs and numbers within parentheses as negative numbers. However, you can use other trailing characters to indicate negative numbers. To define custom signs, use expressions that follow this form: Sign=[Positive String],[Negative String].

For example, if positive numbers are followed by DR (1,000.00DR), and negative numbers are followed by CR (1,000.00CR), the expression is Sign=DR,CR

For example, if positive numbers are unsigned (1,000.00), and negative numbers are followed by CR (1,000.00CR). the expression is Sign=,CR.

The image shows the Import Format screen with sign=,cr in the Expression field of the Amount row.