By using this website, you agree to our Terms of Use (click here)
Hi,
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?
/Jonas
Jonas,
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)
etc...
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).
-Adam
Online Members
