BAI2 Bank statement import

(0) Share

Report

Posted on by Purple Window

Hi,

The bank statement import of BAI2 file formats using the standard ER formatting is work for the most part.

The only problem is that one Transaction Types of 400 - 699 is uploaded with credit amounts.

How can I add ranges to be credited?

I have the same question (0)

All responses (1)

Answers (0)

Purple Window 10 on at

Like (0)

Report

The xml code that I can see is the following...

<ERModelExpressionItem ExpressionAsString="IF(AND(INTVALUE(format.File.FileSeparator.FileContent.Groups.Accounts.Transactions.TypeCode) >= 400, INTVALUE(format.File.FileSeparator.FileContent.Groups.Accounts.Transactions.TypeCode) <= 699), CreditDebitType.Credit, CreditDebitType.Debit)" SyntaxVersion="1">
<Expression>
<ERExpressionGenericIf>
<Condition>
<ERExpressionAnd>
<Contents.>
<ERExpressionNumericGreaterOrEqual>
<FirstExpression>
<ERExpressionStringToInt>
<Input>
<ERExpressionStringItemValue ItemPath="format/File/FileSeparator/FileContent/Groups/Accounts/Transactions/TypeCode" />
</Input>
</ERExpressionStringToInt>
</FirstExpression>
<SecondExpression>
<ERExpressionIntConstant Value="400" />
</SecondExpression>
</ERExpressionNumericGreaterOrEqual>
<ERExpressionNumericLesserOrEqual>
<FirstExpression>
<ERExpressionStringToInt>
<Input>
<ERExpressionStringItemValue ItemPath="format/File/FileSeparator/FileContent/Groups/Accounts/Transactions/TypeCode" />
</Input>
</ERExpressionStringToInt>
</FirstExpression>
<SecondExpression>
<ERExpressionIntConstant Value="699" />
</SecondExpression>
</ERExpressionNumericLesserOrEqual>
</Contents.>
</ERExpressionAnd>
</Condition>
<FalseValue>
<ERExpressionEnumItemValue ItemPath="CreditDebitType/Debit" />
</FalseValue>
<TrueValue>
<ERExpressionEnumItemValue ItemPath="CreditDebitType/Credit" />
</TrueValue>
</ERExpressionGenericIf>
</Expression>
</ERModelExpressionItem>

Was this reply helpful? Yes No