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
Everything Else
Table and field for...
 
Notifications
Clear all

Questions Table and field for Business date

 
Everything Else
Last Post by Tim Rodman 8 years ago
3 Posts
2 Users
0 Reactions
2,244 Views
RSS
VJW
Posts: 51
 VJW
Topic starter
May 28, 2018 5:40 am
(@vjw)
Trusted Member
Joined: 6 years ago

Hi!

We are creating an inquiry where we would like to use the Business date in formulas in the inquiry. In filters you are able to use the @Today, but that doesn't seem to be possible in inquiries. Therefor, is there anyone here that have any idea of in what table the Business date(seen in the upper right corner in the system) is stored and what the name of the field is?


2 Replies
VJW
Posts: 51
 VJW
Topic starter
June 1, 2018 6:40 am
(@vjw)
Trusted Member
Joined: 6 years ago

Got info that the business date seems to be stored in session and not in any table and is therefor it is not available in the Result grid in generic inquiries


Reply
Tim Rodman
Posts: 3195
 Tim Rodman
Admin
June 4, 2018 12:53 pm
(@timrodman)
Famed Member
Joined: 10 years ago

Thanks for confirming this VJW about where the Business Date gets stored. I had suspected this, but wasn't 100% sure.

As far as using the Business Date in the RESULTS GRID tab, have you tried creating a hidden parameter on the PARAMETERS tab, then using the parameter on the RESULTS GRID tab?


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 18 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.

‹›×

    ‹›×