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 :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Email batch customer s...
Microsoft Dynamics AX (Archived)

Email batch customer statements

(0) ShareShare
ReportReport
Posted on by Community Member

Hi all,

I would like to email statments to individuals using batch processing. I have gone to: Accounts Receivables>Reports>External>Customer account statement. I have selected the customer group and set the destination to email and output as PDF.

Now this is my problem. When its sending the statements, its getting data for all customers of the selected group in one statement and sending the same to all individuals.

I hoped it would filter the data per AccountNum and send the statements based on that.

Please advice.

*This post is locked for comments

  • Suggested answer
    Fredrik Sætre Profile Picture
    Fredrik Sætre 12,644 on at

    In the section to the right in the report the selection dialogue you can select a customer accout.

    Click select and fill inn the customer account you want to see in your report

  • Suggested answer
    Fredrik Sætre Profile Picture
    Fredrik Sætre 12,644 on at

    You can however automate the process in SSRS...

    Use the reporting tools to create a scheduled report. Choose your filter (by customer) and delivery method (email).

  • Verified answer
    syed baber Profile Picture
    syed baber 11,633 on at

    Hi Robert,

    Why you are not using print management? If you are on AX 2012 R3, you can send customer statements based on the purpose defined on customer master form. See the below link which describes this process:

    community.dynamics.com/.../ax2012-cu7-enhancement-ability-to-email-reports-to-specific-people-by-using-tokens

    Please verify and let me know if you have further queries.

    Thanks,

    Baber.

  • Community Member Profile Picture
    Community Member on at

    Thanks Fredrik and Baber for your responses. Let me try the options you are both suggesting and revert...

  • Fredrik Sætre Profile Picture
    Fredrik Sætre 12,644 on at

    Hi Baber.

    Doesn't print management only work for documents (invoice, packing slip+++) and not reports in general? I think it has to do with the SSRS report having to be of a customer/vendor/order specific origin. Reports are not...

  • syed baber Profile Picture
    syed baber 11,633 on at

    Hi Fredrik,

    We can use print management to email customer statements as well. The external account statement report dialog has a checkbox 'use print management' which does use print management destination settings when selected.

    Thanks,

    Baber.

  • Community Member Profile Picture
    Community Member on at

    Hi Baber,

    I have over 400,000 customers. How can I make the process of setting up the email addresses easier?

  • Suggested answer
    syed baber Profile Picture
    syed baber 11,633 on at

    Hi Robert,

    How you uploaded your customers information in AX? You can easily import customer's address information (like postal address and electronic addresseses such as emails, telephone numbers etc) in AX using DIXF.

    Please let me know if you need further help in this regard.

    Thanks,

    Baber.

  • Community Member Profile Picture
    Community Member on at

    Ok, thank you

  • Community Member Profile Picture
    Community Member on at

    I used reference from : community.dynamics.com/.../ax2012-cu7-enhancement-ability-to-email-reports-to-specific-people-by-using-tokens

    and works perfectly in batch job.  Except when an account is missing the correct Purpose, the job fails/aborts instead of ignoring error; and therefore the rest of the accounts are not processed.  I appreciate any help you can provide.  Thanks, Richard

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans