| Closing of Books of Account [ SQL Users ] |
| ** COMSQL Closing ** |
| *** |
| Step 1: Check Free Disk Space On Drive Where Sqlbase Server Is Installed. Free Space Must Be Approx. Twice Of Current Database i.e DBS File Size. |
| Step 2: If Available Disk Space Is Sufficient. Run Check Database From Program Utilities Menu. |
| Step 3: If Database Check Is Successful. Take Database Backup. |
| Step 4: Go To
SQL850 Folder Create New Folder With New Database Name (eg. COM0506 ) And Unzip, Uncompress Backup Taken In Step 3). Server Must Be Closed During This Operation. |
| Step 5: Rename Old Year Database DBS File To New Year Database Name i e Same As Folder Name Created In Previous Step (eg. COMSQL.DBS TO COM0506.DBS). |
| Step 6:
A (1) Edit Sql.ini File In Sqlbase Folder. Find Block [dbnt1sv] dbname=comsql,sqlws32 dbname=com0506,sqlw32 (add this line in small alphabets) (2) Copy this sql.ini To Comsql folder also |
| Step 7: Run SCOMCLOSE.EXE From COMSQL FOLDER |
| Step 8: (a)
Select Database Name COMSQL. (b)Enter New Finacial Year Start & End Dates. (eg. Current Fin. Year From: 01/04/2006 Current Fin. Year To: 31/03/2007). (e)Un-Check 'Op Balance To Be Carried Forward' Check Box If Financial Are Not To Be Carried In New Financial Year i.e Opening Balances To Be Entered Manually In New Year. |
| Step 9: This Process Will Take Time Depending on Database Size. Closing Will Be Completed After Successful Message. |
| Step 10. Run
Program File COMSQL.EXE Go To Utilities/System File Maintenance And Change Financial Year In Both The Databases Old & New. |
| Step 11 : For
Backup In Comback folder edit file COM0506.bat and type the following
lines:- @ echo off |