Purchase orders

[Boomer]

WE have a old system @ work that drives me nuts, I have to write a order by
hand and then enter the info manualy into a PO register in Excel and again
into its own job costing report.

What I need is a system that increments the PO number by 1 each time its
used ( i.e auto generates a PO number) It will need the following fields

Supplier, Item(s) required, Date required, Date Ordered, Job Number, Ordered
by.

I'd like the data base to be able to show all orders placed and the total
value (accural and actual) against a its job number, maybe even compair this
figure against a user defined budget.

Any help will be gratefully recieved.

Thanks for reading.

 

[mnature]

Microsoft provides this template, Orders Management Database, which might fit
what you need. There are other templates available, also.

http://office.microsoft.com/en-us/templates/TC010185481033.aspx?CategoryID=CT011366681033

 

[Boomer]

Thanks for finding that. It looks like it could be the type of thing I need.

I cannot use that one though as I only have Acces 2000.

How hard is it to create a database from scratch?

 

[nanne]

Hi

I could help you to create such a database if you want.
analyse the data on your output you require and send it by email to
(e-mail address removed)

Nne

 

[BruceM]

Are you offering this as a free service? If so, you should post your
suggestions in this forum so that all may have the chance to benefit. If
not, the newsgroup is not the place to actively solicit work. If you wish
to include your web site address with your signature, that's fine, but
soliciting paid jobs is not appropriate.

 

[mnature]

Well, there is the Customers Order Database, which should work with Access
2000. I didn't point this one out, because it doesn't have as many nice
features. Creating a database from scratch is really a pain (lots of time),
especially if you don't have much experience with Access to begin with. If
this is close to what want, the forum could probably help you with some
simple modifications. Your company should really buy you the latest Access,
though.

http://office.microsoft.com/en-us/templates/TC010185471033.aspx?CategoryID=CT011366681033