Generic Inquiry - Specify Columns
I have made a Genereic Inquiry for one of our customers that shows the Qty Available on each Warehouse. The problem is that every products shows for each warehouse. In this case we have 6 in stock on Warehouse 1 and 4 on Warehouse 2.
I would like to know if its possible to have these on one row with each Warehouse in a separate column.
In the GI Result Grid I have the Object Lagersaldo (which is InsiteStatus Table) and the data field SiteID.
I tried to get a own column and point out Site ID 2. But that didn't work out good.
Is it possible to do it like that?
The quick fix that we have done is to group, as you have already done, but then use the following logic as one of your results.
=IIf( [INSite.SiteCD]='YourWarehouseID#1', [INSiteStatus.QtyAvail], null)
=IIf( [INSite.SiteCD]='YourWarehouseID#2', [INSiteStatus.QtyAvail], null)
If you are really feeling up to it you could take a look at Tim's blog post where he talked about comma delineating these results, Acumatica Comma-Separated List of Shipments for a Sales Order using a Generic Inquiry and SQL View (augforums.com).