Announcements
No record found.
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
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.
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.
@Fernando, @Ed Boyer, Thanks for the tips!
Cheers!
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
