Electronic reporting ER Vendor payment journal : Show xml with localization field

(1) Share

Report

Posted on by VM-08071421-0

135

Hi,

I have an ER config for a vendor payment journal which is having mexico localization.

When we do generate payment it sends the file to bank and the xml is created via ER config,
I want to add another field in the ER designer from the vendor master on the xml and below is the field name
vendtable.Rfc_MX

Can you please let me know how I add this field, because while mapping the field the designer just shows different text then the field name and not even labels.

I am using the microsoft standard model like 1 design for INDIA and other for MEX and so on.

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

CA Neeraj Kumar 2,031 on at

Like (0)

Report

Electronic reporting ER Vendor payment journal : Show xml with localization field

Hi,

Are you using the correct model mapping? I doubt.. as per my understanding you should use the model mapping

Payment model mapping 1611

Can you please tell the root definition that is showing in your format designer.. as per my understanding it should be : CustomerCreditTransferInitiation

To check the root definition used in the format designer, please go to the format designer.. select the node of Data Model > Edit > Check the root definition.

It looks like you are going in the format mapping ... by click the button "Map format to model", this is for different purpose: to update back the D365 data sources based on format.. This is not the place where you need to do editing.

If this helped, please mark it as "Verified" for others facing the same issue Keep in mind that it is possible to mark more than one answer as verified

Regards,

Neeraj Kumar

Ca

Was this reply helpful? Yes No
VM-08071421-0 135 on at

Like (0)

Report

Electronic reporting ER Vendor payment journal : Show xml with localization field

Hi Neeraj,

Thanks for the reply,

I can see the field under data model
'$AllPayments' Creditor(record) Rfc_MX
but the issue is how do I map it in the designer to a field.
In designer it does not show all the fields.
Is there any extra step tomake this field available.

Also I was not able to see the VendTable here.

Also if I extend the datasources section

In above you can see that actually Cdtr refers to vendtable in this case but I am not sure how to add other fields over here from vendtable.

Below is the designer section of the report.

the creditor dot field is not showing any other field.

Was this reply helpful? Yes No
CA Neeraj Kumar 2,031 on at

Like (1)

Report

Electronic reporting ER Vendor payment journal : Show xml with localization field

Hi,

Are you trying to search directly in the model mapping? it doesn't work like this. You need to find exactly under which node you are getting the vendtable. if it is not available direclty.. basis the vendor account number, you can add a Vendtable and then take the value from it....

I have searched it..

it is under the node: '$notSentTransactions'.'findVendTable()'.

If the field is not visible, do let me know.. sometimes it happen for customized field that it doesn't appear but we have other processes to refresh it. You need to rebuild table references..

If this helped, please mark it as "Verified" for others facing the same issue Keep in mind that it is possible to mark more than one answer as verified

Regards,

Neeraj Kumar

Author of the Book : Electronic Repoting - The Hidden Gem

Was this reply helpful? Yes No