Rename data field in a Generic Inquiry

  • 8 April 2021
  • 2 replies

Userlevel 1

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.



Best answer by hollyclark25 8 April 2021, 16:34

View original

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!


Userlevel 1

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


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 — 2024  Acumatica, Inc. All rights reserved