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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Suggested Answer

Customer aging data storage

(1) ShareShare
ReportReport
Posted on by 94

Hi all,

I want a reoccurrence batch job execute every time with the current date as a parameter in [Customer aging data storage] setup.

Any idea highly appreciated. 

pastedimage1665481926264v1.png

Thanks

I have the same question (0)
  • huijij Profile Picture
    19,811 on at

    Hi Eng.khan,

    This date is optional, what exactly do you want?Can you elaborate on it?

  • Suggested answer
    Brittany Burke Profile Picture
    on at

    Unfortunately this date in the report is Static, and not dynamic, and will not update with each time you run the report. Customizations would be needed here to make it Dynamic, allowing for a syntax such as (day(0)) to allow for users to determine the parameter dates in relation to the current session date when running in a recurring batch.

    Sorry this wasn't the answer you were looking for.

  • Eng.khan Profile Picture
    94 on at

    Hi Judy,

    Whenever the batch job is run, I need these date parameters to be set as current date dynamically.

    Thanks

  • Eng.khan Profile Picture
    94 on at

    Hi Brittany,

    Thanks for you feedback,

    can you please elaborate, where specifically the customization required.

    Regards,

  • Suggested answer
    Brittany Burke Profile Picture
    on at

    The SSRS report would need to be copied/Duplicated and modified by a developer to meet your requirement.

  • Suggested answer
    BillurSamdancioglu Profile Picture
    20,111 Most Valuable Professional on at

    Hi,

    As far as I remember, there is already a idea created in IDEA PORTAL for this.

    Can you please check if there is , or not you may open a new one for that. If exist please vote.

  • Suggested answer
    AH-09091207-0 Profile Picture
    14 on at
    Leave both parameters empty. Then create a batch job that runs daily (or according to your wishes). my batch job runs daily in the evening. The current date is used for each execution. Done.
    You can then use the current data (updated aging data storage) (again daily) via data management.
    Hope that helps.

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

News and Announcements

Season of Giving Solutions is Here!

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 > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 215 Super User 2025 Season 2

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 215 Super User 2025 Season 2

#3
André Arnaud de Calavon Profile Picture

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

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans