inventory-management

Capturing spreadsheet usage throughout a company

We have a lot of customized spreadsheet solutions that are being used and we want some programmatic way of keeping track of them. Obviously since they are spreadsheets, people can save them locally, rename them, etc so we need a solution that can account for that. Some ideas are: On spreadsheet open, handle the OnOpen event and write...

How to structure database for multilevel packing items

I want to make an inventory system where items have multilevel packings e.g A carton has medium boxes , medium boxes has small boxes and small boxes has 2 items. Please tell how to handle it by using sql server 2005 so that it can easily handle sale and purchase and it display exact inventory status of how much carton , medium, small box...

Database design question - using checkpoints in the calculation of on-hand

I have been thinking about the best way to calculate the amount of on-hand units for a given inventory item. The tables will be very large, with many transactions so it may not be realistic to calculate on-hand on demand by adding all receivings and subtracting all shipments and sales. One idea I have come across is to periodically creat...

Open Source PHP accounting/inventory module/script

Hi, i m working on a shopping cart in Zend Framework and looking to integrate some open source accounting/inventory module in it. Please suggest which will suite with Zend Framework best. ...

Need an open source php based inventory / basic accounting system

Hi guys I'm looking for an open source inventory management system for a small store. Basically they require the following features: Product inventory management pricing of products supplier details customer details basic accounting services managing purchase orders managing sales reciepts etc print reports on a periodic basis Someth...