I am trying to write a report involving inventory, but I cannot figure out how to get only active part numbers to print. I would think that I would need a formula something like:
if status=active then {partnumber}, if status=inactive then ""
only I can't find any field that populates the parts status. I've looked all through "Inventory" and "UOM" and a few others, but I can't find any group that contains a field called "status", does anyone know what I can do?
Thank you