Support
Cannot open database "...." requested by the login. The login failed.
Issue: When trying to open Forecast 5, you are receiving the error below: SqlException Cannot open database "Forecast5V3_2018" requested by the login. The login failed. Login failed for user 'Navsoft\JohnDoe'. at ...
Update: Could not connect to Forecast 5 Auto-Update Server.
Issue: Could not connect to Forecast 5 Auto-Update Server. Next try in 1 day. You may receive this error when launching Forecast 5. As the error suggests, Forecast 5 is being blocked from connecting to the F5 update server. To resolve this add the ...
Why are my records are greyed out.
Issue: When opening my forecast, my records are all greyed out. Solution: Check that What If mode is not on. You will be unable to edit the records if What If mode is on. Exit What If by unticking Show What If
Settings: Parameters are not updating my records
Issue: I have changed my parameter defaults under settings and they are not updating the records. Solution: Changing the parameter default for the forecast will not update existing records. It will set these as defaults for newly created records.
P&L Reports - Unable to view reports
Issue: When trying to run the P&L report, the report will not display. All other reports are working fine. Solution: This is caused by the use of SQL Server 2008, which is not supported by Forecast 5. Please upgrade to a supported version of SQL, ...
Unable To Activate License Manually or Online - Access Denied
Issue: When trying to activate online or manually, you are receiving a access denied message to the following path: C:\ProgramData\Forecast5 Solution: Ensure that you have administrative permissions on your PC. If the license still fails, go to the ...
Hotlink Error: "Exception of Type 'Forecast5.Model.HotlinkException' was thrown."
Issue: When trying to setup a second Hotlink record, you receive this error: Exception of type 'Forecast5.Model.HotlinkException' was thrown.: 'location and name of the hotlink file.xlsx 2". Hot Link error found in 'Record Name'. Do you want to ...
One Touch Reporting - An error occured while using the template
Issue: When trying to create a OTR report from Forecast 5, you are receiving the error below: Cause: This can be due to a number of reasons: 1. The excel template you are trying to use is already open. 2. The forecast name contains characters that ...
Database creation: NullReferenceException
Issue: When trying to create a new database, you are receiving the following error but the database is still created in SQL: NullReferenceException Object reference not set to an instance of an object. Cause: This is caused by attempting to connect ...
Hotlink: P&L Report Still Reflecting Old Figures
Issue: When using Hot Links in a forecast, you have updated the figures in the spreadsheet, refreshed the link and the record is correct but when you run the P &L report the old figures are still appearing. Solution: Remove the Hot Link for each ...
Consolidations: ArgumentException: An item with the same key has already been added.
Issue/Error Message: When consolidating, you get the following error: ArgumentException An item with the same key has already been added. at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource) at ...
Import Error: SQL Exception: Incorrect Syntax near "s"
Issue: Receiving this error message when trying to import records, sections or folders. SQL Exception Incorrect Syntax near "s" Unclosed quotation mark after the character string 'WHERE' This error is caused because there is a single quote character ...
Consolidations: Key Not Found Exception - Given key not present in the dictionary
Issue: KeyNotFoundException The given key was not present in the dictionary This error message can occur when record names in the base forecast of a consolidation have been changed. Solution: The consolidation looks for the record name that is ...
Install: Could not load file or assembly 'Infragistics4.Win.UltraWinEditors.v14.1'
Issue / Problem: Get the following error when starting Forecast 5 Verison 3: This may be caused due to installing the incorrect version of Forecast 5 for your operating system. In this case 64-bit files were involved on a 32-bit only Windows ...
SQLException: A network-related or instance-specific error... [Error: 52]
Issue: Forecast 5 cannot continue because of an exception occured: SqlException Solution: This error is generally caused because the Forecast 5 cannot find the SQL Server you are trying to connect to. Please check that your computer can see the SQL ...
SQLException: Failed to update database... because the database is read-only
Issue/Error: When opening Forecast 5, you are receiving an error: Forecast5 cannot continue because of an exception occured: SqlException. Failed to update database "[database name]" because the database is read-only. Forecast 5 will fail to open. ...
TypeInitializationException: A network-related or instance-specific error... [Error: 26]
Issue: You receive the following error when trying to login to Forecast 5. Forecast 5 cannot continue because of an exception occurred. SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified. Cause: This error indicates that ...
Additional Years Not Appearing On Reports When Consolidating
Issue: You have created a multi-year consolidation and the additional years are not showing in the forecast or reports. Solution: Once you have created the consolidation, open a base forecast. Alter a figure to allow calculation. Head back to the ...
GST Cash Payments Opening Balance
Issue: When using the GST Scheme of Cash Payments, there is no way to accomodate for opening entry. Solution: Set to Manually Entered to enter the opening payment. The rest of the process will stay the same.
Hot Link - NullReferenceException in View.HotLinkDetailsExcelView.ComboBox_SelectionChanged
Issue: Receive this error when clicking the Hotlink Button: NullReferenceException in View.HotLinkDetailsExcelView.ComboBox_SelectionChanged Cause: - The user creates a record and changes the method/derivation to HotLink - The user then makes a ...
Exporting Slowness
If you are finding the exporting of forecasts or copy forecasts rather slow, we suggest upgrading your SQL Server from the standard LocalDB to SQL Express. You can download a version from here. Observed improvements on speed: Local DB SQL EXPRESS ...
Reports Screen Appearing Blank
Issue: When running the reports, the screen appears blank: Solution: This is resolved by setting the Negative Number Format to -1.1. You can find this by going to: Date and Time > Change Date and Time.. > Change calendar settings > Numbers > ...
Bank Transfer Causing Unbalanced Balance Sheet
Issue: The bank transfer does not appear to be transfering from the main bank account to the second bank account. Solution: Delete the transfer from the second back. Re-enter.
SqlException: Incorrect syntax near...
Issue / Error Message: When trying to import the record list from excel or hotlink to a spreadsheet, the error message below or similar occurs: SqlException Incorrect syntax near 's' Unclosed quotation mark after the character string ...
GST/VAT Rate Error: TargetInvocationException
Issue / Error Message: When opening a forecast, the following error occurs: TargetInvocationException Exception has been thrown by the target of an invocation. NullReferenceException Object reference not set to an instance of an object. at ...
AUD forecast defaulting with NZD details
Issue/Error: When creating a forecast, and selecting AUD, the forecast still populates with NZD defaults. Solution: Below is an SQL database that will generate AUD template. To restore this, follow the steps below for your license: A – Single ...
License Invalid
Issue: This error message occurs because the license has been entered wrong, you do not have correct permissions or a firewall is blocking the access to the license server. Solution: To resolve this error message you will need to locate your Forecast ...
PAYE showing 0 in Wages record
Issue: When entering your staff using Employee Groups, your PAYE is showing as 0. Solution: Go to Settings > Payroll Tables & Options > Bonus. You will need to make sure this is set to 100. If it is set to 0, this multiplies the figure by 0. If this ...
Activation buttons not showing
Issue: I cannot see the Activate Online Now buttons. Solution: Close Forecast 5. Ensure the screen resolution is set to 1920 x 1080. Re-open Forecast 5. The buttons should now appear. If this did not work or the resolution was already 1920 x 1080, ...
Some records showing no data after consolidating
Issue: When consolidating forecasts, all records import but only the figures from one base forecast is appearing. Cause: The main bank account names are different, causing confusion on consolidating the forecasts. Solution: Update all base ...