Share
ReportHi Community,
I am working on a Dynamics 365 Finance & Operations – Cash and Bank Management – Bank Statement Import scenario.
We have a bank statement import process where the file is picked up from SharePoint, and an Electronic Reporting (ER) format/configuration is involved in processing the imported bank statement.
The issue is related to currency (CCY) mapping in the ER format.
Currently, the bank statement contains currency values such as:
- EUR
- GBP (GGP was also being considered/observed in the requirement)
We need to make sure that the currency value from the incoming bank statement is correctly interpreted/mapped during the import process and stored against the appropriate currency in D365 F&O.
For example, conceptually:
- If incoming CCY = "EUR" → currency should be recognized/stored as “EUR”
- If incoming CCY = "GBP" → currency should be recognized/stored as “GBP”
My main question is whether this can be achieved purely through ER configuration/format mapping, without custom X++ code.
I am specifically looking for guidance on the functional/configuration approach first.
What I want to understand
1. How should the CCY field from the bank statement be mapped in the ER model/format?
2. Can we configure a conditional mapping such as:
- "CCY = EUR" → EUR
- "CCY = GBP" → GBP
3. Is there an ER expression/function that can be used for this type of conditional currency mapping?
4. Is there an existing standard ER configuration or bank statement format that already handles this scenario?
5. Could the issue be caused by the ER model mapping, format mapping, data source, or bank statement configuration, rather than requiring customization?
6. Since the bank statement file is being picked up from SharePoint, I also want to understand the exact role of ER in this process and where the currency transformation/mapping is expected to happen.
Important
I would prefer to resolve this functionally using standard D365 F&O / ER configuration.
Custom X++ coding should be considered only as the last option, after confirming that the requirement cannot be achieved through standard ER configuration.
If anyone has faced a similar issue with Bank Statement Import + Electronic Reporting + CCY/Currency mapping, I would really appreciate guidance on the correct configuration and where exactly this mapping should be implemented.
Screenshots of the current ER configuration/format can be provided if required.
Thanks!
All responses (
Answers (
240,807
