Finance forum

Electronic Reporting - Copying format

(0) Share

Report

Posted on by Zen_Raj

177

Hi,

We want to be able to use the ISO20022 credit transfer format for generating vendor Checks.

Categories:

Data Integration

Development / Customization / SDK

All responses (12)

Answers (4)

Sort by

Eugen Glasow 6,365 on at

Like (0)

Report
Copy link

Link copied!

Yes, you have to manually create hundreds of mappings and nodes to match the ISO ones.
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Why do you want to create checks with the help of the electronic reporting (ER) framework?

Do you need an electronic check format?

If this is the case, can you let us know whether this is something that is commonly required in your country/region?

Is this possibly required by law enforcing you to do that?

Best regards,

Ludwig
Ties Philippi 962 on at

Like (0)

Report
Copy link

Link copied!

[quote user="Eugen Glasow"]
Yes, you have to manually create hundreds of mappings and nodes to match the ISO ones.
[/quote]
There is a way to hack & slash it via XML. Might post about that later when I am done pondering the ethical side of sharing that information :).

Anyway, like Ludwig stated, please tell us what you want.

The ISO mapping has a very specific (XML) setup and mapping attached to it and the Check setup has it's own specific setup attached to it.

What check and what lay out do you want to generate, do you have a lay out definition?
Zen_Raj 177 on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig and Ties,

We are sending vendor payments and the bank would like all the methods of payment to to be of the same ISO format for processing. I basically need it to generate the same way as any other outputted XML payment ;but with the check number auto generated.
Verified answer

Ties Philippi 962 on at

Like (0)

Report
Copy link

Link copied!

Hi Zen,

What is the check number in your request?

The way I understand it now is that you want to have a sequential number you normally print on a physical check which the vendor can exchange at the bank for a predefined amount of money.

A ISO payment is an electronic payment method, comparable with a wire transfer. So no real physical documents come into play. You, as a company, instruct the bank to pay x amount to vendor bank account y.

As by this understanding, the payment process by both methods are very different. And it would seem that a check number would not be needed. So could you explain please what the check number is? And what it's purpose is in the payment process?

Best regards

Ties
Verified answer

Eugen Glasow 6,365 on at

Like (0)

Report
Copy link

Link copied!

Well, in the past the cheque and the ISO credit transfer belonged to the same family of classes (VendOutPaym_Cheque vs. VendOutPaym_ISO20022_Generic). But these times are over. Manipulating the XML file as suggested by Ties is possible (and sometimes absolutely necessary) but you really have to know what are you doing.

Either way, there are no workarounds, no tricks, no hacks, you have to get your hands dirty and implement a new child of the generic ISO20022 credit transfer file, copy the logic to generate the number, maybe also add an attachment to get the cheque printed and so on. This is going to take a few days.
Zen_Raj 177 on at

Like (0)

Report
Copy link

Link copied!

Ties,

I need to populate this as you said with a sequential number that will uniquely identify a check number. I understand what you are saying about how they are different, but this is the formatting required for the integration. What do you suggest?
Verified answer

Eugen Glasow 6,365 on at

Like (0)

Report
Copy link

Link copied!

In the formula designer, there is a NUMBERSEQUENCE formula to draw the next number. However, in the cheque there is no dedicated number sequence, if I recall correctly.

You can extend the data mapping to simply draw the last number with a calculated field of the kind FILTER(BankChequeNum, BankChequeNum.AccountID = xxx.AccountID) and increment it by 1.

Then you need a 2nd parallel mapping of the "To destination" type to write the drawn number back into the BankChequeNum and LedgerJournalTrans tables.
Zen_Raj 177 on at

Like (0)

Report
Copy link

Link copied!

Hi Eugen,

For the model mapping to destination, do you have any documentation on how I add to this? I see there are 4 different components, which one do I need to change, and how do I go about inserting a new record into a destination table.
Verified answer

Eugen Glasow 6,365 on at

Like (0)

Report
Copy link

Link copied!

1. You cannot write "find" in a FILTER expression: it is in essence an SQL statement.

2. You actually need interim variables to find the max. cheque number: $BankChequeTable = FIRSTOREMPTY(REVERSE(ORDERBY(FILTER(BankChequeTable, ...), then you can use ... = $BankChequeTable.ChequeNum + 1

or maybe even 2 variables: one to filter and one to sort in the reverse order.

3. The documentation would be here: [View:https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/analytics/er-parse-incoming-documents?toc=/fin-and-ops/toc.json:750:50]

I am afraid you have to configure a brand new "destination mapping". You can embed this right into the format! I saw these tricks in the Italian and Spanish outbound invoice formats: