- Forum
- General C++ Programming
- Stock Counting
Stock Counting
At work we count the technicians stock periodically throughout the year. We use a scanner at the moment which we scan into excel. Using lookups I pull in the description from another list, and another lookup to denote weather it is vanstock or not, so that it can be left or removed. I recently added another function that checks that they don’t have too many of actual vanstock and once so many are scanned it tells them to get rid of the rest. However the spreadsheet is a bit dirty in the sense its fine for me to use but I don’t trust others to.
I can imagine the code to be quite simple… I hope (I know a little but not enough) so in short it would need to
· Accept numerical input
· Add the scanned number to a saved list, which counts the times each material has been scanned
· Check the scanned number to see if it vanstock or not and display a message either way
· Check the saved list each time a scan is performed checking the scanned quantities against a set list of materials and quantities and indicate by message whether it has been exceeded or not
· Ability to change the checked against list as vanstocks differ between techs
· I’d need to be able to extract the saved list for processing in a backend system / or concatenate the material / quantities together and extract the output to text file
Not a lot I know…
Last edited on
The question is how easy is it to achieve the above in a small program, im not a coder, I have a brief understanding.. but the outcome would help me know end.
Well your description is a bit vague, but I gather you want to do the following:
Have a system that keep track of stock levels for each type of individual item. The system has both a central store as well as stock levels in separate vans. So, in both the central store and each van we want to know what stock is held.
So you would program such a system to be able to identify any separate item using such things as:
a) item code or barcode
b) description
c) unit cost
d) weight
etc...
You would have an overall stock which would be held in the central store and across the vans. Thus at any given point in time you would know where any particular item of stock was located.
You would scan an item when it leaves the central store and is put onto an individual van. Plus when an item is returned to the central store.
When a van driver takes an item off his/her van they would again scan it and record how it was disposed i.e. either delivered to a customer, used or put back into the central store.
Effectively you have a stock control system that uses a central database (not Excel) and distributed system that is connected to the database. I would expect that each scanner located at the central store and on each van would be linked via a wireless link to this stock control system and hence to the database. So at any point in time you should know where every item of stock is located.
Have a system that keep track of stock levels for each type of individual item. The system has both a central store as well as stock levels in separate vans. So, in both the central store and each van we want to know what stock is held.
So you would program such a system to be able to identify any separate item using such things as:
a) item code or barcode
b) description
c) unit cost
d) weight
etc...
You would have an overall stock which would be held in the central store and across the vans. Thus at any given point in time you would know where any particular item of stock was located.
You would scan an item when it leaves the central store and is put onto an individual van. Plus when an item is returned to the central store.
When a van driver takes an item off his/her van they would again scan it and record how it was disposed i.e. either delivered to a customer, used or put back into the central store.
Effectively you have a stock control system that uses a central database (not Excel) and distributed system that is connected to the database. I would expect that each scanner located at the central store and on each van would be linked via a wireless link to this stock control system and hence to the database. So at any point in time you should know where every item of stock is located.
Far Far simpler than that, what I am after is simply for counting. not for controlling.
at the moment I scan everything into an excel sheet. I then pivot table it to give me a single material number with a quantity.
I then concatenate the material number with the counted quantity to produce a string. These are then copied into a text file which I load into our system
-------------
What I would like
Scan the item
Item gets added to a central list
Item gets checked against another list (only contains items we want on his van), if its not on the list message displayed saying to return it.
each time the time a new item is scanned the total scanned quantity is then also checked against another list (only contains items we want on his van) if the count goes above a set number again a message to return is displayed.
Once done I would need to be able to extract the list of counted materials
at the moment I scan everything into an excel sheet. I then pivot table it to give me a single material number with a quantity.
I then concatenate the material number with the counted quantity to produce a string. These are then copied into a text file which I load into our system
-------------
What I would like
Scan the item
Item gets added to a central list
Item gets checked against another list (only contains items we want on his van), if its not on the list message displayed saying to return it.
each time the time a new item is scanned the total scanned quantity is then also checked against another list (only contains items we want on his van) if the count goes above a set number again a message to return is displayed.
Once done I would need to be able to extract the list of counted materials
Ok, it's becoming clearer.
1) Central database of all items and number of each item etc...
2) Static list of items required on a van and number of each item.
3) Items on the van, from which you know what additional items should go on the van and which items should be removed.
You would have a system consisting of items and each item would be located either on a van or in a central store. When you move an item and record its movement via a scanner connected to the system its current location would be updated. I wouldn't have separate isolated lists but a complete connected system from which you would know at all times where all the stock items were located. You would have a single database and a controlling program into which you could connect from PC's, and mobile units. So the program would be on a server connected to a backend database.
1) Central database of all items and number of each item etc...
2) Static list of items required on a van and number of each item.
3) Items on the van, from which you know what additional items should go on the van and which items should be removed.
You would have a system consisting of items and each item would be located either on a van or in a central store. When you move an item and record its movement via a scanner connected to the system its current location would be updated. I wouldn't have separate isolated lists but a complete connected system from which you would know at all times where all the stock items were located. You would have a single database and a controlling program into which you could connect from PC's, and mobile units. So the program would be on a server connected to a backend database.
Last edited on
Topic archived. No new replies allowed.