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, ...
Suggested Answer

Case creation automation

(2) ShareShare
ReportReport
Posted on by 34
I have a unique issue with Collections Process Automations. We are importing all of our invoices from another ERP platform, and all of them are being written to the GL – which Collections Process automation will not pick those invoices up as past due. This is rendering the whole module useless to us, unfortunately. 

We are looking at a custom solution that will create new Cases based on aged balances hitting certain thresholds. Does anyone have any recommendations on how to approach this? Past experiences, etc. 
Categories:
I have the same question (0)
  • Suggested answer
    Zain Mehmood Profile Picture
    4,187 Most Valuable Professional on at
    Hi, 

    Collections Process Automation in D365 Finance is tightly tied to credit and collections transactions, not just GL postings. Since your invoices are imported and only reflected in the GL, the system doesn’t treat them as open customer balances for collections purposes.

    To make Collections automation work, invoices need to exist as customer transactions (e.g., posted sales invoices or free text invoices) under Accounts receivable, not just as GL entries.

     

    Custom process for aging + case creation

    Since you’re considering a custom approach, build a batch job that:

    Analyzes customer open balances from the GL or customer aging reports

    Triggers creation of collection cases when thresholds (e.g., number of days past due or amount) are exceeded

    This logic can be tied to Collections case categories, giving you partial automation.

     

    Alternative workaround

    If feasible, consider importing invoices as free text invoices via data entities. This would allow them to integrate naturally with collections without custom development.

     

    Leverage Power Automate or Dataverse

    If cases and customer data are exposed through Dataverse, a Power Automate flow could also be used to create follow-up tasks or case records based on aging logic.

    Hope this helps
    Zain
  • Jonas "Jones" Melgaard Profile Picture
    4,980 Most Valuable Professional on at
    It might be a dumb question from my side, but is there a reason why you are not using free text invoices for this?
    I did something similar for an integration between Chargebee and D365 Finance.
     
    That way you'll be able to use standard collection processes, as Zain correctly points out. 
  • Suggested answer
    Ramesh Kumar Profile Picture
    7,527 Super User 2025 Season 2 on at
     Switch to Free Text Invoices / Customer Journals Works natively with Collections Automation Requires integration change
    Custom aging + case creation from GL Uses current import process Requires dev effort, lacks D365 automation features
     
    Import via Free Text Invoices or Customer Journal (Preferred)
     
    Thanks
    Ramesh
     
    If this was helpful, please check the "Does this answer your question?" box and mark it as verified.
     
  • Jonas "Jones" Melgaard Profile Picture
    4,980 Most Valuable Professional on at
    Good you can confirm @Ramesh,
    To reiterate what Zain said, it's not automated but part of the normal collection runs in D365 F&O; It's just possible to include the postings in the runs.
     
    If possible, can you share why you cannot use free text invoicing?

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 584 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 254 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans