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

Data Exchange Definition for exporting payment file does not work

(0) Share

Report

Posted on by AleAlonso

323

Hello,

I have created a Data Exchange Definition to export payment files. The bank requires the following information:

1. Document Type

2. Vendor Account

3. Vendor Bank Account Number

4. Vendor Sort Code

5. Company making the payment

I completed the General fields as below in the data exchange definition as below:

I have created two line definitions:

1. Lines from Payment Journal

2. Lines from Vendor

The problem is when I create a Payment Journal and try to export it I'm getting this error

Record(1220) is not compatible with Codeunit.Run(Record(81)).

Table 1220 is Data Exchange and Table 81 is the Gen Journal line table.

Any ideas why I'm getting this error?

Many thanks,

Alejandra

All responses (4)

Answers (0)

Suggested answer

Dallefeld 11,425 User Group Leader on at

Like (0)

Report

RE: Data Exchange Definition for exporting payment file does not work

First, sorry, being in the US, I answer for US. We need to have something that shows version and country when posting questions so everyone can respond and get answers quicker.

So the question is how did you know what codeunits to enter in your definition? The codeunits are processing using certain tables and apparently one is wrong. I know for the US mine are very different than yours.
Suggested answer

YUN ZHU 74,115 Super User 2024 Season 2 on at

Like (0)

Report

RE: Data Exchange Definition for exporting payment file does not work

Hi, I feel it is still a setting problem, please refer to the following MS Learn (Docs).

https://learn.microsoft.com/en-us/dynamics365/business-central/across-how-to-set-up-data-exchange-definitions

In addition, you can also consider customizing, and it is not very difficult to create a program that exports XML using XMLPort.

More details: https://yzhums.com/4809/

Hope this helps.

Thanks.

ZHU
AleAlonso 323 on at

Like (0)

Report

RE: Data Exchange Definition for exporting payment file does not work

Hi Kim,

EFT is not an option for me as I'm in the UK.

There is a SEPA Credit Transfer Bank Export format. However I can't use it as SEPA credit transfers can only be made in the EURO currency and my company is all transactions related are in GBP.

Thanks

Alejandra
Suggested answer

Dallefeld 11,425 User Group Leader on at

Like (0)

Report

RE: Data Exchange Definition for exporting payment file does not work

Are you doing and ACH/EFT export? If so, why re-create the wheel?

Looks like you are mapping to vendor information and that's not generally what the data definition is for.