This will be used for managing paper reels ( For corrugating industry) which are in KG's and in our case for an item if we have 3 reels of 30kg,50kg,40kg then open inventory will Show like this only 30Kg+ 50Kg+ 40Kg.
This is for our corrugating box factory and here are the details
Home Screen - Should Show open Inventory in real time ( Open inventory means inventory in stock)
Eg: Item 1 40KG + 50KG+60kg etc
Add Inventory - SEE ATTACHED EXCEL FOR LAYOUT AND DESCRIPTION OF FIELDS
Use Inventory - Will be used when we use the inventory to make boxes. SEE ATTACHED EXCEL FOR FIELDS AND LAYOUT. WE CAN ONLY USE WHATS IN STOCK.
GSM / QUALITY/ SIZE - Will be auto complete feature (Like [url removed, login to view] when you type it shows similar names). Item must exist since we are using it so shouldnt be able to add new item name.
Date:- Todays date but should be able to edit
Quantity:- Should be able to select from a drop down which shows available inventory for selected item. For eg:- if there are 3 reels of different weight then it should show the weights in drop down.
Balance :- TO BE FILLED BY USER.....Numeric value in KGs. For eg If we selected a reel of 30kg and then type 10 in balance means we used 20KG's and then the new updated inventory should show "10KG(B)".
(B) denotes that this reel has previously been used
Then two button one "Save and CLose" Another one "Save and Use More"
Edit Inventory - to edit the open inventory
We should be able to view and print the following reports
1) Open Inventory - should print complete open inventory i.e. inventory in stock
2) Datewise Inventory - This should show inventory use according to date
3) Datewide Inventory (Add) - This should show report of inventory additions
4) Vendor Report - Self Explanatory
5) Itemwise Report - shows when the item was added and how was it used
If you read everything you'll realise that it is very basic and shouldnt take much time to build.
PS:- you will host this on my web as well as tell me how to set it up locally on a desktop because we need this on a machine which doesnt connect to internet. Machine runs on Windows 7 64 bit version.
PS:- THIS IS JUST PHASE 1 OF A LONG ONGOING WORK
DONT BID UNLESS U CAN DEVOTE 40HRS/WEEK FOR A PAY OF INR 25000/MONTH
DONT BID UNLESS U R HONEST
******ONLY INDIVIDUAL DEVELOPERS****** NO TEAMS/COMPANIES
PS:- SAME HAD TO BE DONE FOR DUPLEX SHEETS MEANS THE SYSTEM WILL HAVE 2 TABS ONE FOR PAPER REEL AND ANOTHER FOR DUPLEX SHEET