Adhancement to PHP-MySQL Invoice DB Project inc. Quick Books

We are in development of a database and e-commerce site, which will serve as a way for customers to search the e-commerce site and order products, via online or by specifying a part number over the phone. A majority of the project is completed by a previous freelancer, so we just need someone to tweak it a bit and add a few minor features. In addition... If you as a freelancer can complete the project with a week, we will award you a $300.00 US bonus!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ---------------------------------------------------------------------------- These are the most important areas that need to be addressed. ---------------------------------------------------------------------------- #1. Backorder Qty. to be delivered to a report and recorded on invoices. ========================================================================================================= #2 Purchase Order Report: a report generated using the backorder qty. as well low stock limits, need to be addressed to individual vendor ========================================================================================================== #3. Inventory: Needs a field that displays the quantity sold in the last 12 months. (with a clickable link to a breakdown of each individual month) ========================================================================================================== #4. Reorder Report: Needs to print daily, showing all purchase orders and product of what is needed for reordered ========================================================================================================== ---------------------------------------------------------------------------------------------- THESE ARE OTHER AREAS THAT WILL NEED TO BE VERIFIED AND TESTED OR ADDED FROM THE PREVIOUS ATTEMPT FROM ANOTHER FREELANCER. ---------------------------------------------------------------------------------------------- The system will generate an invoice, automatically (online purchase) or manually (phone order – to be tracked by who took the order). The system then would be able to generate a file in a format which could easily be imported into quick books, which is why the person has to have a strong understanding of QuickBooks. Invoicing System: The invoicing system must have a database table designed and linked to a GUI page in the administrative control panel. The system has to maintain a record of all website visitors that generate purchase orders. Two ways purchase orders (invoices) are generated are: • Phone Orders: The admin has to have the function to manually create an invoice if they receive a phone order. • Online Orders: Invoices will have to be automatically generated when a customer makes an online purchase. The invoice system has to be searchable so that the administrator could log in and be able to retrieve invoices by name, invoice number, dollar amount, etc. The invoices would be able to output reports so that they could be emailed, printed, or converted via the PDF conversion engine. It must also generate a packing list for each order which the customer for now would print it out on a dot matrix printer which uses 5”x3” perforated cards. Internet Faxing Implementation: This system will be utilizing E-Fax to send and receive fax transmissions via email. A client will need to be installed on the network that will be responsible for managing email faxes. Additionally, special attention will be needed for the specific format of the email to be sent via e-fax. The mailer code will need to be altered to make sure that both the email and email headers are compatible with the E-Fax service. It also needs to be determined if E-Fax will transmit PDF files or strictly text-based emails. QuickBooks/Accounting Engine: Tables for the accounts receivable need to be designed. This engine has to be able to generate comma separate value (CSV) files to output the accounts receivable table, so it can be easily imported into QuickBooks for accounting purposes. Finally the system needs to be able to keep track of not only the orders placed by the customers, but also the purchases made by the company. It should be integrated with the invoicing system as well as the inventory database.