Dynamics Community Forum Thread Details

BAI2 Bank statement import

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?

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>

Quick Links