I have built an invoicing system that creates printable invoices. The system allows any number of companies to register, provide a logo, and some default fee amounts, which is all stored in the DB, along with all data related to a specific invoice.
All of the invoice and company information is stored in 4 seperate DB tables: companies, invoices, invoice_details and company_logos.
WHAT I NEED:
On the customer preferences page, we need the ability to look in the DB for a companies invoices, and export any individual invoice to a QB compatible file. We also need the ability to export a date range of invoices into one file. The user provides a start and end date, and then an export is created that contains all of the invoice data within that range. Data includes various fee descriptions, amounts.
A simple UI will need to be provided that allows a user to set column header info for QB that will be incorporated into each export. These column header names will also be stored in the DB.
In addition to this manual export, I will also need to be able to (using the Quickbooks SDK) automatically update a users quickbooks spreadsheet on their computer through the automated process provided by QB for this purpose. I can provide complete documentation on this.
I can also provide a full registered copy of Quickbooks Pro 2010, that includes support for the Quickbooks SDK.
