Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / AR Import Customer pay...
Finance forum

AR Import Customer payments Camt054 - Invoice does not get filled in

(1) ShareShare
ReportReport
Posted on by Rebecka21 37

Hello,

I'm using Microsoft ISO20022 Camt.054 to import customer payments. The lines are created in the payment journal with the amounts specified in the XML file. But the invoice column does not get filled in. I have looked in the model mapping and tried to understand and I have also tried to map the invoice fields I have found in the Data model to the XML tag (ustrd) that contains our invoice number but it doesn't work. Would greatly appreciate if someone has any idea how to do this. 

This is in 8.1

See attached pictures. The tag that contains the invoice number is in the tag "Ustrd"

XML-file-camt-054.jpg

 Custpay-camt054.jpg

Categories:
Financial Management
  • deepakkb Profile Picture
    deepakkb 140 on at
    RE: AR Import Customer payments Camt054 - Invoice does not get filled in

    Thank you Jayaprakash for your inputs!

    Your solution mentioned in your blog worked to settle invoices. 

    But in the file we receive from bank,  invoice is being sent in <TxDtls><RmtInf><Strd><AddtlRmtInf>. 

    For now I have extended the model mapping fetch the invoice number from <TxDtls><RmtInf><Strd><AddtlRmtInf>. I have extended Model mapping <TxDtls><RmtInf><Strd><AddtlRmtInf> to Remittance -> Structured Remittances -> Creditor Reference -> Reference if there is no data in <RmtInf><Strd><CdtrRefInf><Ref>. 

  • Jayaprakash Reddy Profile Picture
    Jayaprakash Reddy 270 on at
    RE: AR Import Customer payments Camt054 - Invoice does not get filled in

    When it is trying to find customer it will look in one place and for invoice it will look in one place . Until unless you adjust the format you will not be able to import the file with settlement.

    To find customer it will try to look for in invoice in RfrdDocInf , if it's blank then to go for other options like payment I'd , name , bank account number.

    To find invoice number to settle then it will look for invoice number in CrdtRefInf. This will check only when it's able to identify the customer . If it's not able to find th customer then it will not settle the transaction even though u have matching invoice number .

    In your case try to map the customer info also to identify.

    Like same same in file and AX or bank account information 

  • deepakkb Profile Picture
    deepakkb 140 on at
    RE: AR Import Customer payments Camt054 - Invoice does not get filled in

    Ahh now I know why I don't see the mapping there as with export formats. Thanks Eugen!

    Do you have any hints why does the invoice number (<TxDtls><RmtInf><Strd><AddtlRmtInf>) does not get imported?

  • Eugen Glasow Profile Picture
    Eugen Glasow 6,357 on at
    RE: AR Import Customer payments Camt054 - Invoice does not get filled in

    This is because this is not an outbound interface, but an inbound one. It uses a _destination_ mapping, which is in a different configuration. Here is an extract from an FDD of mine:

    The inbound camt.054 format ISO20022 Camt.054 reads the file provided by the bank and places the parsed data into an abstraction container Payment model (v13), then applies the Payment model mapping to destination ISO20022 to write the data from the model into the appropriate Dynamics 365 tables.

  • deepakkb Profile Picture
    deepakkb 140 on at
    RE: AR Import Customer payments Camt054 - Invoice does not get filled in

    Hello Experts,

    I am also facing the same issue.

    Invoice number the bank is sending is not imported in Customer Payment Journal. Bank is sending the Invoice number in <AddtlRmtInf> xml tag. 

    CommunityPost.png

    One more thing I have a doubt on is when I open the format designer for Camt.054 from Electronic reporting workspace, I do not see anything when I click on Mapping tab. But for other file formats , I do see the mapping for example, ISO20022 Credit Transfer files:

    FormatDesignerCamt.054.PNG 

    Platform update : Update33

    Camt file GER Configuration : ISO20022 Camt.054 : version : 14.23

    Any help would be highly appreciated.

    Thank you,

    Deepak.

  • Suggested answer
    Jayaprakash Reddy Profile Picture
    Jayaprakash Reddy 270 on at
    RE: AR Import Customer payments Camt054 - Invoice does not get filled in

    Please read my blog about camt.054 file and how it works while importing in D365FO

    How matching transactions works to settle incoming payments from the ISO20022 camt.054 into Customer payment journal in D365FO

    may be it will give me idea.

    Thanks/Jayaprakash 

  • Suggested answer
    Eugen Glasow Profile Picture
    Eugen Glasow 6,357 on at
    RE: AR Import Customer payments Camt054 - Invoice does not get filled in

    It doesn't understand Ustrd. The standard format relies on creditor data/Strd/... You have to change the related Mapping to model to take the invoice from another field, or the Mapping to destination to take it from another node in the model. Both options require some experience in ER.

    P.S. If I recall correctly, I manipulated the Mapping to destination, it is easier to do.    You do it by deriving a new mapping to destination from the existing one, the declare the new one the default. The place you are looking for is somewhere deep inside called $CustTransByInvoice or something similar. It takes the filter from the remittance node of the model. You have to redirect that to what corresponds to Ustrd in the model.

  • Rebecka21 Profile Picture
    Rebecka21 37 on at
    RE: AR Import Customer payments Camt054 - Invoice does not get filled in

    Yes, I selected settle transactions. I have also tried to put the Invoice number in the paymentID field.

  • Suggested answer
    Peach Profile Picture
    Peach on at
    RE: AR Import Customer payments Camt054 - Invoice does not get filled in

    Dear Rebecka

    Did you select "Settle transaction" when you imported the camt.054 file? - The import will then try to find the matching open customer transaction (based on paymentID) and mark the open transaction for settlement. And then the Invoice is filled on the payment journal line, based on the marked open invoice.


    BR

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.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,202 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,923 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans