Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
January 2017
This release for Microsoft Dynamics NAV adds generic support for ISO20022 CAMT.054 and Pain.002 formats for return files with transaction currency EUR.
Overview
With this update, Microsoft Dynamics NAV Norway can import ISO20022 CAMT.054 and Pain.002 compliant return files.
The following changes have been made:
At export of the SEPA payments
Create Waiting Journal lines based on the payment journal lines
Create a Remittance Payment Order and reference it in the Waiting Journal lines
Delete the Payment Journal lines that were exported to a file
At import of the Return File from the bank
In Pain002 format, use the message date as the transaction date
CAMT 054 format, use each entry book date as the transaction date
e the references in the Return File to find the corresponding Waiting Journal lines
date the status of the Waiting Journal lines
Create a Remittance Payment Order and reference it in the updated Waiting Journal lines
If the status is Settled, create lines in the Payment Journal
One line created from the Waiting Journal line
One balance entry line is created with a negative amount
In case of rounding, an additional line is created containing the round off / divergence amount
Notes:
If you select files to import after clicking on the "Import return data…" button in the Payment Journal, you must set a value in the "File Format" (Telepay, BBS, Pain002 or CAMT054) and the "Agreement Code" columns for each file selected.
The file paths must be shorter than 250 characters.
Possible statuses in the Pain002 format:
ACCP = accepted. The Waiting Journal status will be Approved.
ACSC = accepted settlement complete. The Waiting Journal status will be Settled. It is not possible to go directly to the Settled status if the "Receipt Return Required" checkbox is checked, we must go through the Accepted status first.
ACSP = accepted settlement in process. The Waiting Journal status will be Approved.
ACWC = accepted with change. The Waiting Journal status will be Approved.
PDNG = pending. Nothing will be done.
RJCT = rejected. The Waiting Journal status will be Rejected and the error message or cause will appear in the Errors page accessible from the Waiting Journals page.
In the CAMT054 format, it is expected that the status will be BOOK only.
It will result in the Settled status in the Waiting Journal.
Reference Information
| Reference no. | 201966 |
|---|---|
| Product Area | Financial Management |
| Discovered in | Microsoft Dynamics NAV 2016 |
| Title | Generic support for ISO20022 CAMT.054 and Pain.002 for return files with transaction currency EUR for Microsoft Dynamics NAV 2016 - Norway |
| Released on | January 2017 |
Important Notice to Customers
We recommend that you contact your Microsoft Dynamics Partner before installing service packs or hotfixes. It is important to verify that your environment is compatible with the service pack(s), hotfix(es), or download(s) being installed. A service pack, hotfix, or download may cause interoperability issues with customizations, and third-party products that work with your Microsoft Dynamics solutions.
Important Notice to Partners
As per the SPA, it is non-compliant for partners to redistribute tax and regulatory updates to ERP customers not enrolled in the Business Ready Enhancement Plan. Partners can verify their customer’s status in PartnerSource Business Center. If they're not enrolled, Partners will need to get them current before they can distribute.
Installation
Before this update can be installed, the following prerequisites are required:
Microsoft Dynamics ® NAV 2016 Norway
This update is available through Microsoft Dynamics NAV Cumulative Update 17.
Licensing
Refresh your license to access the new objects that are added with this release.
Objects
The following object has been added/modified through this release:
| Type | No. | Name | Added/Modified |
|---|---|---|---|
| Codeunit | 10635 | Import SEPA Common | Added |
| Codeunit | 10636 | Import Pain002 | Added |
| Codeunit | 10637 | Import CAMT054 | Added |
| Codeunit | 1220 | SEPA CT-Export File | Modified |
| Codeunit | 1221 | SEPA CT-Fill Export Buffer | Modified |
| Report | 15000003 | Rem. payment order - import | Modified |
| Report | 15000062 | Remittance - Import (Bank) | Modified |
| Table | 15000004 | Waiting Journal | Modified |
| Table | 15000005 | Return File | Modified |
| Xml Port | 1000 | SEPA CT pain.001.001.03 | Modified |
| Page | 1500008 | Return Files | Modified |
| Page | 1500009 | Return File Setup List | Modified |
Setup
There are no new setup requirements.
Support Information
For technical support questions, contact your partner or direct your questions to the Support for Business hub: https://serviceshub.microsoft.com/supportforbusiness/create