Import eCommerce Orders and Invoices into Quickbooks, .IIF File

완료 등록 시간: May 20, 2015 착불
완료 착불

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.

ASP.NET C# 프로그래밍 인튜잇 퀵북스 마이크로소프트 SQL 서버 소프트웨어 아키텍처

프로젝트 ID: #7710519

프로젝트 소개

9 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: May 22, 2015

수상자:

subhanisaleem

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

$277 USD (3일 이내)
(1 리뷰)
5.0

이 일자리에 대한 프리랜서 9 명의 평균 입찰가: $491

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 기타

$666 USD (3일 이내)
(11 리뷰)
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 기타

$421 USD (20일 이내)
(14 리뷰)
5.8
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 기타

$494 USD (12일 이내)
(1 리뷰)
3.6
luizcarlossilva

Ainda não foi fornecida uma proposta

$155 USD (4일 이내)
(0 리뷰)
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 기타

$1500 USD (14일 이내)
(0 리뷰)
0.0