1 / 42

General Ledger

General Ledger. GL Inquiry Pages. GL Inquiry Pages Overview. Made in UMS WebFAST replacement Provides all the functionality of WebFAST and more!. Set your own search criteria and save for future use Search for detail or summary values Print results in PDF format Download to Excel

brooklyn
Download Presentation

General Ledger

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

E N D

Presentation Transcript

  1. General Ledger GL Inquiry Pages University of Maine System

  2. GL Inquiry Pages Overview • Made in UMS WebFAST replacement • Provides all the functionality of WebFAST and more! • Set your own search criteria and save for future use • Search for detail or summary values • Print results in PDF format • Download to Excel • Access to data determined by security settings University of Maine System

  3. Login to PeopleSoft Portal From Portal Menu select: University of Maine > Enterprise Applications > Financials When you select Financials link, new browser window opens for PeopleSoft Financials From Financials menu select: University of Maine > General Ledger > GL Inquiry Access University of Maine System

  4. New GL Inquiry page opens with Find an Existing Value tab selected New GL Inquiry University of Maine System

  5. First time you use GL Inquiry, need to enter GL Inquiry Search ID Select Add a New Value tab New GL Inquiry University of Maine System

  6. New GL Inquiry • Enter name for your search in GL Inquiry Search ID field • Name may consist of up to 30 alpha/numeric characters and may include spaces • Select University of Maine System

  7. Search Criteriapage opens Enter Search Criteria Search name appears University of Maine System

  8. Enter Fiscal Year & Accounting Period Enter Fiscal Year Look Up and select AccountingPeriod University of Maine System

  9. For each ChartField you include in your search criteria you can: Enter a specific ChartField value, or … Enter a node from a ChartField tree If you are including more than one ChartField in your search criteria, can enter a specific value for one and a tree node value for another Consider Your Search Criteria University of Maine System

  10. Search Criteria - Detail Value Enter ChartField Value related to your search Narrow results by entering first few digits of ChartField code before conducting look up University of Maine System

  11. Search Criteria - Detail Value From Look Up page, select ChartField value or Description to enter it on Search Criteria page University of Maine System

  12. Search Criteria - Detail Search ChartField value appears in ChartFieldbox on Search Criteria page University of Maine System

  13. We use Trees to organize ChartField data, setup security, create summary reports and change organizational structure without changing entire system Trees provide easy to follow visual representation of ChartField hierarchy PeopleSoft Trees University of Maine System

  14. Look Up Tree Node To enter tree node in critera, click on Look up Tree icon adjacent to ChartField University of Maine System

  15. Look Up Tree Node • Display and Select TreeNodes page opens • In this example, top level nodes on the Department tree for each Business Unit appears under the “AllDEPTS” node Click on Expand Node icon to left of relevant node University of Maine System

  16. Look Up Tree Node • System tracks path to selected node • Nodes along path are clickable links Top level nodes on ChartField tree for the Business Unit will appear University of Maine System

  17. Look Up Tree Node Can click on Expand Node icon to right of Business Unit to view all Business Unit tree nodes for ChartField University of Maine System

  18. Look Up Tree Node • Might result in a list several pages long • Advance to next page by clicking on next arrow University of Maine System

  19. Look Up Tree Node • Continue drilling down until you reach relevant node • Click on node and choose on Display and Select TreeNodes page To limit results, select Expand Node icon adjacent to top level node related to your search University of Maine System

  20. Look Up Tree node Node name appears in ChartFieldbox on Search Criteria page University of Maine System

  21. Find Value Feature • Can also use Find Value feature to locate and select tree nodes or specific value on a tree From Display and Select TreeNodes page, select University of Maine System

  22. Find Value Feature • Enter or look up the tree node name or enter its descriptionin theFind Tree Nodesection,or… • Enter all or part of the Department code or its description in the Find Detail Value section Select when ready University of Maine System

  23. Find Value Feature Choose when ready University of Maine System

  24. Save GL Inquiry Search Criteria To use this search criteria in future, select after all criteria is set University of Maine System

  25. GL Inquiry Search Select University of Maine System

  26. GL Inquiry Search Results One search result row will return for each combination of values that match criteria University of Maine System

  27. GL Inquiry Search Results No value entered for a ChartField will return all values for the ChartField related to the set criteria, including blank University of Maine System

  28. GL Inquiry Search Results • In thisexample, many rows returned for the set criteria • Each row represents a different combination of values resulting from the search University of Maine System

  29. GL Inquiry Search Results Select any link in a search result row to open Summary Display page University of Maine System

  30. Summary Display Summary display of corresponding Asset/Liabilities and/or Revenues/Expenses appear in separate sections University of Maine System

  31. Summary Display - Attributes Select Attributes link to view corresponding FAST account values, effective dates and status… University of Maine System

  32. Summary Display - Attributes University of Maine System

  33. Refine Search Select Refine Search button at any point to return to Search Criteria page University of Maine System

  34. Display Details Select Display Details radio button to view detail results University of Maine System

  35. Display Detail Displays Account numbers Detail page shows subtotals for each summary level and NET BALANCE University of Maine System

  36. Download Results to Excel Select Excel icon to download results in adjacent section University of Maine System

  37. Print Results Can print page to PDF at any point Click Print icon to start process to create PDF University of Maine System

  38. Print Results Can print or save PDF file University of Maine System

  39. View Journal Entry Details Select underlined value to access Journal Details page University of Maine System

  40. Journal Details Page Page lists lines from all journal entries submitted for period University of Maine System

  41. Journal Details Page • Information entered on journal line displays in Journal Entries section Click on Journal ID link to display Journal Header and other Information University of Maine System

  42. Journal Header Information entered on Header page of corresponding journal entry appears here University of Maine System

More Related