Nonstock inventory adjustments

The Product Adjust Non-stock/Direct Order Entry-Adjust function is also launched from the WL Entry Batch Receiving Report. If inventory records must be created for the nonstock, access Product Adjust Non-stock/Direct Order Entry and use the Product Adjust Non-stock/Direct Order Entry-Inventory function.

Nonstock transactions create ICENH and ICENL table records that track the nonstock products when you perform these tasks:
  • Receive them into the warehouse
  • Allocate them to orders
  • Ship them out of the warehouse

The Product Adjust Non-stock/Direct Order Entry function processes these records for nonstock products that are received from vendors, other warehouses, or from customer returns. The order number and line is passed from TWL so that the correct ICENH and ICENL table records are processed. If a journal is already open for the current date, then the transactions are posted to that journal. If the journal is open from a previous day, then that journal is closed and another journal is opened for the daily transactions.

Initiate Product Adjust Non-stock/Direct Order Entry processing by generating the WL Entry Batch Adjust Inventory Report when these conditions exist for a nonstock product that you receive:
  • Damaged
  • Undershipped by the vendor
  • Not associated with an active order or warehouse transfer

The Product Adjust Non-stock/Direct Order Entry-Adjust function automatically handles the damaged goods transaction. If the internal ICENH and ICENL table records balance, then the ICEN table records are closed or removed. This action is based on the Purge NS/DO Shipments After Closing option setting in SA Administrator Options-Products-Costs. The Product Adjust Non-stock/Direct Order Entry-Inventory function is used to move the nonstock product into stock for future processing. This function creates the Product Setup and Product Warehouse Product Setup records, if they do not already exist, and creates the product as an order-as-needed product.

If a nonstock adjustment is synchronized from TWL without an attached cost, then the database is searched for the last active nonstock transaction. If a valid cost is found, then the cost is attached to the nonstock adjustment. If a cost cannot be found, then zero is used. The adjustment is processed, but this exception prints on the WL Entry Batch Adjust Inventory Report and must be resolved: WARNING: No Cost Found For The Non-Stock Adjust; Manually Adjust-ICEAN.

Any primary bin location change that occurs in a live TWL warehouse is processed through WL Entry Batch Adjust Inventory Report. The corresponding Product Warehouse Product Setup bin locations are changed to reflect the TWL changes.

If you are running WL Entry Batch Adjust Inventory Report for a warehouse that is not live on TWL, then Product Warehouse Product Setup is not updated immediately and transactions are queued.

The Product Warehouse Product Setup record may be locked and WL Entry Batch Adjust Inventory Report cannot update the record. If so, then an exception prints and the transaction record is flagged as an error transaction. However, you cannot access WL Transaction Inquiry to reset the MST process type status to update the bin locations. After WL Entry Batch Adjust Inventory Report is run, the bin update is attempted again.

In WL Transaction Inquiry, the detail views, such as Order Data, show information enabling you research out-of-balance conditions, process returns, and resubmit error communications. The detail includes this information:
  • Function
  • Adjustment quantity
  • Adjustment reason
  • Reason unavailable
  • Previous reason unavailable
  • Product Unavailable Inventory Entry quantity
  • Product Warehouse Product Setup or nonstock quantity
  • Product Warehouse Product Setup unavailable quantity