One View Warehouse Location Inquiry (P46273)

Access the One View Warehouse Location Inquiry application (P46273) on the Warehousing Inquiries & Reports menu (G4614). Use One View Warehouse Location Inquiry to query location capacity and percentage fill information and create reports that provide a snapshot of the capacity and percentage fill of a location in the warehouse. The reports include related data from the Location Master (F4100), Location Detail (F4602), Location Dimensions (F46022), License Plate Items (F46l11), and LPN Location Capacity (F46L30) tables. One View Warehouse Location Inquiry uses the One View Warehouse Location Inquiry business view (V46273A), which includes columns from the Location Master, Location Detail, Location Dimensions, License Plate Items and LPN Location Capacity tables.

This application provides the ability to query by percentage of space used and display all the locators below or above a certain percentage. It can also be used to find empty locators. The percentage usage can be queried by units, volume, and weight. Distribution managers may use this information to create replenishment transactions, run the min-max report, or analyze item locator storage relationships. You can set up reports to run based on any combination of filter fields in the header of the One View Warehouse Location Inquiry form. The header filter fields include:

  • As If Volume UOM (unit of measure).

    This field identifies the As If Volume UOM as entered in Warehouse Location Inquiry header.

  • As If Dimension UOM (unit of measure).

    This field identifies the As If Dimension UOM as entered in the Warehouse Location Inquiry header.

  • As If Weight UOM (unit of measure).

    This field identifies the As If Weight UOM as entered in the Warehouse Location Inquiry header.

  • Branch/Plant.

    Enter a code that identifies a warehouse branch plant.