Import Bank Statement-Combine bank detail file debit and credit into single Statement Amount field

(0) Share

Report

Posted on by Community Member

I am working on a Bank Statement Import Data Exchange Definition. The bank detail transaction file from the bank contains a debit and credit column instead of a single column for the amount. How can I configure the Data Exchange Definition to import the debit and credit amounts into the Statement Amount field?

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

Suggested answer

dkatson 2,263 on at

Like (0)

Report

RE: Import Bank Statement-Combine bank detail file debit and credit into single Statement Amount field

Use 1225 Data Exch. Field Mapping table.

msdn.microsoft.com/.../dn495319(v=nav.90).aspx

Was this reply helpful? Yes No
ManishS 86 on at

Like (0)

Report

RE: Import Bank Statement-Combine bank detail file debit and credit into single Statement Amount field

community.dynamics.com/.../229255

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

RE: Import Bank Statement-Combine bank detail file debit and credit into single Statement Amount field

Hi sbuczek,

The following solution will only work if the debit column is blank when credit column is populated and vice versa.

In field mapping:

- set debit column to statement amount and tick optional

- set credit column to statement amount and tick optional

Regards,

Susy

Was this reply helpful? Yes No
Laban Njogu 5 on at

Like (0)

Report

RE: Import Bank Statement-Combine bank detail file debit and credit into single Statement Amount field

Hello,

Is there a navision solution when the debit column is not blank (i.e. has zeros) when the credit column is populated?

Possibly converting zero's in debit column to blank?

Editing the bank excel is sub-optimal.

Regards,

Laban.

Was this reply helpful? Yes No
Joe Pirozzolo 24 on at

Like (0)

Report

RE: Import Bank Statement-Combine bank detail file debit and credit into single Statement Amount field

Hi Laban,

Did you get any joy with this? I'm having the same issue.

Kind Regards

Joe

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,043 Moderator on at

Like (0)

Report

RE: Import Bank Statement-Combine bank detail file debit and credit into single Statement Amount field

What method are you using for importing the bank statement and what format does it have?

Was this reply helpful? Yes No
Joe Pirozzolo 24 on at

Like (0)

Report

RE: Import Bank Statement-Combine bank detail file debit and credit into single Statement Amount field

Hi Inge,

I am using the following setup for Bank Statement imports. I have several feeds working okay, but they all have one column for the debits/credits.

However the statement that is causing a problem has two columns (one debit and the other credit) both with absolute values.

Normally that is fine, because you can set the multiplier on the debit to -1* and map the two fields to "Statement Amount" (and set the two as optional).

But that only works if the empty credit/debit fields are blank. In this case they are not and have zeros. This is causing the problem as the debit always overwrites the credit column.

Hope that makes sense, but any help is appreciated.

Thanks

Joe

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,043 Moderator on at

Like (0)

Report

RE: Import Bank Statement-Combine bank detail file debit and credit into single Statement Amount field

Then it is probably the easiest way to write a small customization that fix that issue in the import.

Are you on a version that supports AL?

Was this reply helpful? Yes No
Joe Pirozzolo 24 on at

Like (0)

Report

RE: Import Bank Statement-Combine bank detail file debit and credit into single Statement Amount field

I am, yes. I've been writing a few extra pages etc, so happy to do some customization for this.

Thanks.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,043 Moderator on at

Like (0)

Report

RE: Import Bank Statement-Combine bank detail file debit and credit into single Statement Amount field

Then you can write a new xml port that supports your need and switch to that object number in your setup.

That will override the standard xml port used.

docs.microsoft.com/.../across-how-to-set-up-data-exchange-definitions

Was this reply helpful? Yes No