FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Accounting Software
Posts: 310
Joined: Mon Oct 10, 2005 05:10 AM
Accounting Software
Posted: Thu Jan 07, 2010 05:01 AM

Hi All

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

Regards

Colin

Posts: 284
Joined: Mon Oct 24, 2005 08:04 PM
Re: Accounting Software
Posted: Thu Jan 07, 2010 02:22 PM

Colin,

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

Randal

Posts: 598
Joined: Tue Apr 15, 2008 04:51 PM
Re: Accounting Software
Posted: Thu Jan 07, 2010 10:34 PM

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?

Thank you

Harvey
Posts: 310
Joined: Mon Oct 10, 2005 05:10 AM
Re: Accounting Software
Posted: Thu Jan 07, 2010 10:46 PM

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

Posts: 598
Joined: Tue Apr 15, 2008 04:51 PM
Re: Accounting Software
Posted: Thu Jan 07, 2010 10:50 PM

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?

Thank you

Harvey
Posts: 310
Joined: Mon Oct 10, 2005 05:10 AM
Re: Accounting Software
Posted: Fri Jan 08, 2010 02:51 AM

Harvey

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

Cheers

Colin

Posts: 3022
Joined: Fri Oct 07, 2005 01:45 PM
Re: Accounting Software
Posted: Fri Jan 08, 2010 03:11 PM

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.

Tim Stone
http://www.MasterLinkSoftware.com
http://www.autoshopwriter.com
timstone@masterlinksoftware.com
Using: FWH 23.10 with Harbour 3.2.0 / Microsoft Visual Studio Community 2022-24 32/64 bit
Posts: 4840
Joined: Fri Nov 18, 2005 04:52 PM
Re: Accounting Software
Posted: Fri Jan 08, 2010 05:48 PM
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
FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10
Posts: 598
Joined: Tue Apr 15, 2008 04:51 PM
Re: Accounting Software
Posted: Sat Jan 09, 2010 12:47 AM

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.

Thank you

Harvey

Continue the discussion