AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Rolodex
  • Login
  • Start Here
  • Consulting
  • Courses
  • Register
Acumatica Forums

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

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica Report De...
Use of @Today in Re...
 
Notifications
Clear all

Use of @Today in Report Filter?  

    Last Post
RSS

Royce Lithgo
Posts: 445
 Royce Lithgo
October 15, 2020 1:04 am
(@roycelithgo)
Over 200 Posts
Joined: 10 months ago

I have an issue with 2020.3 upgrade and AR Aging reports. I need to be able to conditionally use @Today in the report filter (depending on a new boolean parameter that I added to the report which triggers use of today's date instead of the specified Aging Date).

As a test I replaced all instances of @AgeDate with @Today assuming that @Today was a built in parameter.

The report returned no output at all. So i can only assume that either @Today doesn't work as a report filter, or there's an issue in the 2020.3 sandbox we are testing in.

Does anyone know whether @Today really is supported in Schema Builder -> Filter (in the Value column)?

image
2 Replies
Royce Lithgo
Posts: 445
 Royce Lithgo
October 15, 2020 2:08 am
(@roycelithgo)
Over 200 Posts
Joined: 10 months ago

I can answer my own question now. Didnt have any luck with @Today, but it worked with =Today(). So formulas can be used in the Value columns of Filters even though you cant get to the formula editor from the UI. I got the report working with this filter.

image
Reply
Dianne A, Wyatt.ERP and Daru liked
Tim Rodman
 Tim Rodman
    ★★ All-Star ★★
(@timrodman)
Joined: 5 years ago

Over 200 Posts
Posts: 2488
December 30, 2020 11:15 pm
Reply toRoyce LithgoRoyce Lithgo

Very interesting. I didn't realize you could do this. Thanks for sharing @roycelithgo.

Reply
Royce Lithgo liked
  All forum topics
  Previous Topic
Next Topic  
  Forum Statistics
11 Forums
1,656 Topics
7,693 Posts
1 Online
1,110 Members

Latest Post: Timecard reports/queries Our newest member: Janetteraab Recent Posts Unread Posts

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 © 2021 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×