This is my first post on this site so i will start be introducing myself. My family has been in HVAC for years. My 95 year old great grandfather started and HVAC company years ago, one of his sons, my great uncle, took the company over and hired my dad on to help install when he was 16. My dad now owns his own HVAC business and I have worked for him doing install and whatever else he needs.
Right now we are trying to streamline our inventory. We would like to use a barcode system to check shipments in, then check them out onto the trucks/vans, then check them out of the vans to be used for install/service.
For example, a shipment of 100 PVC 3/4" 90's comes in. We scan them into our warehouse/shop. Install Truck is does not have any, so 8 PVC 3/4" 90's are scanned out of the warehouse/shop and scanned into the Install Truck. On the job that day the installer uses 3 90's, so he scans out 3 90's. When he gets in that day his barcode scanner is updated onto our computer. We see that he used 3 90's. So the Warehouse Person goes out and checks out 3 90's from the warehouse/shop and puts it into the truck. So at the beginning of the day we know that the truck has 8 90's and there is no chance of the installer having to come back to the shop in the middle of the day to get any materials.
So at all times we would know:
1. What is in the warehouse/shop
2. What is in the Trucks/Vans
3. How much material is used on each job.
We would like this to synchronies with Quickbooks. That would be great, but i've spent half the day looking for some way to make it work and have not found anything, so i'm not holding my breath.
Is there anyone else out there who has tried to implement a similar system or has found anything that might work for that?