Home

Journal entry general ledger user manual

1. Ledgers Show YTD Balance Include Closing Adjustments Payroll Accounting G Entries MV Show Transact Only in Base Currency Max Ledger Rows 100 Enterprise Learning Mamt Acctg Generic Accounting Entries Student Fin Accounting Entries ChartField Value ChartField Value Set Update New Contributor Relations Accta Account 7 Q Q Update New Entry Event Budget Acctg Entry Event GL Adjust Department 612250000 Q Q Update New Accta i000 ae E panao Fund Code 10000 Q Q Update New Reports Class Field Q Q Update New gt XBRL gt Cash Flow Statement Program Code Q Q Update New gt General Reports gt Federal Reports Budget Reference Q Q Update New Teee Project Q Q Update New gt Reporting Tools gt Set Up Financials Supply SONORIS a Q Update New gt Tree Manager gt Vendors Bes Chartfield Criteria C i Customize Find noooood akg Click Search and the Results will be displayed ORACLE Menu V Review Financial a Information Ledger Inquiry Joumals Transaction Details Ledger Ledger Group Entries F Show Transaction Details P Only in Base Currency Max Ledger Rows 100 Enterprise Learning Student Fin Accounting Entries T Ledger Eencd iry N Unit L Fiscal Year From Period To Period Cranial Inquiry Name edger i ear From Peri o Peri Compare Across LED_INQ GSUFS ACT
2. gt General Ledger gt Set Up Financials Supply Chain gt Background Processes F VWorklist Vorklist WWorklist Details gt Reporting Tools gt PeopleTools Unit GSUFS Journal ID 0000042123 Date 04 28 2009 Home Vorklist Add to Favorites Siqn out New Window Help Customize Page a Unit Approval Check Active Approval Status Approval Action Comments for Denial Email Approval History Step Path Status 0 A Initiated 01 A Approved 02 A Approved 03 A Pending B Save GSUFS TT Pending Approval Approve w Ap p rove Recycle Date Time Stamp User ID 04 28 2009 12 40 30PM GSUUSER2 04 28 2009 12 43 42PM DA1SPEC 04 28 2009 12 45 11PM DA2SPEC 04 28 2009 12 40 30PM Previous in Worklist Refresh Header Lines Totals Errors Approval 15 Eiai EUren The Spectrum System Georgia State University Entering a Journal Entry You can notify the individual it is being sent back to via the Notify Button on the Lines Page and select their email address and detail what the issue is in the message box Worklist MultiChannel Console Add to Favorites New Window Help Customize Page amp Process Submit Journal Process I Errors Only 2 iiel 10 Unit GSUFS Journal ID 0000041977 Report Manager Process Monitor Template List Search Criteria Change Values Lines Select
3. First Process Multi Currency Line Field Name Field Long Name Set Msq Message Text gt Average Daily Balance Combe error for fields Account Program AccountProgram in group gt Open Items 41 ACCOUNT Account 9600 31 ACCT_PROG k oe 2 ACCOUNT Account 9600 44 Combo error for fields Account Program Account Program in group gt Maintain Standard AOCT_PROG Budgets b Monitor Background Process gt Review Financial Information gt Regulatory Ledger Reports gt XBRL gt Cash Flow Statement gt General Reports gt Federal Reports Header Lines Totals Errors Approval gt Project Costing gt Purchasing gt Reporting Tools gt Set Up Financials Supply Chain gt Tree Manager E E r done Home Worklist MultiChannel Console Add to Favorites Sign out New Window Help Customize Paae z gE 4 j an Customize Find 55 First 4 of 1 Last 4 2 of 2 Last If the Budget Status is Error select the E hyperlink in the Totals Section which will open a new window in Review Budget Check Exceptions so that you can review the error Once you have resolved the Budget Check error you will run the Budget Check Journal Process View All First 4 4 of LY Last Unit Total Lines Total Debits Total Credits Journal Status Budget Status GSUFS 2 55 00 55 00 V E 12 The Spectrum System Georgia State University Entering a Journal Entry Worklist MultiChannel Console Add
4. 4 40f4 L Las Unit Total Lines Total Debits Total Credits Journal Status Budget Status GSUFS 1 0 000 0 000 a N fe Save E Notify Refresh Header Lines Totals Errors Approval gt The first step for the user will be to go into the Lines section of the panel and start entering the chartfield combinations to be affected with this journal The user can also select its Soeedtype enter account number amount and journal line description Note Balancing of journal entries by fund have been replaced with PeopleSoft delivered functionality The cash offset lines will be automatically entered by the system when the journal is edited 4 1 1 Adding and or Deleting Rows Lines to add 1 E To add rows to the transaction enter the number and select the sign To delete rows from the transaction select the check box next to the line s you want to delete and select the sign Once all lines intended to be part of the transaction have been entered the user must run a few processes to complete and then send it into Workflow 10 The Spectrum System Georgia State University Entering a Journal Entry 4 1 2 Edit Budget Check Process Worklist MuttiChannel Console Add to Favorites Sign out New Window Help Customize Paae Create Update Journal Entries Header Totals SF Copy Journals E EREET Unit GSUFS JournalID NEXT Date 04 10 2009 Process Edit Journal _ Proce
5. Errors Approval The field Long Description is used to enter a general description or explanation for the transaction Although we can only see two lines the user can write up to 254 characters and then use the scrollbars to move up and down written text Long Description The Long Description should include the purpose of the journal If you are reclassifying a previous transaction include the original Journal ID number Voucher ID number Check Date Check Number or any other identifying information The Spectrum System Georgia State University Entering a Journal Entry The Source Field will determine the origin of this transaction It is a key field for Workflow purposes Source will determine the next step of approval for this transaction To select the Source click on the magnifying glass and make the appropriate selection ORACLE Home Worklist Add to Favorites Sign out New Window Help amp gt Accounts Payable gt GSU gt Purchasing Look Up Source gt Project Costing gt Travel and Expenses begins with E gt Accounts Receivable Source begins with ig Look U Clear Cancel j gt Commitment Control Basic Lookup v7 General Ledger Journals Search Results Journal Entry 1 3 of 3 Source Description DRG Department Regular ISO Internal Service Organization Project Regular Standard Journals fal gt gt Import Journals gt Subsystem Journals gt Process Journals
6. gt Ledgers gt Close Ledgers gt Maintain Standard Budgets gt Monitor Background Process gt Review Financial Information gt General Reports gt Set Up Financials Supply Chain gt Background Processes gt Worklist gt Reporting Tools gt PeopleTools Note Source type must be DRG ISO or PRJ This is a workflow requirement ISO Internal Service Organizations are units that provide products or services to other University Departments such as Auxiliary and Support Services Facilities and Management Services IS amp T DS amp S and Supply Room Charges The ISO Source is used by these areas to post charges PRJ Project Regular is used for all adjusting entries which move revenue and expenses to or from a Restricted Project Fund Code 2xxxx DRG Department Regular is used for all other adjusting entries The Spectrum System Georgia State University Entering a Journal Entry Home Worklist Add to Favorites Sign out New Window Help Customize Page 5 Header Y Totals gt My Favorites gt GSU gt Purchasing Unit GSUFS Journal ID NEXT Date 06 23 2009 UserID GSUUSER1 gt Grants gt Accounts Payable Long Description gt Commitment Control 7 General Ledger Journals Ledger Group ACTUALS Q Auto Generate Lines 9 Journal Entry Ledger Adjusting Entry Adiueti Create Update Journal E aa Non Adjusting Entry En
7. 99 225 00 USD 843105 15000 110600000 11000 2009 2 Supplies and Materials 225 00 USD 714100 15000 110600000 11000 2009 Worklist Journal Inquiry Suspense Status C Ja Document Type ja 0 R Year From Period To Period 2009 Q 1Q 12 Q Source Currency Stat a ja ja Sort By Max Rows Journal Id 100 Unit GSUFS Q Inquiry JRNL_INQ Journal ID aPoo041 890 Q Ledger ACTUALS Q Status Document Sequence wis Customize Find ts Descr Suspense Source am Journal ID Date User Unpost Date AP00041890 02 09 2009 AP No Susp JBACHNER 02 09 2009 Accounts Payable 28 MultiChannel Console MultiChannel Console Georgia State University Add to Favorites Sign out Activity An Type BookCode Adjustment S Add to Favorites Sign out New Window Help Customize Page The Spectrum System Georgia State University Entering a Journal Entry Worklist MultiChannel Console Add to Favorites Sign out GoTo Journal Criteria Journal Header Journal ID AP00041890 Date 02 09 2009 Schedule Ledger Group ACTUALS Original Date 02 09 2009 Process No Request Source AP Date Posted 03 05 2009 Total Lines 2 Posted Reversal Date User ID JBACHNER DR CR Reversal None InterUnit BU GSUFS Budget Status Valid iption Accounts Payable T urrency Find View All First 3 4 of 4 Last ency USD Debit Amount 100 00 Credit Amount 100 00 Net 0 00 From
8. Class Bud Ref Project Amoun gt Close Ledgers X ACTUALS Q p43105 Q Equip amp Furn Purch gt 4 9 15000 Q 110600000 Q Q 11000 Q 2009 Q if X ACTUALS Q 714100 Q Supplies and Materials 15000 Q 110600000 Q Q 11000 Q 2009 Q Lines toada 1 gt Process Multi Currency Average Daily Balance gt Open Items gt Consolidate Financial Data gt Maintain Standard Budgets D Monitor Background Process gt Review Financial Information gt Regulatory Ledger Reports gt XBRL gt Cash Flow Statement D General Reports gt Federal Reports gt Project Costing gt Purchasing gt Reporting Tools gt Set Up Financials Supply Chain gt Tree Manager DS Stee ten Customize Find View All HE First 8 4 of 14 L Last Unit Total Lines Total Debits Total Credits Journal Status Budget Status GSUFS 2 225 00 225 00 E N Header Lines Totals Errors Approval ORACLE Menu zE Journal Entry a Create Update Journal Entries Copy Journals gt Standard Journals n gt Import Journals Unit GSUFS Journal ID 0000041917 Date 03 12 2009 gt Subsystem Journals gt Process Journals a Unit Field Name Field Long Name Set Message Text gt Suspense Correction Unit Field Name Field Long Name Set Msq Message Text gt Ledgers GSUFS JRNL_HDR_STATUS Journal Header Status 5860 53 Journal line errors exist for this header gt Summary Ledgers D Close Ledgers Customize Find
9. Group x Ledger Group fore Q Budget Details Budgets Overview L View Stat Code Budgets Org Budget Ledger Group Ledger Inquiry Set Display Chart si Activity Log Review Fund Source Allocations a Review Fund Source Type of Calendar Detail Budget Period x fase Customize Find View All First H 4 of 14 L Last p roas Pucat From Budget gree cae Include Closing D Budget Reports Select Ledger Group Calendar ID S To Budget Period D Third Party Transactions Period Period s Adjustments gt Review Budget Check Vv ORG YE 2009 Q 2009 Q iv D Exceptions E gt Purchasing ChartField ren From ChartField To ChartField Value Set UpdatelAdd M Open gt Reporting Tools Wi Closed gt Set Up Financials Supply Account NCONOO Q NTROOO q Q Update Add T nad Chain v Ro gt Tree Manager Dept 612250000 Q 612250000 Q i Q Update Add bees a b hak 9 MOT Q Updatemad gt GSU Grants and Projects fe i Aaina Class Q q Q Update Add gt Partners lt Program Q 2 Qq Q Update Add a ID Products Click Search and you will see the results Worklist MuttiChannel Console Add to Favorites Sign out Kevenue Associated F Max Rows 100 Search ia Ledger Totals 3 Rows Return to Criteria Display Options Net Transfers 0 00 Budget 1 028 147 00 Expense 15 061 11 Encumbrance 22 950 00 Pre Encumbrance 0 00 Budget Balance 990 135 89 Associate Revenue 0 0
10. Q la ja ja e Q gt Consolidate Financial User Document Seq mn Sort By seis Fieve Data gt Maintain Standard Q Journal id E 100 No Records Found Budgets Delete Clear Monitor Background E notity Process Review Financial Information Journals Ledger Ledger Group Ledger Period Comparison Compare Across Ledgers Payroll Accounting Entries Enterprise Learning Mamt Accta Generic Accounting Entries Student Fin Accounting Entries Contributor Relations Home Worklist MultiChannel Console Add to Favorites Sign out Menu a pi E i Help Customize Page D My Favorites New Window Help Customize Page je gt Accounts Payable gt Commitment Control i gt General Ledger Journal Inquiry gt Journals Ledger Criteria petal Ledgers Inquiry Unit Ledger Year From Period To Period Suspense Status gt Close Ledgers JRNL_INQ GSUFS A factuas a oda 1a wa ja ecient ee Status Source Currency Stat Document Type gt Open Items 0000041920 Q Ja la ja ja ra Consolidate Financial Document Sequence Sort By Max Rows Data Joumalid i gt Maintain Standard Journal ld y 100 Budgets Monitor Background Process K hea Customize Fin nformation ae Journals Journal ID Date UnitiIU Status Source User Unpost Date Descr Ledger ais
11. Reports gt Third Party Transactions gt Review Budget Check Exceptions gt General Ledger gt Project Costing gt Purchasing gt Reporting Tools gt Set Up Financials Supply Chain gt Tree Manager gt Vendors gt GSU gt GSU Grants and Projects gt Customers gt Partners 5 Procicts In the Budget Type Criteria enter ORG for the Ledger Group In the TimeSpan Criteria enter the Fiscal Year and Budget Periods that you are inquiring on In the Chartfield Criteria enter the chartfield information that you are looking for You can do an inquiry on specific Accounts remember that these are Budget Accounts and not Expenditure Accounts Departments etc You can also use a wildcard if you want a larger return You can save this information so that when you want to use the inquiry again the information is there In addition you can save several inquiries with different run control names 34 The Spectrum System Entering a Journal Entry Georgia State University Home _Worklist Multichannel Console Add to Favorites Sign out Menu q B e gt My Favorites Budget Overview gt Accounts Payable 7 Commitment Control Define Control Budgets Inquiry BUD_OVW Budget Overview gt Define Budget Security Budget Journals Amount Criteria Post Control Budget B tT Journals sog Tne Y Review Budget Activities Business Unit GSUFS Q Ledger Group Set Ledger
12. Sort Order To order columns or add fields to sort order highlight column name then press the appropriate button Frozen columns display under every tab Column Order i a Line frozen gt x Ledger SpeedType colurnn 11 Hidden Account Frozen Fund Dept Program Class Bud Ref PC Bus Unit Project Activity An Type Amount Base Currency Stat UOM Open Item Key Reference Journal Line Description OK Cancel Preview Copy Settings Descending 20 The Spectrum System Georgia State University Entering a Journal Entry For example if the Journal Line Description field is desired to be shown after the Account field then you would select the Journal Line Description field and click the move up arrow until it is after the Account field ORACLE VVorklist Add to Favorites a New Window Help Personalize Column and Sort Order To order columns or add fields to sort order highlight column name then press the appropriate button Frozen columns display under every tab Column Order Select frozen An Line frozen g 5 Ledger SpeedType column 11 ClHidden Descending Account Fund C Frozen Dept Program Class Bud Ref PC Bus Unit Project Activity An Type Amount Base Currency Stat UOM Open Item Key KIED Reference Journal Line Description OK Cancel Preview Copy Settings VVo
13. Vchr Appr Route for 04 09 2009 Additional Vchr Appr Route for 04 09 2009 Additional Vchr Appr Worklist for DA2BIOLI Department Approver 2 Biology Worked By Activity Approve Deny Journal VOUCHER APPROVALS VOUCHER APPROVALS VOUCHER APPROVALS VOUCHER APPROVALS VOUCHER APPROVALS VOUCHER APPROVALS VOUCHER APPROVALS Priority C E C E C E C E C E C E CE Georgia State University Home Worklist Add to Favorites Sign out New Window Help Customize Page Work List Filters z 4 9 of 9 Link 1173 GSUFS 0000041819 2009 04 10 V 0 GSUFS Example of Worklist items to be approved Reassign GSUFS 00000018 1234TEST MHA 1131 GSUFS 00000010 1234TESTYS 1133 Mark Worked GSUFS 00000011 1234TESTBP 1134 __Mark Worked GSUFS 00000013 1234TESTMBB es 1135 Mark Worked GSUFS 00000014 1234TESTNP 1136 GSUFS 00000015 1234cc 1137 GSUFS 00000016 1234TESTRC 1138 Reassign Mark Worked The approver then can go to the Approval Page and either Approve or Recycle If you select Approve you must also click the Lines Tab and select the Submit Journal Process to continue the workflow process If you recycle you can send it back to the Initiator or prior Approver for correction or deletion gt Accounts Payable gt GSU gt Commitment Control
14. in this field Journal Date defaults to current date and is the transaction date This field needs to be verified before proceeding with the transaction This date will determine the accounting period of the transaction Click Add to proceed The Spectrum System Georgia State University Entering a Journal Entry 3 Header Page The first page you will need to complete will be Journal Entry Header This page records information that identifies the Journal Entry ORACLE Home Worklist Add to Favorites Sign out New Window Help Customize Page Header Y Y Totas Errors Y Approval Unit GSUFS Journal ID NEXT Date 06 23 2009 UserID GSUUSER1 gt Accounts Payable Long Description gt Commitment Control General Ledger f Journals Ledger Group ACTUALS Q Auto Generate Lines 9 Journal Entry Ledger Adjusting Entry Adineti Create Update Journal l satiti Non Adjusting Entry Entries Source DRGIQ Fiscal Year 2009 gt Standard Journals gt Process Journals Reference Number Period gt Review Financial Information SJE Type ADB Date 06 23 2009 D Worklist gt Reporting Tools Journal Class Save Journal Incomplete Status AGEORIETIEDE Transaction Code DEFAULT Q Workflow Department Q Currency Defaults USD CRRNT 1 Commitment Control Save E Notity Refresh Ee Add l Update Display v Header Lines Totals
15. to Favorites Sign out Neves New Window Help Customize Page 2 gt Budget Reports New window neip l http D Third Party Transactions v Review Budget Check Exceptions gt Purchasing and Cost Business Unit GSUFS Journal ID 0000041859 Journal Date 03 03 2009 Management gt Travel and Expenses P z Eror H O a R i A gt Accounts Payable Exception Type Override Transaction r Ses and Grants Maximum Rows 100 I More Budgets Exist Advanced Budget Criteria evenues v General Ledger GL Journal Exceptions Y Customize Find View Payroll Generic Transaction Entry Business m l Override Budget Journal Unit Gro Exception More Detail Budget Transfer aE 1 Q GSUFS PRMST_EXP No Budget Exists More Detail O Goto Budget Checking Status 2 Q GSUFS PRMST_EXP No Budget Exists More Detail oO Go To Budaet Exceptions 3 r gt General Ledger 3 GQ GSUFS PROJ_GRT No Budget Exists More Detail O Go To D Project Costing 4 Q GSUFS PROJ_GRT No Budget Exists More Detail O Goto gt Purchasing gt Reporting Tools gt Set Up Financials Supply Chain i is gt Tree Manager im Save Return to Search GL Journal Exceptions Line Exceptions gt Catalog Management Rat le am a Ee wed ee 4 1 3 Delete Journal Use this option if the user does not want to continue or save the Journal Entry This can also be used if a Department Approver determ
16. 0 Available Budget 990 135 89 Budget Overview Results Ledger Group 1 Q orc 2 amp orc 3 amp A orc Return to Criteria Notes Account NEQO00 NSP000 NTROOO 10000 10000 10000 Dept Program Class 612250000 16200 11200 612250000 16200 11200 612250000 16200 11200 PC Bud Ref Bus Unit 2009 2009 2009 Project Activity Customize Find View All Budget Pre Available Pere Period Budget Expense Encumbrance Encumbrance Budaet Avai 2009 503 000 00 0 00 0 00 0 00 503 000 00 100 2009 520 777 00 15 061 11 22 950 00 0 00 482 765 89 92 2009 4 370 00 0 00 0 00 0 00 4 370 00 100 From this page you can drill to detail budget expenses encumbrances and detail transactions Note When accessing the Journal Entry Source from the Journal Line Drill Down page be sure to write down the Journal ID as you will need to enter it when you access the Journal Inquiry page 35
17. 0000041920 03 12 2009 GSUFS Errors DRG No Susp BPOLING 03 12 2009 To correct account code Ledger Group Ledger Period Comparison E Save A Return to Search Notify Compare Across J fF Ledgers Payroll Accounting Entries Enterprise Learning Mamt Accta Generic Accounting Entries Student Fin Accounting Entries Contributor Relations hd You can review the status of the journal entry If the journal originated from a PeopleSoft Financials subsystem the budget status will be valid even though the edit status may not be valid 27 The Spectrum System Entering a Journal Entry You can drill to the source document by clicking the Journal ID hyperlink Worklist GoTo Journal Criteria Journal ID 0000041920 Date Ledger Group Source 03 12 2009 Schedule ACTUALS Original Date 03 12 2009 Process No Request DRG Date Posted Total Lines 2 Journal Status Errors Reversal Date User ID BPOLING Balanced DR CR Reversal None Doc Seq Budget Status NotChkd Long Description To correct account code A Totals by Currency InterUnit BU GSUFS Currency USD Debit Amount 225 00 Credit Amount 225 00 Net 0 00 All Lines CFromito From Line To Line _Query Journal Lines Journal Line Amount in Line Line Descr Transaction Currency Account Fund Dept Program Class BudRef PCBusUnit Project Currency Equip amp Furn Purch gt 4 999
18. JOURNAL ENTRY GENERAL LEDGER USER MANUAL The Spectrum System Georgia State University PeopleSoft Financials Version 8 9 GeorgiaState University i S F July 1 2009 The Spectrum System Entering a Journal Entry 1 INTRODUCTION 1 1 USE OF THE GENERAL LEDGER JOURNAL ENTRIES 2 HOW TO ENTER A JOURNAL ENTRY 2 1 PAGE NAVIGATION 2 2 CREATING A JOURNAL ENTRY 2 2 1 Add a New Value Tab 3 HEADER PAGE 4 JOURNAL ENTRY LINES PAGE 4 1 1 Adding and or Deleting Row 4 1 2 Edit Budget Check Process 4 1 3 Delete Journal 4 1 4 Submit to Workflow 4 1 5 Print Journal 4 1 6 Journal Template 5 RECYCLE JOURNAL 6 FIND AN EXISTING VALUE TAB 7 INQUIRING ON JOURNALS 8 INQUIRING ON LEDGERS 9 BUDGET OVERVIEW INQUIRIES Georgia State University The Spectrum System Georgia State University Entering a Journal Entry 1 Introduction 1 1 Use of the General Ledger Journal Entries A Journal Entry is a batch of accounting entries entered online or input from a feeder system to the General Ledger It is composed of journal lines that carry different chartfields and needs to be balanced debits credits Journal Entries are used to record original transactions in the general ledger from other PeopleSoft applications feeder systems like Accounts Payable Asset Management Purchasing and Accounts Receivable which typically generate accounting or voucher lines from transaction data entered in that particular applicatio
19. Line To Line Journal Line Drill to Amount in EE Line Line Descr Transaction Currency Account Fund Dept Program Class BudRef PC Bus Unit Project Activity An Type Book Code Currency B 4 Accounts Payable 100 00 USD 211000 10000 110600000 11100 11200 2009 ee 2 test 100 00 USD 714100 10000 110600000 11100 11200 2009 Worklist MultiChannel Console Add to Favorites Sign out New Window Help Customize Page Drill to Source Unit Journal Date Ledger Line Line Descr GL Journal GSUFS AP00041890 02 09 2009 ACTUALS 1 Accounts Payable Account fund Dept Program Class BudRef PCBusUnit Project Activity AnType Statistic Amount Stat 211000 10000 110600000 11100 11200 2009 Base Currency Base Amount Currency Transaction Amount USD 100 00 USD 100 00 e EFH Customize Find View All E Voucher ID Descr Vchr Line Distrib Line Amount Currency Base Amount Currency 00000001 Accounts Payable 1 1 100 00 USD 100 00 USD 29 The Spectrum System Georgia State University Entering a Journal Entry Worklist MultiChannel Console Add to Favorites Sign out Voucher Accounting Entries New Window Help Customize Paae Business Unit GSUFS Q Voucher ID 00000001 Q invoice Number 1231 Q Accounting Line View Option Standard Show Foreign Currency Search Reset Invoice Date 02 09 2009 Vendor ID 0000001740 Vendor Name AMERICAN HEART ASSOCIATION Accounting Information Po
20. Line Ledger SpeedType Account Journal Line Description Fund Dept Program Class Bud Ref Project Amount Reference PC Bus ee Unit OD 14 ACTUALS Q 714990 Q Purchase Card Transactio 10000 Q 612250000 Q 16200 Q 11200 Q 2009 Q 11 11 1000456896 Cr 2 ACTUALS Q 714100 Q Supplies and Materials 10000 Q 612250000 Q 16200 Q 11200 Q 2009 Q 11 11 Lines to add 1 co 7 a tH x gt oe Customize Find View All 3 First 4 of 1 L Last Unit Total Lines Total Debits Total Credits Journal Status Budget Status GSUFS 2 i Bs i 11 11 Vv V Header Lines Totals Errors Approval 16 The Spectrum System Georgia State University Entering a Journal Entry 4 1 5 Print Journal The user can print the content of a Journal Entry by selecting the Print Journal Process in the Lines tab Process Print Journal Process The page will refresh and show the Report Manager link and the Process Monitor link Click the Process Monitor link Print Journal Report Mana er Process Monitor Process Once the report GLC7501 has completed processing you will need to click Refresh until the Run Status is Success and Distribution Status is Posted Click the Details hyperlink and the Process Details page opens Add to Favorites Sign out New Window Help Customize Page amp User ID RLASTER Q Type Z tast 7 Days Refresh Server Name
21. Q instance to Run Distribution M Save On Refresh Status Status Process List Customize Find View All First 4 4 2 of 2 P Last Select Instance Seq Process Type Process User Run Date Time Run Status Distribution Details Name Status E 4189 Crystal GLC7501 RLASTER 04 10 2009 2 04 42PM EDT Success Posted Details E 4188 Application Engine FS_BP RLASTER 04 10 2009 1 39 01PM EDT Success Posted Details fm Save E Notify Process List Server List 17 The Spectrum System Georgia State University Entering a Journal Entry Click the View Log Trace link and that window opens Worklist MultiChannel Console Add to Favorites Sign out New Window Help Customize Page Process Detail Instance 4189 Type Crystal Name GLC7501 Description Journal Entry Print Run Status Success Distribution Status Posted EG Run Control ID CJY Hold Request Location Server Queue Request Server PSNT O caiat Delete Request ia Restart Request Actions Request Created On 04 10 2009 2 04 43PM EDT Parameters Transfer Run Anytime After 04 10 2009 2 04 42PM EDT Message Log Began Process At 04 10 2009 2 04 58PM EDT Batch Timings Ended Process At 04 10 2009 2 05 05PM EDT View Loa Trace ok Cancer Click the GLC7501 xxxx HTM hyperlink and the Crystal Report of the Journal will appear in a new window Worklist MultiChannel Console Add to Favorites
22. Sign out New Window Help Customize Page 4 View Log Trace Report iD 2073 Process Instance 4189 Message Log Name GLC7501 Process Type Crystal Run Status Success Journal Entry Print Distribution Details Distribution Node FS9SAN Expiration Date fosv2 5 2009 Name Datetime Created Message Log 04 10 2009 2 05 05 000000PM EDT GLC7501 4189 HTM 04 10 2009 2 05 05 000000PM EDT pssaltrace tre Distribute To Distribution ID Type Distribution ID User RLASTER 04 10 2009 2 05 05 000000PM EDT _ 18 The Spectrum System Georgia State University Entering a Journal Entry A Report ID GLC7501 PeopleSoft Financials Page No 1 JOURNAL ENTRY DETAIL Run Date May 13 2009 Run Time 10 57 36 AM Unit GSUFS Ledger Group ACTUALS Foreign Currency usD Journal ID 0000041977 Source DRG Rate Type CRRNT Date Mar 24 2009 Reversal N Effective Date Mar 24 2009 Description MOVE P CARD EXP TO 714100 Reversal Date Exchange Rate 1 00000000 SOO Ept iit I ivity yp tem ACTUALS 1 714990 10000 612250000 16200 11000 2009 1000456895 Purchase Card Transactions 11 11 USD 2 714100 10000 612250000 16200 11000 2009 Supplies and Materials 11 11 USD v In order to print the journal in landscape and without extra pages change the orientation to Landscape and the Bottom margin to 50 Page Setup Paper Size Letter x Source Automatically Select x Header
23. UALS 2009 1 12 Ledgers I Show YTD Balance F Include Closing Adjustments Mamt Accta Generic Accounting Contributor Relations Home Worklist MultiChannel Console Add to Favorites Sign out Payroll Accounting Go To Inquiry Criteria Transaction Criteria Entries Transaction Details Find View All First 4 4 ofa D Last Ledger by Period and Chartfields Customize Find 1 of 4 Accta Period Account Account Description Stat Entry Event Budget Accta 9 714100 Supplies and Materials Entry Event GL Adjust Accta gt Regulatory Ledger Amount in Transaction Currency 1 022 22 USD Amount in Base Currency 1 022 22 USD Reports gt XBRL Amount in 4 2 i navies rag Sia Journal ID Line Descr Date Seq Stat Amt N R Transaction Currency Amount in Base Base Currency Currency gt Federal Reports i Currency D Project Costing 0000041937 Supplies and Materials 03 19 2009 0 00 N 0 00 USD 0 00 USD gt Purchasing 0000041981 Supplies and Materials 03 24 2009 0 00 N 11 11 USD 11 11 USD eset Ton 0000041998 Supplies and Materials 03 26 2009 0 00 N 11 11 USD 11 11 USD R pera ere AP00041908 Office Machines 03 03 2009 0 00 N 1 000 00 USD 1 000 00 USD gt Tree Manager Vendors In cou B A tH Customize Find 5 x You can drill to the source documents by selecting the Journal ID number for the transaction you are looking at 32 The Spectrum System Georgia St
24. alue Add a New Value Budgets b Monitor Background Process Review Financial Information Journals Generic Accounting Entries Student Fin Accountine Entries Contributor Relations a In the Ledger Criteria enter ACTUALS for the Ledger Group the Fiscal Year you want to do an inquiry on the period from and to that you want to do an inquiry on and USD for the Currency at the top of the page In the Chartfield Criteria enter the chartfield information that you are looking for You can do an inquiry on a specific Accounts Departments etc You can also use a wildcard if you want a larger return You can save this information so that when you want to use the inquiry again the information is there In addition you can save several inquiries with different run control names 31 The Spectrum System Georgia State University Entering a Journal Entry ORACLE Menu ml gt Review Financial z Ledger Inquiry Information Journals Enter ledger period ChartField and rest of the criteria Click on Search button to execute the query Ledger Ledger Group 7 Ledger Period Inquiry Name Unit Ledger Fiscal Year From Period To Period Currency Stat Code a LED_INQ csursQ factuats A 2009Q 4a 21Q Esa ja Compare Across Value Order Sel Period Required By C 998 F 1 E r r E E w a Chain Home Worklist MuitiChannel Console Add to Favorites Sign out
25. ate University Entering a Journal Entry Worklist MultiChannel Console Add to Favorites GoTo Inquiry Transaction Details Criteria Joumal Header Journal ID 0000041981 Date 03 24 2009 Schedule Ledger Group ACTUALS Original Date 03 24 2009 Process No Request Source DRG Date Posted 03 24 2009 Total Lines 2 Journal Status Posted Reversal Date User ID KGEBREAB Balanced DR CR Reversal None InterUnit BU GSUFS Doc Seq Budget Status Valid Long Description MOVE CARD EXPENSES TO 714100 Totals by Currency Currency USD Debit Amount 11 11 Credit Amount 11 11 Net 0 00 All Lines FromiTo From Line To Line avery Journal Lin i pour il Amount in a Line Line Descr Transaction Currency Account Fund Dept Program Class BudRef PCBusUnit Project Activity AnType BookCode Adjustment S 7 Currency 2 Supplies and Materials 11 11 USD 714100 10000 612250000 16200 11200 2009 Worklist MultiChannel Console Add to Favorites Sign out GoTo Inquiry Transaction Details Criteria Journal Header Journal ID AP00041908 Date 03 03 2009 Schedule Ledger Group ACTUALS Original Date 03 03 2009 Process No Request Source AP Date Posted 03 11 2009 Total Lines 14 Journal Status Posted Reversal Date User ID MFRANKLIN Balanced DR CR Reversal None InterUnit BU GSUFS Doc Seq Budget Status Valid Long Description Accounts Payable Totals by Currenc
26. ect Enter Subject here K Template workflow Notification a Text 3 Priority NotificationPriority Mate Cant INNA NARNII i Message w Click OK to send this notification and exit this page Click Cancel to exit this page without sending a notification Click Apply to send this notification and remain on this page OK i Cancel Apply 24 The Spectrum System Georgia State University Entering a Journal Entry 6 Find an Existing Value Tab There are many ways to search for an existing value You can search by Journal ID or Journal Date Make sure that the Budget Checking Header Status is left blank and enter the appropriate Source if known Worklist MulttiChannel Console Add to Favorites Sign out Journal Entry Create Update Journal Entries Copy Journals gt Standard Journals gt Import Journals gt Subsystem Journals gt Process Journals gt Suspense Correction gt Ledgers Summary Ledgers D Close Ledgers gt Process Multi Currency gt Average Daily Balance gt Open Items b Consolidate Financial Data New Window Help Create Update Journal Entries Enter any information you have and click Search Leave fields blank for a list of all values Find an Existing Value Adda New Value Business Unit lesus Q Journal ID begins with O E Journal Date WE D 34 Document Sequence Number begins with TT Line Business Un
27. er signs in they can go to the Worklist link at the right top of the page and click the hyperlink This will open the Worklist for that user and they can select which work list item they want to work on by clicking the hyperlink ORACLE _Worklist Personalize Content Layout Help gt My Favorites gt Accounts Payable GSU gt Purchasing gt Travel and Expenses D Accounts Receivable gt BOR Menus gt Commitment Control gt General Ledger gt Worklist gt Reporting Tools gt PeopleTools Change My Password My Personalizations My System Profile 14 The Spectrum System Entering a Journal Entry gt Accounts Receivable gt BOR Menus gt Commitment Control gt General Ledger Worklist Worklist Worklist Details gt Reporting Tools gt PeopleTools Change My Password My Personalizations My System Profile Detail View Department 1 Approver Biology Department 1 Approver Biology Department 1 Approver Biology Department 1 Approver Biology Department 1 Approver Biology Department 1 Approver Biology Department 1 Approver Biology Department 1 Approver Biology Date From Work Item 04 10 2009 Journal Approval Route for 04 09 2009 Additional Vchr Appr Route for 04 09 2009 Additional Vchr Appr Route for 04 09 2009 Additional Vchr Appr Route for 04 09 2009 Additional Vchr Appr Route for 04 09 2009 Additional
28. es within the transaction the Cash Control Account balancing lines will be automatically entered by the system Running the Edit Journal Process will save and assign a number to the transaction If successful the transaction should now have a valid Journal Status and Budget Status If the status is Error refer to the Errors and Totals panel for further inquiry First U 4 of 4 LE Last Unit Total Lines Total Debits Total Credits Journal Status Budget Status GSUFS 2 11 11 11 11 E N If the Journal Status E select the X in the Lines Section or the E hyperlink in the Totals Section which will take you to the Errors Page so that you can review the error Once you have resolved the Edit error you will run the Edit Journal Process again 11 The Spectrum System Georgia State University Entering a Journal Entry Worklist MultiChannel Console Add to Favorites Sign out Journal Entry Create Update Journal Entries Copy Journals gt Standard Journals gt Import Journals gt Subsystem Journals gt Process Journals Suspense Correction v Lines New Window Help Customize Paae Unit GSUFS JournalID 0000041920 Process EditJoumal Process errors Only 2 Line 10 Template List Search Criteria Change Values gt Ledgers gt ees Ledgers Error Ledger SpeedType Account Journal Line Description Fund Dept Program
29. ground Processes Worklist gt Reporting Tools gt PeopleTools Create update or copy journal entries The Spectrum System Georgia State University Entering a Journal Entry 2 2 Creating a Journal Entry Click the Add button ORACLE Menu Home Worklist Add to Favorites Sign out New Window Help amp gt Accounts Payable gt GSU gt Purchasing Create Update Journal Entries gt Project Costing SE E gt Travel and Expenses Eind an Existing Value Add aNew Value gt Accounts Receivable gt BOR Menus A n gt Banking Business Unit GSUF sqa gt Commitment Control Journal ID NEXT v7 General Ledger Journals Journal Date 04 10 2009 E v Journal Entry Create Update Journal p Add Find an Existina Value Add a New Value gt Import Journals gt Subsystem Journals gt Process Journals gt Ledgers gt Close Ledgers gt Maintain Standard Budgets gt Monitor Background Process gt Review Financial Information General Reports gt Set Up Financials Supply Chain gt Background Processes gt Worklist gt Reporting Tools gt PeopleTools SS SSS ee eS EA ESS SS z 2 2 1 Add a New Value Tab The Add a New Value journal page is displayed Business Unit defaults to GSUFS Georgia State University Financial System The Journal ID defaults to NEXT The system automatically assigns a Journal ID when you save the transaction Caution Do not change the value
30. ines that the journal is incorrect This will completely eliminate the transaction Note This option will not be available after the Journal has been POSTED Worklist MultiChannel Console Add to Favorites Sign out New Window Help Customize Page Process Delete Journal CErorsony une 10 E E Unit GSUFS JournalID 0000041920 Template List Search Criteria Change Values v Lines Select Line Error Ledger SpeedType Account Journal Line Description Fund Dept Program Class Bud Ref Project Amount Reference s Q 34 X ACTUALS Q 843105 Q Equip amp Fur Purch gt 4 9 15000 Q 110600000 Q Q 11000 Q 2009 Q 225 00 Lk 2 X ACTUALS Q 714100 Q Supplies and Materials 15000 Q 110600000 Q Q 11000 Q 2009 Q 225 00 E gt Zh EF R Customize Find View All 55 First H 4 of 4 Last Unit Total Lines Total Debits Total Credits Journal Status Budget Status GSUFS 2 225 00 225 00 E N Ei notity 4 Retesh Header Lines Totals Errors Approval 13 The Spectrum System Georgia State University Entering a Journal Entry 4 1 4 Submit to Workflow This process is used for Workflow purposes If a transaction has been completely validated the user can use this option to move the transaction through workflow and move it into its next step of approval by selecting the Submit Journal process Process When the next level approv
31. it E Q Journal Header Status x fT gt Maintain Standard Budgets rg gt Monitor Background Budget Checking Header Status v v Process Source Q gt Review Financial Information gt Regulatory Ledger Search Clear Basic Search E Save Search Criteria Reports gt XBRL Cash Flow Statement Find an Existing Value Add a New Value gt General Reports gt Federal Reports gt Project Costing gt Purchasing gt Set Up Financials Supply Chain gt Tree Manager 25 The Spectrum System Georgia State University Entering a Journal Entry 7 Inquiring on Journals The journal inquiry page is used to verify that the journals were created The summary and detail information including the status and source about a journal is provided from this inquiry Note Once journals are budget checked you can view them using this process even if they are not posted Click on General Ledger Review Financial Information Journals Note The first time you use this process you will need to set up a run control Enter JRNL_INQ or any other name and click Add ORACLE Menu 77 Home Worklist MultiChannel Console Add to Favorites Sign out A New Window Help ne gt My Favorites gt Accounts Payable gt Commitment Control Journals 7 General Ledger gt Journals _Eind an Existing Value Adda New Value gt Ledgers gt Summary Ledgers gt Close Ledgers Inquiry Name JRNL_ING gt P
32. m Georgia State University Entering a Journal Entry You can notify the individual it is being sent back to via the Notify Button and select their email address and detail what the issue is The Initiator can view the recycled journal correct the journal line s edit the journal and submit it again for approval Home VYorklist Add to Favorites Sign out New Window Help Customize Page B Approval Unit GSUFS JournalID 1000500178 Date 06 01 2009 Unit GSUFS Approval Check Active Y Approval Status Pending Approval Approval Action Approve Comments for Denial Email Approval History Step Path Status DateTime Stamp User ID 0 A Initiated 06 01 2009 9 53 07AM GSUUSER3 01 A Recycle 06 01 2009 9 54 21AM DA1110010000 02 A Pending 06 01 2009 9 53 07AM 03 A Pending 06 01 2009 9 53 07AM save View Worklist tE Previous in Worklist 4 Next in Worklist E notity f Refresh Eraaa Update Display Header Lines Totals Errors Approval Home Worklist Add to Favorites Sign out New Window Help Customize Page amp Send Notification Type names or email addresses in the To CC or BCC fields using a semi colon as a separator Click LOOKUP RECIPIENT to search fora name Click DELIVERY OPTIONS to view or change the method of the send Notification Details Lookup Recipient Delivery Options To CC BCC Priority v Subj
33. n PeopleSoft than posts these accounting lines to an accounting entry table and Journal Generator processes the data in the accounting entry table to create journals in the General Ledger Original transactions are also recorded from ADP Banner Core PCard Works and Telecommunications Journal Entries are also used to make adjusting entries corrections cost transfers to existing transactions such as an incorrect account was used on a voucher telephone billing was charged to an incorrect speedtype to move expense charged on a previous journal entry to another department record Departmental Sales and Services revenue Agency expenses Continuing Education revenue and expenses etc This guide demonstrates how to create edit and budget check a journal entry Journal entries are made to record the financial transactions of any business Journal entries in PeopleSoft consist of a header and detail lines On the Header page you record information that uniquely identifies the journal entry On the Detail Lines page you record the individual transactions and the affected Chartfields that comprise a journal A single journal entry must be at least two lines in length because total debits must equal total credits for a single journal entry A journal can only be posted if it has a valid journal status and it passes budget checking When selecting Edit Journal from the Detail Lines page the journal edit and budget check processes are initiated i
34. n sequential order A major change in creating journals in PeopleSoft 8 9 is the Inter Intra Unit functionality of balancing the journal entry by fund There is now PeopleSoft delivered functionality that automatically creates the cash offset lines when the journal is edited The Spectrum System Georgia State University Entering a Journal Entry 2 How to Enter a Journal Entry Each step in the online process of entering a Journal Entry will be described below Compare your screen to the ones shown in the example for each step 2 1 Page Navigation Click on General Ledger Journals Journal Entry Create Update Journal Entries Worklist Add to Favorites ja Main Menu gt General Ledger gt Journals gt Payable P Journal Entry gt Purchasing gt Project Costing gt Travel and Expenses Create Update JournalEntries E Copy Journals EA gt Accounts Receivable Create new journal entries or update existing journal entries Request a process to copy an existing journal gt BOR Menus gt Banking gt Commitment Control General Ledger Journals v Journal Entry Create Update Journal Entries Copy Journals gt Standard Journals Import Journals gt Subsystem Journals gt Process Journals gt Ledgers gt Close Ledgers gt Maintain Standard Budgets gt Monitor Background Process gt Review Financial Information gt General Reports gt Set Up Financials Supply Chain gt Back
35. nal Entry a a a m pams CreatelUpdate Journal rl 4 ACTUALS Q 714100 Q 10000 Q 612250000 Q 16200 Q 11000 Q 2009 la ajf jal jaf 5 00 USD Entries I y PORNO neers O 2 ACTUALS Q 714990 Q 10000 Q 612250000 Q 16200 Q 11000 Q 2009 a aj a jal 5 00 USD gt Process Journals gt Review Financial Linestoadd 1 El i Information l D Worklist p5 Las gt Reporting Tools Unit Total Lines Total Debits Total Credits Journal Status Budget Status gt PeopleTools GSUFS 2 5 00 5 00 Y Y nto Search E Notity Refresh Header Lines Totals Errors Approval Once the approver recycles the journal the approval history on the Approval page is updated to show that the journal has been recycled by that particular approver Worklist Add to Favorites New Window Help Customize Page Unit GSUFS JournalID 1000500178 Date 06 01 2009 Unit GSUFS Approval Check Active Y Approval Status Pending Approval Approval Action Approve Comments for Denial Email Approval History Step Path Status DateTime Stamp User ID 0 A Initiated Sa OTS hi GSUUSER3 01 A Recycle M DA1110010000 02 A Pending il 03 A Pending 06 01 2009 9 53 07AM Gsave E View Workist t ZPrevious in Worklist 43 Next in Worklist Notify Refresh Add Update Display Header Lines Totals Errors Approval 23 The Spectrum Syste
36. ournals Search Results v Journal Entry q 1 50f8 Create Update Journal Entries Department Description pore 110600000 Bioloay Copy Journals gt Standard Journais 120010000 RCB Telephones l gt Import Journals 140000000 Counseling amp Psychological Svc gt Subsystem Journals 151000000 College of Health amp Human Sci gt Process Journals 612250000 Spectrum System gt Ledgers gt Clase Ledgers gt Maintain Standard Budgets gt Monitor Background Process gt Review Financial Information gt General Reports gt Set Up Financials Supply Chain gt Background Processes gt Worklist gt Reporting Tools gt PeopleTools The Spectrum System Georgia State University Entering a Journal Entry 4 Journal Entry Lines Page This is the page in which the user will enter all chartfields to be affected by this transaction ORACLE Home Worklist MultiChannel Console Add to Favorites Sign out 2 New Window Help Customize Paae Header Lines Totals Errors y Approval Unit GSUFS JournalID NEXT Date 04 10 2009 Process EditJournal Iz _ Process Template List Change Values Inter intraUnit v Lines Select Line Ledger SpeedType Account Journal Line Description Fund Dept Program Class Bud Ref Project Amount Reference Pe E ACTUALS oar af a a a a Jaf Lines toad 1 HE OE M Customize Find View All HH First
37. rklist Add to Favorites New Window Help Personalize Column and Sort Order To order columns or add fields to sort order highlight column name then press the appropriate button Frozen columns display under every tab Column Order Select frozen a P Line frozen z P x Ledger 7 i SpeedType column 11 Oy k Descending Account Journal Line Description Fund Dept Program Class Bud Ref PC Bus Unit Project Activity An Type Amount Base Currency Stat UOM Open Item Key Reference OK Cancel Preview Copy Settings You can repeat this process until all fields are in the desired order When complete click the OK button This will bring you back to the Lines page with the new changes made 21 The Spectrum System Georgia State University Entering a Journal Entry 5 Recycle Journal A journal is recycled when an approver sends the journal back to the Initiator or prior Approver for correction or deletion If the journal is recycled the individual it is being sent back to can be notified via the Notify Button The journal can then be corrected and resubmitted to workflow The approver can access the recycle option from the Approval Page of the journal in their workflow Vorklist Add to Favorites New Window Help Customize Page Approval Unit GSUFS Journal ID 1000500178 Date 06 01 2009 Unit GSUFS App
38. rocess Multi Currency gt Average Daily Balance gt Open Items Add Consolidate Financial Data Maintain Standard Budgets Monitor Background Process v Review Financial Information Journals Ledger Ledger Group Ledaer Period Comparison Compare Across Ledgers Find an Existing Value Add a New Value Payroll Accounting Entries Student Fin Accounting Entries Contributor Relations vv 26 The Spectrum System Georgia State University Entering a Journal Entry Enter all or some of the information at the top of this page and click Search You can do an inquiry on a specific Journal ID Date User etc You can also use a wildcard if you want a larger return You can save this information so that when you want to use the inquiry again the information is there In addition you can save several inquiries with different run control names ORACLE Home Worklist MultiChannel Console Add to Favorites Sign out Menu fl a New Window Help Customize Paae gt My Favorites gt Accounts Payable gt Commitment Control i v7 General Ledger Journal Inquiry Journals edger Criteria eset Inqui Uni aL m From Period To Period Suspense Status b Summary Ledgers ati Unit edger ear rom Peri o Peri gt Close Ledgers JRNL_INQ GSUFS Q facTuALs JQ 20091Q 1Q 2a Q PERE acaba ctearatde Status Source Currency Stat Document Type gt Open Items po00041920
39. roval Check Active General Ledger Journals F Journal Entry Create Update Journal Approval Status Pending Approval Entries Approve gt Standard Journals gt Process Journals gt Review Financial Information gt Worklist gt Reporting Tools gt PeopleTools Approval Action Comments for Denial Email Approval History Step Path Status DateTime S amp p 0 A Initiated 06 01 2009 9 4358AM User ID GSUUSER3 01 A Pending 06 01 2009 9 43 58AM 02 A Pending 06 01 2009 9 43 58AM 03 A Pending 06 01 2009 9 43 58AM E Save Return to Search Notify fy Refresh Header Lines Totals Errors Approval 22 The Spectrum System Georgia State University Entering a Journal Entry Once the recycle option has been selected the approver will need to go to the Lines Page to initiate the recycle status by selecting the Submit Journal item from the Process list Home Worklist Add to Favorites New Window Help Customize Page Unit GSUFS JournalID 1000500178 Date 06 01 2009 Process Submit Joumal v Process _ Change Values _Interintraunit Errors Only Line 10 E Template List Search Criteria b Commitment Control 7 General Ledger v Journals Select Line Ledger SpeedType Account Fund Dept Program Class Bud Ref ei Project Activity An Type Amount Base Currenc Jour
40. s and Footers Header amp webPage amp p of amp P Footer gubbed Orientation Margins inches Portrait Left 0 75 Right 0 75 Landscape Bottom 0 50 Top 0 75 19 The Spectrum System Georgia State University Entering a Journal Entry 4 1 6 Journal Template The user can customize the journal line fields on the Journal Lines page by selecting the Customize hyperlink in the Lines panel ORACLE VVorklist E Add to Favorites New Window Help Custornize Page L 14 2009 Process Edit Journal Process it Errors Only Line 10 Customize Find 8 Fund Dept Program Class Bud Ref Pe Hua Project Activity An Type Amount Base Currency Stat UOM Open Item Key Reference Journal Line Description 10000 Q 612250000 Q 16200 Q 11000 Q 2009 Q Q Q Q 5 00 USD Q Q Q Supplies and Materials 10000 Q 612250000 Q 16200 Q 11000 Q 2009 Q Q Q Q 6 00 USD Q Q Q Purchase Card Transactio Customize Find View All HH First LU 4 of 14 LY Last Total Credits Journal Status Budget Status 5 00 y y st E natty y Refresh From the Column Order box highlight the appropriate field name and click the Move up or Move down arrow ORACLE VVorklist Add to Favorites Sign out gt New Window Help Personalize Column and
41. ss gt Standard Journals _Inter intraUnit gt Import Journals gt Subsystem Journals gt Process Journals gt Suspense Correction Template List Change Values X aaa ii Select Line Ledger SpeedType Account Journal Line Description Fund Dept Program Class Bud Ref Project Amount ummary Ledgers gt Close Ledgers mn 4 ACTUALS a Q Q Q Q Q 2009 Q gt Process Multi Currency gt Average Daily Balance gt Open Items gt Consolidate Financial Data E GE Customize Find View All 8 First LU 4 of 4 L Last b a Standard Unit Total Lines Total Debits Total Credits Journal Status Budget Status udgets gt Monitor Background GSUFS 1 0 000 0 000 I N Process gt Review Financial fa Save E Notify Refresh Information se E notn n gt Regulatory Ledger Header Lines Totals Errors Approval Reports gt XBRL Cash Flow Statement gt General Reports gt Federal Reports gt Project Costing gt Purchasing gt Reporting Tools gt Set Up Financials Supply Chain gt Tree Manager Once all your lines have been entered select the Edit Journal process The edit journal process is used to run a check on the transactions It will verify that the transaction is correctly balanced and if the edit is valid it will also run the budget checking process If there are multiple fund cod
42. sting Process AP Accrual GL Dist Status Distributed Customize Find View All BH Main Information Chartfields Journal Description First L 4 2 of 2 7 Last Monetary Amount Currency Code Ledger GL Unit Accounts Payable 100 00 USD ACTUALS GSUFS test 100 00 USD ACTUALS GSUFS Ss aaa ener ener eee nee eee eee eee ee eee erence 30 The Spectrum System Georgia State University Entering a Journal Entry 8 Inquiring on Ledgers The ledger inquiry page is used to view detail and summary ledger information for a specified string of chartfield values The ledger inquiry allows you to view its journal detail transactions Note Information will only appear in the ledger once a transaction has been posted Click on General Ledger Review Financial Information Ledger Note The first time you use this process you will need to set up a run control Enter LDGR_INQ or any other name and click Add Home Worklist _MuttiChannel Console Add to Favorites _Sign out Menu i gt My Favorites a New Window Help n amp gt Accounts Payable gt Commitment Control edger gt General Ledger g gt Journals F i gt Ledgers Eind an Existing Value Add aNew Value gt Summary Ledgers gt Close Ledgers inqui Name LED_INQ gt Process Multi Currency oe EEO gt Average Daily Balance gt Open Items Add Consolidate Financial Data gt Maintain Standard Find an Existing V
43. tries Source DRGIQ Fiscal Year 2009 gt Standard Journals gt Process Journals Reference Number Period gt Review Financial Information SJE Type ADB Date 06 23 2009 gt Worklist oo gt Reporting Tools Journal Class Save Journal Incomplete Status uksepelbale Transaction Code DEFAULT Q Workflow Department Q Currency Defaults USD CRRNT 1 Commitment Control B Save E Notify Refresh Ey Add Update Display Header Lines Totals Errors Approval The Reference Number field is used to write information that may help us to explain the purpose of the transaction or can be used as a reference in the future The Spectrum System Georgia State University Entering a Journal Entry Select your Department Id in the Workflow Department field by clicking the magnifying glass and making the appropriate selection When searching for the correct Department ID we recommend that the user input some criteria If not the system will give the first three hundred available choices in the table Workflow Department a ORACLE Menu amp Home Worklist Add to Favorites Sign out New Window Help gt Accounts Payable gt GSU gt Purchasing Look Up Workflow Department gt Project Costing gt Travel and Expenses begins with D fy Accoun ReaNahie Department begins with i Look U Clear Cancel i gt Commitment Control _Look Up __Clear Basic Looku v7 General Ledger J
44. y Currency USD Debit Amount 8 195 00 Credit Amount 8 195 00 Net 0 00 All Lines FromiTo From Line ee To Line a Journal Line Hi Drill to Amount in 1 cito Line Line Descr Transaction Currency Account Fund Dept Program Class BudRef PCBusUnit Project Activity An Type BookCode Adius Currency J Ei 13 Office Machines 4 000 00 USD 714100 10000 612250000 16200 11200 2009 a ee _ Eo 33 The Spectrum System Georgia State University Entering a Journal Entry 9 Budget Overview Inquiries The Budget Overview Inquiry component provides summarized and detailed information based on the provided chartfield search criteria Click on Commitment Control Review Budget Activities Budgets Overview Note The first time you use this process you will need to set up a run control Enter BUD_OVW or any other name and click Add ORACLE Worklist MulttiChannel Console Add to Favorites gt My Favorites New Window Help yt gt Accounts Payable gt Commitment Control Budgets Overview gt Define Control Budgets gt Define Budget Security Eind an Existing Value Add a New Value gt Budget Journals gt Post Control Budget Journals Inquiry Name BUD_OVW v Review Budget Activities Budget Details Add Activity Loc Find an Existing Value Add a New Value Review Fund Source Allocations Review Fund Source Activities gt Close Budget gt Budget

Journal entry general ledger user manual

Contents

Download Pdf Manuals

Related Search

Related Contents