| .Closing of Books of Account [ Oracle Users- cApex / foPro ] |
| 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
Osysinfo.exe For Licensed New Year Database. Enter New Year Database Select Valid Package Capex/Fopro Give No. of Nodes Already Connected To Server And Click On Proceed, A Key File Will Be Generated in Current Program Folder, Zip And Upload It On WWW.SHILPI.CC . |
| Step 13. After Getting Rkey, Again Run Osysinfo.exe Give New Year Database Name, Click on Import and Browse Unzipped Rkey And Click On Proceed. A Msg Will Inform You About Successful Licensing Of Your Package. |
| Step 14. 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 15. Run Utilcap10.exe & Create Indexes |
| # pls take activation separately for branch export, digital activation, web export, live activation if you already have in your old database, also pre-informed before start F/a Closing |