GI of Empty Warehouse Locations

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.