Pull data from multiple peachtree companies?

Replies to This Discussion

Permalink Reply by Ruth Gray on September 5, 2011 at 5:39pm

Yes, Peachtree Business Intelligence can do this. If you have the Connector module you can create connections to multiple databases/ multiple Peachtree Companies. If you are including all the information you would like in your report in Peachtree database, then Peachtree Business Intelligence can pull this information from the database. You would need to set these connections and containers up yourself as their are currently no standard PBI reports for Payroll.

You could create PICKLIST, if you have like data you can create Picklists to connect to the multiple companies. You will then need to create the containers to set up what information you want pulled from the database, and then you can create the report. Once you have set this up, you basically just need to press the green run button every time you want to run the report.

 

Attachments:

• Sage Peachtree Business Intelligence Picklists.docx, 15 KB
• PBI PVS.SQL DB Manager.docx, 79 KB
• PBIReportingWritingBestPractices.pdf, 439 KB

• ▶ Reply

Permalink Reply by Roy Mowbray on December 6, 2011 at 6:21pm

How do I create the payroll containers for multiple companies? Thanks

• ▶ Reply

Permalink Reply by Roy Mowbray on December 6, 2011 at 6:34pm

I found it. Thanks anyway and thanks for posting the initial information.

• ▶ Reply

Permalink Reply by Roy Mowbray on December 7, 2011 at 4:34pm

What tables (and joins) did you use to create the container used for reporting on 25 different companies? Am also trying to create this same type of report which resembles the payroll journal report. (Employee, GL Acct ID, reference, Debit/Credit, etc.)

• ▶ Reply

Permalink Reply by Roy Mowbray on December 8, 2011 at 10:29pm

Were you able to successfully create the containers and report across 25 companies? Am working on the exact same issue.

Thanks-

• ▶ Reply