FastClose Installation Instructions

Before You Start

There are several components to FastClose including:

• FastClose Repository Database

• FastClose Server

• FastClose Designer

• FastClose (Desktop) Reader

• FastClose Scheduler

• FastClose (Web) Reader

You can discover more about these on our website.

For a full installation of the product, read on, following these steps:

• Creation of the FastClose repository database

• Installation of the FastClose Server and unpacking of the client installers.

• FastClose Server Configuration including:

  • Single Sign On

  • Connecting to the repository

  • Licencing

  • Connecting to the ERP

  • Adding Users and Groups

• Installation of the Worker Service (Scheduler)

• Installation ofUser Clients (Designer, Excel, Reader)

• Importation of pre-built templates and solutions

• Configuration of Planning

FastClose Repository Database & Login

Database

To create the FastClose repository database, start SQL Server Management Studio and connect to the database server.

Expand the tree on the left until “Databases” is shown. Right click on “Databases” and select “New Database”. We recommend naming this database “FastClose”. FastClose Server will create the necessary tables in a later step.

Login

To create the login for FastClose, first collapse “Databases” and expand “Security”. Right click “Logins” and choose “New Login”. We recommend naming the login “FastClose”, select “SQL Server authentication” and enter a password. Untick “Enforce password policy” so that the password never expires nor requires change on first login.

Click “User Mapping” to grant the login access to the FastClose Repository.

Grant the user db_datareader to the ERP database and db_datareader, db_datawriter and ddl_admin rights to the FastClose repository.

If the ERP database is on the same database server, then also grant access to the ERP database to this login. Click the checkbox next to the ERP database then select db_datareader and click OK.

If authentication in being handled by Active Directory rather than SQL Server it will be necessary to configure the above access for whatever domain account the FastClose server will run as (described below), such as a Managed Service Account.

Install FastClose Server

Downloading the Software

You will have received a link in your email to the software download, so click on that to do the download. When the download is complete, copy it to the application server.

Once there, double click the Installer to run it. FastClose Server communicates on port 5101 by default and we suggest this is left unchanged.

Wait until the installation completes.

NB: In the event that the installer can't find the version of .net framework required on the server, a warning will be given. Click here to Download .NET 6.0. The item required is the Hosting Bundle.

Single Sign On

FastClose can be configured to authenticate users via a traditional username / password challenge known as ‘FastClose authentication’ or can use ‘Windows authentication’ which uses the Windows login name to identify a user.

Using Windows Authentication means the user's identity is taken from the current windows session and they don't have to provide username and password as they login.

Windows Authentication can be setup at a later date if desired but if single sign on is desired now, follow the guide Windows Authentication to configure it at this point.

Configuring the Repository

Now launch a web browser such as Chrome, Edge or similar. If the Server only has Internet Explorer available, it will be necessary to install a more modern browser OR configure the server remotely from a user machine.

Browse to http://[ApplicationServer]:5101 where “[ApplicationServer]” is the name of the server that FastClose is installed on. If the installation was successful,a web page like this should display:

Click the link “Click here to configure the repository” next to the text “The repository is not yet configured”. Enter the FastClose Repository database information. The fields are:

• Name

  • Defaults to “FastCloseRepository” and there's no need to change this.

• DataSource

  • The name of the database server, including any instance name. If the FastClose repository is installed in SQL Server Express, this will usually have the format of “[MachineName]\SQLExpress”.

  • NB: Avoid the use of localhost here as it makes it impossible to read the log from client machines.

• Database Name

  • Enter the name of the database created earlier. We recommended “FastClose”.

• Authentication Type

  • Whether the connection will use a Windows account or a SQL Server login.

• Username

  • The name of the SQL Server login

• Password

  • The password of the SQL Server login

• Connection Timeout

  • Leave as default for now

• SSL Encryption Settings

  • Leave unchecked for now

The credentials are validated on saving. If successful, there will be prompted to upgrade the database. This will create the tables and views necessary for FastClose. First click the link “Click here to upgrade the repository”.

Then, click the “Upgrade Repository” button.

Logging in for the first time

Click on the Sign In link in the top right corner, logging in as "Administrator", the default password will have been supplied separately. It is recommended this is changed once some other users have been set up (covered below).

