Scripts to connect Quickbooks Desktop to Google Sheets in Real-time

Lukket Lagt ut 7 år siden Betales ved levering
Lukket Betales ved levering

Hello,

Please see the below description of what is required by means of scripts in Google Sheets to retrieve information from Quickbooks Desktop (Enterprise edition.)

1) Auto populate Work Order information in Google Sheets

When a Work order is created in Quickbooks Desktop automatically create an entry in Google Sheets including the information below:

i. Work Order Number

ii. Customer Name

iii. Due Date

iv. Item Name

v. Item Description

vi. Item Quantity

When Work Order is Closed in Quickbooks, remove from Google Sheet.

2) Auto populate Work Order information in Google Calendar

When a Work Order is created in Quickbooks Desktop automatically create an entry in Google Calendar using the associated due date and information below:

i. Work Order Number

ii. Customer Name

iii. Due Date

iv. Item Name

v. Item Description

vi. Item Quantity

3) Auto populate Item information in Google Sheets

When a new Item is created in Quickbooks Item List automatically populate Google Sheets with the information below:

i. Item Name/Number

ii. Item Description

iii. Bill of Material Item(s)

iv. Bill of Material Item Quantity

Thanks

JavaScript

Prosjekt-ID: #12009471

Om prosjektet

8 bud Eksternt prosjekt Aktiv 7 år siden

8 frilansere byr i gjennomsnitt $632 for denne jobben

prashushinde9

Hello, I understood the initial scope of this project. Although i want to discuss further this job in order to prepare the final concept for this project. After Complete discussion over the call or in chat, i wi Mer

$773 CAD på 20 dager
(5 Omtaler)
4.7
mdkass

Hello, I have good Google apps script experience and looking to work on your project. I can do a small desktop application + a Google web app The small desktop application will get the updates on the quickbook db, Mer

$593 CAD på 7 dager
(9 Omtaler)
4.3
RubyOnRail

Hi,I have gone through your project description. I could be confident if we can proceed towards more discussion. I am an individual developer and you will be working directly with me if we proceed work on this project Mer

$777 CAD på 15 dager
(2 Omtaler)
3.8
AdeelAslam4

Hi there! I have read what you exactly need, however I would like to ask you a few questions. I wouldn't call myself a master but I do work smart and do not rest until I get the job done. Please feel free to ping me an Mer

$500 CAD på 10 dager
(1 anmeldelse)
3.2
mike199

My name is Mike and I’m from UK. I work with individual clients and also provide outsourcing services for a number of UK and USA based agencies. Your project description sounds interesting to me and I do have skills & Mer

$555 CAD på 10 dager
(1 anmeldelse)
3.2
nagarajdvdg2009

Hi, I have 7 years of experience in web development. I gone through the requirment. Hope we can have more conversation Regards, Nagaraja Devadiga

$744 CAD på 10 dager
(2 Omtaler)
2.9
AleenaIlyas

Hello, I have read what you exactly need, however I would like to ask you a few questions. I do work smart and do not rest until I get the job done. Please feel free to ping me anytime so we can have a detailed discus Mer

$555 CAD på 10 dager
(0 Omtaler)
0.0