| |
| |
Step 1:
Check Free Disk Space On Drive Where Oracle Server Is Installed.
Free Space Must Be Approx. Twice Of Current Database i.e Size Of
Database Folder In Oracle/Oradata/<Old Database Name>. |
| |
| Step 2: If
Available Disk Space Is Sufficient Then Take Running Database Backup. |
| |
| Step 3: Create
New Database For New Financial Year From 'Database Configuration
Assistant'. |
| |
Step 4: Edit
Sql.ini File In program Folder And Find [oragtwy] Block,
Add New Line:- remotedbname=<New Year Database>,@<New Year Database> ie
Database Created In Step 3(eg. NSE0607). |
| |
| Step 5:
Unzip/Uncompress UTILCAP10.ZIP In Program Folder And Run Executable File
UTILCAP10.EXE. |
| |
Step 6: FA
Closing click on cApex/foPro-EXPORT- 1 (a)
Enter Running/Current Database Name (eg. NSE9798,NSE0708).
(b) Enter New Financial Year Start & End Dates (eg. Current Fin. Year
From: 01/04/2008 Current Fin. Year To: 31/03/2009).
(c) Enter Profit & Loss A/C Code.
(d) Select Export Drive Where Free Space is Available.
(e) Check 'Take Full Database Backup' Check Box.( Mandatory )
(f) 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.
(h) Un-Check 'Closing Stock To Be Carried Forward' Check Box If Shares
Closing Stock Are Not To Be Carried In New Financial Year. |
| |
Step 7: Click
Start Button This Process Will Take Time Depending on Database Size.
Closing
Will Be Completed After Successful Message. |
| |
Step 8: After
Successful Completion Of Step 7. Go To second option of FA Closing
>>cApex/foPro-Import- 2
(a) Enter New Year Database Name.
(b) Select Import File Drive ie. Drive Selected In Step 7 (d).
(c) Select 'New Financial Year Database' Button.
(d) Click Start Button And Wait For Successful Import. |
| |
Step 9: Edit
File COFILE.DLL In Program Folder. Edit Line With Old Year Entry:
<Old Year Database Name>
<Old Year Financial Year Description>
(eg. NSE0708 Financial year 01/04/08 To 31/03/09).Total Length Of
Database Name Entry Must Be 9 Characters, If Not Add Spaces In End. |
| |
Step 10. Run
Capex, Go To Utilities/System File Maintenance
And Change Financial Year In Both The Databases Old & New. |
| |
| Step 11. Also
Run Create/Update balances from Utilities in New Financial Year |
| |
Step 12. After
Checking Data, Logout From Package Go To Program Folder And Run
licclient.exe For Licensed New Year Database. Enter New Year Database
and click on 'Get Activation', after successful message you can run your |
| package |
| |
Step 13. For
Remove Current Year Data From Last Year Database, Go To next option
cApex/foPro-Closing- 3 enter admin password click on connect and
give req. date (default dates are already given) and click on proceed. |
| |
| Step 14. Run Utilcap10.exe
& Create Indexes |
| |
| # 1. Pls take backup
before start this process |
| 2.
Pre-informed before start F/a Closing |
| 3.
Trial should be tallied before start process |