Page 1 of 1

Accounting Software

Posted: Thu Jan 07, 2010 5:01 am
by Colin Haig
Hi All

Has anyone interfaced their software with Sage Pastel or any of the other
smaller accounting packages ie MYOB , Quickbooks.

Regards

Colin

Re: Accounting Software

Posted: Thu Jan 07, 2010 2:22 pm
by Randal
Colin,

I've done some work with Quickbooks. What do you want to know?

Randal

Re: Accounting Software

Posted: Thu Jan 07, 2010 10:34 pm
by hag
I import data from accounting software using CSV files.

Colin I'd like to see what your doing with quickBooks. Do you have a direct link to QB or use an intermiedate step such as a csv file?

Re: Accounting Software

Posted: Thu Jan 07, 2010 10:46 pm
by Colin Haig
Hi Randal and Harvey

Harvey - Randal has the done the interface to Quickbooks.

I am trying to interface my job costing software to an accounting package - my
client likes Sage Pastel - there is a SDK which uses activex but I cant find any
code samples and if I want to evaluate the product I would have to purchase the
full accounting product , SDK and the SQL database it uses and this is over $2000 AUD.

So this is why I am asking about other products and how the interface is achieved.

Cheers

Colin

Re: Accounting Software

Posted: Thu Jan 07, 2010 10:50 pm
by hag
Sorry Got you mixed up. Can you client upload data from a csv. I send my data to excel have it save in a CSV file which is then imported into their bookkeeping program. This any help?

Re: Accounting Software

Posted: Fri Jan 08, 2010 2:51 am
by Colin Haig
Harvey

I am hoping to transfer data in realtime rather than in batches.

Cheers

Colin

Re: Accounting Software

Posted: Fri Jan 08, 2010 3:11 pm
by TimStone
You can also use an SDK ( free ) for Quickbooks, but you would have to buy that product.

There are samples available for working with QB.

Re: Accounting Software

Posted: Fri Jan 08, 2010 5:48 pm
by James Bott
Harvey,

I send my data to excel have it save in a CSV file which is then imported into their bookkeeping program.


You do know that you can save data directly to a CSV file directly from within FW? You don't have to go through Excel.

James

Re: Accounting Software

Posted: Sat Jan 09, 2010 12:47 am
by hag
Thanks james I do create a CSV directly from the porgram. Its on the import side when the file to import must be a csv file.