Generic Inquiry List/Report

  • 16 October 2020
  • 3 replies
  • 51 views

I am trying to build a GI to list all Generic Inquiries in the system. The Site Map Title is not within the GIDesign table. I believe I need to tie the GIDesign table with the SiteMap table to get those details. Can’t seem to figure that out though… Has anyone been successful with this?


3 replies

Userlevel 1

Hi @Ehren_Dimitry,

 

I have created a simple GI to get all the Generic Inquiries with SiteMap details. Please find attached the XML format of GI and verify it. I hope this will help you.

 

Best Regards,
Naveen B

Hi Naveen!

Thanks for your help! So much appreciated…

This certainly gets me closer. However, it is only showing me generic inquiries that are visible to the UI. I changed the join to LEFT for GIDesign & SiteMap and the results didn’t change. 

My goal is to have a list of all GI’s so we can better manage them. There are several that are created for testing/learning, others that are project-based. I want to create filters based on the description field, if they are in the UI, etc….

Thanks again!

Ehren

Userlevel 1

Hi Ehren,

Sure. Yes, will get the exected results by doing this way!  Thanks for verifying and providing an update on this.


Thanks,
Naveen B
 

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