Product Adjust Non-Stock/Direct Order Entry overview

Product > Entry > Adjust Non-Stock/Direct Order

Function acronym: ICEAN

Use this function to inquire on nonstock and direct order product inventory. You can also use it to adjust or write-off inventory levels and clear active sets of information.

A transparent header record (ICENH) that shows the product and related information is created when these events occur:

  • You specify a nonstock product on an order in Sales Order Entry.
  • You invoice a nonstock or direct order product on a sales order using the Sales Entry Invoice Processing Report.
  • You receive a nonstock or direct order product for a Return Merchandise (RM) sales order through these functions:
    • Purchase Receipt of Inventory Entry
    • Transfer Receipt of Inventory Entry

The transparent header record is created if an open set for the company/product/warehouse/product category does not already exist. Detailed information is stored on an internal line item record (ICENL) that shows the document information that is attached to the header record.

The combination of the detailed information and header record is referred to as a set. The set is active until the quantity and cost received and invoiced are in balance. When a set balances, it can be closed or deleted, based on the Purge NS/DO After Closing option in SA Administrator Options-Products-Defaults. If you attempt to clear a set that might be closed in the future because of existing order ties, a warning is displayed.

You can print the Product Trial Balance of Non Stock Inventory Report and Product Trial Balance of Direct Orders Report to track every order and receipt to ensure that the transaction process was handled correctly. The Product Entry Non Stock Count Report provides a count of nonstock products in your inventory, including this information:

  • Expected quantity
  • Ties to orders
  • Shipping status of tied orders

Use the Product Non-Stock/Direct Order Report to find nonstock products that are not tied to orders and are available to sell or return to the vendor.

You may be required to enter corrections to resolve a transaction. These are examples of transactions that may require correction:

  • Nonstock or direct order products were received at one cost but costed in Vendor Invoice Center Entry at another cost.
  • Nonstock or direct order products were received at one quantity but costed at another quantity.
  • Addons were not included in the received cost.
  • The customer accepted a smaller quantity than originally ordered, and the remaining quantity must be moved to stock inventory.
  • You stock customer-returned product instead of returning it to the vendor.
  • You must write off a small balance, which occurred because of a rounding difference, so the set can be closed.

Bin locations

Bin locations are tracked in Product Adjust Non-Stock/Direct Order Entry within the header record (ICENH) and detail records (ICENL). The header record stores the primary default bin location. The detail records store the bin location from the receiving transaction. When nonstock inventory is moved within the warehouse or adjustments are required, you can use this report to change bin locations or adjust the quantities in a bin location.

General Ledger

Product Adjust Non-Stock/Direct Order Entry interfaces with the general ledger. It makes the required postings, including moving items from nonstock inventory to stock inventory accounts.

When a posting is made to the Nonstock and Direct Order Inventory accounts, a corresponding posting is made to the inventory files if the record is still active. The inventory files are the transparent header and line item records. For example, when you receive a nonstock product in Purchase Receipt of Inventory Entry, a transparent header record is created. If the product cost is $50.00, this is the posting for Purchase Receipt of Inventory Entry:

DR CR
Nonstock Inventory $50.00  
 Uninvoiced Inventory   $50.00

When the purchase order is costed in Vendor Invoice Center Entry and the nonstock or direct order record is still active, the Post Cost of Goods Adjustments in Costing option in SA Administrator Options-Products-Costs is irrelevant. Cost adjustments are posted to the nonstock inventory account to keep General Ledger and subsidiary reports in balance.

If an active nonstock or direct order header or line item record is not available, the Post Cost of Goods Adjustments in Costing applies.

When the tied order is invoiced, the set is inactivated. If the Purge NS/DO After Closing option is selected in SA Administrator Options-Products-Defaults, the set is closed or deleted.

When a lot or serial product is converted from direct inventory to stock inventory, the On Hand balance in Product Warehouse Product Setup is updated automatically. You must manually adjust the serial or lot quantities in Product Extended Lot Number Setup or Product Extended Serial Number Setup.

Security

Users with level 3 (Inquiry and Change) security can use Product Adjust Non-Stock/Direct Order Entry to take these actions:

  • View nonstock products
  • Adjust nonstock quantities and amounts
  • Write off nonstock quantities
  • Move nonstock products to inventory
  • Update bin locations for nonstock products that are stored in inventory

Allow Bin Loc Entry in NS Adjust Users with level 2 (Inquiry Only) security are only allowed to view nonstock information unless in SA Operator Setup is set to Yes. This setting enables them to update the bin location for nonstock products, but they cannot make any other adjustments.

Tied and available quantities

These columns in Product Adjust Non-Stock/Direct Order Entry are updated for nonstock products only:

  • Tied Quantity
  • Tied Value
  • Available Quantity
  • Available Value

They do not apply to direct orders.

Options

Select a set in the grid to access these functions:

  • Adjust: Use to make adjustments to inventory levels for products.
  • Write Off: Use to clear differences for nonstocks and direct orders.
  • Inventory: Use to remove quantities from the set and place in regular inventory.
  • Mass Update: Use to move multiple nonstock products into your regular inventory. This function is not available for Direct Orders or TWL/ION warehouse products.