Tweet
Is there a filter that can be used to show only available inventory numbers in a report? I am trying to come up with a Grid Report that will show the "Available" products with inventory numbers that are not on existing orders at the time of running the report. I have tried creating the report using both Product or Inventory Numbers. The closest I have come is with Inventory numbers and using the count function. The only issue is coming up with a filter to only count the inventory numbers that have an "on hand of greater than zero"
Without the filter it counts all inventory numbers under a product. I just can not figure out how to create a filter to do what i need?
Report without the required filter shows to many with count.....
However what i want is it to be filtered to only show the 2 available.
Is tthere a custom expression that can be written to make this work?
I am not able to export out the Product Menu from Espcrm and that is what I am trying to do with this report. Any help will be very usefull..
Without the filter it counts all inventory numbers under a product. I just can not figure out how to create a filter to do what i need?
Report without the required filter shows to many with count.....
Is tthere a custom expression that can be written to make this work?
I am not able to export out the Product Menu from Espcrm and that is what I am trying to do with this report. Any help will be very usefull..