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).
- 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
-We'd like the UI to look nice (use our logo and coordinating colors).
-We'd like to populate it with all the existing data in our current database too.
-There will likely be ongoing improvements to it too, which is why we went by-the-hour. I'd like to be able to re-engage the freelancer to tweak things after we use if for a while.