Closing of Commex,Fxfuture & Spotxl

1. Closing of Commex,Fxfuture & Spotxl

2. Commex10, Fxfuture and Spotxl Closing NOTE: Trial balance should be tallied before closing. • Step1: Check free Disk space on Drive where Oracle is Installed. Free space must be approx. twice of Current Database Size. • Step2: Check for any pending amount .If found any dues then consult account department. • Step3: Ask the client to send request for closing. For it, follow the following steps: • Download new licclient .zip from http://www.shilpisoft.com and extract it in package folder(example: d:\commex10) • Run licclient.exe licclient.zip licclient.exe

3. Check i-net connection . If connection is successful then click on Send FA Closing Request otherwise check internet connectivity or port 8089 (This port should open.). 4. Send FA closing Request 1. Click on it 2. Wait for the following message 3 .Click on OK.

4. Following window will open .Fill all details and send request Enter database name Enter Contact person name Enter Mobile no/ Ph. no Click on send request. Following message will display. Click on OK.

5. Step5: After sending request, a DCR will be created automatically(if all details are valid ). • Step5:Now, FA Closing is allowed for that database.

6. NOTE: Before start process of closing please make sure that no one doing work in commex10 (i.e. comdata) • Step6 : After confirming with license dept. then start the process of closing. • Run Update License Status from new Licclient.Exe. 1. Click here .Following message must display 2.Click on OK

7. Click on update license status. 1. Enter database 2. Select Auto Mode 3. Click on Get Activation. Following message will display

8. Step7: Take Backup Running Database. • Login commex10.exe. • Select backup>> Backup of Database.   Backup of Database.

9. A Following window will open: 2. Enter file name as database name with current date (e.g. Comdata). 1. Select Drive. 3.Click on start to take backup.

10. Data is exported here.

11. After exporting data there will be open a log file by which check the status of data exporting.

12. Step8: Create New Database For New Financial Year. • Follow the following steps to create database : • Go to start • Select Program • Select Oracle-OraHome92 • Select Configuration and Migration Tool • Select Database Configuration Assistant

13. Following window will open. Click on Next.

14. Select create a database. Click on Next.

15. Select General purpose. Click on Next.

16. Enter Database name. Click on Next. * In Case Of Commex10,Fx10,Spot10 New database name should be previous year name as e.g. Com0910,Fx0910,Spot0910

17. Select Share Server Mode. Click on Finish.

18. Click on Ok.

19. Database Creation in Progress.

20. Enter password in each field (e.g. s). It is mandatory. Click on Exit .

21. Step9: Edit Sql.ini File In program Folder And Find [oragtwy] Block. • Add New Line:- Remotedbname=Com0910,@Com0910.

22. Step10: Tune New Database. Select Oracle Version Enter password (Password must be same as of Oracle database creation while installing oracle ) Enter Database Name Browse backup datafile (i.e. comdata backup which was taken earlier before) Click on this button.

23. Do not close this window because data is imported here

24. After importing data there will be open a log file by which check the status of data importing

25. Database Tuning is successfully completed.

26. Step11: Run New Utilcap10.exe From COMMEX10 Folder .

27. Enter database name (e.g. Comdata). Click on Connect.

28. Step12: Then go to Commex-Import option under FA Closing Menu.

29. Choose Closing Segment-- Commodity. (b) Select Database Name COMDATA. (c) Select Previous Database name. • This Process will take time Depend on Database size. Closing will be completed after successful Message.   2.Click on Ok. 1.Click Start Button.

30. 3.Click on Cross Button. 4. Click on Yes.

31. 5. Enter the Password (i.e. metro). 6. Click on Proceed.

32. This is time consuming process and take time as per data size or system performance, Closing Will Be Completed After Successful Message.   Click on OK.

33. Select Database Restored/Fin.Closing. Select Product Type. Enter New database name. Enter database Id given by license department. Click on Get Activation . Following message will display. • Run Licclient.Exe and test I-NET Connection. Message Should be Successful.  • Click on Product Activation & License New Database after closing. 

34. Double Click on Commex10 Shortcut and login in Comdata database.

35. Also Run Create/Update balances from Utilities in Current Financial Year and take Backup. 

36. Click on Generate. Click on OK.

37. 2. Enter file name as database name with current date (e.g. Comdata) 1. Select Drive. 3.Click on start to take backup • Take backup Of Comdata.

38. Now Backup is starting i.e. data is exporting here.

39. After exporting data there will be open a log file by which check the status of data exporting.

41. Double Click on Commex10 Shortcut and Now Login into Com0910 database

42. Run Create/Update balances from Utilities in Last year Financial Year and take Backup. 

43. Create/Update balances has been successfully updated Click on Generate. Click on OK.

44. Take backup Of Com0910 . 2. Enter file name as database name with current date (e.g. Com0910) 1. Select Drive. 3.Click on start to take backup

45. Now Backup is starting i.e. data is exporting here.

46. After exporting data there will be open a log file by which check the status of data exporting.

48. Commex,Fxfuture & Spotxl Closing successfully done.