Commitment Control Budget Transaction Detail Report
Contents
1. 1 After clicking Run the Process Scheduler Request screen will appear Make sure Server Name is PSNT and Type is Web and Format is PDF Click ox Process Scheduler Request User ID Dhi Run Control ID Budget_Transaction_Detail Server Name 5 a 12 34 2008 en me g 15 44AM Reset to Current Date Time Time fone a Process List Select Description Process Name e Type a oe i Budget Transaction Detail Rep GL58005 Web 2 This will return you to the initial criteria entry screen You should now have a Process Instance number this tells you that the report is running To access the report click on the Process Monitor link Commitment Control Budget Transaction Detail Repor Run Control ID Budget Transaction Detail report Manag Frocess Monitor 2 Language English Process Instance 4874245 Report Request Parameters INDSU1 North Dakota State University January 15 2009 Budget Transaction Detail Report 10 Running Reports 3 You cannot access the report until your Run Status is Success and the Distribution Status is Posted To update the Run Status click on the _Refresh_ button This will show you the most recent Run Status for your report Clicking on the _Retresh_ button does not speed along the process 4 Once you have a status of Success and Posted click on the Details link Process List List Server List List2. JOURNAL IDB0556349 04 08 2008 Data Processing Sup 05 13 2008 GL BD JRNL me fae a Veal eel fa PH pod pod pod pa pad a 05 27 2008 GL JO IDBA93221 06 30 2008 GL JOURNAL IDBA94283 07 08 2008 GL JOURNAL IDB0559230 07 08 2008 GL JOURNAL IDB0559350 05 27 2008 Software Licenses U 06 30 2008 Data Processing Sup 06 30 2008 Software Licenses U 06 30 2008 Data Processing Sup oooooocoeoeoecoeoc oo ooooococococceocnea a ae Ee Oe ee ee ee oooooo0co0co0c0c0c 0c0ca HHH Number of Transactions 13 Totals January 15 2009 Budget Transaction Detail Report 13
3. LD ee or January 15 2009 Budget Transaction Detail Report 2 Accessing an Existing Run Control ID Once you ve established a Run Control all future searches with that particular Run Control will be accessed though the Find an Existing Value tab To find an existing Run Control 1 Click on the Find an Existing Value tab Your screen should now look like the one below Example Find an Existing Value Add a New Value Run Control ID begins with I Case Sensitive 2 Click on the Search button to select a ee Search Results previously created Run Control ID irst 4 1 14 0f14 p a un Contro N Budget Transaction Detail Enalish COPY JOURNAL English DELETE RC English GL Activity English JOURNAL EDIT English ournal Entry Detail English edger Activity English English English English English Trial Balance English gt My Favorites Budget Transaction Detail gt Supplier Contracts Enter any jofoomation you have and click Search Leave fields blank for a list of all values gt Customer Contracts gt Vendors gt Purchasing t eProcurement gt Services Procurement gt Grants t Program Management gt Project Costing Billing t Accounts Receivable t Accounts Payable gt Asset Management Find an Existing Value Add a New Value gt Banking 7 Commitment Control t Budget Journals t Review Budget Activities lt Budget Reports Budgets Actuals Reconciliat
4. Status Budget Control Report Budget Periods Report Budget Status Budget Transaction Detail Ledger Details gt Review Budget Check Exceptions January 15 2009 Budget Transaction Detail Report 1 Find an Existing Value Add a New Value L Case Sensitive Establishing a New Run Control ID Some notes on Run Controls They only need to be set up the first time you run a report They re required when running reports in Oracle They cannot contain spaces between words dashes or underlines may be used in its place To create a New Run Control 1 Click on the Add a New Value tab Your screen should now look like the one below 2 Type a name for your Run Control ID It is Example recommended to use a name that is similar to the report you are running like Budget Transaction Detail Run Control ID Budget_Transaction_Detail Add Budget_ Transaction Detail 3 Click on the Add button when finished gt My Favorites gt Supplier Contracts gt Customer Contracts gt Vendors A gt Purchasing _ eae gt eProcurement i ID Type a Name E Services Procurement gt Grants gt Program Management gt Project Costing gt Billing gt Accounts Receivable gt Accounts Payable gt Asset Management Find an Existing Value Add a New Value gt Banking 7 Commitment Control gt Budget Journals gt Review Budget Activities Who coat
5. 27 2007 Motor Aircraft Pool 133 11 28 2007 GL JOURNAL FAMIS 11 27 2007 Motor Aircraft Pool 133 11 28 2007 GL JOURNAL FAMIS 11 27 2007 Motor Aircraft Pool 133 02 13 2008 AP VOUCHER 00323567 Adams Ramona D AIRLINE TICKET 528 02 26 2008 GL JOURNAL FAMIS 02 26 2008 Motor Aircraft Pool 41 03 12 2008 GL JOURNAL PROCARD 02 29 2008 Registration Fees 04 08 2008 AP VOUCHER 00337088 Adams Ramona D MAR TRAVEL 04 08 2008 AP VOUCHER 00337088 Adams Ramona D MAR TRAVEL 04 08 2008 AP VOUCHER 00337088 Adams Ramona D MAR TRAVEL 05 13 2008 GL BD JRNL 05 22 2008 AP VOUCHER 00350332 Semmens Theresa Y MAY TRAVEL 05 22 2008 AP VOUCHER 00350660 TREASURY INSTITUTE FOR HIGHER 06 24 2008 AP VOUCHER 00359849 Wawers Gary Lynn PERSONAL PAYE E E E oocoooooooooo0oo0oo0o0 D R EE E a eee oocoocoocoocooocoooo0oo0oo0oo0oo0 Number of Transactions Totals Currency Account USD 531000 Budget Total Recognized Total Collected Pre Encumbered Expended Override Override Post Date Transaction Document ID t TR User BD User 11 28 2007 GL _ JOURNAL IDBA88780 11 28 2007 Data Processing Sup 11 30 2007 GL JOURNAL IDB0551530 11 30 2007 Software Licenses U 12 06 2007 GL JOURNAL IDBA88694 12 06 2007 Data Processing Sup 01 07 2008 GL JOURNAL IDB0553584 01 07 2008 Software Licenses U 01 07 2008 GL JOURNAL IDBA89035 01 07 2008 Data Processing Sup 02 04 2008 GL JOURNAL IDB0554023 02 03 2008 Software Licenses U 03 18 2008 GL JOURNAL IDBA91193 03 18 2008 Data Processing Sup 04 08 2008 GL
6. Commitment Control Budget Transaction Detail Report This report is used to view detail on transactions that have posted against a budget or fund Navigation Path gt Commitment Control gt Budget Reports gt Budget Transaction Detail This will bring you to the Budget Transaction Detail screen where you have the option to find an existing Run Control ID or add a new Run Control ID Favorites link in the upper right hand corner of your screen By doing this it creates a This would be a good time to add this to your favorites by clicking on the Add to shortcut for this report in the Menu under My Favorites It also eliminates the need to remember the Navigation Path every time you want to run this report ORACLE Menu gt My Favorites Budget Transaction Detail gt Supplier Contracts Enter any information you have and click Search Leave fields blank for a list of all values gt Customer Contracts Vendors gt Purchasing gt eProcurement gt Services Procurement Run Control Ds begins with gt Grants Program Management gt Project Costing ae Search Clear Basic Search B Save Search Criteria gt Accounts Receivable b Accounts Payable gt Asset Management Find an Existing Value Add a New Value gt Banking 7 Commitment Control t Budget Journals t Review Budget Activities Budget Reports Budgets Actuals Reconciliation Budget Attributes Report Budget Checking
7. PC Bus Unit Subsystem Activity ID PC Business Unit ss Glass Field Activity subsystem Analysis Type Operating Unit Program Code Project Source Type Statistics Code T aAa AAA ulm m Le Ld Ma E Save E Return to Search E Previous in List January 15 2009 Budget Transaction Detail Report Entering your search criteria 10 Now that you have selected your search criteria and entered your search values you will want to indicate how you want your report sorted in the Sequence area This is where you can tell the report how to sort your information In the example below the report will be sorted by Account first Fund Code second Department third and Budget Period last Click B save when finished Now you re ready to run your report Click the Run button at the top right of your screen i m ChartField Selection Customize Find First 4 1 15 of 15 Lr Last Sequence ChartField Name a To Value lt I jg 1 Account x 2 Fund Code x 3 Deparment x Budget Period Subsystem PC Bus Unit Subsystem Activity ID PCBusiness Unit ss Glass Field Activity subsystem Analysis Type Operating Unit Program Code Project source Type Statistics Code 5 5 E Save E Return to Search tE Previous in List E Next in List Notify January 15 2009 Budget Transaction Detail Report Running Reports
8. View Process Request For User ID imkuppich Q Type Last T Days l Server Name QU instance to Run Distribution M Save On Refresh Status Status Process List Customize Find View Select Instance sen Process Type E luser Run Date Time E 45 4245 SQR Report GLS8005 mkuppich 12 37 2008 9 15 444M CST E 4868792 Crystal APY2001 mkuppich 12 24 7006 9 40 54AM CST Success ne oy a im rp Fa Lok i L aoa Oma wee in al r E E an a a l D i E A a i d HIH HA hl oT Succes January 15 2009 Budget Transaction Detail Report ann a aes Distribute Status Details 11 Running Reports 5 On the Process Detail page click on the View Log Trace link This brings you to the View Log Trace page Process Detail Instance 4674245 Type SOR Report Name GLS8005 Description Budget Transaction Detail Rep Run Status Success Distribution Status Posted Update Process Run Control ID Budget_Transaction_Detail Hold Request Location Server Queue Request Sever PSNT Cancel Request Delete Request pial ala Restart Request Request Created On 12 31 2008 9 30 22AM CST Parameters Transfer Run Anytime After 12 31 2008 9 15 444M CST Message Log Began Process At 13 31 2008 9 30 36AM CST Ended Process At 12 31 2008 9 30 57AM CST View Log Trace 6 To retrieve the report click on the PDF link Distribution Details Distribution Node NT Expiration Date 03 01 2009 File List File Si
9. ion Budget Attributes Report Budget Checking Status Budget Control Report Budget Periods Report Budget Status Budget Transaction Detail Ledger Details gt Review Budget Check Exceptions January 15 2009 Budget Transaction Detail Report Basic Search El save Search Criteria Entering your search criteria 1 Unit should always be NDSU1 2 Choose the Ledger Group by using the lookup glass Choosing the wrong ledger group could result in little or no information on report 3 The Transaction Type Option has All or Specify to choose from in the drop down Choosing All will return every transaction related to that value or values in the ledger group chosen If Specify is chosen you will need to choose a Type from the drop down and only transactions related to that type will be returned 4 User Budget Overrides should not be checked Commitment Control Budget Transaction Detail Report Run Control ID Budget Transaction Detail Report Manager Process Monitor Run English Report Request Parameters INDSU1 North Dakota State University FNDDTL P User Budget Overrides 4 3 Transaction Type Option An Type 07 01 2008 3 DateTo 12 11 2008 Commitment Control Ledger Type Commitment Control Ledger Type xl January 15 2009 Budget Transaction Detail Report B Entering your search criteria 5 The Commit Control Date Opti
10. nge January 15 2009 Budget Transaction Detail Report 5 Entering your search criteria 6 The Ledger Type Option has All or Select to choose from in the drop down Choose option All there is no need to change this option to Select 7 The Commitment Control Ledger Type should be left blank see example below di rN AOE After selecting all your Request Parameters first time users may need to click the _Refresh_ button to display Chartfield Selection Commitment Control Budget Transaction Detail Report Run Control ID Budget Transaction Detail Report Manager Process Monitor _ Run Language English Report Request Parameters Unit INDSU1 G North Dakota State University Ledger Group FNDOTL Q User Budget Overrides Transaction Type Option All Type b Commit Control Date Option Range Ledger Type Option All January 15 2009 Budget Transaction Detail Report Entering your search criteria 8 Check the boxes for the Chartfields you would like to have included in your report The most common are Account Fund Code Department Project and Budget Period Do not use the program chartfield in the selection of Chartfields because budgets are not used at the program level Click BD save when finished Including the budget period is highly recommended Using a Budget Period is particularly helpful around the end and beginning of fiscal yea
11. on has All Range or Specify to choose from in the drop down Selecting All will return every transaction related to your search criteria therefore overriding the dates in the Date From and Date To fields To identify a range of dates select Range and then enter the dates in the Date From and Date To fields Do not select Specify to select a date instead use the Range option This report goes by the posted date not the accounting date so keep that in mind when running this report Example if you wanted all transactions for a particular month in the Date To field choose a date that is a week or so into the next month to make sure you have all transactions for the month you are inquiring about In the example below the user wanted all transactions through November so they searched through 12 11 08 to make sure all transactions would be pulled into the report Commitment Control Budget Transaction Detail Report Run Control ID Budget_Transaction_Detail Report Manager Process Monitor Run English Report Request Parameters Unit NDSU1 Q North Dakota State University Ledger Group FNDDTL Q I User Budget Overrides Transaction Type Option A l Type Date from 07 01 2008 DateTo 12711 2008 Ledger Type Option Commitment Control Ledger Type Commitment Control Ledger Type E Refresh D Commit Control Date Option Ra
12. rs Since some transactions are still being done for the prior year in July using a budget period will help separate them out m ChartField Selection Customize Find F First 4 4 45 of 15 Last Sequence Charfield Name T Value To Value aa Account 2 Fund Code 8363 Department 4 BudgetPeriod o Subsystem PC Bus Unit Subsystem Activity ID o PC Business Unit Glass Field AMi o subsystem Analysis Type Operating Unit Program Code Project source Type Statistics Cade Li C1 E A cT A T O T a T E TEN ET i E Save E Return to Search E Previous in List E Next in List E Notity l Upa January 15 2009 Budget Transaction Detail Report 7 Entering your search criteria 9 Enter the values you wish to review for the Chartfields you have included in your report If a value is not specified for a Chartfield all values will be returned As shown in the example below the user wants all transactions charged to fund 30734 for all account codes in fiscal year 2009 Selecting All in the Commit Control Date Option step 5 and including the Budget Period Chartfield with a fiscal year Value and To Value will return all transactions posted to that fiscal year to date S m ChartField Selection Customize Find 1 First 1 15 of 15 Last Sequence ChartField Name Value To Value al Account 2 Fund Code 3 Department 4 Budget Period Subsystem
13. ze bytes Datetime Created GLS8005 4674245 PDF 29269 12 31 2008 9 30 57_403000AM CST et rT 12 31 2008 9 30 57 403000AM CST SOR GLS8005 4674245 log Re 1431 2008 9 30 57 403000AM CST Distribute To Distribution ID Type January 15 2009 Budget Transaction Detail Report Reading the Report Budget Post Date The date the transaction was actually posted in Oracle Transaction Type of transaction GL_JOURNAL General Ledger Journal AP VOUCHER Accounts Payable Voucher Document ID The ID or number that identifies the transaction Some ID s begin with letters Examples PAY Payroll AP Accounts Payable Voucher SF Student Finances Interface IDB Interdepartmental Billing Reference For AP Vouchers displays the Vendor Name and any information entered in the Description field on the Voucher For GL Journals displays the GL date and description Expended Amount Amount of the transaction Peoplesoft GL Report ID GLS8005 BUDGET TRANSACTION DETAIL Page No 1 Bus Unit NDSU1 North Dakota State University Run Date 01 06 2009 Ledger Grp FNDDTL Fund Detail Ledger Group Run Time 13 28 29 Post Date All Dates Tran Type All Types Currency Account USD 521000 30734 3100 Budget Total Recognized Total Collected Pre Encumbered Expended Override Override Post Date Transaction Document ID Amount Amount TR User BD User 09 20 2007 AP VOUCHER 00284311 NW NORTH DAKOTA WORKFORCE TRAI 80 11 28 2007 GL JOURNAL FAMIS 11
Download Pdf Manuals
Related Search