Licencing FastClose

A licence key should have been provided prior to starting the install. The next step is to install this. Expand the “System” area on the left hand side, and click on “Licencing”:

Click on “Add New” and paste the licence key into the box provided. FastClose Server will authenticate with our FastClose Licencing Server and then enable the product.

Connecting FastClose to the ERP

There are three steps to this:

1. Define a new data source

2. Select the catalog for the ERP

3. Create a connection combining the two

At the time of writing, FastClose supports connections to any ERP where the data resides on an accessible SQL Server instance or SAP Hana instance. In addition it can also communicate via API with Nextworld, Epicor Public Cloud, Acumatica and SAP By Design.

As SQL Server, is currently the most commonly used connection type, we describe this below, but for others, please click on one of the following links for more specific guidance:

• SAP Hana

• Nextworld

• Epicor Public Cloud via REST API

• Acumatica

• SAP Business by Design

SQL Server

Expand Connections and click ERP Data Sources. Click “Create New Data Source...” and choose "New SQL Server Data Source". Fill in the connection information to connect to the ERP SQL Server database. The fields are:

• Name

  • The name of the connection, the best practice is to name the connection to match the database name.

• Data Source

  • The name of the database server, including any instance name.

• Database Name

  • The name of the ERP database on the database server

• Authentication Type

  • Where the connection will use a Windows account or a SQL Server login.

• Username

  • The user name of the SQL Server login

• Password

  • The password of the SQL Server login

• Connection Timeou

  • Leave as default for now

• SSL Encryption Settings

  • Leave unchecked for now

Test the connection information to ensure all is in order. Click the “Save” button to save changes.

(other connection types, re-join the setup steps here)

Move to the "Catalogs" submenu as shown below.

Click "Discover New Catalogs" which will find the catalogs shipped with FastClose. The catalog file describes the tables and relationships within the ERP. It is named to indicate the ERP name as well as the major version of the ERP.

Tick the catalog or catalogs which correspond to the ERP version.

NB: For Kinetic, select Epicor10.

Click "Save", this will create the necessary settings to use the catalogs.

Move to the "ERP Connections" submenu as shown below.

Click "Create New ERP Connection".

This screen has three fields:

• Name

  • The name of the connection. This will appear in reports in the connection selector. For Epicor users, this is often “Live” or “Pilot”. NB: For SAP Business One customers with multiple company databases, this should be the name of the Company whose data is stored in the database.

• Catalog

  • Select the catalog that matches the ERP type (and version if appropriate) of the database.

• Data Source

  • Select the database to connect to.

Click "Save" to save changes.

Users and Groups

The next step is to create the users and groups who will use FastClose. It is worth creating at least one user who is an Administrator user in case the Administrator password gets changed and mislaid.

Authentication

By default for a speedy setup, FastClose is set to use it's own internal authentication system for users, however it does support other systems as well. Information on how to set this up, can be found here. This can be adjusted at a later date.

Password Policy

Initially FastClose is set to a loose password policy for a speedy setup, but it does support more restrictive password policies to ensure users select robust passwords. Information on how to set this up server wide, can be found here. This can be adjusted at a later date.

Create a User

Click “Users” in the menu on the left and “Create New User”. The following fields are available:

• Username

  • The username that the user will use to login with in combination with their password. The best practice is to use the user’s Windows username as the FastClose clients will default to it in the login screen.

• Email

  • The users email address. This is used if the user requests a "Reset Password" link to set a new password when the current one is forgotten.

• First Name

  • The user’s first name.

• Last Name

  • The user’s last name.

• Comments

  • Optional comments to add

• Password

  • The user’s password

• Confirm Password

  • Confirm the user’s password

• Time Zone

  • The time zone the user typically works in

• Culture Name

  • The cultural preferences that they would like to use. This also determines the language that the embedded help system sends to the user.

• User must change password on next login

  • Tick this if just supplying an initial password

Clicking the “Save” button to move on to selecting the groups the user will be a member of, if these are already set up. Administrators will have full access to all FastClose reports and folders regardless of the folder or report permissions.

Click “Save” to save changes.

Administrator User’s Password

If a new user has been created who is a member of the Administrator’s group, it is recommended to change the default Administrator password. Click the “Edit” button next to the Administrator user.

