Display Item number with and without Part numbers and Manufacturer in Custom Onhand Inventory Report
Summary: The query below displays all inventory item numbers with part numbers and manufacturer information. However, the report does not show items without part numbers and manufacturer information, even if the item has an on-hand quantity in the system. Is there a way to modify the report to display all items, whether they have part numbers and manufacturer information or not, as long as the item has an on-hand quantity
Content (required): The query below displays all inventory item numbers with part numbers and manufacturer information. However, the report does not show items without part numbers and manufacturer information, even if the item has an on-hand quantity in the system. Is there a way to modify the report to display all items, whether they have part numbers and manufacturer information or not, as long as the item has an on-hand quantity.