NetClose - Sharepoint Reconciliations Setup
Overview
The Document Management feature in NetClose Reconciliations provides the user with a live connection between their Microsoft SharePoint files and the Reconciliation Records within NetClose. This feature streamlines the reconciliation process by providing the user with a direct link to all support documentation and the ability to auto-create support "Items" within the Reconciliation Record. The walkthrough below explains how to set up Document Management.
Click here to view the walkthrough in full screen.
Initial Setup
Download the Shared Transactions SuiteApp (No additional cost) .
Navigate to Netgain > Setup > System Setup> Document Management
Specify the URL of the SharePoint Site that you will be using for Document Management. Note that the URLs when accessing the same Site through SharePoint or OneDrive are different, make sure you use the SharePoint URL.
The system will automatically create a "Netgain Tools" folder. The user can specify where they want that folder to be stored under the field "SharePoint Folder Path". If no folder path is specified, the "Netgain Tools" folder will be created at the root folder of the drive. If anything is populated in the Netgain Tools Folder Path folder, then there needs to be a forward slash before the value initial value. For example, if there is a folder named "Reconciliations" in the Root Folder that you want to use for your reconciliations then in the SharePoint Folder Path you would type "/Reconciliations"
Click on the Microsoft Authentication link. This will prompt the user to sign in to their Microsoft account. Once signed in, the system will gain access to the user's authorized folders. Users will know the connection was successful when there are asterisks under the "SharePoint Access Token" field.
Parse X Tabs: This setting is designed for users with very large supporting files who may encounter issues syncing large files. This field takes an integer value and NetClose will look only at the first number of sheets indicated. For example, if the Parse X Tabs is set to 1, NetClose will read only the first tab/sheet in the file. If it is set to 2, NetClose will read only the first two tabs/sheets in the file.
