Accounting Software Interface


Author
Message
MCOLLINS
MCOLLINS
Supreme Being (223 reputation)Supreme Being (223 reputation)Supreme Being (223 reputation)Supreme Being (223 reputation)Supreme Being (223 reputation)Supreme Being (223 reputation)Supreme Being (223 reputation)Supreme Being (223 reputation)Supreme Being (223 reputation)
Group: Forum Members
Posts: 1, Visits: 3
Is there a way to interface to Peachtree Software? We would like to be able to synchronize the inventory in our accounting package with the product list in StarDraw. Is there a different accounting package you would reccomend ?
Rob Robinson
Rob Robinson
Forum Administrator (392K reputation)
Group: Administrators
Posts: 2.3K, Visits: 9K
Yes, Stardraw AV 2007 can exchange data with any other system that supports common formats such as .XLS, .CSV etc. and ODBC is also supported.  The best implementation will depend on what exactly you want to achieve, but a suggested workflow would be as follows:

1) Populate Stardraw AV's External Datasource, which is simply a spreadsheet (.XLS), with the product libraries you commonly use.  This is an automated process in Stardraw and takes about 1 minute.

2) In the External Datasource map Stardraw's Model Numbers to the unique product IDs used in your system.  This is a manual process but only needs to be done once.

3) Modify a report template to output the data you need, e.g. Quantity and Product ID.  This could take as little as 1 minute and, again, only needs to be done once.

4) Using the template from (3) you can now generate reports in Excel from any Stardraw document that include your Product IDs.  

5) Import the report into your system (which is where I'm assuming you want to manipulate the data)

This is one way of doing it, but of course there are many others, depending on your particular requirements.

I hope this is helpful.

Kind regards,
Rob Robinson
Stardraw.com

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic
1 active, 1 guest, 0 members, 0 anonymous
No members currently viewing this topic!

Login

Explore
Messages
Mentions
Search