Skip to main content
Solved

GI of Empty Warehouse Locations


Jeff96
Captain II
Forum|alt.badge.img+4

I’m wondering how to create a GI that will list all warehouse locations that are empty so we know where to put away newly received goods.

 

Best answer by podonnell11

Jeff96 wrote:
podonnell11 wrote:

Hi Jeff,

 

Do you have the Storage Details by Item Warehouse Location inquiry on your version of Acumatica?

 

 

I do, but that doesn’t do what I’m looking for. Should I just do a pivot table on that? 

The pivot table is probably quickest way to do this. I was having a hard time using INLocation.SiteCD and INLocationStatus.SiteCD in a results grid ‘if then’ formula. My idea was to create a separate field per each warehouse location , then total aggregate sum that field on the bottom. Not the greatest but it would have shown the same thing as a pivot table: 

Unfortunately this doesn’t work: 

I hope the pivot table works as planned.

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

4 replies

Forum|alt.badge.img
  • Semi-Pro II
  • 40 replies
  • May 30, 2024

Hi Jeff,

 

Do you have the Storage Details by Item Warehouse Location inquiry on your version of Acumatica?

 

 


Jeff96
Captain II
Forum|alt.badge.img+4
  • Author
  • Captain II
  • 246 replies
  • May 30, 2024
podonnell11 wrote:

Hi Jeff,

 

Do you have the Storage Details by Item Warehouse Location inquiry on your version of Acumatica?

 

 

I do, but that doesn’t do what I’m looking for. Should I just do a pivot table on that? 


Forum|alt.badge.img
  • Semi-Pro II
  • 40 replies
  • Answer
  • May 30, 2024
Jeff96 wrote:
podonnell11 wrote:

Hi Jeff,

 

Do you have the Storage Details by Item Warehouse Location inquiry on your version of Acumatica?

 

 

I do, but that doesn’t do what I’m looking for. Should I just do a pivot table on that? 

The pivot table is probably quickest way to do this. I was having a hard time using INLocation.SiteCD and INLocationStatus.SiteCD in a results grid ‘if then’ formula. My idea was to create a separate field per each warehouse location , then total aggregate sum that field on the bottom. Not the greatest but it would have shown the same thing as a pivot table: 

Unfortunately this doesn’t work: 

I hope the pivot table works as planned.


  • Freshman I
  • 7 replies
  • July 9, 2024

Did anyone have success with this report? Our customer has requested the exact thing - a report that shows any empty locations (they use bins) that are available for use. I am also finding it hard to validate the inquiry results without the customers assistance. 


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