"A balance on the Transaction Detail Report may be incorrect. The Column Layout used with a transaction detail report must contain a CURrent column and a YTD column."

Entry Type: Informational

Product: FRx

Application: FRx Desktop

Version Reported: All

Subject:

"A balance on the Transaction Detail Report may be incorrect. The Column Layout used with a transaction detail report must contain a CURrent column and a YTD column."

Possible Resolution:

Resolution 1: The report includes transaction detail and has more than one YTD column in the column layout. Transaction reports that use multiple YTD columns are not supported.

Although the out of balance message may not appear on all transaction reports including multiple YTD columns, this configuration is not guaranteed to produce reliable transaction detail reports, and should not be used. As a workaround, perform one of the following:

1. Change the detail level of the report to 'Financial Report', 'Account Only', or 'Financial & Account'.
2. Change the additional YTD columns to CUR with the period code of '1 TO 12'.

Resolution 2: The report includes transaction detail and spans multiple fiscal years. Transaction reports spanning multiple fiscal years are not supported.

Although the out of balance message may not appear on all transaction reports spanning multiple fiscal years, this configuration is not guaranteed to produce reliable transaction detail reports, and should not be used. As a workaround, perform one of the following:

1. Change the detail level of the report to 'Financial Report', 'Account Only', or 'Financial & Account'.
2. Change the report so that it does not span multiple fiscal years.

Resolution 3: The report includes transaction detail and more than one book code in the column layout.  FRx does not support displaying transactions from multiple book codes at the transaction level.

Although the out of balance message may not appear on all transaction reports with multiple book codes, this configuration is not guaranteed to produce reliable transaction detail reports, and should not be used. As a workaround, perform one of the following:

1. Change the detail level of the report to 'Financial Report', 'Account Only', or 'Financial & Account'.
2. Remove columns with additional book codes from the column layout.