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)

CA Neeraj Kumar 4,915 on at

Like (3)

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
VM-08071421-0 166 on at

Like (2)

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
Suggested answer

CA Neeraj Kumar 4,915 on at

Like (3)

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 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
Suggested answer

CA Neeraj Kumar 4,915 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,

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,915 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 (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,915 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 (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