how do i create a database for purchase orders

[Joy29]

I would like to create a database that as well as logging purchase orders
would also print a purchase order form to send to suppliers - I am not sure
if this is possible or how easy/difficult it would be. Any help gratefully
received.

Thanks

Joy

 

[Arvin Meyer [MVP]]

Unless you are using Access 2007, you will need to use Stephen Leban's free
Access PDF maker.

http://www.lebans.com/reporttopdf.htm

so that all your suppliers can easily read your POs if you email them. If
you get fancy and want automatic generation of POs as soon as stock levels
get to a certain point, or if you want automatic creation and email of POs,
there's some programming involved. A simple PO that's physically mailed is
nothing more than an Access report.

 

[Joy29]

I am using Access 2007 - so is it pretty straight forward - I am really a
novice as far as Access is concerned. I would like to be able to print a
purchase order off to send to a supplier.

thanks for your help

Joy

 

[Klatuu]

Purchase Order systems usually consist of multiple tables.
Vendor table - Vendors you purchase from
Product Table - Items you purchase from the vendors
PO Header Table - Information about the PO (vendor, date, PO Number, etc)
PO Detail Table - Line items related to a specific PO.

So, to print a PO, you need to create a report. For the report's record
source (the data the report will present), you need to create a query that
joins the tables so you have all the data you need. You will probably want
to use Sorting and Grouping and Group on the PO Number. Put the PO
information in the PO group header. The line item detail should go in the
report detail section. The PO total pluse any additional items such as tax,
shipping, etc should go in the PO group footer.

When you run the report, you can use the Where argument of the OpenReport
method to tell the report which PO's to print. Using this method, you could
print one PO, all POs for a vendor, or however you want to print them.