Finance | Project Operations, Human Resources, ...

wrong information in the xml output of electronic report payment

(0) Share

Report

Posted on by Sinda DRIDI

hello,

I just configure electronic report for payment model "ISO20022 Credit transfer (DE)".

I create after a vendor payment with method of payment SEPA which the type is electronic report.

I can after generate the XML file of electronic payment, but some informations are wrong like:

InitgPty>
<Nm> it show another ordering party than that of the payment made.

and the IBAN number

can someone help me to solve this problem and understand the reason of its happening!

thnx advance

best regards,

Sinda

I have the same question (0)

All responses (16)

Answers (0)

Suggested answer

Alireza Eshaghzadeh 14,616 Super User 2025 Season 2 on at

Like (0)

Report

RE: wrong information in the xml output of electronic report payment

Hi Sinda,

When you want to re-generate the payment file of one vendor payment journal, you can do as follows:

1-Open the vendor payment journal line and if journal lines does not have "None" as payment status, change them to "None"

2-Perform required changes. e.g. delete a journal line or add/remove invoice to a specific journal line

3-Click on "Refresh" button

4-Click on Generate payment, choose method of payment that "ISO20022 Credit transfer (DE)" is associated and choose bank account and file name

5-Choose "Strd" or structured format and click on OK to generate payment file

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: wrong information in the xml output of electronic report payment

Hi,

i need to know how to generate the payment file agin, after reversing the specified line, such the generate payment function will be freezed after posting the journal ?

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,616 Super User 2025 Season 2 on at

Like (0)

Report

RE: wrong information in the xml output of electronic report payment

Hi again Sinda,

Then you need to delete the specified journal line and then generate the payment file again.

When you generate payment file from payment journal UI. payment status will be updated to "Sent".

I hope the provided feedback helped you with this issue. Please set the provided answers as verified (i.e. Did this answer your question? > Yes) to help others in the communities.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: wrong information in the xml output of electronic report payment

thank you Alireza for your help!

but I have one case in which I have to reverse one line from journal payment and regenerate the file.

for example: I have a vendor journal payment with 5 lines, after the generation of the electronic payment file, and the validation of the journal, I noticed that one line is wrong, so I have to reverse this line from the journal and regenerate the electronic payment file for the 4 lines remaining.

In this case, neither the payment status, neither the generate payment function are functionnal (this buttons are freezed after posting payment)

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,616 Super User 2025 Season 2 on at

Like (0)

Report

RE: wrong information in the xml output of electronic report payment

Hi Sinda,

When you want to import received file from the bank , you need to import config "ISO20022 pain.002" from Microsoft repositories.

For verified processed file (e.g. customer payment file and vendor return file), you need to import "ISO20022 Camt.054" from Microsoft repositories.

Then add these two config to your vendor method of payment:

To import Pain002 (Received file) and Camt054 file, navigate to Account payable > Payment > Payment transfer > Return file - vendor . Then choose method of payment

and then load file based on its format:

Regarding "But this function is not available after validation of the payement, so if i need to rerun the electronic file from the electronic report configuration, it generate fail information. knowing that I put the journal number as a filter for the generation of the file."

If you have not sent the payment file to the bank, you can re-generate the payment file again as follows:

-Navigate to the vendor payment journal

-Open the actual journal and them mark all journal line and set payment status to "None"

-Click on "Generate payment" and generate a new payment file

Regarding the error message, please generate the payment file form payment journal UI and see if you get the samme error message. If yes, provide more info from journal and the error message.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: wrong information in the xml output of electronic report payment

yes Alireza i added the "ISO20022 Credit transfer (DE)" to vendor method of payment, and it works fine from the payment journal intefrace.

But this function is not available after validation of the payement, so if i need to rerun the electronic file from the electronic report configuration, it generate fail information. knowing that I put the journal number as a filter for the generation of the file.

FYI the file is generated and i got this error message

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,616 Super User 2025 Season 2 on at

Like (0)

Report

RE: wrong information in the xml output of electronic report payment

Hi Sinda,

You need to add "ISO20022 Credit transfer (DE)" to vendor method of payment that you want to generate payment file (i.e. Pain001). Payment file need to be generated from the payment journal after you have run the payment proposal.

As you already mentioned, when you generate the payment model from the journal payment UI, it works fine and indicate correct info. It is because that the config (i.e. "ISO20022 Credit transfer (DE)") is designed to be run from vendor payment journal UI.

You can test generation of the payment file from electronic reporting configuration itself, while you need to have a open vendor journal and specify journal number that you want to generate file. It is mostly used of other reports that needed to be run from electronic reporting configuration since there is not any function for them (e.g form) to be generated.

If you do not fill out the all required fields, it can due to get error message or get payment file with fail data.

It is recommended to run this function from payment journal.

I hope it helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: wrong information in the xml output of electronic report payment

I just runing the payment model from Organization administration from the entity "DJW"

the file generated indicate informations of another legal entity:

while, when I generate the payment model from the journal payment interface, all the informations are correct

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,616 Super User 2025 Season 2 on at

Like (0)

Report

RE: wrong information in the xml output of electronic report payment

Hi Sinda,

Can you elaborate '' if I generate the electronic report from the organization system i find errors in the dbt entity and the IBAN ''. Can you provide some more detail and screenshots?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: wrong information in the xml output of electronic report payment

up

Was this reply helpful? Yes No