RealWorld Expertise.LAN/Expertise.SQL
Inventory Management
Inventory Management tracks quantities on-hand and on-order to help you maintain
inventory at optimal levels. You'll be able to determine how quickly items sell and the
value of your inventory. You'll be able to maintain detailed information, including serial
number and bin tracking, on all inventory items throughout any period.
- An unlimited number of inventory items can be maintained. Each inventory item can have
up to 20 alphanumeric characters, 15 user-defined fields and 4,000-character notes.
Photographic images of items can be stored with each record for product identification.
- Stock turns can be analyzed using five user-defined aging periods. Preferred vendor
information can be maintained for each inventory item, with substitute item information
for out-of-stock materials. Non-inventory items are also handled. Valuation can be based
on Standard, Average, LIFO, FIFO and Last Cost methods.
- Inventory Management can manage the inventories of up to 50 warehouse locations per
company. An unlimited number of price tables, with up to 10 quantity breaks per table, and
optional add-on amounts per break are supported. Vendor quotes or price tables are
supported. A complete Bill of Materials offers up to 80 items per manufactured assembly or
kit.
- Inventory Management maintains complete history information on sales and purchases.
Consignment or floor planning settlement reporting options are handled. After inventory
count, automatic book to physical adjustments can be made. An automatic adjustment after
change is made to the standard code.
- Inventory Management integrates with Accounts Payable, Accounts Receivable, General
Ledger, Point of Sale, Purchase Order and Sales Order.
- Inventory item information can have a default general ledger account and a 20-character
alternate look up or sort field.
- Bar code readers are supported.
- Manufactured by-products are supported.
- Inventory items can be entered on-the-fly. Item location defines the General Ledger
account for each transaction.
- Stock can be transferred to another location.
- Freight can be added to the invoice or pro-rated into the item unit cost.
- Inventory items, vendors and customers can be quickly viewed.
- Purchase orders can be created for out-of-stock items.
- Commissions can be based on gross profit, net profit or additional promotion.
- Unit of measure can be automatically converted for purchases and sales.
- Inventory items ordered can be compared by vendor.
- User-defined transaction detail can be maintained.
|