Enter a new password and confirm the password. Click “Save” to save changes.

Install FastClose Scheduler Service

If the Scheduler Service has been purchased, now is a good time to install it. Follow the instructions here to complete this, and then return to this point.

Open a Firewall Port

It is quite common that the application server will have Windows Firewall installed and running. If so, it may be necessary to open a port on it, so that FastClose clients can communicate with the server.

To test this, go to a separate PC and in a web browser, navigate to http://[ApplicationServer]:5101 replacing [ApplicationServer] with the name of the FastClose server.

If the FastClose Administration Web page does not display, it is likely the firewall on the Application Server needs to be configured with an open port to allow the connection. More on how to open a port on the firewall, here.

Install FastClose Designer on the First PC

So that FastClose has some starter content for users to work with, the standard templates and solutions need to be imported into the repository. This is done using the FastClose Designer tool, so that needs to be installed and configured on at least one PC now.

Using a web browser on the PC, navigate to http://[ApplicationServer]:5101
replacing [ApplicationServer] with the name of your FastClose server.

Then click on the Download icon (either central or bottom left)

Within that web page, click on the link to download the installer for Designer and then run it. Once installed, start FastClose Designer from the Start Menu.

Change the Server Address to match the address of your FastClose server, including the port number.

Click OK. Now the log in prompt will display, which can be done using the Administrator user as below, or some other user that belongs to the Administrators group.

Install FastClose Standard Templates

Templates are provided via a link on the same download page as the FastClose Server. Save the .fcdb file to the PC.

Log in to FastClose Designer and select the Advanced tab in the ribbon, click “Import Templates”.

Select the templates file saved to the PC and click “Open”. When complete, a message will show how many templates were imported.

To confirm templates are installed as expected, click “File” then “Home”.  If the screen shows modules and templates, then template installation is complete.

Install FastClose Standard Solutions

FastClose also comes with a set of standard "solutions" reports that are a bit more specific and provide examples of certain focussed types of business report. These are provided via a link on the same download page as the FastClose Server. Save the .fcdb file to the PC.

Solution installation is very similar to template installation and is carried out within FastClose Designer.

Click “Import Solutions” within the Advanced tab of the ribbon. Select the solutions file and click “Open”. When complete, a message will show how many solutions were imported.

Installing FastClose Clients on User PCs

The next step is to install the FastClose client applications on each user’s PC.

Using a web browser on each client PC, navigate to 'http://[ApplicationServer]:5101/Admin/Downloads'

Click on each client required for that user, to download and then run the installer.

Connecting FastClose Clients to FastClose Server

When a user first launches FastClose Designer, Reader or the Excel Add-in they will need to tell it where to find the FastClose Server.

When the installer has finished downloading, install it. Once installed, start FastClose Designer or the desktop Reader from the Start Menu.

Change the Server Address to match the address of your FastClose server, including the port number.

Click OK and the server address will be saved for use by all three FastClose client applications. The user can then log in if they want to eg:

They are now logged in and ready to work with FastClose.

Verification

Now that the system is configured it is worth verifying that the setup is correct such that data can be displayed on screen.

Log into FastClose Designer as described above.

Click “File” then “Home” and select the GL 01 Balances template

Place the cursor in the Fiscal Year filter

and update the "Fiscal Year" to point at this year, and then click the run button.

If numbers come through to the grid - then connection to your ERP is verified.

This is also an opportunity to update this template so that subsequent users do not have to repeat this change.

In FastClose Designer go to the "File" menu and select "Options" at the very bottom. In the Options dialog, tick the "Advanced Features Enabled" box and click OK. Now select the "Advanced" tab in the ribbon and click on "Save As Template" to overwrite the existing "01 GL Balances" template.

Configure Planning

If FastClose Planning has been purchased, this is the time to configure it. Follow the instructions here to complete this, and then return to this point.

Install FastClose Reader Web App Service

If the FastClose Reader for the Web has been purchased, now is a good time to install its service. Follow the instructions here to complete this, and then return to this point.

Next Steps

Now that the system is installed and functional it is worth taking some time to configure it optimally configuring users, groups, setup folders and so on.

Visit the Administration page on the FastClose website to find out how. In particular check out "1001 Planning User Group Config"