Crystal Reports Templates and Samples

Kick start your Crystal Reports solution with the Unity Report Template suite, purpose built to use our unique ODBC drivers for JD Edwards. Our consultants and Crystal Reports developers have built a suite of financial reports that will simply blow you away - these are ready to deploy and can be used to report from straight away. You can also gain some inspiration from them, using the Unity Crystal Reports as a template to build your own reports that will knock hours if not days from your development schedule.

These report templates combined with our database driver will equip your report developers with the tools necessary for quick and easy report deployment against your JD Edwards data.
Minimum requirements:

  • jdeDirect ODBC for World or OneWorld/EnterpriseOne
  • erpDirect for JD Edwards World..  special instructions
  • Crystal Reports XI 

List of Crystal Reports Templates

R59U001 Business Unit List A template to be used for Business Unit reports to list chart of accounts or business units and cost centre's. No account balance or transactional data is available with this template.

R59U002 Quarterly Income Statement A template which can be used to summarize financial data into quarterly buckets, displaying ledger types and amount fields. Based on a user defined point in time, data is rolled up into quarterly columns for 12 periods.

R59U003 AP Payment History A template which can be configured to print supplier history data. Generate detailed reports on your suppler payment data or generate payment summary listings.

R59U004 Company List A template to be used for Business Unit reports to list chart of accounts or business units and cost centre's. No account balance or transactional data is available with this template.

R59U005 Chart of Accounts Standard COA template to give you a chart of accounts listing or business unit listing. No financial data is included in this template.

R59U006 Object Account Report Master template to design business unit listings or COA listings without any financial or transactional data.

R59U007 Open AP Report Accounts Payables Template designed to report your open accounts payable in detail grouped by supplier. Can be used to report supplier activity.

R59U008 AR Payment Detail Accounts Receivable Template reporting payment activity by customer. The template includes financial transactions grouped by customer and batch number. Detailed transaction data is reported - check date, receipt number, document type and batch number, etc.

R59U009A Customer AR Detail Accounts Receivable Template reporting ledger and open AR details grouped by customer. Open AR items are aged by standard aging time periods of 30, 45 and 60 days. Detailed transactional level data available on the report including as invoice number, document type, document number, address number, etc.

R59U009B Customer AR Activity Accounts Receivable Template (similar to R59U009A) reporting ledger and open AR details grouped by customer. Open AR items are aged by standard aging time periods of 30, 45 and 60 days. Detailed transactional level data available on the report including as invoice number, document type, document number, address number, etc.

R59U013 Income Statement Income statement template listing key financial data along with ledger types and other detail information. Financial computations based on current vs prior year, cumulative, YTD, current period and current year.

R59U015 Income Statement - Period Based Income statement template listing key financial data along with ledger types and other detail information. Financial computations based on current year, and quarterly buckets. Based on a user defined point in time, data is rolled up into quarterly columns for 12 periods.

R59U016 Income Statement - Full Year A full year income template with financial data summarized on a period by period basis from the current period rolling forward 12 periods.

R59U017 Income Statement - Forecast An Income Statement template with a breakdown by ledger type reporting current month actual vs budget and YTD actual vs budget.

R59U018 Account Ledger Activity Account Ledger Template listing transaction detail based on financial data posted by other JDE modules. Detail includes document number, dates, amounts, account number and remarks

A sample of our Crystal Report templates are available for download, just follow the links below.  These are full working reports, pre-configured for jdeDirect ODBC drivers, yours to keep - at no cost.

Download Samples for JD Edwards World

Download Samples for JD Edwards OneWorld/EnterpriseOne

Buy the complete Package  Download Package for World | Download Package for OneWorld/E1

Purchase the complete package for $2,500.00 USD, this represents less than 200 dollars per report.

We also have a complete Crystal Reports division that can help you with all things Crystal:

  • Crystal Reports Software Licenses
  • Report Customization
  • Report Development
  • Crystal Reports Training
  • Crystal Reports Server Training
  • Software Installation and Configuration

Contact us with your requirements..

Screen shots


Crystal Reports Templates and Sample Reports
(view as slideshow)