Is there a way to combine qty on hand from multiple warehouse’s to come up with a total qty available in a GI? We have a use case where we want to look at two warehouses as a whole. (I know I could create a location as well but that would require a lot of inventory shifting.)
Answer
Combining QTY On Hand from multiple Warehouses
Best answer by lauraj46
Hi
Yes. Start with the INSiteStatus data access class, group on InventoryID, and sum the QtyOnHand. A simple GI to do this is attached.
+8Hi
Yes. Start with the INSiteStatus data access class, group on InventoryID, and sum the QtyOnHand. A simple GI to do this is attached.
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
+1Hi, @cmoreland!
You’ll need to join two tables as shown below and then group your results by InventoryID.
Also, in the Results Grid, make sure you select Aggregate Function = SUM.
Attached is the GI for your reference.
~Anna
Luck is what happens when preparation meets opportunity. ~Seneca
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.