Finance | Project Operations, Human Resources, ...

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

(2) Share

Report

Posted on by VM-08071421-0

166

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 (13)

Answers (0)

Suggested answer

CA Neeraj Kumar 4,016 on at

Like (1)

Report

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

You can set one of the model mapping as default out of all those model mapping which are based on same model.

In this case, i can see "Payment model mapping for refunds to customers" is also defined as default for model mapping. In that case, you can check your root definition "CustomerCreditTransferInitiation" is available or not inside that model mapping, if available, then you will not be able to mark other as default for model mapping.. doing this , will impact the existing reports as well.

In such case, you should follow the second approach that i suggested.. which is to create the extension of format and keeping the extended payment model as base. In that case, model mapping created on extended model mapping will be used.

Regards,

Neeraj Kumar

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

Like (0)

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

Hi Neeraj,
thanks again,

I have marked the mapping to default.

and then on changing the status on the ER format report to complete , I got below error

Changing version statusMore than one model mapping exists for the 'PaymentModel (CustomerCreditTransferInitiation)' data model in the configurations Payment model mapping 1611, Payment model mapping for refunds to customers. Set one of the configurations as default.

I have made Payment model mapping 1611 as not default.and not sure why "Payment model mapping for refunds to customers" this one is coming here.
Do we need to follow a particular step once we do default ?
Also if the custom model is set to default that means it will be default for al lthe existing reports correct.

Was this reply helpful? Yes No
Suggested answer

CA Neeraj Kumar 4,016 on at

Like (1)

Report

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

Hi,

From the below reply, i can sense that the format is not using the extended payment model that you have created as "Custom Payment Model", it is referring to existing payment model, this is the reason that it is picking email address even after making the changes..

There are two approaches to resolve the same:

1) Create extension of Payment Model Mapping 1611 with Payment model (Standard), and mark the model mapping as default. then your changes will be reflecting properly in the format run.

2) If you are using the extended payment model (Custom), then you need to extend the format also with Extended payment model..

Here the main gap is , you are using standard payment model in the format and custom payment model in model mapping.

Looking forward for further feedback.

Regards,

Neeraj Kumar

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

Like (0)

Report

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

Hi Neeraj,

sorry for the delayed response.

I have followed below steps

1) click designer after selecting the custom model

2) click designer

3) on the below form search name with rfc field as shown below

and then I have saved this and did complete change status as complete.

Now on ER designer I have mapped this field .

On running the report I have got errors as below.

Payment generation process information
Evaluating expression for path 'Creditor/Identification/Alias'.
Path 'Payments/Creditor/Identification/Alias' is not bound
Evaluating binding of format component ISO20022CTReports/XMLHeader/Document/CstmrCdtTrfInitn/PmtInf/CdtTrfTxInf/Tax/Cdtr/Inf/strInf.
An error occurred during the 'Format mapping' run. For more information, contact your system administrator.
An error occurred during the 'Format mapping' run. For more information, contact your system administrator.
Evaluating binding of format component ISO20022CTReports/XMLHeader/Document/CstmrCdtTrfInitn/PmtInf/CdtTrfTxInf/Tax/Cdtr/Inf/strInf.
Error while evaluating expression for path 'Creditor/Identification/Alias'.
Path 'Payments/Creditor/Identification/Alias' is not bound
The payments cannot be generated

WHAT is not bounded in this , I already updated this one.

Then I tried to use an existing record , eg email with below
@.'findVendTable()'.'email()' but in this case when I mapped the field to email , it gave me the email address but not the RFC code.

If there is a way to use any existing field then that would be great or else it would imply changing the model for all ER designs.

Looking forward for your reply.

Was this reply helpful? Yes No
Suggested answer

CA Neeraj Kumar 4,016 on at

Like (3)

Report

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

Hi,

I am telling that step 3 is not correct... You should not go to Map to format. You need to extend the payment model mapping 1611...please confirm Whether you have this model mapping in your Electronic page..

Regards,

Neeraj

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

Like (1)

Report

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

Hi Neeraj,

Thanks , it seems I am navigating wrong path.

In your case the datasources section shows vendtable but in my case its showing the xml format navigation,

I selected the record and then on the right side I clicked on bind and still it did not show me the values.
Below are the navigation steps.
Seems I am missing something here.
Note that I have IND and other countries using same design which I have duplicated via changing GUID and working fine in Prod from months.

