RE: DB Integration for Peachtree Complete Accounting 2004

This message was sent from: Suggestions and Proposals
http://forums.oscommerce.com/viewtopic.php?p=211040#211040
----------------------------------------------------------------

CSV seems to be the way to go.  I did a search in Peachtree help and it gave a pretty detailed expanation of how to import/export.  It also lists the field definithions and how they need to be formatted.

It seems that if one were to make some good MYSQL queries, this data can be produced as needed.

I think I will take a look at this a little further.  I am no expert in either MYSQL or Peachtree, but I will give it a shot.

Here are the things I think will be needed...Please let me know if I am missing anything:
[list]Products in inventory[/list]
                 - cost should be maintained in Peachtree?
[list]Products sold[/list]
                  -  Affects inventory and sales accounts
[list]Sales taxes collected[/list]
[list]Shipping charges collected[/list]
[/list]