General Ledger
Contents
1. 37 of 70 ICAR Oracle General Ledger User Manual Version 20 0 Process to run Balance Sheet e Following screen will open e Here enter the Ledger and select the Institute name for which you want to extract the financial reports e The user can open find screen by clicking on the Magnifier button and use to search ORACLE Project MIS amp FMS in Indian Council of Agricultural Research Select Segment Override Ledger Institute Fund Type Scheme Code Account Division Future 1 Future 2 N Navigator Y E Fortes Diagnostics Preferences Help Personalize Page Close Window Apply ICAR2021 NR a 54 14 q Q q ooo Y Default 0000 Y Diagnostics Preferences Help Personalize Page Close Window Copyright c 2006 Oracle All rights reserved Click on Apply 38 of 70 Oracle General Ledger User Manual Version 20 0 Process to run Balance Sheet e Click on Next ORACLE Project MIS amp FMS in Indian Council of Agricultural Research N Navigator Y E Favorites Diagnostics Preferences Help Personalize Page Close Window D D D Submission Parameters Publishing Parameters Storage Location Presentation Review Submission Parameters Indicates required field Cancel Step 1 of 5 Next Define Ad Hoc Reports2. Oracle General Ledger User Manual Version 20 0 Process to run Schedules forming part of Annual Accounts e Click on Next ORACLE Project MIS amp FMS in Indian Council of Agricultural Research N Navigator Y BF Fanites Y Diagnostics Preferences Help Personalize Page Close Window 0 0 0 QA Submission Parameters Publishing Parameters Storage Location Presentation Review Presentation ne Indicates required fed Se 45 E Create Menu Item for this report About this Page Privacy Statement Diagnostics Preferences Help Personalize Page Close Window L Canel Bad Septet Copyright c 2006 Oracle Al rights reserved 60 of 70 Oracle General Ledger User Manual Version 20 0 Process to run e This is the final step where you can review the details of the parameters for which you are going to run the report Schedules forming e If any changes are to be done then click on back else move forward and click on Submit part of Annual Accounts OR ACLE REPORT MANAGERS in Indian Council of Agricultural Research n Navigator v Favorites v Diagnostics Home Logout Preferences D D 3 Q Submission Parameters Publishing Parameters Storage Location Presentation Review Review Cancel Back Step5of5 Submit Submission Nes Report Name Schedule 1 amp 2 Period ADJ MAR 13 Date 31 Mar 2013 Flag Exceptions No Currency INR Ledger ICAR Content Set
3. Oracle General Ledger User Manual Version 20 0 DOCUMENT RELEASE NOTICE General Ledger User Manual Document Version no 20 0 Release no All Releases 14 October 2014 Indian Council of Agricultural Research FMS amp MIS Implementation Sh Himanshu Garg Sh Anil Sharma Date 14 October 2014 Date Date 4 of 70 gt Oracle General Ledger User Manual Version 20 0 BD ICAR REVISION HISTORY Document No Document Title Payables User Manual Document Version Issue Date Change Details Owner Approved By Remarks No 1 0 20 August 2013 No Previous Document Himanshu 10 0 14 October 2014 Reviewed Version 1 0 and made Himanshu applicable changes 20 0 23 May 2015 Reviewed Version 10 0 and Sneha changed the URL for the instance on Page 12 5 of 70 NS N Oracle General Ledger User Manual Version 20 0 v ES A ICAR Table of Contents A NAAA A 7 1 1 ABOUT THIS DOCUMENT td ts AEE e it eee 7 1 2 ENVISIONED CHART OF ACCOUNTS COA STRUCTURE ccsscccssssececssscecesseeecnesaeeecsneeecsssaeeecsesaeceseeeeeceesaeeecsesaeeeceeeecessaeeeceesaeceseeecessaeeecseaaececseeeesesaeeecsesaeeeseneeeeened 8 1 3 IMPORTANT KEYBOARD SHORT CUD r a aa a adoCecadedens das useveaaiedeus aa adewsnndubbustad a a Gousaas dduWaendu dun aa esbvaaaietausaad a OA aAa AAE esbvanate dausaad gaaveenda ious bat antvennbeiwbedss 9 1 4 JOURNAL ENTRIES 02 03 22e53deececaeececscats ave
4. Report Name BALANCE SHEET Y Content Set 4 Period ADJ MAR 13 Q Display Set q Date 31 Mar 2013 3 Row Order A Currency INR y Rounding Option Calculate Then Round 7 Ledger ICAR q E Fag Exceptions Segment Override ICAR2021 INR 554 S Scheduling Options Diagnostics Preferences Help Personalize Page Close Window 39 of 70 ICAR Oracle General Ledger User Manual Version 20 0 Process to run Balance Sheet e Instep 2 of 5 the Default template will come e Click on Next ORACLE Project MIS amp FMS in Indian Council of Agricultural Research M Navigator Y FF Favorites Y Diagnostics Preferences Help Personalize Page Close Window J Submission Parameters Publishing Parameters Indicates required field i Publishing Parameters Storage Location Presentation Review Primary Parameters Set Auto Archive No Y E ATT DA ime a t 205 1 JAvalabity Aboutthis Page Privacy Statement Diagnostics Preferences Help Personalize Page Close Window Copyright c 2006 Oracle AI rights reserved 40 of 70 Oracle General Ledger User Manual Version 20 0 ICAR Process to run e Give a name to the report Balance Sheet e All the reports that are being run through report manager have to be saved in some folder e To create a new folder click ok button da Project MIS amp FMS in Indian Council of Agricultural Res
5. Storage Project MIS amp FMS in Indian Council of Agricultural Research ORACLE n Navigator Y amp Favorites Y Diagnostics Preferences Help Personalize Page Close Window Y O y 0 Submission Parameters Publishing Parameters Storage Location Presentation Review Storage Location Cancel Back Step 3 of 5 Next Location Used Saved Select New Report Name BALANCE SHEET 2013 Enter the name of the report as it will be stored in the Repository Expand All Collapse All Y Select Focus Name Add Folder Reports Repository ap O Cancel Back Step 3 of 5 Next Diagnostics Preferences Help Personalize Page Close Window Copyright c 2006 Oracle All rights reserved About this Page Privacy Statement 68 of 70 Oracle General Ledger User Manual Version 20 0 ICAR Process to Create a e Give a name to the folder that you want to create and click on Apply New Folder for Storage ones ORACLE Project MIS amp FMS in Indian Council of Agricultural Research FL Navigator Favorites Diagnostics Preferences Personalize Page Close Window Storage Location Add Folder About this Page Cancel Apply Cancel Apply Diagnostics Preferences Personalize Page Close Window Privacy Statement Copyright c 2006 Oracle All rights reserved e Jt would create a folder with this nam
6. noprint Enter the Name of the concurrent program name Enter the Parameters Pagebreak Segment Low 554 l Pagebreak Segment High 554 Period un Cancel Clear Help Amount Type Cancel Select the combination for which Trial Balance is to be run Select the Institute name Clear Help 31 of 70 BED ICAR Oracle General Ledger User Manual Version 20 0 Concurrent program Trial Balance Enter the parameters for running the report At these Times Upon Completion Run this Request Copy Name MENE Operating Unit Parameters Language American English Parameters Run the Job As Soon as Possible Ledger Ledger Set Ledger Currency Currency Type Save all Output Files Entered Currency Layout Pagebreak Segment Notify Pagebreak Segment Low 554 Pagebreak Segment High 554 Period Print to noprint Select the period Enter the Amount Amount Type type as Year to Date l Year to Date Cancel Clear Help 32 of 70 y Oracle General Ledger User Manual Version 20 0 ADA ICAR Concurrent e Click on Refresh Program should be completed with status as Normal As shown in fig program Trial O Requests MN Tal ES e JO Balance Refresh Data Find Requests Submit a New Request Request shall be A co
7. 0 0 0 e UN Submission Parameters Publishing Parameters Storage Location Presentation Review Presentation E Create Menu Item for this report Cancel Back sepa Net Diagnostics Preferences Help Personalize Page Close Window About this Page Privacy Statement Copyright c 2006 Oracle Al rights reserved 52 of 70 Oracle General Ledger User Manual Version 20 0 Process to run e This is the final step where you can review the details of the parameters for which you are going to run the report Income amp e If any changes are to be done then click on back else move forward and click on Submit Expenditure report OR ACLE REPORT MANAGERS in Indian Council of Agricultural Research n Navigator Favorites w Diagnostics Home Logout Preferences 9 9 O 3 9 Submission Parameters Publishing Parameters Storage Location Presentation Review Review Cancel Back Step50f5 Submit Report Name INCOME amp EXPENDITURE ACCOUNT Period ADJ MAR 13 Date 31 Mar 2013 Flag Exceptions No Currency INR Ledger ICAR Content Set None Display Set None Row Order None Rounding Option Calculate Then Round Segment Override ICAR2021 INR 554 00000 00000 Schedule Now Recurrence Default Template INCOME amp EXPENDITURE ACCOUNT Timeframe ADJ MAR 13 Security None Availability Now Storage Location Repository Location Reports Repository gt FINAL ACCOUNTS 2013 gt INCOME amp EXPENDITURE ACCOUNT
8. BREA ICAR 4 Posting of Manual Journals Purpose e Once manual journals are created they need to be posted in General Ledger to update the account balances Posting can be done by selecting a single journal a journal batch or a group of journals Navigation e Login gt General Ledger Super User gt Journals Enter e Click on open The Find Journal Batches screen will be displayed s Documents Processes Journals Post Post journals Journals ES Top Ten List Enter Encumbrance Import Define Generate Schedule AutoAllocation Reconciliation Launch Journal Wizard Budgets Inquiry Currency Consolidation Reports 00 E et ee 19 of 70 BR ICAR Oracle General Ledger User Manual Version 20 0 Posting of Manual Journals Batch Informati Clear Find N To query an existing Journal enter any or a combination of following criteria a Query it Based on the Batch Name If a single journal was created then enter the Journal name with and search for the journal b For a particular period like for Jan 13 Mar 13 etc c Click on Find Period Total Entered Balance Batch Type Debit Find Journal Batches Balance Type Any z 73 18 10 38 Entered Debit Entered Credit Control Batch brumas Review Batch Post Credit Control Tot
9. Close Exit screen F4 Invoke List of Values CTRL L Insert duplicate field SHIFT F5 Insert duplicate record SHIFT F6 To query the form 1 For query first press F11 2 Give partial information on screen like partial invoice name number and prefix or suffix with 3 Execute the query by pressing CTRL and F11 List of Value LOV LOV is a UI component that facilitates the completion of a text entry field when there are numerous values that may be assigned LOVs are a useful alternative to drop down lists particularly in cases where displaying a long list of selections in a drop down list would require excessive scrolling Search within LOV list 1 Click on the LOV icon 2 The list of LOV is displayed 3 If short list then scroll and select the required value Press OK 4 If the LOV list is long then enter any partial full value and suffix with the in the Find field The as prefix and suffix is also used where the subsequent word s of the total value is used for query 5 Then click Find button 6 This displays a shortened list of values that will match the query submitted 7 Select the value desired and click OK The original text entry screen is populated 9 of 70 BRE oa ICAR Oracle General Ledger User Manual Version 20 0 1 4 Journal Entries Process Overview Description e Audit and Accounts section will create Manual Journals Adjustment Journals Year end
10. Form Function Name None ES Renannintian Danian Mana 53 of 70 Oracle General Ledger User Manual Version 20 0 ICAR Process to run e Following confirmation will come showing that the request has been submitted and saved in the folder Income amp e Click on Ok Expenditure report OR ACLEREPORANANA CERO in Indian Council of Agricultural Research Navigator Y Favorites Y Diagnostics Home Logout Preferences Ch Confimation ThereortINCONE amp EXPENDITURE ACCOUNT has been submitted wth request d 2557812 Montor Requests _ Submit Another Request 0 Diagnostics Home Logout Preferences Aboutthis Page Privacy Statement Copyright c 2006 Oracle All rights reserve e The process to view these reports are explained in the coming process Follwing shall be the output of the request dll INCOME amp EXPENDITURE xlsx 54 of 70 Oracle General Ledger User Manual Version 20 0 7 1 3 Schedules forming part of Annual Accounts Navigation e Reports Manager gt Financial Report submission Process to run Schedules forming part of Annual Accounts Workist From Navigator REPORT MANAGER Project MIS amp FMS in Indian Council of Agricultural Research Oracle Applications Home Page Subject There are no notfications in this view REPORT MANAGER Fanci Report Template Edtor Financial Report Submission 3 Standard Report Submission R
11. e This is the final step where you can review the details of the parameters for which you are going to run the report e If any changes are to be done then click on Back else move forward and click on Submit ORACLE Project MIS 8 FMS in Indian Council of Agricultural Research n Navigator Y amp Favorites Diagnostics Preferences Personalize Page Close Window 2 D D P Submission Parameters Publishing Parameters Storage Location Presentation Review Review Cancel Back Step 5 Submission oe a Report Name BALANCE SHEET Period ADJ MAR 13 Date 31 Mar 2013 Flag Exceptions No Currency INR Ledger ICAR Content Set None Display Set None Row Order None Rounding Option Calculate Then Round Segment Override 554 00000 00000 Schedule Now Recurrence Publishing s Default Template BALANCE SHEET Timeframe ADJ MAR 13 Security None Avalabiity Now _ Storage Location o o PP Repository Location Reports Repository gt FINAL ACCOUNTS 2013 gt BALANCE SHEET 2013 Presentation Form Function Name None Presentation Location None Presentation Template None 45 of 70 Oracle General Ledger User Manual Version 20 0 ICAR Process to run e Following confirmation will come showing that the request has been submitted and saved in the folder Balance Sheet e Click on Ok e The process to view these reports is explained in the further process ORACLE Project MIS amp FMS in Indian Council
12. Ledger Super User gt Journals gt Enter e Click on open Navigator General Ledger Super User Functions Documents Processes Journals Enter generate and post actual and encumbrance journals Top Ten List Budgets Inquiry Currency Consolidation Reports Setup Other BUDGET UPLOAD EFC ITEM LISTING FORM EFC BUDGET UPLOAD 00 42 e Le 23 of 70 Oracle General Ledger User Manual Version 20 0 URE ora ICAR Journal Inquiry e Enter any of the Field information to inquire any Journal e Enter Ledger name as ICAR e Enter the Journal or Batch name or search in the List using e Enter Period and click on Find button Jal Batch Status Source Category Period Batch Name Journal Name Currency Journal Debit Journal Credit O Find Journals Jo Batch Journal Test Ledger ICAR Source Period ADJ MAR 14 Category Currency Status Control Total Posting Batch Funds Journal More Clear New Batch New Journal y 4 Review Journal Review Batch Post Reverse Batch Requery New Journal New Batch Tax Batch Approve AutoCopy 24 of 70 Oracle General Ledger User Manual Version 20 0 BRE ICAR Journal Inquiry e Jt will reflect the Batch status and other details e The status of the Journal that is posted will be reflected here e Click on Review Journal button to review the journal further
13. None Display Set None Row Order None Rounding Option Calculate Then Round Segment Override ICAR2021 INR 554 00000 00000 Schedule Now Recurrence m Publishing Default Template Schedule 1 amp 2 Timeframe ADJ MAR 13 Security None Availabilty Now Repository Location Reports Repository gt FINAL ACCOUNTS 2013 gt Schedule 1 amp 2 Presentation Form Function Name None Dracantatinn nratian Nano 4 61 of 70 Oracle General Ledger User Manual Version 20 0 ICAR Process to run e Following confirmation will come showing that the request has been submitted and saved in the folder Schedules forming e Click on Ok part of Annual Accounts OR ACLE REFORAMANACER gt in Indian Council of Agricultural Research M Navigator fx Favorites Diagnostics Home Logout Preferences E iy Confirmation ThereportScheduk 1 amp 2 has been submitted with request id 2558054 Monitor Requests Submit Another Request Ok Diagnostics Home Logout Preferences About this Page Privacy Statement Copyright c 2006 Oracle All rights reserved The process to view these reports are explained in the coming process Follwing shall be the output of the request Schedule 1 amp 2 x Isx 62 of 70 ICAR Oracle General Ledger User Manual Version 20 0 7 2 Process to View Saved Reports Navigation e Reports Manager gt Financial Report submiss
14. Oo Enter the Period and other details shall come automatically ORACLE Project MIS 8 FMS in Indian Council of Agricultural Research n Navigator Y B Favorites Y Diagnostics Preferences Help Personalize Page Close Window Submission Parameters Publishing Parameters Storage Location Presentation Review Submission Parameters Indicates required field Cancel Step 1 of 5 Next Report Name INCOME amp EXPENDITUR A Content Set A Period ADJ MAR 13 A Display Set 4 Date 31 Mar 2013 3 Row Order Currency INR y Rounding Option Calculate Then Round Ledger ICAR A Flag Exceptions Segment Override a Scheduling Options Cancel Step 1 of S Next Diagnostics Preferences Help Personalize Page Close Window Privacy Statement Copyright c 2006 Oracle All rights reserved About this Page 48 of 70 Oracle General Ledger User Manual Version 20 0 Here enter the Ledger and select the Institute name for which you wants to extract the financial reports The user can open find screen by clicking on the Magnifier button and use to search Select it and click on Next HRT A ICAR Process to run e Now in additional parameters enter segment override Income amp e Click on the Magnifier button to open the screen Expenditure report Oo ORACLE REPORT IANR GERMS in Indian Council of Agricultural Research n N
15. instead booked and accounted under wrong head Then we need to pass a rectification journal for this in the Journals screen This screen is used to enter a journal entry manually 17 of 70 NE BED ICAR Oracle General Ledger User Manual Version 20 0 Creation of Manual Journals e After entering the entry click on Check Funds to check for the availability of funds e Click on ok on the message e If funds are available then click on save button and close the window The system will generate the voucher number Journals ICAR Test 02 AUG 2013 18 10 38 Journal UES Conversion Reverse Description Currency INR Date Ledger ICAR Category Miscellaneous Date 31 MAR 2014 Period Period ADJ MAR 14 Effective Date 31 MAR 2014 Type User Method Switch DriCr y Balance Type Actual Budget Rate 1 Status Not Reversed Clearing Company Tax Not Required EOS Control Total M Lines Other Information Y Line Account Debit INR Credit INR Description 1 166 201 00000 532005 00000 00000 0001 10000 00 2 156 201 00000 110000 00000 00000 0001 10000 00 10000 00 4 Acct Desc JARI PUSA NEW DELHI Non Plan Default Postage amp Telegram Default Default Default Post AutoCopy Batch Approve Line Drilldown T Accounts Check Funds Reserve Funds View Results Change Period Change Currency 18 of 70 Oracle General Ledger User Manual Version 20 0 y
16. run Schedules forming e Now in additional parameters enter segment override part of Annual e Click on the Magnifier button to open the screen Accounts e Here enter the Ledger and select the Institute name for which you wants to extract the financial reports e The user can open find screen by clicking on the Magnifier button and use to search Select it and click on Next ORACLE rerontakin er gt in Indian Council of Agricultural Research n Navigator v amp Favorites w Diagnostics Home Logout Preferences Help O 3 O Submission Parameters Publishing Parameters Storage Location Presentation Review Submission Parameters Indicates required field Cancel step 1of 5 Next Primary Parameters _ _ o Define Ad Hoc Reports Report Name Schedule 1 amp 2 a Content Set a Period ADJ MAR 13 a Display Set a Date 31 Mar 2013 El Row Order J amp Currency INR Rounding Option Calculate Then Round Ledger ICAR a E Fag Exceptions Segment Override ICAR2021 INR 554 0000 S Scheduling Options Cancel Step 1of5 Next Diagnostics Home Logout Preferences Help 57 of 70 ICAR Oracle General Ledger User Manual Version 20 0 Process to run Schedules forming part of Annual Accounts e Instep 2 of 5 the Default template will come e Click on Next OR ACLE REFORAMANACER in Indian Council of Agricultural Research n Navigator Y Favorites Y Diagnostics Home Logout Pr
17. saved in an existing folder also Here select the folder in which reports are to be saved Check the radio button of that folder and click on Next Cancel Back Step 3 of 5 Location Used Saved Select New Report Name BALANCE SHEET 2013 Enter the name of the report as it will be stored in the Repository Expand All Colapse All 4 E 19 JUNE 13 HH User Guide FINAL ACCOUNTS 2013 Select Focus Name Add Folder Reports Repository 4 E GPF FSGs for UAT dp ut 4 E UAT_G8B 4 Gand BUAT lt gt E ASRI NEW lt gt E ASRI 2014 E UAT27 28 lt gt E UAT27MAY2013 ENAR 4 E 30may 2013 43 of 70 Oracle General Ledger User Manual Version 20 0 Process to run e Click on Next to move to the next step Balance Sheet ORACLE Project MIS amp FMS in Indian Council of Agricultural Research N Naigatorv Faves Y Diagnostics Preferences Help Personalize Page Close Window 0 y 0 Submission Parameters Publishing Parameters Storage Location Presentation Review Presentation Indicates required feld Step 4 of 5 Create Menu Item for this report O Diagnostics Preferences Help Personalize Page Close Window About this Page Privacy Statement Copyright c 2006 Oracle Al rights reserved 44 of 70 Oracle General Ledger User Manual Version 20 0 Process to run Balance Sheet
18. 009 in Institute 156 O Submit Request Run this Request Operating Unit At these Times Upon Completid Help C te Institute 156 hss a Fund Type 000 ooo Scheme Code Enter the Name of the concurrent program name Parameters INR 01 APR 2012 31 MAR 2014 111 101 00000 531009 00000 00000 00000 999 201 00000 Name American English Language Enter the Parameters Currency cl WR Accounting Date From 01 APR2013 Accounting Date To Flexfield From 111 101 00000 531009 00000 00000 00000 Flexfield To 999 201 00000 532005 00000 00000 00000 Lal A gt N J Since we want to analyze entries from all the il schemes fund types and division coming into this account we have to select it in following way Low igh Account Division Future 1 Future 2 Cancel Clear J Help 29 of 70 NE Oracle General Ledger User Manual Version 20 0 BREA ICAR Concurrent e Click on Refresh Data Program should be completed with status as Normal As shown in figure program ICAR equ E A tal Account Analysis Request shall be Report Reresnosta Find Requests J Suorita New Reg completed in status Debit Journal Credit as Completed and Request ID Parent Normal Name Phase Status 2490136 Completed Normal 2021 50354 Ir 2489595 ICAR Account An
19. 2 of 5 Next Diagnostics Preferences Help Pers About this Page Pri c 2006 Oracle All rights r 50 of 70 Oracle General Ledger User Manual Version 20 0 Process to run Income Expenditure report After giving a name to the report create a new folder 1f required Reports can otherwise be saved in an existing folder also Here select the folder in which reports are to be saved Check the radio button of that folder and click on Next Submission Parameters Publishing Parameters Storage Location Presentation Review Cancel Back DD Storage Location Location Select New Report Name INCOME amp EXPENDITURE ACCOUNT Enter the name of the report as it will be stored in the Repository Expand All Collapse All E FINAL ACCOUNTS 2013 Select Focus Name Add Folder L Reports Repository E GPF FSGs for UAT po El VAT E UAT_G amp B amp Gand BUAT 1H IASRI_NEW E TASRI_2014 de El UAT27 28 PON E UAT27MAY2013 gt E FIN_IASRI E 30 may gt Y ll 2013 de 19 JUNE 13 E User Guide E 51 of 70 Oracle General Ledger User Manual Version 20 0 Process to run Income e Click on Next to move to the next step Expenditure report ORACLE Project MIS amp FMS in Indian Council of Agricultural Research N Navigator Y Favites Diagnostics Preferences Help Personalize Page Close Window
20. Adjustments entries to be passed in GL directly Journal Entries from Oracle Receivables e Entries relating to Sales Invoices Trade Receipts entered in Receivables will be imported in General Ledger Journal Entries from Oracle Payables e Entries relating to Purchase Invoices and Payments entered in Payables will be imported in General Ledger Journal Entries from Oracle Assets e Capitalization depreciation retirement adjustment entries will be imported in General Ledger 10 of 70 y Oracle General Ledger User Manual Version 20 0 Process Overview Perform financial activities requiring journal entries Enter Journals by Audit and Accounts 2 e Do Funds Check Funds Check passed Post Journal by Audit and Accounts 11 of 70 Oracle General Ledger User Manual Version 20 0 2 Logging into Oracle Applications Navigation e Open the link for the Oracle Instance http icarerp iasri res in Logging into Oracle e Enter the Username and password as provided individual user name password to be used Password needs to be changed on Applications first time login e On logging into the application a new page consisting of the responsibilities assigned to the user and the active notifications for the user will open up Project MIS amp FMS in Indian Co UserName sandeep example michael james sm
21. D Enter Journals ICAR g Batch Status Source Category Period Batch Name Journal Name Currency Journal Debit Journal Credit Posted Manual Miscellaneous ADJ MAR Test 02 AUG 2013 18 Test INR 10000 00 10000 00 4 4 Review Batch Post Reverse Batch Requery Tax Batch Approve AutoCopy New Batch New Journal 25 of 70 Oracle General Ledger User Manual Version 20 0 y BR or ICAR 6 Concurrent Programs 6 1 ICAR Account Analysis Report Overview e ICAR Account Analysis Report gives the analysis of any account which is entered in the parameters This report will show all the entries that are being entered in this account irrespective of the source along with the User name who entered them Navigation e View gt Request Run the Concurrent e Process for running any concurrent report is same program ICAR Account Analysis 4 Oracle Applications Report File Edit AENA Folder Tools Window Help EN sos NADAR Zoom Find f ouen By Example gt nts Processes X bpliers Additional Information Record Translations Attachments tion Top Ten List summaryDetail y Suppliers Additional Information Issue ST Forms A Others a India TDS Challan 3 India TCS VAT Service Tax FBT Asia Pacific Lookups Oracle Payables AP UPLOAD WEBA
22. DI 26 of 70 UTA ICAR Oracle General Ledger User Manual Version 20 0 Concurrent program ICAR Account Analysis Report e Click on Submit a New Request O Requests O Find Requests My Completed Requests My Requests In Progress All My Requests Specific Requests Request ID Name Date Submitted Date Completed Status Phase Requestor Order By C Include Request Set Stages in Query Request ID M Select the Number of Days to View 7 l Submit a New Request i 27 of 70 Oracle General Ledger User Manual Version 20 0 Concurrent program ICAR Account Analysis Report O Requests Click Ok for submitting Single Request oR Requests O My Completed Requests O My Requests In Progress O All My Specific Submit a New Request What type of request do you want to run This allows you to submit an individual request Request Set This allows you to submit a pre defined set of requests Cancel Select the Numb Submit a New Request 28 of 70 99 Oracle General Ledger User Manual Version 20 0 BD ICAR Concurrent Enter the parameters as shown in figure program ICAR Click on Ok and again click on Submit Button and submit the request to run the report Account Analysis E Report For Example we want to analyze the flow of all the entries in Account 531
23. E EEE auavs8es deeb E bee uubyisap a ai 63 7 3 PROCESS TO CREATE A NEW FOLDER FOR STORAGE ccccsseeeeeesesesesesesesecesecececeneseseseseseeeseneseneseneseseseneseseseneseseceseceeesesecesesenecesesereceeeseseceneceneceeeceteseseseeecerereeenececeeess 68 6 of 70 gt Oracle General Ledger User Manual Version 20 0 BRA ICAR 1 Introduction 1 1 About this document This document covers the above mentioned contents of the following module General Ledger The document has been developed by the IBM Team based on the inputs from the ICAR Team 7 of 70 e Y Oracle General Ledger User Manual Version 20 0 aTa ICAR 1 2 Envisioned Chart of Accounts COA Structure Process Map A Natural ras Division Future 1 Future 2 Segment Remarks Intended to Capture Institute Name Institute Proposed Balancing Segment Fund Type Intended to capture Plan Non Plan AP CESS etc Scheme Intended to capture Scheme Number Division Intended to capture Division Natural Account Natural Account Value Futurel For future use Future2 For future use 8 of 70 N Oracle General Ledger User Manual Version 20 0 A aTa ICAR 1 3 Important Keyboard shortcut Function Purpose Keyboard Shortcut Enter into query mode F11 Query with partial information Prefix or suffix with Execute query CTRL F11
24. GA Sh Harpal SO Cash I Sh Dilip Roy CASH DISBURSEMENT Sh SK Behera DS GAC Sh Rajiv Mangotra DS P Smt Rashmi Rao Deputy Director Finance Sh GP Sharma DDF Sh S K Pathak SF amp AO Sh S K Sharma F amp AO Smt Sunita Arya SF amp AO Smt Rajashree Sunil US Tech amp WS Sh Naresh Kumar Arora F amp AO Edn Sh Kanhaiya Lal Chowdhary DS Edn NDRI Karnal Sh J K Kewalramani JD Admn amp Registrar Sh Vishal Acharya AF amp AO Sh Brahm Parkash AAO Sh S George CF amp AO General Ledger User Manual Version 20 0 2 of 70 CIFE MUMBAI Sh Suresh Chandra CF amp AO Sh Suresh Kumar CAO Dr S Jahageerdar Officer In Charge IT NAARM Hyderabad Sh Sanjay Kant JD Admn amp Registrar Sh Jakir Hussain Khilji F amp AO CMFRI Sh Rakesh Kumar CAO Sh AV Joseph SF amp AO CRIJAF Sh K P Nath F amp AO Sh M K Pachauri SAO Dr D Barman Scientist NBPGR Sh B K Bansal F amp AO Sh S K Sinha SAO IARI Sh Radhey Shyam CF amp AO Sh P K Jain CAO DKMA Sh Himanshu Scientist DIPA ICAR Sh Naresh Kumar Arora F amp AO Edn General Ledger User Manual Version 20 0 NAIP Sh S Bilgrami CF amp AO Sh Kumar Rajesh US IVRI Sh Pankaj Kumar Joint Secretary ICAR REC Sh Pushapanayak CAO General Ledger User Manual Version 20 0 3 of 70 Date of Release Client Project Author Reviewer Approved by Control Assurance by
25. General Ledger User Manual Version 10 0 i 1 aye Vd lt NS NS 3 Y op INA General Ledger User Manual Implementation of Management Information System MIS Including Financial Management System FMS ICAR Version No 20 0 ty INDIAN AGRICULTURAL STATISTICS RESEARCH INST amp OR 7 N INDIAN COUNCIL OF AGRICULTURAL RESEARCH A eid 3 V LIBRARY AVENUE PUSA NEW DELHI 110012 BESS E ICAR WWw lasri res in o ad 2013 General Ledger User Manual Version 20 0 Mission Leader Dr N S Rathor DDG Engg IASRI New Delhi Lead Institute Dr A K Choubey HoD CA Dr Alka Arora Sr Scientist Dr Sudeep Marwaha Sr Scientist Smt Shashi Dahiya Scientist Sh Dr Sh Sh Sh S N Islam Scientist Anshu Bhardwaj Scientist Soumen Pal Scientist till 30th September 2012 A P Sharma S F amp AO K P S Gautam SAO IBM Team Sh Sh Sh Sh Sh Sh Sh Sh Sh Amit Bothra Sameer Sachdeva Anil Sharma Ravi Kant Singh Navroz Singh Dhillon Pushpendu Roy Sapthagiri Srirangam Amarnath Vankadara Himanshu Garg Smt Sneha Yadav Sh Sh Sourabh Kumar Nitin Batta Smt Lakshmi Sowmya General Ledger User Manual Version 20 0 Project Team List of Resource Personnel ICAR Sh Devendra Kumar Dir F Sh Sanjay Gupta Dir A till July 2012 Sh J Ravi Dir P Dr AK Vasisht ADG PIM ESM Ms Namrta Sharma DS P Sh Rupesh Sharma SO
26. ICAR Process to run Balance Sheet Oracle General Ledger User Manual Version 20 0 Select the report name by clicking on the Radio Button and then Select Search and Select Report Name Sarh To find your item select a filter item in the pulldown list and enter a value in the text field then select the Go button Search By Report Name BALANCE Sheet Go Select Quick Select Report Name a BALANCE SHEET Report N o ES ET OF GPF amp CPF About this Page canal Gea Y 36 of 70 ICAR Oracle General Ledger User Manual Version 20 0 Process to run Balance Sheet e Enter the Period and other details shall come automatically e Now in additional parameters click on the Magnifier button to open the screen M Navigator Y BF Favorites w Diagnostics Preferences Help Personalize Page Close Window Submission Parameters Publishing Parameters Storage Location Presentation Review Submission Parameters SS L Indicates required field Step 1 of 5 Primary Parameters Define Ad Hoc Reports PPP ReportName BALANCE SHEET q Content Set X Period ADJ MAR 13 a Display Set a Row Order Date 31 Mar 2013 Currency INR y Rounding Option Calculate Then Round Y Ledger ICAR Q Flag Exceptions Additional Parameters Segment Override CD Scheduling Options Cancel step 10f5 Diagnostics Preferences Help Pers bout this Page
27. agnostics Home Logout Preferences Indicates required fed Tmefame ADJ MAR 13 e YE Diagnostics Home Logout Preferences About this Page Privacy Statement Copyright c 2006 Oracle All rights reserved e Following message will appear Do not close the window since the report generation is in process This message may not come if report manager does not take much of time to create a report Project MIS amp FMS in Indian Council of Agricultural Research 1 Processing Create Document Your document is being generated Do not close this window until Excel Template Editor is ready Copyright 2005 Oracle Corporation All rights reserved 66 of 70 Oracle General Ledger User Manual Version 20 0 Process to View Saved Reports e Following confirmation comes when the required report is being already generated in the required format as asked for e Open that report form your taskbar which will keep on flashing once the report is generated Project MIS amp FMS in Indian Council of Ag P Confirmation Your document has been created x BALANCE SHEET 2013 xlsx 67 of 70 Oracle General Ledger User Manual Version 20 0 BR ora ICAR 7 3 Process to Create a New Folder for Storage Process to Create a e All the reports that are being run through report manager have to be saved in some folder New Folder for e To create a new folder click on Add folder button
28. al Open 20 of 70 e Y Oracle General Ledger User Manual Version 20 0 UT A ICAR Posting of Manual Journals e In the Post Journals screen you will find all the journals that have not been posted e Steps 1 Select the journal to be posted 2 Preview the journal batch by clicking on the Review Batch This will be applicable if the query screen returns a journal batch and not a single journal 3 Post the journal or the journal batch by clicking on Post button Post Journals Total Entered Balance E Period Batch Type Debit Credit Control Total Batch Information Post Status Postable Batch Status Requires funds reservation Review Batch Open 21 of 70 S URT A ICAR Oracle General Ledger User Manual Version 20 0 Posting of Manual Journals 1 A concurrent request will be submitted 2 Click on Ok O Post Journals ICAR BEE Total Entered Balance Period Batch Type Debit Credit Control Total ADJ MAR 14 Test O2 AUG 2013 18 1038 Actual 1000000 tg0n 00 O O O O O O E Your Posting concurrent request ID is 2488876 Ey Batch Information Post Status Postable Batch Status Requires funds reservation Review Batch Post 22 of 70 o Y Oracle General Ledger User Manual Version 20 0 5 Journal Inquiry Navigation e Login gt General
29. alysis Re Completed Normal 2021 50354 INR 2013 07 01 2409594 ICAR PENSION Reconcilia Completed Normal IARI APR 13 2489593 ICAR PENSION Reconcilia Completed Normal IARI APR 13 2489592 ICAR PENSION Reconcilia Completed Normal IARI APR 13 2409577 ICAR PENSION Reconcilia Completed Normal IARI APR 13 2489559 ICAR PENSION Reconcilia Completed Normal IARI APR 13 Click on 2489558 ICAR PENSION Reconcilia Completed Normal IARI APR 13 View output 2489520 ICAR Account Analysis Re Completed Normal 2021 50354 INR 2013 07 01 2488876 Posting Single Ledger Completed Normal 2021 1000 50354 3426 Hold Request View Details J View Output Cancel Request Diagnostics Wiew Log gt Review Journal Review Batch Post Reverse Batch Requery New Journal New Batch Tax Batch Approve AutoCopy e To View the result click on View output ICAR Account Analysis xIsx 30 of 70 Oracle General Ledger User Manual Version 20 0 6 2 Process to run Trial Balance Concurrent program Trial Balance 5 e Process to run any concurrent program is same e Select Trial Balance in the Name of the report and enter the parameters Run this Request Name Operating Unit Parameters Language At these Times Run the Job Upon Completion Layout Notify Print to Help C Trial Balance American English As Soon as Possible Enter the page break segment as Institute
30. ault Post AutoCopy Batch Approve Line Drilldown l T Accounts SSS Check Funds Reserve Funds View Results Change Period Change Currency 16 of 70 BRE ICAR Oracle General Ledger User Manual Version 20 0 Creation of Manual Journals Entering Header Section of a Journal Steps 1 Journal Enter the Journal Name If left blank system will generate a running manual number 2 Period Select the Period in which the general needs to be entered 3 Category Select Miscellaneous for adjustment journals as shown below 4 Effective Date Enter the date on which the Voucher is to be accounted 5 Description Enter the Narration for the voucher in the Description field In the Detailed section the adjustment entry needs to be passed Entering Detail Section of a Journal Steps 1 Line Give first line as number 1 and the credit line as number 2 2 Account Enter the amount to be debited credited in the respective fields Which account is to be debited credited will depend upon the adjustment to be done Click on account to select the correct code combination 3 Description You can additionally enter the description for individual line item 4 Debit Credit Enter the amount Since it is passing of a journal entry only the total of debit and credit shall match to pass a successful journal For example an invoice shall be booked under the head Postage and Telegram but
31. avigator y Favorites w Diagnostics Home Logout Preferences Help 9 D D z p Submission Parameters Publishing Parameters Storage Location Presentation Review Submission Parameters Indicates required field Cancel Step 1of5 Next Primary Parameters _Define Ad Hoc Reports Report Name INCOME amp EXPENDITURE AG a Content Set a Period ADJ MAR 13 a Display Set a Date 31 Mar 2013 E Row Order a Currency INR y Rounding Option Calculate Then Round Ledger ICAR Q Flag Exceptions fverride ICAR2021 INR 554 0000 Scheduling Options Cancel Step 1 of 5 Gar y Copyright c 2006 Oracle All rights reserved Diagnostics Home Logout Preferences Help About this Page Privacy Statement 49 of 70 Oracle General Ledger User Manual Version 20 0 ICAR Process to run e Instep 2 of 5 the Default template will come Income amp e Click on Next Expenditure report ORACLE Project MIS amp FMS in Indian Council of Agricultural Research M Navigator Y BF Favorites Diagnostics Preferences Help Personalize Page Close Window y I es Submission Parameters Publishing Parameters Storage Location Presentation Review Publishing Parameters Indicates required field Step 2 of S _ Primary Parameters a ae coe aa o f Default Template INCOME 8 EXPENDITUR Timeframe ADJ MAR 13 a Set Auto Archive No a Security x Availability Cancel Back Step
32. e where you can save the reports 69 of 70 Oracle General Ledger User Manual Version 20 0 ADA ICAR A _ _ _ _ _ _ __ __ _ ___ ___ _______________ Process to Create a e Here you can select the folder in which reports are to be saved New Folder for e Check the radio button of that folder and click on Next Storage e You can see the folder that is created is appearing in the following screenshot Cancel Back Step 3 of5 Next Location Used Saved Select New Report Name BALANCE SHEET 2013 Enter the name of the report as it will be stored in the Repository Expand Al Colapse Al 4 Select Focus Name Add Folder z Reports Repository LH GPF FSGs for UAT 4 LH 19 JUNE 13 User Guide Du Y LH UAT_G8B lt gt E Gand BUAT dy E TASRI_NEW dy E ASRI 2014 4 LH UAT27 28 y LH UAT27MAY2013 dy E FN ASRI E 30may 4 2013 70 of 70
33. earch N Navigator Y Fanrtes Y Diagnostics Preferences Help Personalize Page Close Window y 0 OH Submission Parameters Publishing Parameters Storage Location Presentation Review Storage Location Location Used Saved 0 Select New Report Name BALANCE SHEET 2013 Enter the name of the report as it wil be stored in the Repository Expand Al Colapse Al q Select Focus Name Add Folder Reports Repostory i Diagnostics Preferences Help Personalize Page Close Window Canca sepa Net About this Page Privacy Statement Copyright c 2006 Oracle Al rights reserved 41 of 70 ICAR Oracle General Ledger User Manual Version 20 0 Process to run e Give a name to the folder that you want to create and click on Apply Balance Sheet ORACLE Project MIS amp FMS in Indian Council of Agricultural Research N Naig ES Fontes Y Diagnoses Preferences Personae Page Close Window Storage Location Add Folder foer aL ACCOUNTS 201 gt Diagnostics Preferences Personalize Page Close Window About this Page Privacy Statement Copyright c 2006 Oracle AI rights reserved e Jt would create a folder with this name where you can save the reports 42 of 70 Oracle General Ledger User Manual Version 20 0 BRA ICAR Process to run Balance Sheet After giving a name to the report create a new folder if required Reports can otherwise be
34. eferences Help Submission Parameters Publishing Parameters Storage Location Presentation Review Publishing Parameters DE Indicates required field Step 20f5 Default Tempate bcheduera2 Y Tmefame q Set Auto Archive No y a Security Availabilty cane ak Sep 25 Net Diagnostics Home Logout Preferences Help About this Page Privacy Statement Copyright c 2006 Oracle All rights reserve 58 of 70 Oracle General Ledger User Manual Version 20 0 EE Process to run e After giving a name to the report create a new folder if required Schedules forming e Reports can otherwise be saved in an existing folder also part of Annual e Here select the folder in which reports are to be saved Accounts e Check the radio button of that folder and click on Next v w Submission Parameters Publishing Parameters Storage Location Presentation Review Storage Location Cancel Back Step3of5 Next Location 0 Select New Report Name Schedule 1 8 2 Enter the name of the report as it will be stored in the Repository Expand Al Colapse Al Select Focus Name Add Folder gt Reports Repository g E GPF FSGs for UAT UAT E UAT_cas 4 Gand B UAT de TASRI_NEW TASRI_2014 E UAT 27 28 gy E UAT27MAY2013 E FIN_IASRI gt 30 may 821 19 JUNE 13 User Guide e g FINALACCOUNTS 2013 59 of 70
35. epository Management P Favorites Y Diagnostics Logout Preferences Help Logged In As MIRAZUDDIN Favorites You have not selected any favorites Please use the Personalize button to set up your favorites Full List Sent 55 of 70 Oracle General Ledger User Manual Version 20 0 Process to run Schedules forming part of Annual Accounts e Following screen shall open in a new window e In Report Name search the name of the report using Click on Magnifier glass button It is used for making a search Select the required report and click on Ok Aes Review Submission Parameters Submission Parameters Indicates required field OR ACLE REPO MANAGER gt in Indian Council of Agricultural Research Publishing Parameters Navigator Favorites w Storage Location Presentation Diagnostics Home Logout Preferences Help Cancel Step 1of5 Next About this Page Privacy Statement Report Name Schedule 1 y Content Set J Period Loading g Display Set y Date El Row Order Currency INR y Rounding Option Calculate Then Round y Ledger ICAR j e Flag Exceptions Segment Override Ee Scheduling Options Diagnostics Home Logout Preferences Help Cancel Step 1of5 Next Copyright c 2006 Oracle All rights reserved 56 of 70 Oracle General Ledger User Manual Version 20 0 BRE ICAR Process to
36. ion Process to View Saved Reports Project MIS amp FMS in Indian Council of Agricultural Research Favorites Y Diagnostics Logout Preferences Help Logged In As MIRAZUDDI Oracle Applications Home Page Worklist Favorites You have not selected any favorites Please use the Personalize button to set up your favorites From Subject Sent There are no notifications in this view REPORT MANAGER E Financial Report Template Editor Financial Report Submission E Standard Report Submission Diagnostics Logout Preferences Help Copyright c 2006 Oracle All rights reserve bout this Page Privacy Statement 63 of 70 ICAR Oracle General Ledger User Manual Version 20 0 Process to View Saved Reports e Rrepository management screen is the screen which will store all the reports which are ever generated from report manager It is a repository of the reports e Click on the button to explore all the available folders Now look for the folder in which the report was saved ORACLE REPOR MANAGER in Indian Council of Agricultural Research Repository Management Delete Select Al Select None Expand Al Colapse Al 9 Select Focus Name View Create Menu Item Update Move Secure Add Folder g E Reports Repository S Navigator w Favorites w Diagnostics Home Logout Preferences Help Maintain Repository View Archives Maintain Repositor
37. ith AD Password goeeeeeees example 419923 Login Cancel Login Assistance Accessibility None v ICAR Select a Language English 12 of 70 NS Oracle General Ledger User Manual Version 20 0 VRE ora ICAR 3 Creation of Manual Journals Purpose The purpose to create manual journals in General Ledger is mainly for passing adjustment entries This is required when an incorrect treatment is being done in some other sub module and accounting is done Following is the way to pass a journal Journal General Ledger will create a batch for each journal entry automatically using the source Manual combined with a unique batch ID and the system date 13 of 70 e Y Oracle General Ledger User Manual Version 20 0 URT A ICAR Creation of Manual Journals e Login gt General Ledger Super User gt Journals gt Enter e Click on Open or Enter on the Keyboard AY Navigator General Ledger Super User AEREA Documents Processes Journals Enter generate and post actual and encumbrance journals Top Ten Ls Other BUDGET UPLOAD EFC ITEM LISTING FORM EFC BUDGET UPLOAD Budgets amp Inquiry gt Currency gt mr Consolidation Report f eports ra _ amp Setup Call 14 of 70 NE HDI ICAR Oracle General Ledger User Manual Version 20 0 Creation of Manual Jour
38. mpleted in status Journal Credit Request ID Parent as Completed and 2 Name Phase Status aro Normal 9 2554314 Completed Normal AR2021 INR 2490136 ICAR Account Analysis Re Completed Normal 2021 50354 INR 2013 04 01 2489595 ICAR Account Analysis Re Completed Normal 2021 50354 INR 2013 07 01 2489594 ICAR PENSION Reconcilia Completed Normal IARI APR 13 2409593 ICAR PENSI N Reconcilia Completed Normal IARI APR 13 2489592 ICAR PENSION Reconcilia Completed Normal IARI APR 13 Click 2489577 ICAR PENSION Reconcilia Completed Normal IARI APR 13 ICS ON a View output 2489559 ICAR PENSION Reconcilia Completed Normal IARI APR 13 2489558 ICAR PENSION Reconcilia Completed Normal IARI APR 13 2489520 ICAR Account Analysis Re Completed Normal 2021 50354 INR 2013 07 Y Hold Request View Details Wiew Output Cancel Request Diagnostics Wiew Log Review Journal Review Batch Post Reverse Batch Requery New Journal New Batch Tax Batch Approve AutoCopy Trial_Balance txt 33 of 70 S Oracle General Ledger User Manual Version 20 0 RB oa ICAR 7 Report Manager For Running Financial Reports 7 1 Run Reports 7 1 1 Balance Sheet Navigation Reports Manager gt Financial Report submission Process to run Balance Sheet Project MIS amp FMS in Indian Council of Agricultural Research Favorites Y Diagnostics Logout Preferences Help Logged In As MIRAZUDDIN Oracle Applications H
39. nals O Enter Journals ICAR BEE A gt e To create a new Journal click on New Journal e Journal screen will open Batch Status Source O Find Category _ Journals Batch Journal Ledger l Source Category Status Posting Funds Period Batch Name Period Currency po Control Total Batch Journal JouralName Currency JoumalDebit Clear CT TIA Journal Credit Review Journal Review Batch Post Reverse Batch Requery New Journal New Batch Tax Batch Approve AutoCopy 15 of 70 Oracle General Ledger User Manual Version 20 0 Save Button Creation of Manual Journals ES AA was ar rr ETE JE gS Naor mm JO E Journals ICAR Tes Journal Test Conversion Reverse Description Currency INR Date Ledger ICAR Category Miscellaneous Date 31 MAR 2014 Period Period ADJ MAR 14 Effective Date 31 MAR 2014 Type User Method Switch Dr Cr F Balance Type Actual Header Section Rate 1 Status Not Reversed aring Company _ Lax Not Required ee Reverse Control Total l Other Information iv Liye Account i Debit INR Credit INR Description ul 1 1156 201 00000 532005 00000 00000 0001 10000 00 2 10000 00 10000 00 4 Acct Desc IARI PUSA NEW DELHI Non Plan Default Repairs amp Maintenance Fu Default Default Def
40. of Agricultural Research N Navigator Y Fanrtes Diagnostics Preferences Personalize Page Close Window H Confirmation The report BALANCE SHEET has been submitted with request id 2557032 rst T Diagnostics Preferences Personalize Page Close Window About this Page Privacy Statement Copyright c 2006 Oracle Al rights reserved 46 of 70 N Oracle General Ledger User Manual Version 20 0 7 1 2 Income amp Expenditure Navigation e Reports Manager Financial Report submission Process to run Income amp Project MIS amp FMS in Indian Council of Agricultural Research Pop ena ener Favorites Y Diagnostics Logout Preferences Help Logged In As MIRAZUDDIN Oracle Applications Home Page Workiist Favorites You have not selected any favorites Please use the Personaize button to set up fe your favorites Full List From Subject Sent There are no notifications in this view Navigator _ REPORT MANAGER REPORT MANAGER E Financial Report Template Editor Financial Report Submission Standard Report Submission 3 Repostory Management 47 of 70 Oracle General Ledger User Manual Version 20 0 Process to run e Following screen shall open in a new window Income amp e In Report Name search the name of the report using Expenditure report e Click on Magnifier glass button It is used for making a search and select Income amp Expenditure
41. ome Page Worklist Favorites You have not selected any favorites Please use the Personalize button to set up your favorites Full List From Subject Sent There are no notifications in this view Navigator C REPORT MANAGER REPORT MANAGER Financial Report Template Editor Financial Report Submission 8 Standard Report Submission Repostory Management 34 of 70 Oracle General Ledger User Manual Version 20 0 ICAR Process to run e Following screen will open in a new window Balance Sheet e In Report Name search the name of the report using e Click on Magnifier glass button It is used for making a search ORACLE Project MIS 8 FMS in Indian Council of Agricultural Research Navigator Y P Fav y y J Y Submission Parameters Publishing Parameters Storage Location Presentation Review Submission Parameters Indicates required field Cancel Step 1 of 5 Next Primary Parameters Define Ad Hoc Reports Content Set 4 Display Set A Date a Row Order a Currency INR y Rounding Option Calculate Then Round Ledger ICAR a Flag Exceptions Additional Parameters Segment Override a Scheduling Options Cancel Step 1of5 Next Diagnostics Preferences Help Personalize Page Close Window About this Page Copyright c 2008 Oracle All rights reserved 35 of 70 ur
42. s cate cess AEE a tias 10 2 LOGGING INTO ORACLE APPLICATIONS siccssccecstsccssvstocssevsensssevscceseetascessvedsesssedsesesseesesedesdcssesdessbendsedsestdcessesesesbessesssusteossebseossensccesosdeccesdeasseedsedsssedeessosececvesssees 12 3 CREATION OF MANUAL JOURNALS wssiisssciicsssccssesssceiscsaseossvsssssersssssssccesdsbeccesessessesssbessesss ceseeascsesesasssesusoesosssssesscenscoseveadeossssesdsbondesssssstoadsbecessesssssesdsboesesss anseousss 13 4 POSTING OF MANUAL JOURNALS sscsssssisssesscsssscsscsssscssvsecsosavsasessessssssscctesssbscissesvessesesdessesssbicsessacoesesassessvsoesoesssseiscenssosevbessosessesssboc ssssbssbeassbsscsossbessesseceesesssbaseeesess 19 5 JOURNAL ENQUIR Y E A A NN N A NA E E N A 23 6 CONCURRENT AAA A O 26 6 1 ICAR ACCOUNT ANALYSIS REP dial 26 6 2 PROCESS TO RUN TRIAL BALANCE A ai 31 7 REPORT MANAGER FOR RUNNING FINANCIAL REPORT sscsccssssscccssscecessscccssssccecssceccesnsccccsssscccessncecsessccsessaccsessceccesnaceccesnecscessnseceesscceccesscecessnees 34 7 1 RUNREPORES E TE A EEEE E EEEE ENEE EET EEE EAEE EET 34 7 1 1 BG ONGC ANIA A EAEE E A E E teaver EET IEEE E E E EE AEE E E E AE 34 7 1 2 Income E Expendit te srme ieie E EEE E E EEN E EO EEEE AEE EN EREE ENEE E A A NEE EEA E A E EENE AER 47 7 1 3 Schedules forming part of Annual ACCOUNTS ooinnniinnninniinni RR RR RARA RAR RAR RAR RRA RR RR RR RR Reena cananea nenas 55 7 2 PROCESS TO VIEW SAVED REPORTS is cies sess da bass cade ah a
43. y View Archives Diagnostics Home Logout Preferences Help About this Page Privacy Statement Copyright c 2006 Oracle All rights reserved 64 of 70 Oracle General Ledger User Manual Version 20 0 Process to View Saved Reports e Again click on button to view all the stored reports in that particular folder e Click on the output button a RACLE REPORT MANACER OO in Indian Council of Agricultural Research Navigator E Diagnostics Home Logout Preferences Help Repository Management Maintain Repository View Archives Archive Delete Select Al Select None Expand All Collapse Al Reports Repository gt Select View Create Menu Item Update Move Secure Add Folder E ACCOUNTS 2013 E a nl its AD LE 2 10 a D Maintain Repository View Archives Diagnostics Home Logout Preferences Help bout this Page Privacy Statement button Copyright c 2006 Oracle All rights reserve 65 of 70 Oracle General Ledger User Manual Version 20 0 Process to View Saved Reports Here you can select the format in which you want the report to be generated The reports can be generated in Excel PDF and HTML formats Click on the desired symbol To generate report in excel format click on excel symbol as shown OR ACLE REPORAMANA CERO in Indian Council of Agricultural Research Navigator Favorites Y Di
Download Pdf Manuals
Related Search