Small and medium business | Business Central, N...

Import Bank Statement CSV - Question?

(0) Share

Report

Posted on by LanaAbs

Hi BC gurus,

Have any of you come across a bank statement format when both Debit and Credit columns have a value:

Debt	Credit
0	1810000
1185000	0
552.74	0
0	3165.64

When importing such a statement the “0”s in the Credit column overwrite the imported Debit.

I tried to create a Transformation Rule to replace “0” with blank but couldn’t yet find the way for it to work only for “0” amounts.

Have you ever encountered such a thing, any ideas on how to make it work without customization?

Thanks!

Categories:

Dynamics 365 Business Central

All responses (8)

Answers (0)

Joe Pirozzolo 22 on at

Like (0)

Report

RE: Import Bank Statement CSV - Question?

Hi LanaAbs,

Did you ever manage to figure this one out?

I'm having the same issue.

Thanks... joe
LanaAbs 5 on at

Like (0)

Report

RE: Import Bank Statement CSV - Question?

I am already doing this. But as I mentioned, when Credit Amount is being imported, the "0" there overwrites the imported Debit amount.
Community Member on at

Like (1)

Report

RE: Import Bank Statement CSV - Question?

You do need to combine the 2 columns into 1 column and use the positive and negative amounts.
Suggested answer

darcnus 235 on at

Like (1)

Report

RE: Import Bank Statement CSV - Question?

What about using code to net the two columns into a new field and working from positive and negative figures?
LanaAbs 5 on at

Like (0)

Report

RE: Import Bank Statement CSV - Question?

No, then it replaces all zeros with blank, i.e. if there's an amount 30000, it will be transformed into 3.
JAngle 95 on at

Like (0)

Report

RE: Import Bank Statement CSV - Question?

Will a transformation rule to set 0 to blank work?
LanaAbs 5 on at

Like (0)

Report

RE: Import Bank Statement CSV - Question?

Thank you Josh. Unfortunately the supplied link is not helping.

As I said, the problem is when Debit is xxxxx and Credit is "0" (not blank)

In Mapping I specify both Debit and Credit to go into "STatement Amount" and they are market as optional.

So after Debit Amount is imported, and the turn goes to Credit Amount, the "0" overwrites the imported Debit Amount.
JAngle 95 on at

Like (0)

Report

RE: Import Bank Statement CSV - Question?

This thread has the answer: community.dynamics.com/.../633678