- DESIGN CONCEPTS
- The Inventory module is an essential component of the Material Control system that also includes the Purchasing, Receiving, and Accounts Payable modules. Inventory's design incorporates data from Material Receiving reports; maintains details on the quantity, value and physical location of every inventory item; and controls the issuance of inventory to the Equipment, Work Order, Payroll, Cost Accounting or Accounts Receivable modules. The Order Entry functions of the Inventory module record customer orders, generate picking and packing lists, and subsequently creates accounts receivable invoices.
FEATURES-
- • Daily transaction reports provide a continuous record of inventory activity and an audit trail.
- • Simultaneous processing available for most functions.
- • Security locks protect database from concurrent, but conflicting processes.
- • Multiple warehouses with on-line status of the inventory of any item in all warehouses.
- • Both on-line updating and batch processing.
- • Multiple recording methods for receiving materials into inventory: Direct Shipment, Material in Transit, Transfer, and Refurbished Parts.
- • Inventory valuation, using the average cost, standard cost, FIFO or LIFO methods.
- • Actual cost, standard cost, and sales prices can be maintained for each inventory item.
- • Surcharges are selectively and automatically added for freight, warehouse overhead, etc., on the receipt, transfer between warehouses, and issuance of materials.
- • Easy access to the inventory system by inventory code, supplier part number, user part number or customer part number.
Inventory Activity Selection Screen
Transaction Inquiry by period
Inventory Reserved/Locked Detail
Inventory On Order Detail
- • Keyword capability facilitates data entry, processing and reporting functions.
♦ Product Review Entry (Approvals)
♦ Site Specific Data
♦ Product Identification Data
♦ Hazardous Components
♦ Physical Properties
♦ Fire and Explosion Hazards
♦ Health Hazards
♦ Reactivity Data
♦ Spill and Disposal Procedures
♦ Protective Equipment Requirements
♦ Storage and Handling Procedures
♦ Transportation Procedures
- • Simple transfer of inventoried items between warehouses utilizing picking and packing lists.
- • Alternate methods for adjustment of physical inventory shelf count and differences (shorts).
- • Details of material-in-transit from the supplier to the warehouse.
- • Tool issues and returns facility to record inventoried warehouse items issued to and returned by employees.
- • Inventory reservations for placing inventoried items in a reserved or locked status.
- • Inventory items can be issued to a specified cost account in the Cost Accounting module, work order in the Work Order module, unit of equipment in the Equipment module, or employee in the Payroll module.
- • Reorder and purchase requisitions are generated based on user-defined algorithm of inventory consumption to maintain stock at optimum levels.
- • Purchase orders can be generated for non-stock items originating from a customer order in the order entry functions.
- • Order Entry function permits the recording of customer orders, selective generation of picking lists, printing of packing lists, and generation of accounts receivable invoices.
- • Customer Quotation Facility allows you to input, track and print quotes made to customers of inventory in stock.
- MODULE INTERFACE
- REPORTS
-
Control File Section Listings
Physical Inventory Worksheet
Material Master
Physical Inventory Differences
Warehouse Master
Negative Quantity Listing
Warehouse Master Catalog
On Order Status
Warehouse Bin Labels
Receiver Analysis
Warehouse Search Listing
Inventory Investment reports
Inventory Code - Supplier Part Number
Tool Issues Status
Supplier Part Number - Inventory Code
Delivery Request
Inventory Code - Customer Part Number
Warehouse Reorder
Customer Part Number - Inventory Code
Inventory Stockout
Alternate Inventory Codes
Sales Price Catalog
Inventory Code Components
Confirming Order
Inventory Transaction Listing
Customer Open Orders
Inventory Subledger
Customer Backorders
Keyword Table
Customer Completed Orders
Pending Transfers
Customer Sales Analysis
Transfers
Print Customer Quotations
Picking List
Salesman Commissions
Packing List
-
The following System 20/20 modules send (
) transactions to and receive (
) transactions from the Inventory module.
|
|
|
TRANSACTIONS | ||
| Accounts Payable |
|
Purchase invoices |
|||
Purchasing |
|
"On order" transactions |
|||
Receiving |
|
Material receipts |
|||
Work Order |
|
Inventory locks and reservations |
|||
Accounts Receivable |
|
Customer order sales invoices, credit memos for returned goods |
|||
Cost Accounting |
|
Inventory issues |
|||
Equipment |
|
Inventory issues |
|||
General Ledger |
|
Material receipts, issues, transfers, surcharges, physical inventory adjustments |
|||
Payroll |
|
Inventory issues (deductions for employee purchases) |
|||
|
Purchasing |
|
Reorder requisitions |
||
|
Work Order |
|
Inventory issues |