Product Unavailable Inventory Entry overview

When the Unavailable quantity in Product Warehouse Product Setup-Costs is increased or decreased, records are created in Product Unavailable Inventory Setup. Each record shows the quantity of product that is unavailable and the reason it is unavailable. When a product is moved into unavailable, you must specify an unavailable reason unless you are processing changes to a physical count. The unavailable reason is then automatically assigned.

These functions are affected by unavailable quantities:

• Product Maintain Balance Entry

  If you select Unavailable in Change Field, you must specify a reason why the product is unavailable.

• Product Entry Count Update Report

  When the unavailable quantity that is counted is different from the expected quantity, the records in Product Unavailable Inventory Entry are updated.

• Product Warehouse Inventory Audit Report

  When you select Yes for Update IC Discrepancies, the unavailable records in Product Unavailable Inventory Entry are used to determine the total unavailable quantity for these products:

  • Non-FIFO
  • Non-serial
  • Non-lot
• Sales Order Entry

  When you enter a customer return for unavailable product, the unavailable reason is copied to the PO line when a Returned Merchandise (RM) PO is created in Sales Order Entry.

• Sales Entry Processing Invoice Processing Report

  When the report includes customer returns, the Unavailable balance in Product Warehouse Products Setup is increased for products that are identified as unavailable in Sales Order Entry. Sales Entry Processing Invoice Processing Report also updates the Product Unavailable Inventory Entry record.

• Purchase Receipt of Inventory Entry

  An unavailable reason is required for transactions that involve unavailable quantities. The Product Unavailable Inventory Entry record is updated and includes the unavailable reason on the RO type Product Unavailable Inventory Entry record.

  If the product requires an inspection before being placed in inventory, assign an unavailable reason in Purchase Receipt of Inventory Entry. The unavailable reason must be set up SA Table Code Value Setup with an Unavailable Reason Type of inspection. After the product is inspected and can be placed into inventory, use Product Unavailable Inventory Entry to move the unavailable quantities to On Hand.

  If you select Receive As Unavailable for a Storeroom product in Product Warehouse Products Setup, it is automatically received as unavailable.

• Product Warehouse Transfer Entry

  Product Unavailable Inventory Entry records are updated in both the from and to warehouses when unavailable quantities are transferred.

• Transfer Exception Receipt Entry

  Product Unavailable Inventory Entry records are created when the unavailable quantity inProduct Warehouse Product Setup is increased in the ship from warehouse. This can occur when products were not received by the ship to warehouse during Transfer Receipt of Inventory Entry processing.

• Transfer Receipt of Inventory Entry

  When you specify an unavailable reason for transactions involving unavailable products, Transfer Receipt of Inventory Entry updates Product Unavailable Inventory Entry.

  If the product requires an inspection before it is placed in inventory, assign an unavailable reason in Transfer Receipt of Inventory Entry. The unavailable reason must be set up in SA Table Code Values Setup with an Unavailable Reason Type of inspection. After the product is inspected and can be placed into inventory, use Product Unavailable Inventory Entry to move the unavailable quantities to On Hand.

  If you select Receive As Unavailable for a Storeroom product in Product Warehouse Products Setup, it is automatically received as unavailable.

• Total Warehouse Logistics

  Total Warehouse Logistics contains resident unavailable reason types to segregate different types of damaged stock for disposition. When you implemented TWL, these unavailable reason types were set up in SA Table Code Value Setup.

  When an RM includes a return reason that contains an unavailable reason that is not valid in TWL, a message is displayed. When the RM is printed and the line is downloaded to TWL, a blank unavailable reason code is assigned to the line. The picker is directed to a location with available stock. To direct pickers to locations containing unavailable stock, you must specify a return reason that is valid in TWL.