Read Microsoft Word - BPG_Transaction_Inquiry.doc text version

CSU Bakersfield

PeopleSoft Training

Transaction Inquiry

CSUB Business Process ­ Transaction Inquiry

PeopleSoft Functionality

PeopleSoft delivers a variety of inquiry pages for users to track transactions through the system. Several of the most-frequently used are listed below, along with their navigation. CSUB Business Process

Transaction Inquiry Pages

Inquiry Page Vendor Inquiries Vendor Information Navigation Vendors, Vendor Setup/Maintenance, Vendor Information Purpose Confirm that a vendor exists in the system. Look up an address for a vendor. Identify other transactions associated with a requisition Identify other transactions associated with a purchase order Identify other transactions associated with a voucher Identify other transactions associated with a payment Review a purchase order transaction, including its current status Review a voucher transaction, including its current status Review a payment, including its current status Review a journal entry, including its current status Review accounting entries created by a requisition Review accounting entries created by a purchase order Review accounting entries associated with vouchers and payments

Document Status Inquiries Requisition Document Purchasing, Requisitions, Review Status Requisition Information, Document Status PO Document Status Purchasing, Purchase Orders, Review PO Information, Document Status Voucher Document Accounts Payable, Review, Status Vouchers, Document Status Payment Document Accounts Payable, Review, Status Payments, Document Status Single Transaction Inquiries Review Purchase Orders Purchasing, Purchase Orders, Review PO Information, Purchase Orders Voucher Inquiry Accounts Payable, Review, Vouchers, Voucher Inquiry Payment Inquiry Accounts Payable, Review, Payments, Payment Inquiry Journal Inquiry General Ledger, Review Journal/Ledger Data, Journals Accounting Entry Inquiries Requisition Accounting Purchasing, Requisitions, Review Entries Requisition Information, Accounting Entries Purchase Order Purchasing, Purchase Orders, Accounting Entries Review PO Information, PO Accounting Entries Voucher Accounting Accounts Payable, Review, Entries Vouchers, Voucher Accounting Entries

Document Last Updated: 07/01/03

Page 1 of 7

CSU Bakersfield

PeopleSoft Training

Transaction Inquiry Using PeopleSoft Query to Retrieve Data

PeopleSoft Query is a reporting tool that allows users to build ad-hoc inquiries. At CSUB, the project team creates queries for use by department users. The queries are then accessed through Query Viewer. The following illustrates an example of using PeopleSoft Query to access financial data. Navigation: Reporting Tools, Query, Query Viewer

Here, you may search for the name of an existing query. In the example, we are looking for the Query BAK_LEDGER_TRAINING. Enter part of the Query name and press Search.

Document Last Updated: 07/01/03

Page 2 of 7

CSU Bakersfield

PeopleSoft Training

Transaction Inquiry

Select BAK_LEDGER_TRAINING

Document Last Updated: 07/01/03

Page 3 of 7

CSU Bakersfield

PeopleSoft Training

Transaction Inquiry

The user is prompted for Department, Fiscal Year and Accounting Period. The project team will commonly use prompt values like these in the queries we develop for department users. Enter the requested information into each prompt field and press OK.

Document Last Updated: 07/01/03

Page 4 of 7

CSU Bakersfield

PeopleSoft Training

Transaction Inquiry

Document Last Updated: 07/01/03

Page 5 of 7

CSU Bakersfield

PeopleSoft Training

Transaction Inquiry

This is an example of the results. From here, you may rerun the query by clicking the Rerun Query link, or download the results to Excel by clicking the Download to Excel link.

Document Last Updated: 07/01/03

Page 6 of 7

CSU Bakersfield

PeopleSoft Training

Transaction Inquiry Exercises

1. What is the Vendor ID for the vendor School Savers? In what city is it located? Inquiry page used:_____________________________________ 2. Has requisition number 0000000046 been converted to a purchase order? If so, what is the purchase order number? Have the goods been received? Has the vendor been paid? Inquiry page used:_____________________________________ 3. How was requisition number 00000046 funded? Inquiry page used:_____________________________________ 4. Access Hardware Supply called to ask about invoice number 5171761-IN. Find the check number and check date that shows the invoice was paid. Inquiry page used:_____________________________________ 5. Business Machine Security called to inquire about check number 000068. They are not sure how to apply the check. Find the invoice ID and invoice date for them. 6. Review the general fund (AD203) expenditure amounts for Department ID = D10130. How much was spent in operating expenses during June 2004? Use Query BAK_LEDGER_TRAINING.

Document Last Updated: 07/01/03

Page 7 of 7

Information

Microsoft Word - BPG_Transaction_Inquiry.doc

7 pages

Report File (DMCA)

Our content is added by our users. We aim to remove reported files within 1 working day. Please use this link to notify us:

Report this file as copyright or inappropriate

594984


You might also be interested in

BETA
Oracle Cash Management User Guide
Microsoft Word - Upgrade Value Proposition for JD Edwards World to Enterpri...
Chapter 1