Hi,
In customer payment journal when importing Camt.054 file which contains multiple <strd> tags under one <rmtinf> section i.e customer account marked with multiple invoices, we'll get only one line imported and the invoice id value show as *, we have the requirement where we need to import individual line per invoice that is marked against same customer account, so it is feasible to achieve this by changing the ER format logic?
Hi Vignesh,
Do you mean that although you get payment file (Cam054) with several <Strd> nodes under <RmtInf> (i.e. several customer invoices for one customer) you need that it can be imported as separate journal line in customer payment journal?
If yes, you can try to create a customization on GER config Payment model mapping to destination ISO20022 > Import mapping for customer payment journal.
You can also raise a support ticket to Microsoft via LCS to get better assistance.
Hi Alireza,
Yes, you got exactly what is needed.
We're using the custom model mapping by deriving from standard payment model mapping to destination ISO2022 format , so in our derived format we need to modify the logic to import multiple lines per invoice, currently the logic is defined to import the line based on <rmtinf> section present in incoming camt. 054 but now we need to modify the way to import one line against one <Strd> section, it would be great if you can provide more guidance on this?
On the other hand we can achieve this exact requirement when we're using the payment proposal to import the lines by having 'period' selection as 'Invoice' in method of payment level setup but we need to achieve this in ER level import payments process!
Exactly! I will try to create a config and test this behavior via creating a rule to define journal line based on Strd node and keep you updated.
Any updates/input on this?
Hi Vignesh V,
I am working on this issue and have discovered some inconsistencies that I need to report to Microsoft. I will come with a update as soon as I create a custom GER config for this purpose.
Hi Vignesh V and Sabina,
Importing Camt.054C files per Strd or Ustrd transaction as separate journal line when they are summarized is not supported in the standard configuration. This is because the Camt.054 structure does not include all the required invoice details, such as AmtDtls and RltdPties. The RmtInf section only contains information about the invoice, which can complicate the process of importing journal lines based on each Strd node, especially if the bank sends a summarized Camt.054C file.
Strd
Ustrd
AmtDtls
RltdPties
RmtInf
There are two approaches to address this issue:
TxDtls
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 1,933
André Arnaud de Cal... 793 Super User 2025 Season 2
Sohaib Cheema 537 User Group Leader
