Jun 24, 2011 next the security chapter gives you a good view of how security works in peoplesoft applications and it also explains the preferences settings that go along with security. Oracle general ledger gl interview questions and answers will guide us that oracle general ledger module within oracle financials is an integrated part of the erp package oracle applications. Ledgers can also be interpreted in the last stages of the accounting book of the final entry that holds a summary of data that has been grouped or classified derived from the journals. The general ledger summary report shows line activity by account for a selected fund. Gl the general ledger module is the control center of the peoplesoft financials system as it integrates and reports on information from all modules. Peoplesoft comes delivered with standard currency codes, however, if a particular code does not exist then. This is different than peoplesoft metatables and they should not be included in this wiki general. Finance teams waste days going over mismatched journal entries, and balancing debits and credits, to reconcile the general ledger gl. Reconciling the ledger to subledgers is a control and audit requirement for all organizations as part of regular financial processing. I would like to know what are the tables used in psoft gl and when it gets updated. The peoplesoft general ledger course provides focus is on leading students. A journal can be created by other peoplesoft modules such as accounts payable, accounts. Benchmark for the systems current reporting period and calculations of yeartodate amounts.
The current booktobank reconciliation functionality integrates with general ledger, payables. It is especially critical and time consuming at periodend. Upper level equitization results are not the same as. Book code, 4, identifies subsets of ledger rows to segregate and maintain in the same. How to setup peoplesoft account reconciliation erin mitchell manager. Peoplesoft general ledger processes, such as journal edit, revaluation, closing, position accounting. The general ledger is the master set of accounts that aggregates all transactions recorded for a business. The user can have one ledger that addresses common transactions. A third ledger for entering local gaap adjustments. So far we have discussed the submodules in the peoplesoft financial applications. Customers need to reconcile the ledger balances to bank account balances. How to make peoplesoft multicurrency multibook work for you. List of all tables used in peoplesoft general ledger. It would not be an exaggeration to say that general ledger is the heart of the peoplesoft financial applications.
Peoplesoft general ledger stores large quantities of data to support many business functions in database tables. After you summarize the journals for your business and develop the entries you need for the general ledger, you post your entries into the general ledger accounts. When a person is reconciling the general ledger, this usually means. At, we are here to help you in clearing your oracle 1z0228. When processing accounting entries, you should understand the relationship between peoplesoft asset management business units and peoplesoft general ledger business units.
Read book peoplesoft general ledger study guide peoplesoft general ledger study guide right here, we have countless books peoplesoft general ledger study guide and collections to check out. How to make peoplesoft multicurrency multi book work for you. The general ledger gl in peoplesoft is the repository for all financial transactions. Ledgers can also be interpreted in the last stages of. This tutorial will cover the topic on introduction to general ledger. Cameron has written and presented on this topic for user groups at the local and national level and served on the board of directors for the azoaug from 20022007. Youll learn how to structure your organization for reporting efficiency using business units, ledgers, trees and chartfield management from the ground up.
You can easily pass 1z0228 peoplesoft general ledger 9 certification with the help of our online practice exam. The following chapters walk through the key modules. Next the security chapter gives you a good view of how security works in peoplesoft applications and it also explains the preferences settings that go along with. Peoplesoft application fundamentals and companion documentation. A general ledger is a bookkeeping ledger that serves as a central repository for accounting data transferred from all subledgers like accounts payable, accounts.
The project costing chartfields are available on various page displays and entry grids for use within project costing, expenses, resource management or general ledger. Integrating peoplesoft general ledger with oracles fusion accounting hub. Peoplesoft reporting, bi, and analytics software solutions. General ledger general ledger definition figure 1 base currency.
We additionally come up with the money for variant types and along with type of the books to browse. These questions are the most frequently asked in actual peoplesoft general ledger 9 1z0228 certification exam for oracle peoplesoft general ledger 9 consultant certified expert oce credential. If you use the book code feature to further segregate transactions into. Dec 23, 2011 this tutorial will cover the topic on introduction to general ledger. The table has the financial asset book transactions. Peoplesoft general ledger module oracle peoplesoft.
All other modules such as billing, ar, ap, and so on send. Understanding accounting structureledgers and journals oracle. We discussed most of the important building blocks of general ledger such as chartfields, journals, and ledgers in chapter 1, peoplesoft financials. In peoplesoft enterprise asset management, used for storing financial and. Understanding accounting structureledgers and journals the following illustration depicts a high level view of accounting entry creation and processing in peoplesoft financial applications. The lack of realtime data and the limited drill downs offered by nplosion in psnvision complicate and extend your period close. They are entered using the pages and components mentioned in the preceding list of chartfields and are fully described in the peoplesoft project costing documentation. If you use the book code feature to further segregate transactions into balancing subsets within the.
A ledger consists of posted balances that represents a set of books for a business. This is part of series on general ledger under the process area of finance. Peoplesoft financials training institutes in hyderabad, india. Generally, it is a manual process to ensure that ledger balances agree with the appropriate sub ledger totals. Any financial transactions in peoplesoft general ledger are recorded in the form of journal entries. Oracle peoplesoft enterprise financial management 9. Understanding business units and setid oracle peoplesoft. This course provides stepbystep instruction for implementing, using, and maintaining the fundamentals of peoplesoft general ledger 9. Peoplesoft financial website peoplesoft financial youtube tutorial links job titles peoplesoft techno functional alternatives supply chain management certification peoplesoft financial key words basics a ledger is a set of posted balances that represents a set of balanced books for a business unit.
Peoplesoft financial applications offer the following 25 chartfields. Peoplesoft general ledger supports detail, multiple, and summary ledgers. If you are using different business units for the applications because you use multiple ledgers, you must be sure to specify the ledger. Expert oracle university instructors will teach you how to structure your organization for optimal performance for business units, ledgers, trees. How to make peoplesoft multicurrency multibook work.
A typical peoplesoft financials implementation requires the following configuration activities. Peoplesoft finance tip sheet general ledger summary report page 1 of 1 12109 general ledger summary report this documentation will show users the general ledger summary report. An additional accounting period in the peoplesoft financials system, used to. Oracle 1z0228 certification online practice exam and sample. This module performs the critical function of consolidating the accounting information from various sources peoplesoft modules as well as non peoplesoft systems and performing management reporting. Proprietary and confidential to state of georgia sao, opb and anteo group, inc. This tutorial covers the general ledger a key concept in accounting from both points of view. Peoplesoft general ledger foundation accelerated 9. Peoplesoft general ledger processes, such as journal edit, revaluation, closing, position accounting, and so on, with the appropriate balance sheet or off balance sheet account to.
This is different than peoplesoft metatables and they should not be included in this wiki. The companion documentation consists of important topics that apply to many or all peoplesoft applications across the financials, enterprise service automation. General ledger ledger populated by gl posting process. As a result, we will not discuss this area in our book. Tip peoplesoft recommends using bu names that are five characters long. At, we believe in the more you try, the more confidence you gain, please try our sample practice exam to build the trust.
All other modules such as billing, ar, ap, and so on send their accounting selection from oracle peoplesoft enterprise financial management 9. Heres a way for your company to implement a complete and flexible financial infrastructure in a clientserver environment without the burdens of lowlevel programming. Summary peoplesoft general ledger is the central repository of all accounting information created by accounting transactions. Melanie anjele cameron has 15 years of experience with oracle ebusiness suite, beginning on r9, and has worked with subsequent release making her wellversed on both oracles. Read book peoplesoft general ledger study guide peoplesoft general ledger study guide right here, we have countless books peoplesoft general ledger study guide and collections to check. Journal processing in peoplesoft general ledger peoplesoft.
Peoplesoft enterprise fin general ledger version 9. The user can then create reports using nvision and. Setting general ledger user preferencesconcept see it. Understanding accounting structureledgers and journals the following illustration depicts a high level view of accounting entry creation and processing in peoplesoft financial. This peoplesoft ps nvision for general ledger rel 9. The author, an experienced implementor of peoplesoft systems.
Virtual ledgers provide an alternative view of ledger data that can be used for psnvision reporting purposes. Melanie anjele cameron has 15 years of experience with oracle ebusiness suite, beginning on r9, and has worked with subsequent release making her wellversed on both oracles functionality and business impacts. Heres a way for your company to implement a complete and flexible financial infrastructure in a clientserver environment without the burdens of lowlevel. Virtual ledgers are not setup and configured as part of the peoplesoft. Harnessing oracle governance, risk, and compliance.
Select the ledger, ledger group, and source to be used as defaults for this user. Peoplesoft general ledger module oracle peoplesoft enterprise. General ledger summary report general ledger summary report. The only primary currency for the general ledger business unit sometimes referred to as the book currency, will be usd. This intensive, 5day peoplesoft general ledger foundation accelerated rel 9. However, additional, essential information describing the setup and design of your system resides in companion documentation. A wiki for the community to start organizing peoplesoft financials tables in one place. When posting to the general ledger, include transaction dollar amounts, as well as references to where material was originally entered into the books, so you can track a. How to enter manual general ledger gl journal entry. Each activity in a company is posted to two accounts in the. But, implementation remains complex and requires reengineering of the business processes and cultures of the using organizations. Peoplesoft financials general ledger task guide task tab process new journal entry add a new value enter data edit journal process button post journal process button delete a journal find an existing value delete journal process button entry not posted search and select the edit reqdvaliderrors. The ledger approach allows users to define different or multiple ledgers to suit the organizations structure.
Oracle 1z0228 certification online practice exam and. Summary oracle peoplesoft enterprise financial management 9. Billing, accounts receivable, asset management, accounts payable, general ledger, expenses, and commitment control. Peoplesoft general ledger processes, such as journal edit, revaluation, closing, position accounting, and so on, with the appropriate balance sheet or off balance sheet account to perform the necessary balancing. It is a financial management solution within ebusiness suite for entering journals, planning and budgeting, financial reporting etc of large companies. Virtual ledgers are not setup and configured as part of the peoplesoft general ledger system, thus they cannot accept transactions and are used exclusively for psnvision reporting. Oracle general ledger gl interview questions and answers will guide us that oracle general ledger module within oracle financials is an integrated part of the erp package oracle. Peoplesofts account reconciliation is a flexible tool used to configure and manage the account reconciliation. Select to change the journal date in the corrections journal which is on the journal suspense correction page. Optimizing general ledger performance introduction. General ledger gl in accounting is a collection of accounts used to summarize transactions that have been recorded in the journals.
665 550 953 745 242 120 1457 1394 1145 806 1549 1447 349 444 525 1551 1078 56 777 1044 772 1010 957 341 121 1343 335 1206 369 347 1028 341 857 1362