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.