INFORMATIONAL ** THIS INFORMATION HAS NOT BEEN VERIFIED **

"Report Execution Error: Exception from HRESULT: 0x80040E14 Number -2147217900" when generating a custom Financail Report in Sage MAS Intelligence

Entry Type: Informational

Product: Sage ERP MAS Intelligence

Application: n/a

Version Reported: 4.40

Subject:

"Report Execution Error: Exception from HRESULT: 0x80040E14 Number -2147217900" when generating a custom Financial Report in Sage MAS Intelligence. The custom report is created using the Financial Reports container and all columns were selected in the new report.

Possible Resolution:

The columns in the Financial Reports Container have additional settings required in order to produce a valid report.  The chart below contains the columns and settings required:

Column Action
BeginningBalance_Prior Apply MAXIMUM Aggregate
BeginningBalance_Current Apply MAXIMUM Aggregate
ActivityPeriod01 Apply MAXIMUM Aggregate
ActivityPeriod02 Apply MAXIMUM Aggregate
ActivityPeriod03 Apply MAXIMUM Aggregate
ActivityPeriod04 Apply MAXIMUM Aggregate
ActivityPeriod05 Apply MAXIMUM Aggregate
ActivityPeriod06 Apply MAXIMUM Aggregate
ActivityPeriod07 Apply MAXIMUM Aggregate
ActivityPeriod08 Apply MAXIMUM Aggregate
ActivityPeriod09 Apply MAXIMUM Aggregate
ActivityPeriod10 Apply MAXIMUM Aggregate
ActivityPeriod11 Apply MAXIMUM Aggregate
ActivityPeriod12 Apply MAXIMUM Aggregate
ActivityPeriod13 Apply MAXIMUM Aggregate
BudgetPeriod01 Apply MAXIMUM Aggregate
BudgetPeriod02 Apply MAXIMUM Aggregate
BudgetPeriod03 Apply MAXIMUM Aggregate
BudgetPeriod04 Apply MAXIMUM Aggregate
BudgetPeriod05 Apply MAXIMUM Aggregate
BudgetPeriod06 Apply MAXIMUM Aggregate
BudgetPeriod07 Apply MAXIMUM Aggregate
BudgetPeriod08 Apply MAXIMUM Aggregate
BudgetPeriod09 Apply MAXIMUM Aggregate
BudgetPeriod10 Apply MAXIMUM Aggregate
BudgetPeriod11 Apply MAXIMUM Aggregate
BudgetPeriod12 Apply MAXIMUM Aggregate
BudgetPeriod13 Apply MAXIMUM Aggregate
PYActivityPeriod01 Apply MAXIMUM Aggregate
PYActivityPeriod02 Apply MAXIMUM Aggregate
PYActivityPeriod03 Apply MAXIMUM Aggregate
PYActivityPeriod04 Apply MAXIMUM Aggregate
PYActivityPeriod05 Apply MAXIMUM Aggregate
PYActivityPeriod06 Apply MAXIMUM Aggregate
PYActivityPeriod07 Apply MAXIMUM Aggregate
PYActivityPeriod08 Apply MAXIMUM Aggregate
PYActivityPeriod09 Apply MAXIMUM Aggregate
PYActivityPeriod10 Apply MAXIMUM Aggregate
PYActivityPeriod11 Apply MAXIMUM Aggregate
PYActivityPeriod12 Apply MAXIMUM Aggregate
PYActivityPeriod13 Apply MAXIMUM Aggregate
YEBudget Apply MAXIMUM Aggregate
YE1YearAgo DON?T USE
YE2YearAgo DON?T USE
YE3YearAgo DON?T USE
YE4YearAgo DON?T USE
Account_Type DON?T USE IF Type is used
YTDPeriod01 Turn on Omit From Group By
YTDPeriod02 Turn on Omit From Group By
YTDPeriod03 Turn on Omit From Group By
YTDPeriod04 Turn on Omit From Group By
YTDPeriod05 Turn on Omit From Group By
YTDPeriod06 Turn on Omit From Group By
YTDPeriod07 Turn on Omit From Group By
YTDPeriod08 Turn on Omit From Group By
YTDPeriod09 Turn on Omit From Group By
YTDPeriod10 Turn on Omit From Group By
YTDPeriod11 Turn on Omit From Group By
YTDPeriod12 Turn on Omit From Group By
YTDPeriod13 Turn on Omit From Group By
PYTDPeriod01 Turn on Omit From Group By
PYTDPeriod02 Turn on Omit From Group By
PYTDPeriod03 Turn on Omit From Group By
PYTDPeriod04 Turn on Omit From Group By
PYTDPeriod05 Turn on Omit From Group By
PYTDPeriod06 Turn on Omit From Group By
PYTDPeriod07 Turn on Omit From Group By
PYTDPeriod08 Turn on Omit From Group By
PYTDPeriod09 Turn on Omit From Group By
PYTDPeriod10 Turn on Omit From Group By
PYTDPeriod11 Turn on Omit From Group By
PYTDPeriod12 Turn on Omit From Group By
PYTDPeriod13 Turn on Omit From Group By