Skip to main content
Solved

Combining QTY On Hand from multiple Warehouses

  • 6 December 2022
  • 3 replies
  • 272 views

cmoreland
Semi-Pro III
Forum|alt.badge.img

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.) 

Best answer by lauraj46

Hi @cmoreland ,

Yes.  Start with the INSiteStatus data access class, group on InventoryID, and sum the QtyOnHand.  A simple GI to do this is attached.

View original
Did this topic help you find an answer to your question?

3 replies

lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 512 replies
  • Answer
  • December 6, 2022

Hi @cmoreland ,

Yes.  Start with the INSiteStatus data access class, group on InventoryID, and sum the QtyOnHand.  A simple GI to do this is attached.


aborisova37
Semi-Pro I
Forum|alt.badge.img+1
  • Semi-Pro I
  • 62 replies
  • December 6, 2022

Hi, @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.

 

 

 


cmoreland
Semi-Pro III
Forum|alt.badge.img
  • Author
  • Semi-Pro III
  • 106 replies
  • December 7, 2022

@lauraj46 and @aborisova37  Thanks so much. I for some reason was just not seeing the forest for the trees on this one. You guys are the best.  I wish I could check best answer on both of your answers. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings