I’m trying to create a Generic Inquiry table that has all the inventory balance by location and serial number. There’s been several different tables presented on this site that can get qty by location (attached below) however, whenever I add Serial Number to them, the serial number gets attached to everything of the same part, producing duplicate results (and grouping isn’t smart enough to match deal with that). Is there a way to get the serial number to link only to the qty it belongs to?
Solved
Stock Item Balance GI by Location AND Serial Number?
Best answer by bwhite49
I didn’t open your GIs, but the INLotSerialStatus (Location/Bin and lot numbers) will have your qty on hand info for each lot number. You can link to the INLocationStatus (warehouse location/bin total) table via the SiteID, InventoryID, and LocationID. From there you can link to the INSiteStatus (Warehouse total) table through the Inventory ID and Site ID fields.
From there you will know the qty on hand by the warehouse through the INSiteStatus.QtyOnHand field, the Bin through the INLocationStatus.QtyOnHand and then lot number qty through INLotSerialStatus.QtyOnHand
Make sure you are using the correct qty on hand where appropriate.
+12I didn’t open your GIs, but the INLotSerialStatus (Location/Bin and lot numbers) will have your qty on hand info for each lot number. You can link to the INLocationStatus (warehouse location/bin total) table via the SiteID, InventoryID, and LocationID. From there you can link to the INSiteStatus (Warehouse total) table through the Inventory ID and Site ID fields.
From there you will know the qty on hand by the warehouse through the INSiteStatus.QtyOnHand field, the Bin through the INLocationStatus.QtyOnHand and then lot number qty through INLotSerialStatus.QtyOnHand
Make sure you are using the correct qty on hand where appropriate.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.