Peachtree - create a custom report


I have Peachtree 2017.2 and there are two reports that have two different sets of data that I need.  The "Invoice Generated Report" and the "Cash Receipt Journal" report.

How can I create a custom report that will show me the information from both in one report.  I need at least the customer number/id and/or customer name, the invoice number, receipt number (from the CRJ report) and the amounts.

Thanks. :)
Adam DIT Solutions DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Raghavendra HullurSoftware DeveloperCommented:
If those 2 data sets are unrelated, then you can include 2 subreports one each for each dataset and disply the information in required format.

Provide more information if this is not what you are looking for.
Adam DIT Solutions DeveloperAuthor Commented:
Thanks Raghavendra.  Can you provide me the steps in Peachtree on how to do that?  Thanks. :)
Raghavendra HullurSoftware DeveloperCommented:
As for as I have read, the Crystal Reports from sage 50 or peachtree has been discontinued from 2015 version and you can use Crystal Reports from outside of sage and access the peachtree database using odbc(you need to create a 32 bit odbc) connection.
So, If you have SAP Crystal Reports installed on your computer, then using a ODBC connection, you can create connectivity to your peachtree and then pull required data into Crystal.

Hope that helps.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Adam DIT Solutions DeveloperAuthor Commented:
Thanks Raghavendra.  Sure, I can create a report through ODBC, but I need to create it within Peachtree, if at all possible. :)
Raghavendra HullurSoftware DeveloperCommented:
Not sure, because the support for Crystal Reports isn't there in 2015 version onwards. You can try navigating on Reports tab and if you see "Crystal Reports Designer" option (mostly last option), try the options with that.
How are the existing reports connecting?

Can you use that database connection to build the report?

Adam DIT Solutions DeveloperAuthor Commented:
Thanks mlmcc, but what I am really after is the ability to create a custom report right inside of Peachtree.

For example, in Quickbooks, I can take any report and customize it or combine other report data from it (I haven't done that in a while, but I am pretty sure that can be done).  I have not found a way to do that in Peachtree.

Any thoughts?  Thanks. :)
I don't think that is possible.  If Peachtree is using Crystal for its reports then I believe you have to use Crystal stand-alone and then import the report to Peachtree.

I know SAP/Crystal does not include an embeddable designer with the VS version of Crystal which is what is required to create/modify reports. That capability was available but dropped when they support with CR2008 and the VS versions of Crystal.

Adam DIT Solutions DeveloperAuthor Commented:
No answer really solved my problem, but these two were the closest solution to what I want to achieve.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.