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.
