Suoritettu

Import eCommerce Orders and Invoices into Quickbooks, .IIF File

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).

Process.

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.

Output.

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.

Additions:
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:
OrderNumber,OrderDate,CustomerName,SubTotal,Tax,Total, etc.

Taidot: ASP.NET, C# -ohjelmointi, Intuit QuickBooks, Microsoft SQL Server, tietojärjestelmäarkkitehtuuri

Näytä lisää: www intuit com, quickbooks admin, invoices design, intuit com, design imports, import invoice iif file quickbooks, import iif file quickbooks automatically, import sample iif file quickbooks, create iif file quickbooks free, export invoices iif file quickbooks, iif file quickbooks, import iif file quickbooks, create iif file quickbooks invoices, example iif file quickbooks import, create iif file quickbooks

Tietoa työnantajasta:
( 32 arvostelua ) United States

Projektin tunnus: #7710519

Myönnetty käyttäjälle:

subhanisaleem

Dear sir, i complted few quickbooks projects [login to view URL] this one i completd using quickbooks best regards, saleem

$277 USD 3 päivässä
(1 arvostelu)
5.0

9 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

ByteAnt

Hello, we have a lot of experience in ASP.NET C# websites development and also have a lot of experience with AspDotNetStorefront ecommerce platform! We did something similar already a few years ago - AspDotNetStorefron Lisää

$666 USD 3 päivässä
(11 arvostelua)
6.1
logicpowered

We are very interested in this project. I have read your above description and i think its well within our range to execute this is in a good time frame, We would build it from scratch on C# .NET , so would you be kind Lisää

$421 USD 20 päivässä
(14 arvostelua)
5.8
momentumsoftware

We can do this for you.... We have recently created Online store for 3 companies -: [login to view URL] [login to view URL] [login to view URL] With a team of over 75 experienced and p Lisää

$250 USD 2 päivässä
(4 arvostelua)
3.5
bhuasri876

Hi hanks for writing the requirement very precisely. I am Readily available to work on your project and assist you in it . Well, following is what I inferred for your Import Tool : You want an scripts which i Lisää

$494 USD 12 päivässä
(1 arvostelu)
3.6
dgagan

Hi, I am a .NET Developer having 7+ years experience in Development Maintenance and Enhancement of .NET Desktop and Web Applications with C#, VB.NET and ASP.NET-MVC According to your job description: - I am co Lisää

$500 USD 8 päivässä
(3 arvostelua)
2.7
RightClickInfo

Hi, We are 40+ people team and skilled in Asp.Net, and C#. We have separate team for --Development (Asp.net,C#, VB, SQL, MYSQL,Jquery,PHP) --Design (Photoshop) --Testing We are Expert in following --C#, Lisää

$155 USD 17 päivässä
(1 arvostelu)
0.5
luizcarlossilva

Ainda não foi fornecida uma proposta

$155 USD 4 päivässä
(0 arvostelua)
0.0
vesquenazi

I think the best way to approach this is not using C# and .IIF because an easier, more reliable method is available. Why not C#, because it is complicated and tedious to build solutions. Why not .IIF, because it has b Lisää

$1500 USD 14 päivässä
(0 arvostelua)
0.0