Solved

Rename data field in a Generic Inquiry

  • 8 April 2021
  • 2 replies
  • 788 views

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.

Thanks

icon

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!

Holly 

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

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