Double entries cause double values—ICRW

This Interactive Custom Report Writer (ICRW) example is of a report with a column showing double the expected value. This is a standard report that does not use custom SQL. The root cause is determined and a solution is provided.

Subscription Interactive Custom Report Writer

Platform Services

Regional availability

All regions
User type Interactive Custom Report Writer: Business, Project Manager
Permissions

Interactive Custom Report Writer: Run, List, View, Add, Edit, Delete

Platform Services: Run, List, View, Add, Edit, Delete

Problem

The Growing Great Landscaping company had an Interactive Custom Report Writer report with values in the Amount column that were double (2x) the expected value. This is a standard report does not use custom SQL.

The value of 5,951.34, in the Amount column of the following report example, is 2x what was expected (2,975.67).

Columns in a General Ledger report with a single row of values under each column heading.

Finding the root cause

The first step is to determine if there's a column that's not currently selected in the report could be causing the doubled value. Start by adding attribute columns until you find one that forces a second line to appear.

The following example shows that there were two Amount entries, one in the Cash book, one in the Accrual book. ICRW accurately reflected the data in Intacct.

ICRW General Ledger report column headings with the Acrual and Cash entries in the Reporting method column highlighted.

Solution

There are two Amount entries in the report, one in the Cash book and one in the Accrual book. The company can apply either of the following solutions:

  • Remove the incorrect GL entry from the report.
  • Filter the report for the appropriate value of "General ledger detail Attributes"."BOOKID".