web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Customer collections letters DMF import

(0) ShareShare
ReportReport
Posted on by 307

Hello folks, 

I'm about to process data transfer from a previous system to D365 F&O. 

My question is about collection letters. As soon as I get customer invoices from the previous systems do we have a way to import the related collections letters? People from cash collection service  need to start in D365 with the right collection letter code. 

For example, in my previous system I already sent two collection letters at customer CUST01 for INV01 and INV02. I need to start in D365 with Collection letter code 3 and not 1. 

Thanks for your feedback, 

Regards

I have the same question (0)
  • Verified answer
    Satish Panwar Profile Picture
    14,669 Moderator on at
    RE: Customer collections letters DMF import

    Hi PICCIN,

    Don't see any entity specific to CustTrans and that's as expected. Also don't see open in Excel feature for the same. If it's handful of transactions, suggest that you plan to update this manually. If lot of transactions, then build a custom entity to update CustTrans collectionLetterCode field.

  • Apix Profile Picture
    307 on at
    RE: Customer collections letters DMF import

    Hi Ludwig,

    Perfect as usual.

    I did not find a CustTrans Entity to import this status, do you think we must do this manually?

    Regards,

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Customer collections letters DMF import

    Hi Piccin,

    You can define the next collection letter that is applied in the customer transaction form.

    col.jpg

    What you need is thus an update on those transactions to ensure that the next collection letter created in D365FO is in line with the ones created in your prior system.

    Best regards,

    Ludwig

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 745 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 597 Most Valuable Professional

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 580 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans