Build a Quick Books / MySQL database connection that synchronizes QB & a web Server database.

Anulowany Opublikowano Aug 19, 2014 Płatność przy odbiorze
Anulowany Płatność przy odbiorze

We have a client with QuickBooks (latest version) running on Windows Server 2012 OS. We also have an on-line application that allows customers to schedule appointments, pay invoices & update customer data (like phone number, etc.). The client in-house staff also uses the online system to create new customers and make appointments.

Once a day, a Windows scheduled process runs of the client server. This process accepts changes made to customer data on the web server, updates Quick Books & then totally replaces the on-line equivalents of the Customer, Invoice Header & Invoice Detail tables on the web server. The process uses An Access database that interconnects with the Quick Books database via “External” (to Access) tables. The process uses an Access Macro & a number of Access Queries. It uses command line ftp to upload files and initiates several web server php programs that offload or upload QB data from/to the on-line MySQL database.

We want to replace this process with a process that synchronizes the two databases “on the fly” and does not require an Access intermediary. We would like to use php because that is the language used on the web server now. We found this reference on-line: [login to view URL]

We require that the Customer table on the web server be kept synchronized with the QB Customer Table (note; web table has fewer fields, they are NOT an exact match). Also, invoice records (Header & Detail) need to be synchronized if a payment is made (either on web or manually entered into Quick Books) or if a new invoice is entered into QB.

Note, the appointments part of this is web only, no QB interface.

MySQL PHP Architektura oprogramowania

Numer ID Projektu: #6345609

O projekcie

18 ofert Zdalny projekt Aktywny Aug 26, 2014

18 freelancerów złożyło ofertę za $984 w tym projekcie

meet2amitvw

Let's discuss over freelancer Personal Message Box for the proper estimation of cost and time. I am myself doing programming so you will directly work with one person and that's me. No mediators. No managers. No sub Więcej

$773 USD w ciągu 10 dni
(173 Oceny)
9.3
rajeshsonisl

Hello, With 99% completion rate, 700 successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page !!)... you can never go wron Więcej

$2631 USD w ciągu 14 dni
(970 Oceny)
8.7
pan09

Worked with QB sync before . You can check my feedback regarding to this . Ready to start right away .

$631 USD w ciągu 15 dni
(313 Oceny)
8.7
Aloknano

A proposal has not yet been provided

$1000 USD w ciągu 14 dni
(274 Oceny)
7.6
prashushinde9

Hi, I (Myself a senior PHP, ASP.NET programmer using C# and VB) have a team having experience of more than 10 years in developing web and mobile applications. I have a team of expert programmers who write robust and bu Więcej

$721 USD w ciągu 20 dni
(55 Oceny)
7.1
acronymsolutions

Hi, I have gone through your requirements .I am a Database developer at CMMI-5 Level company since August 2010.I am working on MySql,MSSQL Server,Oracle database, I can do your job confidently. I am very much Intereste Więcej

$736 USD w ciągu 15 dni
(36 Oceny)
5.9
seomaster212

!!! We will provide service until you satisfied our quality work !!! <<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Regards seomaster

$526 USD w ciągu 10 dni
(25 Oceny)
4.5
kingent

Quickbooks is a very detailed program to write in. The online version of quickbooks is a good bit easier to program with and would allow for real time updates. I can write to the software version as well if you like Więcej

$500 USD w ciągu 15 dni
(6 Oceny)
3.7