Item list in an inventory system.

Any inventory system has two parts. The first one is a program and the second one is a database. The database is a set of tables. Some tables we'll name lists. These tables will keep information about your products,customers, vendors and other constant parameters. The other tables we will name Actions. These tables must include information on the inflow and outflow of inventory items as well as the quantities and prices of items.

Items or products are base of any inventory system. You'll keep information about your items in the item table. This table usually has fields Item Name,Description,Vendor Price, Sales Price,Department, Bar Code. You'll fill out these fields one time when you receive an item in your warehouse. If you receive this item second time you use your first record. You can only change vendor and sales prices. You'll be able to search any item in the item list.

And you'll be able to edit any record in the item list.

The item table doesn't have information about current on hand amount of items. The inventory system calculates this amount as difference between received and shipped quantity each time when your open the item list form.