Access Database for Purchase Orders
Budget: $25 – $50 USD
Our business issues many Purchase Orders to vendors. Currently, we build the purchase order in Microsoft Word, then we manually enter the data in Microsoft Access for tracking. I'd like to have a database where we fill out a form, then Access produces the purchase order for us (does the addition for us) and at the same time it populates the database.
I've attached an example of our existing PO form and out existing Access Database. This should give you a basic idea, but I'm sure we'll need to exchange a few more emails to define it. We would just save the database on our server (no need for web hosting or anything like that).
Other requirements:
- we need to be able to revise a purchase order after issuance. It then needs to increment to Rev A, B (subsequent)
- we need the standard language on pg 2 of the example PO added to every po when it is output to pdf
- the "notes" field, on the PO should default to the example shown, but be editable for each PO
I've attached an example of our existing PO form and out existing Access Database. This should give you a basic idea, but I'm sure we'll need to exchange a few more emails to define it. We would just save the database on our server (no need for web hosting or anything like that).
Other requirements:
- we need to be able to revise a purchase order after issuance. It then needs to increment to Rev A, B (subsequent)
- we need the standard language on pg 2 of the example PO added to every po when it is output to pdf
- the "notes" field, on the PO should default to the example shown, but be editable for each PO