Accounting Software

[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

[Randal]

Colin,

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

Randal

[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?

[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

[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?

[Colin Haig]

Harvey

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

Cheers

Colin

[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.

[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

[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.