I need help generating a pdf form that would resemble the PO [url removed, login to view] attached.
I will supply logo on .png format.
My Company Name, Street Address, City, State Zip Code, Phone, Fax and Email will be static information.
The date will need to be the current date.
The PO# will need to be unique, incremental.
The Vendor information will be fetched from an existing database.
The Shipper information will also be fetched from an existing database.
I will need a database created with the following fields:
Drop down list for Vendor. (It will need to connect to Vendor's database)
Drop down list for Shipper. (It will need to connect to Shipper's database)
Name of Requestor:
Drop down list for freigh co. ie: Fedex, UPS, etc.
Drop down list for shipping terms ie, priority, ground, 2nd day etc.
Turn Around Time
Day of week
check box for RoHS Certs Required
Comments or special instructions text box.
information entered in the above database will populate a good portion of the information in pdf form.
We will need to have the Qty multiplied by Unit price and show the total in the column at the right and
grand total at the bottom of the page.
All other information will be static.