Question Purchase Order Database

[Red_Stafford]

Hi all, I work at an engineering/fabrication company and was hoping for some advice regarding PO database.

At the moment when we order a product we write it up in a folder:
Order no.
Date.
Supplier.
Product.
Price.

Then once the invoice comes in from the supplier the invoice is cross referenced with the delivery note to make sure it all arrived then cross referenced with the PO folder to check prices.

Most items ordered dont have stock codes, i.e. welding wire, grinding disks etc, so they dont need to be taken out of stock once used.

Is there an easy way to setup a PO database to replace this, or is there one available somewhere to download ?

 

[Minty]

Do you need to take account of partial deliveries of products?
e.g. Your order 100 widgets, but the supplier only supplies 75 and the rest follow later ?

 

[Dreamweaver]

There might be a Microsoft example database that might give you a start I'm at work so can't check

 

[Red_Stafford]

Do you need to take account of partial deliveries of products?
e.g. Your order 100 widgets, but the supplier only supplies 75 and the rest follow later ?

That would be handy

 

[jdraw]

See these free data models at Barry Williams' site for insight on design.
http://databaseanswers.org/data_models/customers_and_orders/index.htm
http://databaseanswers.org/data_models/customers_and_partial_deliveries/index.htm

 

[isladogs]

There might be a Microsoft example database that might give you a start I'm at work so can't check

The MS Northwind example database covers all of this and more