Question

Rename data field in a Generic Inquiry

  • 8 April 2021
  • 2 replies
  • 20 views

What do I need to do in a GI to replicate the functionality I would use in SQL for example to have

SELECT Contact.DisplayName [Contact Name] from Contact where ContactType = ‘LD’

I want my GI column name to be Contact Name and not DisplayName.

Thanks


2 replies

If I understand your question correctly, On the Results tab of the Generic Inquiry, there is a column called “Caption”.  You can ‘alias’ your column using this field:

Caption to ‘alias’ the column heading

Hope this helps!

Holly 

RATS! That was sickeningly easy. I didn’t think to look in the column configurator….Thank you Holly, have a great rest of your day

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2020  Acumatica, Inc. All rights reserved