Small Business Inventory Management System for Microsoft Access Templates,
Features:
1. Products
- Product ID;
Product Name;
Product Unit Cost;
Adjusted Qty (Automatically Calculated).
2. a. Suppliers
- Supplier ID,
First Name,
Last Name,
E-mail Address,
Address,
Phone Number;
b. Deliveries details by the Supplier:
- Product,
Qty Bought,
Expected Date,
Actual Delivery Date,
Order Status.
3. a. Customers
- Customer ID,
First Name,
Last Name,
E-mail Address,
Phone Number,
Address;
b. Sale to the Customer:
Product,
Transaction Data,
Qty Sold,
Unit Cost,
Total Cost,
Available Qty (Automatically Calculated/Adjusted).
3. Reports: Generate Printable Report for:
Sales Report: Customer Transaction; Orders Report: Supplier Transaction; Product Inventory Report: Inventory Quantity Status.