Skip to main content
Question

Generic Inquiry Data Source No Results

  • February 9, 2026
  • 1 reply
  • 13 views
J
Freshman I

Hi all,

I recently created 2 separate Generic Inquiries for my company. One is Inventory with Sales/Margin/Margin % info. The other is inventory with units by location by warehouse.

My goal is to combine these 2 GIs into one master GI to avoid having to switch between different reports when viewing sales and inventory information.

Below are the data sources for the FIRST Generic Inquiry: Inventory Units & Cost by Warehouse.

When I use this GI as a data source for a new GI, NO fields show up even after selecting them in the results field. I have not joined anything to this in the new GI yet, so I doubt it’s a data relation mapping issue.

Conversely, when I use the other GI - Inventory by Sales/Margin/Margin % - as a data source, all records populate when I show them in the results field. 

Both individual data source tabs are shown below.

thanks all!

Joseph

 

1 reply

dhuynh75
Freshman I
  • dhuynh75
  • Freshman I
  • February 9, 2026

hi ​@JHuang ,

It would be great if you can clarify what you did when you mentioned

I use this GI as a data source for a new GI”

If you have not joined anything yet then you should check

  • Relation: I did not see relation in your 2nd so I am not sure if anything can be changed there, join conditions could let wrong mapping
  • Condition: check if you have any condition pre-defined or not.
  • Result column: check if any column added in Result tab?

That all I can suggest, hope it help.

 
 

 

 

    Terms & ConditionsCookie settingsAccessibility statement
    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