1 / 36

Purchase Order Invoices Detailed Universe Guide

Finance Data Ed: ReqPOInv DUG-2005. 2. . . Section 1: Understanding Purchasing data. Finance Data Ed: ReqPOInv DUG-2005. 3. Purchasing data

ellery
Download Presentation

Purchase Order Invoices Detailed Universe Guide

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. Purchase Order Invoices Detailed Universe Guide December 2005

    2. Finance Data Ed: ReqPOInv DUG-2005 2 Section 1: Understanding Purchasing data

    3. Finance Data Ed: ReqPOInv DUG-2005 3 Purchasing data – General information Banner Finance data began in July 2003 There is not a guaranteed one-to-one relationship between requisitions, purchase orders, and invoice vouchers. Transaction date is the date used to post a financial document and its related transactions to the ledgers. Remember, a transaction date can be altered by a user at time of input. For example, future dating or back dating of transactions.

    4. Finance Data Ed: ReqPOInv DUG-2005 4 Document Data Concepts [Review Slide][Review Slide]

    5. Finance Data Ed: ReqPOInv DUG-2005 5 Document Data Concepts [Review Slide][Review Slide]

    6. Finance Data Ed: ReqPOInv DUG-2005 6 Document Data Concepts [Review Slide][Review Slide]

    7. Finance Data Ed: ReqPOInv DUG-2005 7 Document Data Concepts [Review Slide][Review Slide]

    8. Finance Data Ed: ReqPOInv DUG-2005 8 Document Data Concepts [Review Slide][Review Slide]

    9. Finance Data Ed: ReqPOInv DUG-2005 9 From Requisition, to PO, to Invoice Voucher, to Bank Check [Review Slide][Review Slide]

    10. Finance Data Ed: ReqPOInv DUG-2005 10 Requisition, PO, Invoice Voucher Document Concepts [Review Slide] [Review Slide]

    11. Finance Data Ed: ReqPOInv DUG-2005 11 Requisition, PO, Invoice Voucher Document Concepts

    12. Finance Data Ed: ReqPOInv DUG-2005 12 Requisition, Purchase Order, Invoice Vouchers, & Bank Checks [Review the slide] Questions? [Review the slide] Questions?

    13. Finance Data Ed: ReqPOInv DUG-2005 13 Business Objects Sample Reports:

    14. Finance Data Ed: ReqPOInv DUG-2005 14 Finance Purch Order Invoices - Description This Universe contains: C-FOAPAL hierarchy information Posted Document information Requisitions Purchase Orders Receiving & Returns Invoice Vouchers Bank Check payments (C5 only) Vendors [Review Slide][Review Slide]

    15. Finance Data Ed: ReqPOInv DUG-2005 15 Finance Purch Order Invoices – Intended Uses Intended use(s) of this Universe: Analysis of Requisitions Listing Purchase order information Relating PO’s to Invoice Vouchers Relating Bank Checks to the InvVchr’s they pay for [Review Slide][Review Slide]

    16. Finance Data Ed: ReqPOInv DUG-2005 16 Finance Purch Order Invoices – Universe Limitations [Review Slide][Review Slide]

    17. Finance Data Ed: ReqPOInv DUG-2005 17 Tips for Combining Objects in the Universe [Review the slide] Now do the fiscal periods and “buckets” make sense? Questions? Would you like me to show you these ideas with a Business Objects report?[Review the slide] Now do the fiscal periods and “buckets” make sense? Questions? Would you like me to show you these ideas with a Business Objects report?

    18. Finance Data Ed: ReqPOInv DUG-2005 18 Tips for Understanding Objects in the Universe [Review the slide] Now do the fiscal periods and “buckets” make sense? Questions? Would you like me to show you these ideas with a Business Objects report?[Review the slide] Now do the fiscal periods and “buckets” make sense? Questions? Would you like me to show you these ideas with a Business Objects report?

    19. Finance Data Ed: ReqPOInv DUG-2005 19 EDW – Purch Order Invoices Universe Example Query 5: Business Question: I would like a listing of posted Requisitions and related Purchase Orders for my unit

    20. Finance Data Ed: ReqPOInv DUG-2005 20 Finance Purch Order Invoices Universe Example:

    21. Finance Data Ed: ReqPOInv DUG-2005 21 Finance Purch Order Invoices Universe Example:

    22. Finance Data Ed: ReqPOInv DUG-2005 22 Finance Purch Order Invoices Universe Example

    23. Finance Data Ed: ReqPOInv DUG-2005 23 Finance Purch Order Invoices Universe Example:

    24. Finance Data Ed: ReqPOInv DUG-2005 24 Finance Purch Order Invoices Universe Example:

    25. Finance Data Ed: ReqPOInv DUG-2005 25 Finance Purch Order Invoices Universe Results:

    26. Finance Data Ed: ReqPOInv DUG-2005 26

    27. Finance Data Ed: ReqPOInv DUG-2005 27 What is QCH? DS Query Clearinghouse A place to share report templates Any EDW user can post Business Objects files for others to use as a starting point Share and work together! Query Clearinghouse link: https://www.ds.uillinois.edu/Reports/QCH

    28. Finance Data Ed: ReqPOInv DUG-2005 28 Query Clearinghouse

    30. Finance Data Ed: ReqPOInv DUG-2005 30 Resources for Data Warehouse Users DS Monthly Practice Labs Once per month, on each physical campus FAC from Student, Finance, and HR present to answer questions and provide hands on assistance in creation of custom reports View Practice Lab dates: http://www.ds.uillinois.edu/events.asp

    31. Finance Data Ed: ReqPOInv DUG-2005 31 Resources for Data Warehouse Users

    32. Finance Data Ed: ReqPOInv DUG-2005 32 How to Contact DS By filing an on-line Help Desk case http://onlinesupport.uillinois.edu/ds.html. To complete the form: Authenticate via Bluestem Click "Start Here" on the left-hand margin Select "New Case"  Be sure "Decision Support" is listed on Help Desk line (first line of New Case entry form). If it does not, click "Change Help Desk" and select Decision Support from the list of options. Enter your contact information and the nature of your problem Click "Create Case" to submit the case to Decision Support for response Create a Help Desk Ticket Phone the AITS Help Desk: Chicago: (312) 996-4806 Urbana: (217) 333-3102 Springfield: (217) 333-3102 Email the AITS Help Desk: helpdesk2@uillinois.edu (one address for all 3 campuses to use) If you have access to Clarify, Send a Clarify Ticket directly to the ‘Decision Support’ Queue—we’ll take it from there; the appropriate person will respond.

    33. Finance Data Ed: ReqPOInv DUG-2005 33 Appendix 2: Handy Accounting Concepts

    34. Finance Data Ed: ReqPOInv DUG-2005 34 General Ledger Concepts My version of CFOAPAL! – Accounting info – General Ledger My version of CFOAPAL! – Accounting info – General Ledger

    35. Finance Data Ed: ReqPOInv DUG-2005 35 General Ledger Concepts My version of CFOAPAL! – Accounting info - General Ledger T accounts My version of CFOAPAL! – Accounting info - General Ledger T accounts

    36. Finance Data Ed: ReqPOInv DUG-2005 36 Operating Ledger Concepts My version of CFOAPAL! – Accounting info – Operating Ledger My version of CFOAPAL! – Accounting info – Operating Ledger

    37. Finance Data Ed: ReqPOInv DUG-2005 37 Operating Ledger Concepts My version of CFOAPAL! – Accounting info - Operating Ledger T accounts My version of CFOAPAL! – Accounting info - Operating Ledger T accounts

More Related