Accountants Enterprise only
To utilise SQL functionality for your application ledgers, a new folder must be created and flagged accordingly. Existing data that is stored in a Cheetah File System folder (for example, Central Database and all Tax ledgers for 2003 or later) must be copied into this new folder to enable the required tables to be created for the SQL database.
The SR Data Access Layer (SR DAL) component and MSDE or SQL, must be installed and running before the SQL folder is created.
How to create a SQL folder
-
From the Navigation bar, click Administration > Folders to open the Folder Maintenance window.
-
Click File > New, or right click on an existing folder and select New to create a new SQL folder. The New Folder properties window opens.
-
Enter the name of this folder in the Title field. It is highly recommended that you identify in the title that this is an SQL folder (for example, **SQL** Tax).
-
Enter a user defined code in the Reference field which identifies folders when folder links are used. For example, TAXSQL. It is recommended that the code used is up to a maximum of 10 alpha-numeric characters in length and is unique.
-
Tick the checkbox Use database server. This is the only mechanism that identifies this folder as using an SQL database. Selecting this checkbox changes the available fields below.
-
Click the Down arrow
-
Ensure the Contains master data files checkbox is ticked. The Contains master program files checkbox is blank for SQL folders as master programs reside in the \SOL64 folder.
-
Click OK to create the SQL folder. Refer to Copying CFS Data into a new SQL Folder 2023.
If you are using Tax and Central Database on SQL/MSDE and are adding new clients to a prior year's tax ledger (that is, prior to 2003), client details must be maintained and added to both CFS and SQL/MSDE databases.