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

Notifications

Announcements

No record found.

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
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    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

  • Apix Profile Picture
    307 on at

    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
    Satish Panwar Profile Picture
    14,671 Moderator on at

    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.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
Martin Dráb Profile Picture

Martin Dráb 544 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans