Accessing Sales Orders and Purchase Orders without DDE
Accessing Sales Orders and Purchase Orders without DDE
(OP)
Does anyone know a way I can access Sales Orders and Purchase Orders withOUT using DDE? I am actually trying to pull info from S.O.'s and P.O.'s from PHP, but PHP does not have any support for DDE. Yes I am aware of PawCom, that is a last resort. I am using PSQL 8, and would like to not have to purchase anything else for this project. Any help on this is much appreciated.
Regards,
Flinn
Regards,
Flinn
RE: Accessing Sales Orders and Purchase Orders without DDE
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
www.trianglepartners.com
RE: Accessing Sales Orders and Purchase Orders without DDE
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.
RE: Accessing Sales Orders and Purchase Orders without DDE
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
www.trianglepartners.com
RE: Accessing Sales Orders and Purchase Orders without DDE