Inter-entity transaction report package

We offer an inter-entity (IET) report package that contains a pre-built IET report that you can access through Customization Services or Platform Services, depending on how your company was implemented. You can use this report as a starting point when creating your own custom IET reports.

Subscription
  • Multi-Entity
  • Customization Services OR Platform Services
User type

Business user with admin privileges can install report packages.

Non-admin business users can duplicate and edit reports.
Permissions

Add, Edit, List, View, Delete custom reports

About the IET report package

You can run a customized inter-entity transaction report by installing the IET report package and then customizing and running the included sample report.

Use the Inter-entity transaction report to view inter-entity transactions and the source transactions that generated the IET entries. This report enables tracing both the IET and source transactions. The dimension values from the source journal entry are included with each transaction in the report. Source journal entries that trigger the inter-entity transactions are derived from the General Ledger journal entries and are shown in the report. This improves reconciliation, and identifies data entry errors.

You can use the report package as a starting point for reconciliation and reporting. For example, you can run a report to determine the amount of inter-entity transactions generated by each department in your company.

With the Inter-entity transaction report you can:

  • Add source journal entry dimensions, such as Department, Class, Vendor, or any user-defined dimension you want to track.
  • Add IET entry columns, such as account, amount, base currency, entry date, location, line number, transaction amount, and more.
  • Group, sort, and filter by all columns from source and IET entry.

You can filter the data to include in the report by single account, account range, account group, or multiple accounts. You can also constrain the data by location and/or department. You might also want to sort by location, and then sort by department within the location to view corresponding subtotals.

For example, the following IET report is grouped by general ledger account and location, with the department dimension clearly listed:

A sample custom IET report showing transactions grouped by GL account and location, with the department dimension listed.

This report works only for new IET entries posted as of May 15, 2020.

Install the IET report package

Business users with administrator privileges can install report packages.

  1. Do one of the following:
    • If you are subscribed to Customization Services, go to Customization Services > All > Customization tools > Customization packages.
    • If you are subscribed to Platform Services, go to Platform Services > All > Customization tools > Custom packages.
  2. Select Package Library in the top-left section of the page.
  3. In the Packages list, find Inter-entity transaction reports and select Install.

Create your own custom IET report

Duplicate a standard report and customize it to suit your business needs. Although you cannot edit the standard IET custom report, you can edit your duplicated versions as desired.

You can:

  1. Do one of the following:
    • If you are subscribed to Customization Services, go to Customization Services > Setup > Custom reports.
    • If you are subscribed to Platform Services, go to Platform Services > All > Custom reports.
  2. In the Custom Reports list, locate the Inter-entity transaction report and select Duplicate next to it.

    The Custom Report Writer opens.

  3. Accept the existing primary data source and select Next.
  4. Use the custom report writer wizard to customize your report and then save it with the desired name. See Use Custom Report Writer Wizard—CRWZ for detailed information on how to customize a report.

Delete the IET custom report package

You can delete the IET custom report package, and in so doing, delete the included report. You can always install a package again to access the report.

Duplicate all reports in a package first and then delete the package. Then you can edit, inactivate, or delete your duplicated reports as desired.
  1. Do one of the following:
    • If you are subscribed to Customization Services, go to Customization Services > All > Customization tools > Customization packages.
    • If you are subscribed to Platform Services, go to Platform Services> All > Platform tools > Custom packages.
  2. Select Del next to the applicable package.
  3. In the Delete Package dialog box, select Yes, I want to complete this action and then select Delete.
  4. In the Delete Customization Package page, select Delete.