Solved

Need help with a Generic Inquiry

  • 3 June 2022
  • 6 replies
  • 62 views

Userlevel 2
Badge

Hi,

I am new to Acumatica and need assistance setting up a Generic Inquiry. I was able to setup a GI but the information looks incomplete.

We want to create a GI that shows invoices under Bills and Adjustments for a project that has a pending status for the Project Task and Inventory ID in Bills & Adjustments under the Details tab. See first screenshot below:

 

The next three sceenshots show the configuration and results. What am I missing in my GI setup? Any information would be helpful. Thanks. 

Relations Setup:

 

Results Grid:

 

 

Inquiry Results:

 

 

 

icon

Best answer by Naveen Boga 3 June 2022, 19:27

View original

6 replies

Userlevel 7
Badge +12

Hi @FrancesPantelidakis24  Below are the changes that are missed. 

You can add the below changes and verify them.

 

In the RELATIONS tab.

 

CONDITIONS tab: To show only Invoices (Type = Bill)

 

Here is the final result. If required you can more fields in the RESULTS tab.

 

 

 

Userlevel 7
Badge +12

Yes @FrancesPantelidakis24  That is correct!

Userlevel 2
Badge

Thanks I will try this and let you know if I have any questions. 

Userlevel 7
Badge +12

Hi @FrancesPantelidakis24  Can you please share the XML format of GI here?

 

 

Userlevel 2
Badge

Hi Naveen,

 

Here you go.

 

Thanks, 

Frances 

 

 

Userlevel 2
Badge

HI Naveen,

 

Great one more question so I just add these additional items and leave the other configuration before as is? Correct?

 

Thanks, 

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