AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Report De...
Schedule Sales Orde...
 
Notifications
Clear all

Questions Schedule Sales Order Details by Inventory Item report to run monthly

 
Acumatica Report Designer
Last Post by Tim Rodman 5 years ago
9 Posts
4 Users
0 Reactions
4,855 Views
RSS
Posts: 35
 Geremy Partridge
Topic starter
October 3, 2018 9:03 pm
(@geremy-partridge)
Member
Joined: 8 years ago

Hello.  

 I'm trying to automate this report to run monthly. From what I have read the Automatic Schedule needs a screen ID of a Process and not the Report. Do I want to use Process Orders (Under the Process tree) as the screen ID?  

Thanks. 


8 Replies
Tim Rodman
Posts: 3195
 Tim Rodman
Admin
October 12, 2018 7:21 pm
(@timrodman)
Famed Member
Joined: 10 years ago

Hey Geremy,

You have to click the SAVE TEMPLATE button to save your preferred settings as a template (make sure you set the PRINT AND EMAIL SETTINGS -> To field so Acumatica knows who to send the email to):

 

Then you can click the SCHEDULE TEMPLATE button:

 

If you don't have a schedule yet, just leave the option set to <Set up a schedule first.> and click OK.

 

This will take you to the Automation Schedules (SM205020) screen where you can setup your monthly schedule. Note that the schedule is actually getting assigned to the Send Reports (SM205060) screen.

 

After you do this, your report should get emailed automatically according to the schedule that you defined.


Reply
Posts: 35
 Geremy Partridge
Topic starter
October 13, 2018 1:22 pm
(@geremy-partridge)
Member
Joined: 8 years ago

I have been trying to figure this out for a while. I was all hung up on not being to create a schedu;le for a reprt I could only find directions to set one up for a Process. 

Thank you so much!


Reply
Posts: 35
 Geremy Partridge
Topic starter
October 13, 2018 1:41 pm
(@geremy-partridge)
Member
Joined: 8 years ago

Will I need to change the Date Parameters manually every month?


Reply
Tim Rodman
Posts: 3195
 Tim Rodman
Admin
October 23, 2018 7:36 pm
(@timrodman)
Famed Member
Joined: 10 years ago

Hmmm, good question, not sure. Maybe try clearing them out before saving the template to see if they get populated dynamically?


Reply
Ellie
Posts: 129
 Ellie
April 12, 2019 10:37 am
(@ellie)
Estimable Member
Joined: 6 years ago

Has anyone figured our how to add a dynamic date filter  ( @ monthsstart for example )?

i left the date parameters blank and it populates the default dates


Reply
Tim Rodman
Posts: 3195
 Tim Rodman
Admin
April 25, 2019 11:35 pm
(@timrodman)
Famed Member
Joined: 10 years ago

What about setting the Report Parameter defaults in the Report Designer report definition itself?


Reply
sanjayhvermak
 sanjayhvermak
(@sanjayhvermak)
Joined: 5 years ago

Active Member
Posts: 3
April 16, 2021 2:35 pm
Reply toTim RodmanTim Rodman

@timrodman

Can we use a notification template for this?


Reply
Tim Rodman
 Tim Rodman
Admin
(@timrodman)
Joined: 10 years ago

Famed Member
Posts: 3195
May 10, 2021 3:51 pm
Reply tosanjayhvermaksanjayhvermak
Tim Rodman

@sanjayhvermak I think you could as long as you populate that notification template in the MailSettings -> TemplateID field on the Report Properties of the report definition that is getting called by the scheduler.


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 37 Online
  • 2,411 Members
Our newest member: thollings
Latest Post: Generic inquiry with information from Audit history(CT301000)
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×