Use GWMS to Query and Process Warehouse Inventory

Updated: 2026-05-21

1. Scenario

Definition: Inventory Management is the warehouse page used to review the current inventory result stored in GWMS. The page supports multiple inventory perspectives so the team can check quantities, shelf life, volume, pending outbound inventory, inventory to be received, defective inventory, and total inventory.

Purpose: The warehouse team can use this page to query current inventory, confirm customer stock levels, export inventory data, import opening inventory, and start stock transfer tasks from the location perspective.

Applicable scenarios:

• Check the current inventory result for one warehouse, location, SKU, owner, or batch.
• Review inventory from different perspectives before transfer, counting, or billing.
• Export inventory data after narrowing the result scope with filters.
• Import opening inventory during initialization or a special correction scenario.
• Start a stock transfer from the location perspective.

Not applicable:

• If you need to trace why inventory changed, use GWMS-Warehouse Operations-Inventory Records.
• If you need to count physical stock and sync the result, use GWMS-Warehouse Operations-Inventory Count.
• If the customer only needs to review its own inventory, use the customer-side inventory pages instead of the warehouse page.

2. Operation Guide

Prerequisites

Please confirm the following before you start:

1. Your account can open GWMS-Warehouse Operations-Inventory Management.
2. The target warehouse, zone, location, SKU, and owner data are already maintained.
3. Inventory data has already been generated by inbound, import, stock count, or stock transfer operations.
4. If you need to export data, prepare at least one useful filter such as Warehouse, Storage Location, SKU, Owner, or Batch.
5. If you need to transfer stock, confirm that the destination location can be used and that the current inventory is not blocked by downstream work.

2.1 Open the Inventory Management page

Menu path: GWMS-Warehouse Operations-Inventory Management

1. Sign in to GWMS.
2. In the left navigation, expand Warehouse Operations.
3. Click Inventory Management.
4. The top area shows the filter panel, the middle area shows action buttons, and the lower area shows inventory tabs for different perspectives.

The current page shows these main filters:

• Warehouse
• Storage Location
• Warehouse Zone Type
• Warehouse Area
• SKU
• Owner
• Batch
• Listing Date
• Include zero inventory

After you set the filters, click Search. If you want to clear the filters and query again, click Reset.

2.2 Review inventory in Detail Perspective

Detail Perspective is the default tab after the page opens. It is suitable when you need to review one inventory record with its full detail.

The current list shows fields such as:

• Warehouse
• Storage Location
• Owner
• SKU
• GSKU
• Batch Number
• Shelf Life (Days)
• Volume (m³)
• Inventory

Use this perspective when you need to confirm one exact inventory line, such as one SKU in one location for one owner and one batch.

2.3 Review inventory by location and start a stock transfer

Click Location Perspective. The page groups inventory by location and lets you expand the location row to review the SKU lines below it.

The current page shows fields such as:

• Storage Location
• Warehouse
• GSKU
• SKU
• Volume (m³)
• Pending Outbound Inventory
• Total Inventory
• Warehouse Transfer Operations

If you need to start a stock transfer from this page:

1. Expand the target location row.
2. Select the SKU row that should be moved.
3. Click Transfer Stock.

4. The system opens the SKU Transfer dialog.
5. Click Target Location in the target row.
6. Select the destination location and enter the transfer quantity.
7. Click Confirm.

System result:

• After the transfer is submitted successfully, the stock transfer task is created.
• The source location inventory is reduced and the destination location inventory is increased after the transfer is processed.

The current page also shows a direct destination-location input in the Warehouse Transfer Operations column. Use that area when you need to process one single line quickly.

2.4 Review inventory by SKU, owner, warehouse, and batch

Inventory Management provides several summary perspectives. After you switch tabs, the page refreshes the result using the current filters.

Common uses:

• SKU Perspective: Review the total stock result for one GSKU, including volume, inventory to be received, pending outbound inventory, defective inventory, available inventory, and total inventory.
• Owner Perspective: Review the inventory held for one owner.
• Warehouse Perspective: Review the inventory result by warehouse.
• Batch Perspective: Review inventory by inbound batch and shelf-life result.

These perspectives support drilling down into the current scope so you can continue checking the related SKU and warehouse details.

2.5 Export inventory data

1. Set at least one filter, such as Warehouse, Storage Location, SKU, Owner, or Batch.
2. Click Search to confirm the result scope.
3. Click Export.
4. The system downloads the current inventory result as an Excel file.

Use filters before exporting so the result only includes the inventory range you need to review internally.

2.6 Import inventory

Applicable scenario: You need to import opening inventory in bulk during initialization or a special correction scenario.

1. Click Import.
2. The system opens the Inventory Import dialog.
3. Click Download Template.
4. Fill in the inventory data in the template file.
5. Upload the .xls or .xlsx file.
6. Click Confirm.

System result:

• After the import succeeds, the inventory list is refreshed.
• The current dialog states that only .xls and .xlsx files are allowed.

3. Additional Notes

3.1 What the inventory quantities mean

• Inventory: The current recorded quantity for the selected perspective.
• Pending Outbound Inventory: Inventory already occupied by outbound work.
• Inventory to be received: Inventory that is still on the inbound path and has not finished the full process.
• Defective Inventory: Inventory stored in the defective area or marked as defective.
• Available inventory or Total Inventory: Summary quantities used to help review the current usable and total stock range.

The summary tabs help you locate inventory distribution. Whether the stock can be picked, transferred, or shipped still depends on the actual downstream task status and location situation.

3.2 Shelf life and batch review

Shelf Life (Days) is calculated from the listing or putaway time shown in the current inventory record. Batch is used when you need to review long-aged inventory, batch-specific stock, or one inbound scope.

When you need to investigate aged stock, a practical order is:

1. Start with Batch Perspective.
2. Expand the current batch to locate the related SKU and warehouse data.
3. Return to Detail Perspective if you need one exact inventory line.
4. Switch to Location Perspective if the stock also needs to be moved.

3.3 Difference between Inventory Management, Inventory Records, and Inventory Count

• GWMS-Warehouse Operations-Inventory Management: Review the current inventory result and use export, import, or transfer actions.
• GWMS-Warehouse Operations-Inventory Records: Review the historical increase, decrease, transfer-in, or transfer-out result.
• GWMS-Warehouse Operations-Inventory Count: Count physical stock and sync the difference to the inventory result.

If you only need to know how much stock exists now, use Inventory Management. If you need to know why the quantity changed, use Inventory Records. If you need to correct the difference between system stock and physical stock, use Inventory Count.

4. FAQ

Q1: Why is the inventory query result empty?

A1: Click Reset first, then query again with only one basic filter such as Warehouse. If the page is still empty, confirm whether inventory has already been generated by inbound, import, stock count, or transfer operations.

Q2: Why does the system require filters before export?

A2: Inventory data can be very large, so the page is intended to export only a narrowed result scope. Select at least one practical filter before exporting.

Q3: Why can't I start a stock transfer from Inventory Management?

A3: Start from Location Perspective, expand the location row, and select the target SKU line first. The transfer action is tied to the current location and SKU scope.

Q4: Where can I review the result after a stock transfer is submitted?

A4: You can review the related stock transfer task in GWMS-Warehouse Operations-Warehouse Transfer Operations, and you can also return to inventory-related pages after the transfer result is refreshed.

Q5: What file format does Inventory Import accept?

A5: The current import dialog states that only .xls and .xlsx files are supported.