Rentals Report

I am creating a report called (Like This?) to use for my rentals

That variable/column seems to be working correctly for me...are you also running a filter that is maybe making it act differently?

The issue is for the infinite items

That's because before someone checked "unlimited" on these items someone had 100 saved for the quantity. To fix you would need to go to the item...uncheck the unlimited box. Delete the quantity and recheck the unlimited.

When I do that the limit is blank, which isn't awesome but also not the worst,

I just wish it was possible to pull the same data that is in the default for a report so I can add columns that I feel are necessary (Like location)

There is the variable: Rentals Location Name

That's because you have to choose a location already...so, if you are choosing a location FOR the inventory page...there's no need for that column. Everything on the page should be for the location anyways

But I want to see which locations have which piece of equipment on it I want to see all of the locations and all of the pieces of equipment so I can determine what I’m missing without having to dive into each individual inventory item, especially considering we have similar items across most of the locations

You can do that with the report....but before a location is set. Just go straight to the inventory page and click on the report.

If you could walk me through it that would be amazing.

I haveIf you could walk me through it that would be amazing.

I have tried many things to get what I’m looking for And none of them work

I just went to Settings-->Inventory. Didn't click on anything else (no location, no filters) and just clicked on the "like this?" report and it comes up w/ the locations

Yes, but the other columns are not pulling the same information/variables as the default columns. Which is why we are having issues with the Like this? Report.

Category for example is not the same as Rental Category or Rental Categories

Quantity is not the same as Count of Rental Quantity (Max)

Consumable isn't even an option when creating a report

It's going to act two different ways if you are running by location as a whole. It's either to run per location to get that info...or you can w/ the location column with that info.

I want to add the location column to the default Inventory report.