Stock Display System

This Stock Display System is created to display warehouse stock on TV or Monitor. This software is developed with specific requirements from client. Before using this system, the client was displaying stock on whiteboard with daily writing the stock board which is time consuming and also don’t maintain the history of stock.
This system helps in monitoring and controlling the material stock flow.
This software takes the todays stock in form of excel which is maintain by client or generated from another ERP software. In current case there is, SAP system which generate excel of today’s stock.

Complete Documentation with screenshots included in package.
Requirements: -
This Stock Display System required following system configuration to use it.
1. Visual Studio 2012+
2. .NET Framework 4.5
3. Language: VB.NET
4. SQL Server 2008+

Features: -
1. Project stock on default screen or secondary screen.
2. Arrange meeting and maintain task reminders for vendors with SMS notification to vendor.
3. Add Product, Categories, Raw Material, Raw Material Stock in bulk with excel as well as single item using software.
4. Color status to the stock with auto scrolling throughout the stock list.
5. Display Setting – manage display for projection.
6. Send SMS prior 24hr to the vendors for task reminder.
7. Manage users.
8. Database Backup and Restore.
9. Settings
a. Display Setting – Display name and screen settings.
b. SMS Setting – SMS API Settings.
c. Manage Users – Add, Edit, Delete Users.
d. Database – Backup and restore database.
10. Categories
a. Add Category
b. Category Record – Update, Delete, Export to excel
11. Product
a. Add Product
b. Import Product – Add products in bulk using excel.
c. Product Record – Export to excel, Edit, Delete product.
12. Raw Material
a. Add Material
b. Import Material – Add, edit material details in bulk using excel.
c. Material Record – Edit, Delete, Search, Export to Excel Material.
13. Vendor
a. Add Vendor
b. Vendor Record – Edit, View, Delete, Export to Excel
c. Vendor Details – Vendor details with reminders. Export Reminders records to excel.
14. Stock
a. Import Stock – Add todays stock / Update today’s stock
b. Edit Stock Record – Delete, Edit Stock record for day.
15. Reminders
a. Reminder List – View and export reminder list for day.
b. Reminder List with filter – View and export reminder record with filter.
16. Project Todays Stock
a. Display Todays Stock with color status with ‘last for days’ prediction.
b. Scroll stock records auto.
c. Reminders details with status.
d. Filter for sort listing the stock records.
e. Material Details
i. Material Details – Details and Add Remark.
ii. Task Reminders – Add reminder, take action on old reminder, extend task dead line.
iii. Material Stock Graph – Graph date wise, export to image.
iv. Material Stock History – Stock history date wise, export to excel.