Sage 100

PTQ - that ought to get @JeffSchwenk attention ... Have a client running Peachtree and am looking to extract certain sales invoice data to update another software package. Was thinking that the PTQ might be an avenue worth exploring. Anyone ever do this with Peachtree?

Is this a recurring basis? As long as Peachtree has an ODBC driver, pulling the data via Access or Excel should be doable.

Not sure what your silent connection ODBC security string would look like....

The process I have in mind is two things - a subreport on a crystal form to print the invoice number on a shipping thank you letter printed from the other system. And, a nightly process to actually physically update the other system with the days invoice numbers. The crystal reports I am using w/ Peachtree use an OLE DB connection instead of ODBC - does that work?

Don't know. Maybe @DanBurleson can jump in.

Sounds like a Peachtree question, is that Pervasive? Google says: Server Name=myServerAddress;Database Name=myDataBase;User ID=myUsername; Password=myPassword;Pooling=False;