Accessing Sales Orders and Purchase Orders without DDE

Does peachtree support P.SQL v8?

When you say "access" POs and SOs, are you talking about reporting on the data or updating/writing to the data?

Please advise.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

Well, when I started Peachtree with PSQL8, I got a warning message saying it is not supported but I have not had any issues with it.

I am not trying to poke anything. I just need to read a Sales Order and/or a Purchase order.

When I connect via ODBC the only tables I have read access to are:

"Chart","Company","Customers","Employee","General_AP","Gener
al_AR","General_GL","General_Inv","General_Jobs","JobEst","J
obs","JrnlHdr","JrnlRow","LineItem","Vendors","X$Field","X$F
ile","X$Index"

I may be wrong, but I do not see S.O.'s or P.O.'s in any of these tables. I see what appears to be invoices in "JrnlRow" table.

POs and SOs are in the JrnlHdr and JrnlRow tables.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

Hey you're right. I thought those tables were only for invoices. I just figured out how they are storing them. It's seems really odd for them to store all those different types of transactions in two tables rather than having a specific table to handle each different type of transaction. Thanks for the tip dgillz.