Hello fellow coders,
I need help creating an import code for our eCommerce Orders and Invoices into Quickbooks, most likely an .IIF File .
We are running a modified version of AspDotNetStorefront (.NET, C#) with SQL Server 2005 DB as back-end ( [url removed, login to view] ). I would need someone familiar with C# and .IIF file format to build some C# code that would work as part of our admin interface to create IIF Quickbooks import files (that's current design, if you can suggest better then go ahead). We can import data directly from the DB (ideally you can do it, I can provide sample tables, if you aren't good in this I can write you a stored procedure to get all required data).
An asp.NET page will show dates (start and end) for the Orders and Invoices to be imported. On click of a button, Orders or Invoices for these dates are pulled from DB into an .IIF file of a specific format and name (name should have date appended, such as [url removed, login to view] and [url removed, login to view]). After that, a log record is created in a separate DB table to log today's date, start-end dates, start-end Order or Invoice numbers.
1. .NET page that can be used to select dates and click button to generate .IIF file for specific dates for Orders or Invoices.
2. If you can do it, database procedure to extract Invoices or Orders (please specify in quote).
3. If you can, SQL code to create log table, and code to log both order and invoice imports into it.
Quickbooks IIF file formats:
[url removed, login to view]
We would be generating credit card orders Imported as Sales Receipts (also called Cash Sales), while Invoice (and other non-credit card) orders import as Invoices.
1. If you think it would cost more to build, let me know why. I understand costs.
2. I can provide you with a data export in any format. Consider it to be a recordset/dataset from a stored procedure that has one order / invoice per record in a format that has all fields required to make .IIF file, such as: