About Item Stockroom Locations

The Item Stockroom Locations form keeps records of every location where an item is kept. You can maintain the lot number and quantity-on-hand for each location of each item. You can also specify nettable and non-nettable locations and to view detailed information when more than one location is used for each item, including an item's quantity, location, and the quantity available at the location.

Note: Non-nettable stock locations are not available for selection when moving inventory to a production line. Scrapped inventory is moved to non-nettable stock locations.

When you move or adjust a quantity or add a new location, a material transaction is created to provide an audit trail. You may print this audit trail with the Material Transaction Report. Material transactions are also created when you:

Issue an item to, or withdraw an item from, an SRO
Ship or return sales orders
Receive or return purchase orders
Check an item in/out on a rental contract

Accounting Considerations

When you create a new stockroom location, records are created in the Inventory Control Ledger Distribution Journal in the General Ledger. For either Actual or Standard costing (specified in the Inventory Parameters), the transaction is posted only if a quantity is entered for the location at the time it is added. The amount used is the quantity entered multiplied by the unit cost. For Actual costing, the unit cost used depends on the cost flow method specified for the item. For Standard costing, the standard unit cost is used.

The Update function creates records in the Inventory Control Ledger Distribution Journal in the General Ledger. For either Actual or Standard costing (specified in the Inventory Parameters form), the transaction is created only if the inventory account tied to the location is changed. When using the Specific cost flow method, a transaction is also created when the unit cost tied to a location is changed.

Creating Stockroom Locations

You can create stockroom locations for an item when you are entering transactions.

For example, you may be in the middle of a receiving transaction and decide you want to receive an item to a location that does not currently exist on the system. The system supports adding locations during these transactions:

CO Shipping
PO Receiving
Warehouse Transfers: Ship, Receipt, or Combined
Item Quantity Move
Miscellaneous Receipt
Job Receipt
Job Material Issues
Job Labor Transactions

Note: The same logic also applies to transactions within Data Collection. You can create locations when entering transactions from the list above.

Logic Used by the System When Creating Item Stockroom Locations Automatically

With lot tracking: If you enter a location and lot that does not exist, but for which the stock location code is valid, you are prompted to confirm the new stockroom location/item combination. The record is then created using the default values from the item's product code or the G/L account numbers. The Permanent check box is cleared. The Non-Nettable and Type fields use default values from the stock location code.

If the item stockroom location exists for the location but the location/lot does not, then the default values used to create the new location are taken from the first item stockroom location record. These include the G/L account numbers, Permanent check box, Non-Nettable check box, and Type. You are asked to confirm the new item stockroom location.

Without lot tracking: You can create item stockroom locations when entering transactions if you are not using lot tracking. You can key this new location and it is created using the default values from the product code of the item for the G/L account numbers. The Permanent check box is cleared. The Non-Nettable and Type fields use default values from the stock location code. You are asked to confirm the new item stockroom location.