what kind of small business

>>1070142
pesticide manufacturing

I used Quickbooks Point of Sale with a neat little barcode scanner to handle lots of inventory at a tire store.

The best tip I have on inventory is figure it by the bulk quantity. I pulled my hair out trying to micro the small shit and then realized it didn't matter.

I agree with the other dude - if you want easy go Quickbooks

We were using quickbooks before I got involved in the inventory process. It was just so poorly managed that it's more of a distraction now.
The owner won't even let me see the quickbooks program because it contains pricing information but he still wants me to figure out why quickbooks is wrong and justify why my numbers are right!

There just has to be a better way. Have you guys ever used Microsoft Access? I'd be interested to find out what it can be used for.

>>1070157
Something like this:

https://support.office.com/en-us/article/Cut-expenses-manage-inventory-and-ship-effectively-by-using-the-Goods-web-database-template-dba011e4-a432-4bbd-becd-10cf02d7d76d

I usually just write something that does it, though. I'm trying to push family's business off of Quickbooks, but after years of using it, you kind of get locked in. Currently using their SDK to connect and get most of the data out of it and put it into my own database for the time being.

>>1070137
At my company, the warehouse guys input the data into a shared google docs file, that is then uploaded by someone at the office into LinnWorks.

I've seen other guys manage inventory through quickbooks for much smaller operations.

>>1070150
Work out the EOQ for inventory and include shipping times. That's what I took away from the CA program.