Generic Inquiry simple condition not working

  • 7 February 2022
  • 3 replies

Userlevel 6
Badge +6


I have a very simple GI I am working on.  I want to select “Receipt” records.

The GI works and I can see records where InDocType and TranType have a value of “Receipt” in them.  However, I cannot limit my results with a simple condition on either field I return no records if I add this condition for either field.





Best answer by jinin 7 February 2022, 18:19

View original

3 replies

Userlevel 7
Badge +11

Hi @ltussing03 

You missed selecting the From schema checkbox. If you are not checked the checkbox, you need to add the DB value.

I have attached xml for your reference. It is working fine for me.


Userlevel 7
Badge +19

Hi @ltussing03  you can just click on the From Schema and select the Receipt. Just like below.


Userlevel 6
Badge +6

Perfect!  Thank you both!


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