7

When importing a Customer Payment ICO20022 Camt054C file to Dynamics 365 Finance and Operation, the system will create lines of messages with information about the imported transactions, for example that payments are not settled fully or have some other issues. For each payment line there is several message lines, sometimes up to 10 messages not saying anything about the issue, only that there is an issue. When customers have 500-1500 payment lines per day this is not a very efficient way to work, because they will get about 200-400 lines with messages lines and you still almost need to go through every payment line to check the settlement. Our suggestion is to create a report with information about the payment lines. For example, the Swedish Payment model Bankgirot (SE) has a good report. It would be very helpful to add information about which invoices have been settled on the report and if the invoice was settled totally or partial. And if the report is created in a way so it is easy to export and work with the report in Excel.


Appended: 


- Today, and for at least a one year or two, customer in Sweden are able to pay a Debit and a Credit invoice were the “sum” is 0 SEK (zero). And you can’t post a ledger line with a zero amount. That means that you have to delete the lines in the customer payment journal, go to the customer => All transactions and settle the transactions manually. This is also manually work that is not efficient. - If a customer with “Invoicing and delivery on hold” set to YES, the imported file can’t find the customer and instead set up the transaction against the “Error customer”. Makes even more manually work.

STATUS DETAILS
New

Comments

T

@Tatjana - Configuration of formulas in the designer of Payment Model mapping to destination ISO20022 allows for the warning messages to be captured at import and written in the Notes field, which is then filterable. It's a bit tricky and trial and error-ing to setup but when it's in place it's working splendidly.

As for the zero payments, assumingly this will not be kept after the national/Nordic P27 transformation project and Sweden will most likely align with the global practice of not allowing zero payment or separate credit note specification in payments. At least that's my understanding.

___________________________________

(I'm not part of PG but MCS)

Category: Cash and bank management

T

Also I need to add below information to this idea:

- Today, and for at least a one year or two, customer in Sweden are able to pay a Debit and a Credit invoice were the “sum” is 0 SEK (zero). And you can’t post a ledger line with a zero amount. That means that you have to delete the lines in the customer payment journal, go to the customer => All transactions and settle the transactions manually. This is also manually work that is not efficient.

- If a customer with “Invoicing and delivery on hold” set to YES, the imported file can’t find the customer and instead set up the transaction against the “Error customer”. Makes even more manually work.

Category: Cash and bank management