Hello,
Is there a way to schedule a report in RMS? Example: I want Item Quantity report to be executed @23:59hrs every last day of the month.
Thanks.
*This post is locked for comments
@Fernando, @Ed Boyer, Thanks for the tips!
Cheers!
Sam
I think one of the ISV partners have an addon that can help you with this. I cant find that ISV currently but I remember this being created by someone.
Nothing like that out of the box; maybe implementing Reporting Services; better approach may be to create an empty copy of the ITEM table (minus any IDENTITY fields like ItemID), create a stored procedure that runs an INSERT against that table, then schedule that store procedure to run the first of every month at midnight. Add a column named DATE or RUNDATE or something like that, where on your INSERT you map GETDATE() into that field, so you can view the actual date of your insert.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Mansi Soni as our August 2025 Community…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
