[Solved] Production Order Comp. Qty. Avail.
I'm trying to make a custom GI so we can see quantity available for each item on a production order in a given warehouse.
I'm almost there, I can show quantity grouped by item for all warehouses, but when I try to run this If statement, I keep getting 0.
=IIf( [INLocation.SiteID]='001', [INLotSerialStatus.QtyAvail],0)
I made a stripped down GI that just uses INLocation.SiteID and INLotSerialStatus.QtyAvail and I've attached the GI below. Thanks!