1 / 83

Capex & Fopro closing

Capex & Fopro closing. Closing of cApex10 & Fopro10. 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.

aricin
Download Presentation

Capex & Fopro closing

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Capex & Fopro closing

  2. Closing of cApex10 & Fopro10 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 capex10 folder • 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. Step4: After sending request, a DCR will be created automatically(if all details are valid ).Now, FA Closing is allowed for that database.

  6. Note: Before start process of closing please make sure that no one doing work in cApex10 (i.e. Nse0910). • After Confirming to License Department Start the Process of Closing • Step5: Download New licclient .exe and utilcap10.zip from www.shilpisoft.com before start process of Closing. • Step6: Run Update License Status from new licclient.exe. • Note: If Connection was not successful then ask the Client to open the port 8089. 1. Click on it to check the connection. 2.Click on OK.

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

  8. Step7: Create new database for new financial year from 'Database Configuration Assistant'. • Follow the following steps to create database for new financial year : • Go to start. • Select Program. • Select Oracle-OraHome92. • Select Configuration and Migration Tool. • Select Database Configuration Assistant.

  9. Following window will open: Click on Next.

  10. Select create a database. Click on Next.

  11. Select General purpose. Click on Next.

  12. Enter Database name. Click on Next.

  13. Select Share Server Mode. Click on Finish.

  14. Click on ok.

  15. Database Creation is in Progress

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

  17. Step8:Edit Sql.ini FileIn program Folder and Find [oragtwy] Block. • Add New Line:- Remotedbname=NSE1011,@NSE1011 i.e. Database Created (e.g. NSE1011).   Add New line

  18. Step9: Open Profit & Loss Account • Follow the following steps to open profit & Loss Account • Login capex10.exe • Select Account Head Master under Masters menu

  19. Account Head Master 1. Enter Account code 2. Enter Account Description 3. Click on Account Group chart

  20. 4. Click on Reserve and surplus 6. Click on select 5. Click on Reserve and surplus

  21. 8. Click on Save 9. Following message will display ,click on ok 7. Select Account Type others

  22. Step10: Download new utilcap10.zip & extract it in program folder(cApex10) and run utilcap10.exe. 1. Enter exiting database 2. Click on Connect. Following message must display

  23. Step11: Select cApex/FoPro Export-1 option under FA Closing. Select capex/fopro Export-1.

  24. cApex/foPro-export-1 1. Enter first Trxn For Arbitrage Of New Year( In Case of arbitrage) 2.Enter profit & loss a/c code. 3. Select export drive where free space is available. 4.Click on start

  25. As you click on start , password window will open • Enter password (i.e. metro) 1. Enter Password (i.e. metro) 2. Click on proceed. Following window will open 3. Click on Start

  26. Data is exporting here. It will export in two stages 1. Fulldata 2. New Tab Now Fulldata export is in progress • This process will take time depending on database size.

  27. Now Newtab export is in progress

  28. Check the status of data exporting (i.e.Fulldata)

  29. Check the status of data exporting (i.e for newtab)

  30. NewTab Fulldata

  31. After completing first step(cApex/foPro-export-1) successfully , Click on yes to continue for second step

  32. cApex/FoPro-import- 2 1.Select Oracle version 2.Select import file drive i.e. drive selected in step1 (cApex/FoPro Export-1). 3. Enter new year database name 4. Enter Password (i.e. what given at the time of database creation) 5. Click start button and wait for successful import.

  33. Now Importing start in new database nse1011 • First Newtab will import

  34. Now Fulldata.dat is importing in new database NSE1011 This process will take time depending on database size. Closing will be completed after successful message.

  35. A following window will display for mismatch records and please make sure there will be no record in the table. Click on Exit

  36. Click on OK

  37. Click On Exit

  38. Click on OK

  39. Now Click on Exit

  40. Step12: Run licclient.exeto license new year database and test i-net connection. Message should be successful. 1. Click here .Following message must display 2.Click on OK

  41. Click on Product Activation& license new database after closing. Select database Restore/Fin closing Select Product Type Enter database name Enter Installation Id given by license department Click on Get Activation . Following message will display

  42. Step12: Edit file cofile.dll in program folder. Edit line with new year database entry: (eg. nse1011 financial year 01/04/10 to 31/03/11).

  43. Step13: Now Double Click on capex10.exe(shortcut icon) • First login into Nse0910 database • Run Capex10, Go To Utilities/System File Maintenance and Change Financial Year in both the Databases (Old & New) 1.Double click on capex10.exe 2. Select nse0910 Login into package with userid, password

  44. Go to utilities>>System file maintenance • Window on next slide will open

  45. Click on save and close the window • Change financial year in the databases old Change financial year

  46. Create/Update Balances • Follow the following steps to create /update balances • Login package with old database(nse0910) • Select utility>> create/update balances

  47. Following window will open • Click on generate

  48. Balance Carry Forward • Follow the following steps to carry forward balances • Login package with old database(nse0910) • Select utility>> Balances Carry Forward

  49. 1. Select export closing balances 2. Enter old database name 3. Click on it. Following message will display 4. Click on OK

  50. 7. Click on Export. Following message will display 6. If client maintain their exchange wise balances then tick on it otherwise do not tick. 5. Enter file name 8. Click on OK

More Related