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 Account Statement Reports Monthly Batch Date settings

(0) ShareShare
ReportReport
Posted on by 98

Good Day,

We are currently using AX2012 CU13. Every month I am tasked by accounts to create the customer account statements from Sales Ledger/Reports/External/Customer account statement. This all works fine as I set up 10 of these batches broken down by account number and set the from/to dates manually as they have to run to the most recent month each time I create them.

My question is, is there any way to have these batches setup to repeat each month? I understand I can do this via the "recurrence" settings, but if I do this the to/from dates (in the customer account statement)  are set and will not always run to the "latest" month. It seems odd that AX has the functionality to run these repeatedly, but not so the data is fresh/up to date each time.

So, say at the end of the month I set up these batches to run with a "from date" of 01/01/2000 and a "to date" of 31/05/2020. They will run correctly this run, but if I set the batch to repeat every month, at the end of June the "from date" will be 01/01/2000 (which is fine), but the "to date" will still show 31/05/2020, instead of 30/06/2020 as required.

Apologies if this is a simple setting somewhere, but I have very limited finance experience, and this seems like something that AX should be able to cope with.

Regards Cliff

I have the same question (0)
  • Verified answer
    André Arnaud de Calavon Profile Picture
    299,415 Super User 2025 Season 2 on at
    RE: Customer Account Statement Reports Monthly Batch Date settings

    Hi Cliff,

    There is no simple setting for this. It would require a customization. In the past, all reports were created with a start and end date. In AX2012, on some reports there are enhancements where you can set a period code. This can determine a start and end date, based on configuration. In the ledger area, you will see this more often on reports. Also the inventory closing has this period code selection option. A customization can be considered to copy similar logic to your batches.

  • CXF Profile Picture
    98 on at
    RE: Customer Account Statement Reports Monthly Batch Date settings

    Hi Andre, Thank you for you reply. Although no the answer I was hoping it was what I was expecting and at least I can stop searching now. I will document a change request foo our developers, based on you comments.

    Rgds Cliff

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,841

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 490 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans