AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • 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...
Monthly Scheduled r...
 
Notifications
Clear all

Questions Monthly Scheduled report

 
Acumatica Report Designer
Last Post by Geremy Partridge 7 years ago
3 Posts
2 Users
1 Reactions
2,310 Views
RSS
Posts: 35
 Geremy Partridge
Topic starter
March 1, 2019 2:40 pm
(@geremy-partridge)
Member
Joined: 8 years ago

Hi All.

 We are using 2017 R2. I have 3 reports scheduled to run on a monthly basis.

I have been having issues with these reports sending properly. 

1st issue I had was when the month changes from the last day to the first day of the month it was changing the report parameters. It would keep the date for the last day of the month I wanted the report for, but would change to the first day of the current month. To rectify this, I went into the report in Report designer and set the date parameters in there to @monthstart-1 and @monthend-1. Theoretically,

If the report runs on March 1st, I should get the data from Feb 1st to Feb 28th. The reports sent but there was no data in them. The report showed it was listing the data from the correct time period(2/1 to 2/28).  The hardest part of troubleshooting this is that I can only try different settings once a month since it's the month change that seems to screw up the reports. I can attach the report if you would like to take a look at it. 

Anyone have any ideas what I need to change to get this to work properly? For march I am going to change the run date to 11:30 PM on the last day of the month and I bet it will work. If I set it to run April 1st, it won't work. 

 

Thanks.


2 Replies
Tim Rodman
Posts: 3204
 Tim Rodman
Admin
March 8, 2019 11:14 pm
(@timrodman)
Famed Member
Joined: 10 years ago

If the parameters are displaying correctly in the report, then it seems like you set them correctly. This smells like a buggy thing to me. You might want to try an Acumatica support case for this.


Reply
Posts: 35
 Geremy Partridge
Topic starter
March 18, 2019 2:45 pm
(@geremy-partridge)
Member
Joined: 8 years ago

Thanks Tim.


Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,530 Topics
  • 11 K Posts
  • 12 Online
  • 2,418 Members
Our newest member: Chad Treadwell
Latest Post: Negative/Credit Inventory Value?
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

  • Johnny Tang
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×