The Percentage of Total Budget Remaining on a Statement of Revenue and Expenditures is incorrect without the Current Year column added to the Content Tab (Report Body Section).
Running a Trial Balance Report with Report Groups and using the Drill Down function produces the following error.
The multi-part Identifier “tblDLtrans.sCodeIDF_1” could not be bound.
Invalid object name ‘##DDFSL1’.
Cannot drop the table ‘##DDFSL1’, because it does not exist or you do not have permission.
SELECT * FROM ##DDFSL1 ORDER BY nPosition
Once OK is select a longer error displays beginning with:
At System.DataSQLClient.SQLConnection.OnError(sql
When exporting to Excel the Error ‘Excel Automation Error – General Exception Caught. The system has detected an Excel Automation error and is unable to continue. Exit and re-enter the application before attempting to export the report again. Call MIP Customer Support for assistance if the problem persists.
You will be given the option to save what was exported, but the data will be missing formatting information.
An error ‘Cannot insert the value NULL into column ‘PlayerID’, table Tempdb.dbo #Tmp2’ occurs in the Cash Journal report if any vendors have adjustments made for the year being reported but Issue 1099 for this Vendor is de-selected.
Report dates determine what amounts are calculated for reporting columns. Setting up the correct reporting dates is imperative for users to have the correct information in reports.
If the Code Type filter is removed from the from Pay Codes History Report filter screen, then the resulting report will show data outside of the Transaction Date limit set on the Setup tab.
Creating and then displaying the Chart from the Combining Statement of Revenues and Expenditures report, the Chart/Graph display does not close when the Exit icon is selected. You must hit the X to close out of the graph.
When using the Drill Down feature in Reports, an invalid object error is returned with references to Temp table and SQL script commands. When OK is selected, SqlClient connections and exceptions errors also appear.