About Item Stockroom 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, a job
  • finish a job
  • start a job
  • move an item to the next operation in a job
  • ship or return customer orders
  • receive or return purchase orders

Accounting Considerations

When you create a new stockroom location, the system creates records in the Inventory Control Ledger Distribution Journal in the General Ledger. For either Actual or Standard costing (specified on the Inventory Parameters form), the transaction is posted only if a quantity is entered for the location at the same 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 on 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.

Warehouses Controlled by External Applications

For a warehouse where Controlled by External Warehouse is selected on the Warehouses form:

  • Only one location with a location type of Stock is allowed for the warehouse.
  • All inventory is held under one location.
  • The location type cannot be Non-Nettable.

Auto-Delete of Item Stockroom Locations

The Permanent check box identifies a location as permanent or temporary. If the location is temporary, the item stockroom location is automatically deleted when the on hand quantity becomes zero through any of these transactions:

  • Customer Order Shipping
  • Purchase Order Receiving
  • Warehouse Transfers: Ship, Receipt, or Combined
  • Quantity Move
  • Quantity Adjustment
  • Miscellaneous Issue
  • Miscellaneous Receipt
  • Job Receipt
  • Job Material Issues
  • Job Labor Transactions
Related topics