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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Account statement for all Customers

(0) ShareShare
ReportReport
Posted on by 15

Hello everybody. I have a question about managing customer overdues. Do you send account statements to your customers automatically via AX2012? (I mean a statement of account - Not reminders) For the purpose of confirming receipt of all invoices.

I tried to do it via AX but I cannot generate 1 statement per customer (in pdf) by email to all customers at once. Some tips ? Thanks a lot.

I have the same question (0)
  • OsmanIstanbul Profile Picture
    2,818 on at

    following..

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi And MIt,

    There is an "customer account statement" report available in the AR module in the report section.

    This report allows you creating and transmitting account statements to all of your customers.

    A prerequisite is that your customers have all emails set up and that your system is configured in a way that you can send out emails from AX directly.

    If you are not sure whether the necessary setups have been made then talk to your system admins.

    Best regards,

    Ludwig

  • And Mlt Profile Picture
    15 on at

    Hi Ludwig Reinhard,

    Thanks for your support.

    In fact I am already using this report.

    It took me 4 hours to generate one statement in pdf by customer (!) => enter the customer account + save the file and send it to customer.

    I cannot send it by email directly to customer as the file in attachment is not pdf even if I chose "pdf" it is still .html attachment (and I guess most of our Customers wont open an .html file for IT internal rules).

    I know that I can simplify the process. It's not possible to spend so much time generating statements...

    In the report: If I don't fill in the "account number" field in order to generate all account statements of all customers at once I will get one big pdf file with all the statements of accounts of each customer in succession (not even 1 statement per page). And this is useless.

    I'm sure there is a way to get what I want, but how?

  • Suggested answer
    Ramit Paul Profile Picture
    22,803 Most Valuable Professional on at

    Hello,

    I think you may use some custom code to generate the report and save it to SharePoint for per customer.

    From there, you can use power automate flow for this/.

  • Suggested answer
    SouravDam Profile Picture
    11,730 on at

    Hi And Mlt,

    You can use Business events and link to power automate.

    You can try with below links and see if this solves the case.

    https://ravishchandragupta.blogspot.com/2021/08/send-email-using-power-automate-flow.html

    https://d365bits.com/2020/06/14/how-to-create-business-events-in-dynamics-365-finance-and-operations/

    Regards,
    Sourav

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Good morning And MIt,

    I think you should have a talk with one of your colleagues from the development team.

    Many things that you mention indicate either that some set ups are missing or that some small code changes could accelerate and automate this process.

    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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 689

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 478 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 258 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans