AUGForums.com

An Acumatica User Group

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

Acumatica Generic Inquiry Date and Time

June 14, 2016 by Tim Rodman

Sometimes you want to display both the Date and the Time in a Generic Inquiry column. Use this Acumatica Generic Inquiry Date and Time trick to do it.

I learned a cool trick recently when it comes to getting a column to display both the Date and the Time in a generic inquiry.

 

The Problem

I create a simple Generic Inquiry like this.

Acumatica Generic Inquiry Date and Time

Acumatica Generic Inquiry Date and Time

 

The problem is that I only see the Date (not the Time) in the second column when I run it.

Acumatica Generic Inquiry Date and Time

 

The Solution

In order to get the Time to display, we can use a trick by adding the CRCase table without any relationships like this.

Acumatica Generic Inquiry Date and Time

Acumatica Generic Inquiry Date and Time

 

Then we put CRCase.CreatedDateTime in the Schema Field column of our already existing row. We’re basically “hijacking” the format from CRCase.CreatedDateTime and using it to get the format that we want on our SOOrder.CreatedDateTime field.

Acumatica Generic Inquiry Date and Time

 

Now the column shows both the Date and the Time.

Acumatica Generic Inquiry Date and Time

 

The only problem left is that it took the column title from CRCase.CreatedDateTime and gave the column an incorrect name of Date Reported, but we can fix this by overriding the caption on the Generic Inquiry.

You might have to add the Caption column to your grid using the icon to the left of the paper clip in the grid.

Acumatica Generic Inquiry Date and Time

Acumatica Generic Inquiry Date and Time

 

Pretty cool huh?

 

Filed Under: Acumatica Reporting Tagged With: Acumatica, Acumatica Blog, Acumatica Learning, Acumatica Reports, ERP

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

Online Members

Recent Blog Posts

  • EP 38: From Welder to Consultant, Nick Savage-Mady on his journey with Acumatica and MYOB Advanced (Podcast) January 21, 2021
  • Acumatica Reporting Tools Consulting January 19, 2021
  • EP 37: Jody Lorincz, IT Manager at MHR Brands, sharing his Acumatica Customer Story (Podcast) January 13, 2021
  • EP 36: What Motivates ERP Veteran Nicole Ronchetti To Participate in Acu-Connect (Podcast) January 8, 2021
  • Acumatica and Scanco WMS – A Cautionary Tale for ISVs January 6, 2021
Acumatica Learning Resources

Recent Forum Posts

  • RE: Popup screen fields not being auto populated

    Are you clicking the SEND button in both scenarios or t...

    By Tim Rodman, 6 hours ago

  • Legal Name?

    I am trying to get the Legal name of a company listed i...

    By Chip Fritsch, 6 hours ago

  • RE: Kensium Shopify versus Acumatica Shopify

    @garenmardirossian I have not but I am interested in hi...

    By Carl Brooks, 1 day ago

  • RE: Kensium Shopify versus Acumatica Shopify

    Have you also seen Biz-Tech Services Shopify Connector?

    By Gary Mardirossian, 1 day ago

  • RE: ACH postings in Acumatica

    ACH payments are better managed via the batch payments ...

    By Michael.Barker, 1 day ago

  • RE: Adding bill description on check stub

    @jswartz Yes, that does make sense, and yes without tho...

    By Chip Fritsch, 1 day ago

  • RE: Adding bill description on check stub

    @cfritsch Chip thank you for that. I did stumble upon t...

    By Jswartz, 1 day ago

  • RE: Create payment

    Hi @cndr, I think you’ll have better luck with this p...

    By Tim Rodman, 1 day ago

  • RE: Changing how fields are displayed on mobile app

    So I was able to figure this out in case we are not the...

    By jvandonkersgoed, 2 days ago

Recent Tweets

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.