Inquiring on orders in Storeroom

Only active records are displayed.

The status of the product in Customer Product and Customer Product Warehouse determines if it is displayed in the grid. If the product is inactive in Customer Product, then the product is not displayed. If the product is active in Customer Product, then it is displayed for each warehouse in which it is active.

• Product Detail

  Displays details from Product Warehouse Product Setup-Storeroom in Distribution SX.e. This inquiry also shows the product’s net available, including customer-owned and distributor-owned quantities, on order quantities, and ordering points. The Distributor Cost, based on the Customer Mark Up From setting in Product Warehouse Description Setup-Storeroom and the associated cost in Product Warehouse Product Setup-Costs, is displayed. The Warehouse Status identifies the product status, such as Stock, Direct Ship, or Do Not Reorder.

• Storeroom Detail

  Displays details from Product Warehouse Product Setup-Storeroom in Distribution SX.e and Customer Product in Storeroom.

• Transactions

  Displays all transactions that include the product, including invoices, receipts, returns, stock adjustments, and unavailable transaction. Displays these details about each transaction, if applicable:

  • Affected Distribution SX.e module
  • Increased or decreased inventory
  • Quantity shipped
  • Date transaction was posted
  • Customer-owned or distributor-owned inventory
  • Issued to

    This value is based on the Employee field on the issue.

  • Issued by

    This value is based on the user that created the issue.

  • Department
  • Machine

  If you are enabled to use drillbacks, then you can click the Document # hyperlink to open the corresponding inquiry for the transaction in Distribution SX.e.

• Back Orders

  Displays open back orders that include the product.

• Open PO/WTs

  Displays all open purchase orders and warehouse transfers that include the product. The due date for each open PO and WT is displayed so you can determine when the product is arriving in the Storeroom warehouse. For warehouse transfer, the From Warehouse is displayed. If you are enabled to use drillbacks, then you can click the PO # / WT # hyperlink to access the transaction in Purchase Order Inquiry or Transfer Inquiry in Distribution SX.e.

  Displays customer purchase orders that were manually entered in Customer Product PO Edit in Storeroom. The transaction type is req.

• Warehouse Availability

  Displays the net availability, including customer- and distributor-owned quantities, of the product in all Storeroom-managed warehouses in which the product is set up.

• Serials

  Displays each serial number that is assigned to the product, and details for each product such as bin location, status, and comments. Use the grid filter to search for serial numbers by a partial or complete number, or by status, such as available, retired, sold, or unavailable. When you search by status, only specify the first letter of the status, such as a, r, s, or u.

• Lots

  Displays each lot number that is assigned to the product, and these details about each lot:

  Open date	Quantity
  Expire date	Unavailable quantity
  Comments	Status

  Use the grid filter to search for lots by active or inactive status. Only specify the first letter of the status, such as a or u.

• Unavailable Reasons

  If a product has unavailable quantities, the reasons and quantities for both customer- and distributor-owned products are displayed. If the product does not have unavailable quantity, this tab is not displayed.