1) I have created a new design by exporting IND one and change GUID and created new one for MEX

2) Then click on designer

3) map format to model

4) click designer again

5) select data model left side and extend datasource section in middle and on the right side i see the RFC code field which i bind.
but I also see that even after saving the record when i revisit it does not show the binded field.

I even tried to map the field in designer edir formula section at pt 3 to check if it can give results
Basicaaly i tried to get the field via the relations node but this too gives blank values.

concatenate(CustVendProcessedPayments.'<Relations'.'<Documents'.'<Relations'.VendTable.Rfc_MX,'$CustVendProcessedPaymentsFiltered'.'>Relations'.LedgerJournalTrans.Voucher,
'$CustVendProcessedPaymentsFiltered'.'>Relations'.LedgerJournalTrans.'>Relations'.VendTrans.'>Relations'.AccountNum.Rfc_MX,'$CustVendProcessedPaymentsFiltered'.'>Relations'.LedgerJournalTrans.'>Relations'.VendTrans.'>Relations'.AccountNum.CreditRating)
concatenate(CustVendProcessedPayments.'<Relations'.'<Documents'.'<Relations'.VendTable.Rfc_MX,'$CustVendProcessedPaymentsFiltered'.'>Relations'.LedgerJournalTrans.Voucher,
'$CustVendProcessedPaymentsFiltered'.'>Relations'.LedgerJournalTrans.'>Relations'.VendTrans.'>Relations'.AccountNum.Rfc_MX,'$CustVendProcessedPaymentsFiltered'.'>Relations'.LedgerJournalTrans.'>Relations'.VendTrans.'>Relations'.AccountNum.CreditRating)

Was this reply helpful? Yes No
Suggested answer

CA Neeraj Kumar 4,016 on at

Like (3)

Report

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

Hi @VM-08071421-0,

You need to follow below steps to achieve the solution:

1) Extend your Payment Model Mapping 1611

2) Bind one of the existing field with Vendtable.rfc_MX

Here i have taken the SenderId field under payment model.. and binded with $VendTable.ITMAgent (as an example)

3) Extend your ISO20022 format then bind that field in the format designer with given formula:

'$PaymentByDebtor'.lines.Creditor.Identification.SenderId

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

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

Like (2)

Report

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

Hi Neeraj,

Thanks again,
I will explain with example. Below is the designer form
If I want to add email id ,
I will add a node and then click on edit formula

So on edit formula i have the below screen

My question is that what should be the formula to get the value for vendtable.Rfc_MX
'$AllPayments' Creditor(record) Rfc_MX

Thanks.

Was this reply helpful? Yes No
Suggested answer

CA Neeraj Kumar 4,016 on at

Like (2)

Report

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

Hi,

Basis the screenshot shared for Model > root definition, i can confirm that you must extend the Model Mapping "Payment model mapping 1611" or if you have already extended this model mapping for other purposes, you can utilize the same. Initially you have shared the Format mapping which i explained in my previous reply..

So, try with this model mapping and let us know if you are still facing any issues..

Have you already extended your "Payment model", if yes then new model mapping must refer to the extended payment model and similarly while extending the ISO20022 Credit transfer MEX, you should use the extended payment model..

Answer to your second question:

If you want to extend the existing ISO20022 Credit transfer HSBC MEX, then it will be created as subnode only. If you select the ISO20022 Credit transfer, then only it will create parallel to ISO20022 Credit Transfer (ZA) IND.

Is there any specific reason to create parallelly or subnode is creating any issues?

And if it is must to create parallelly, then there is a way to do it, export the xml file in text editor, update the GUID and name of ER format and then import again, it will create a parallel but copy of ISO20022 Credit transfer HSBC MEX. I don't recommend this approach unless you are very sure about your changes.. i have done this for GSTR report while i need the exact copy of Microsoft versions without extending them.

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

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

Like (2)

Report

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

Hi Neeraj,

Below is the screenshot for your question.

Another question :
q2) If I want to duplicate an existing report

lets say I want to create MEX2 which will be exact copy of MEX (not a subnode) but a parallel node like IND.
then what is the process to create it as I tried with creating a new record but it keeps on creating a subnode.

Thanks again for helping

Was this reply helpful? Yes No