|
|
|
| WAREHOUSE / INVENTORY MANAGEMENT SYSTEM |
· Maintains data bank on items, equivalent suppliers, alternate suppliers and addresses.
· Captures all relevant information on the item such as
Item Number
Vendor part number
Equivalent item
Description
Prices of current supplier
On hand quantity
Allocated quantity
Delivery times
Desired stock level etc.
· Multiple warehouse / cost centre
· Multiple key field to access inventory data items - e.g. System Catalogue No., Vendor Part No.,
System generated Serial No.
· Centralised update & control on Inventory files of various warehouse.
· Multiple currency input & single base currency
· Weighted Average Method for unit average price & stock valuation on each warehouse
· Multiple unit of measure
· Multiple Classification of items - e.g. Item Family, Manufacturer, ABC etc.
· Item location by bin within warehouse
· Provision for minimum, maximum, re-order level, re-order quantity, lead time etc., for each item
· On line and batch processing option of transactions to update stock movement, balance, status,
history, statistics etc.
· On line and batch processing option to update of stock item receipts, quantity on order etc.
from purchasing system. Inventory & Purchasing system are integrated
· Recommendation for re-order based on stock status
· Multi Warehouse system storing of price, quantity, cost, balance, statistics, history etc.
· Cycle count & Physical Inventory verification provision.
· Automatic document reference number generation for all the transactions by warehouse
· Provisions for corrections and adjustments
· Exception reporting feature on Integrity / variance
· System security feature on all levels
· Provision for budgetary information & comparison with actual
· Provision to track issues made to company employees
· Generates accounting entries of inventory transactions & print journal voucher.
· Upload of transactions from various warehouses located a different places during every month
to the centralised Inventory control system at the Material Dept. Provision for manual input
of inventory transactions
· Provision to generate query & reports from database files based on user diffident parameters
· Provision to input data in Arabic e.g. Account description, Manufacturer name etc. & generate
essential reports in Arabic
· On-line user help facility
· Operations / Users Manual & Systems Documentation
· On-line item status
· Capability to define service levels, reorder point, recommended purchase qty, recommended
supplier for items.
· Maintains items in multiple units of measure. By weight, volume, pieces, cases, cartons with
correlation between them.
· Inventory transaction can be in any unit of measure e.g. receive in KGs. and issue in pieces.
· Maintains relationship between Material Requisition and corresponding Purchase Order.
Automating the procedure for additional stock or stock replenishment from other warehouses.
· Item issue procedure based on First In First Out
· Automates the procedure for stock movement receipt and stock transfer from one division to
another division
· Item costs captured in the system would be direct actual costs and the stock transfers would
be on cost basis.
· Interaction with Finance Dept. for funds requirement, planning.
· Management report on inventory.
· Consolidated monthly report by division on Inventory level, receipts, issues, comparison
with last period, variances.
· Itemised purchase report by company, by PO, comparison with last period and variances.
· It is possible to determine the inventory requirements based on planned and actual business
volumes.
· The Inventory System is designed to be a powerful tool to keep track of all
items on order, the location of the items in the store, cost of the item, reorder point,
name and address of the vendor.
This allows the user to locate an item quickly, also to get a list of items on
order and items to be reordered
Queries
1. Item Inquiry by System Catalogue No., Vendor Part No., Item Serial No., manufacturer,
description, Item family no. etc. - All warehouses or individual warehouse
2. Inquiry on stock balance, transactions, status, history, movement etc. by system catalogue
no., part number, serial no., manufacturer, item family, description etc. - All warehouse
or individual warehouse
3. Issue, Receipts, Reverse Issue, Reverse Reception, Transfer Transactions Inquiry by Document
Reference No.
4. Issues inquiry by employees badge number
Reports
1. Issue, Receipts, Reverse Issue, Reverse Reception, Transfers Transaction Reports
2. Stock balance, status, history etc. Report by System Catalogue No., Part No., Serial No.,
Manufacturer, Account code, Bin Location etc. - All warehouse or individual warehouse
3. Stock Ledger & stock movement report by warehouse
4. Current & year to date transactions summary reports
5. Stock valuation summary report by warehouse & account
6. Warehouse Transactions Journal Voucher
7. Stock Movement Analysis, Inventory Analysis Report
8. Physical verification Inventory Sheet
9. Physical count variance report
10. Cycle count verification list
11. Recommended Orders List
12. Actual vs. Budget comparison report
13. Arabic Reports - Stock Balance, Stock Valuation Summary Report
|
|
|
