Docstoc

Cardinal Delivered Reports

Document Sample
Cardinal Delivered Reports Powered By Docstoc
					                                         Cardinal Delivered Reports




This document provides a list of all of the delivered reports in Cardinal.

Each tab provides a list of delivered reports available by the specified functional area.

All reports, except for those containing sensitive data, will be available to all users.


User executed reports are available for 30 days and batch reports are available for 90 days from post date.
                                                    Cardinal Delivered Reports Job Aid - Accounts Payables


  Report
              Report Name                        Report Description                   Report Navigation Path     Query / Report   Comments
  Number
APS8003    Voucher Listing by    Listing of vouchers that contain the Chartfield(s) Main Menu > Accounts       Report
           Chartfield            specified in the report run control.               Payable > Reports >
                                                                                    Vouchers > Voucher
                                                                                    Listing by Chartfield
APY1090    Match Exceptions      Lists the match exceptions with voucher data,      Main Menu > Accounts       Report
                                 purchase order data, receiver data, and match      Payable > Reports >
                                 error information. For each Buyer Name, the report Vouchers > Match
                                 lists Voucher Data (Unit, Voucher, Line Vchr Qty, Exceptions
                                 Vchr Price, Vchr Amt); Purchase Order Data (Unit,
                                 PO ID, Line, Sched, PO Qty, PO Price, PO Amt);
                                 Receiver Data (Unit, Recv ID, Line, Seq); and
                                 Match Error information (Match Control ID, Match
                                 Rule).
APY1406    Payables Open         Lists all open liabilities by business unit.       Main Menu > Accounts       Report
           Liability                                                                Payable > Reports >
                                                                                    Voucher Reconciliation >
                                                                                    Payables Open Liability

APY2000    Payment History by    Provides a register of payments for a vendor.        Main Menu > Accounts     Report
           Vendor                                                                     Payable > Reports >
                                 Using the Print Options radio buttons on the         Vendor > Payment History
                                 Payment History by Vendor page, you can              by Vendor
                                 generate either a Detail, or a Summary version of
                                 this report.
EXC4500    Expense Report        Prints a standard expense report.                    Main Menu > Travel and Report
                                                                                      Expenses > Central Entry
                                                                                      > Expense Report > Print
                                                                                      Report
EXC5500    Cash Advance          Prints a standard cash advance request.              Main Menu > Travel and Report
                                                                                      Expenses > Central Entry
                                                                                      > Cash Advance > Print
                                                                                      Cash Advances


EXC8500    Travel Authorization Lists travel authorizations that are in the expense   Main Menu > Travel and Report
                                system.                                               Expenses > Central Entry
                                                                                      > Travel Authorization >
                                                                                      Print Travel Authorization



EXC3500    GL Balancing Report Lists transaction balancing with general ledger        Main Menu > Travel and   Report
                               entries.                                               Expenses > Manage
                                                                                      Accounting > Print
                                                                                      Reports > GL Balancing
                                                                                      Report



                                                                                                                                             2
                                                  Cardinal Delivered Reports Job Aid - Accounts Payables


  Report
              Report Name                      Report Description                    Report Navigation Path     Query / Report   Comments
  Number
EXC5601    Cash Advances by    Lists all cash advances billed to a specific          Main Menu > Travel and Report
           Bus Unit            business unit.                                        Expenses > Manage
                                                                                     Accounting > Print
                                                                                     Reports > Cash Advances
                                                                                     by Bus Unit
EXC5600    Cash Advances by    Lists all cash advances billed to a specific          Main Menu > Travel and Report
           Dept                department.                                           Expenses > Manage
                                                                                     Accounting > Print
                                                                                     Reports > Cash Advances
                                                                                     by Dept
EXC5701    Cash Advance Aging Lists all outstanding cash advances for a business Main Menu > Travel and       Report
           by Bus Unit        unit and how long they have been outstanding.      Expenses > Manage
                                                                                 Accounting > Print
                                                                                 Reports > Cash Advance
                                                                                 Aging by Bus Unit




EXC5700    Cash Advance Aging Lists all outstanding cash advances for a              Main Menu > Travel and Report
           by Dept            department and how long they have been                 Expenses > Manage
                              outstanding.                                           Accounting > Print
                                                                                     Reports > Cash Advance
                                                                                     Aging by Dept
EXC4601    Expense Trans by    Lists all expense transactions billed to a specific   Main Menu > Travel and Report
           Bus Unit            business unit.                                        Expenses > Manage
                                                                                     Accounting > Print
                                                                                     Reports > Expense Trans
                                                                                     by Bus Unit




                                                                                                                                            3
                                                    Cardinal Delivered Reports Job Aid - Accounts Payables


  Report
              Report Name                        Report Description                     Report Navigation Path     Query / Report   Comments
  Number
EXC4600    Expense Transaction Lists all expense transactions billed to a specific      Main Menu > Travel and   Report
           by Dept             department.                                              Expenses > Manage
                                                                                        Accounting > Print
                                                                                        Reports > Expense
                                                                                        Transaction by Dept




EXAVEM_XR Employee Average       Lists the average amount spent by an employee          Main Menu > Travel and   Report
PT        Expenses               over a period of time. Select Direct Report            Expenses > Manage
                                 Employees to list the employees that report directly   Accounting > Print
                                 to the user that is signed on.                         Reports > Employee
                                                                                        Average Expenses
EXETRD_XR Employee Trends        Lists the trend of an employee's expenses over a       Main Menu > Travel and   Report
PT                               specified period of time. Select Direct Report         Expenses > Manage
                                 Employees to list the employees that report directly   Accounting > Print
                                 to the user that is signed on.                         Reports > Employee
                                                                                        Trends
EXESPD_XR Employee Top           Lists the amount that an employee has spent over       Main Menu > Travel and   Report
PT        Spenders               a given period of time. The report is displayed in     Expenses > Manage
                                 descending monetary amount (the highest                Accounting > Print
                                 spenders are at the top of the page). Select Direct    Reports > Employee Top
                                 Report Employees to list the employees that report     Spenders
                                 directly to the user that is signed on.




                                                                                                                                               4
                                                 Cardinal Delivered Reports Job Aid - Accounts Payables


  Report
              Report Name                     Report Description                  Report Navigation Path      Query / Report   Comments
  Number
EXC2501    Employee Data by    Lists employee personal, organizational, and job   Main Menu > Travel and   Report
           Business Unit       data by business unit.                             Expenses > Manage
                                                                                  Employee Information >
                                                                                  Employee Data by
                                                                                  Business Unit




EXC2500    Employee Data by    Lists employee personal, organizational, and job   Main Menu > Travel and   Report
           Department          data by department.                                Expenses > Manage
                                                                                  Employee Information >
                                                                                  Employee Data by
                                                                                  Department
EXC2510    Business Purpose    Lists Business Purposes defined in PeopleSoft    Main Menu > Set Up        Report
                               Expenses                                         Financials/Supply Chain >
                                                                                Product Related >
                                                                                Expenses > Reports >
                                                                                Business Purpose
EXC2581    Cash Advance        Lists Cash Advance Sources defined in PeopleSoft Main Menu > Set Up        Report
           Source              Expenses.                                        Financials/Supply Chain >
                                                                                Product Related >
                                                                                Expenses > Reports >
                                                                                Cash Advance Source


EXC2570    Standard Distance   Lists Standard Distance Rates defined in           Main Menu > Set Up        Report
           Rates               PeopleSoft Expenses.                               Financials/Supply Chain >
                                                                                  Product Related >
                                                                                  Expenses > Reports >
                                                                                  Standard Distance Rates




                                                                                                                                          5
                                                  Cardinal Delivered Reports Job Aid - Accounts Payables


  Report
              Report Name                      Report Description                  Report Navigation Path       Query / Report   Comments
  Number
EXC2523    Expense Billing      Lists Expense Billing Codes defined in PeopleSoft Main Menu > Set Up        Report
           Code                 Expenses.                                         Financials/Supply Chain >
                                                                                  Product Related >
                                                                                  Expenses > Reports >
                                                                                  Expense Billing Code




EXC2530    Expense Location     Lists Expense Locations defined in PeopleSoft     Main Menu > Set Up        Report
                                Expenses.                                         Financials/Supply Chain >
                                                                                  Product Related >
                                                                                  Expenses > Reports >
                                                                                  Expense Location
EXC2529    Expense Location     Lists Expense Location Amounts defined in         Main Menu > Set Up        Report
           Amount               PeopleSoft Expenses.                              Financials/Supply Chain >
                                                                                  Product Related >
                                                                                  Expenses > Reports >
                                                                                  Expense Location Amount

EXC2522    Expense Type         Lists Expense Types defined in PeopleSoft         Main Menu > Set Up          Report
                                Expenses.                                         Financials/Supply Chain >
                                                                                  Product Related >
                                                                                  Expenses > Reports >
                                                                                  Expense Type
EXC2561    Payment Type         Lists Payment Types defined in PeopleSoft         Main Menu > Set Up          Report
                                Expenses.                                         Financials/Supply Chain >
                                                                                  Product Related >
                                                                                  Expenses > Reports >
                                                                                  Payment Type
EXC2525    Preferred Merchant   Lists Preferred Merchants defined in PeopleSoft   Main Menu > Set Up          Report
                                Expenses.                                         Financials/Supply Chain >
                                                                                  Product Related >
                                                                                  Expenses > Reports >
                                                                                  Preferred Merchant
EXC2540    Reimbursement        Lists Reimbursement Actions defined in            Main Menu > Set Up          Report
           Action Code          PeopleSoft Expenses.                              Financials/Supply Chain >
                                                                                  Product Related >
                                                                                  Expenses > Reports >
                                                                                  Reimbursement Action
                                                                                  Code




                                                                                                                                            6
                                                                           Cardinal Delivered Reports Job Aid - Accounts Receivable


  Report
                 Report Name                        Report Description                        Report Navigation Path           Query / Report   Comments
  Number
AR_AGEBU      AR_AGEBU            Provides aging details such as business unit,        Reporting Tools > Query >         Query
                                  customer id, aging id, aging category, aging count,  Query Manager
                                  and grouped by business unit, customer, aging id and
                                  aging category.



AR_CUSTOM AR Customers In         Lists setid, customer id, dispute code, date, dispute     Reporting Tools > Query >    Query
ERS_IN_DIS Dispute                amount                                                    Query Manager
PUTE


AR_ITEMS_I AR Items In Dispute Lists cust, item, line, sum balance where dispute date Reporting Tools > Query >          Query
N_DISPUTE                      is less than input parameter.                          Query Manager




AR11002P      AR11002P AR         Lists all pending items within a group, in either the     Accounts Receivable >        Report
              11002 Pending       business unit base currency or the entry currency.        Pending Items, Reports >
              Items               Specify a point in time when you run the report.          Pending Item - Point in Time
                                  (Crystal)                                                 > Pending Item - Point in
                                                                                            Time

AR20001       AR20001 Deposit     Lists detailed information for deposits, in either the    Accounts Receivable >         Report
              Summary             business unit base currency or the entry currency.        Payments > Reports >
                                  (SQR)                                                     Deposit Control by Entry Date
                                                                                            > Deposit Control by Entry
                                                                                            Date



AR20001P      AR20001P Deposit    Lists detailed information for deposits, in either the    Accounts Receivable >        Report
              Control             business unit base currency or the entry currency.        Payments > Reports >
                                  (Crystal)                                                 Deposit Control - Point in
                                                                                            Time > Deposit Control -
                                                                                            Point in Time

AR21001       AR21001 Payment     Lists predicted payments. If a remit from setID and       Accounts Receivable >        Report
              Predictor Detail    customer are associated with the payment, it is listed.   Payments > Reports >
                                  If more than one remit from setID and customer are        Payment Predictor Detail >
                                  associated with the payment, only one is listed.          Payment Predictor Detail
                                  (SQR)




AR31002       AR31002 Business    Lists all customers and customer addresses within a       Accounts Receivable >        Report
              Unit Customers      business unit. (SQR)                                      Customer Accounts >
                                                                                            Customer Reports >
                                                                                            Customers by Unit >
                                                                                            Customers By Unit



                                                                                                                                                           7
                                                                           Cardinal Delivered Reports Job Aid - Accounts Receivable


AR31004    AR31004 Business         Lists all customers and customer contacts within a        Accounts Receivable >       Report
           Unit Contacts            business unit. (SQR)                                      Customer Accounts >
                                                                                              Customer Reports > Contacts
                                                                                              by Unit > Contacts By Unit

AR33006    AR33006 Dunning          Provides a preview of which dunning letters will print. Accounts Receivable >          Report
           Letter Preview           (Crystal)                                               Customer Interactions >
           Report                                                                           Dunning Letters > Print Letter
                                                                                            > Dunning Letter Print


AR34001    AR34001 AR/AP            Lists all open vouchers for each vendor ID that           Accounts Receivable >     Report
           Balance by               corresponds to the selected customer ID. It also lists    Customer Accounts >
           Customer                 all items for the customer. The vouchers are grouped      Customer Reports > AR/AP
                                    by vendor ID, by payables business unit within vendor     Balance by Customer >
                                    and currency within payables business unit. (Crystal)     AR_AP Balance by Customer

AR34003    AR34003 AR               Lists detailed item information by customer, including Accounts Receivable >            Report
           Customer Item            entry type, balance, reference, dispute, terms, and    Customer Accounts > Item
           Inquiry                  discount date. (Crystal)                               Information > Item List >
                                                                                           Select Generate an Open
                                                                                           Item Report in the Item
                                                                                           Action field and click Go on
                                                                                           the Item List page.


AR50002P   AR50002P                 Shows summarized accounting entry information by          Accounts Receivable >         Report
           Accounting Entries -     accounting date, in the business unit base currency. It   Pending Items > Reports >
           Summary by               shows one line for each ChartField for each               Accting Entries - Point in
           Accounting Date          accounting date. You specify a point in time when you     Time > Accounting Entries -
                                    run the report. (Crystal)                                 Point in Time


AR60002P   AR60002P Item            Shows a picture of business unit activity for a           Accounts Receivable >          Report
           Activities by Entry      selected date range summarized by entry type and          Receivables Analysis >
           Type/Origin              origin ID. You specify a point in time when you run       Receivables Reports >
                                    the report. (Crystal)                                     Business Unit Activity - PIT >
                                                                                              Unit Activity - Point in Time

AR60003P   AR60003P Item            Shows a picture of business unit activity for a           Accounts Receivable >          Report
           Activities by Entry      selected date range summarized by entry type and          Receivables Analysis >
           Type/Reason              reason. You specify a point in time when you run the      Receivables Reports >
                                    report. (Crystal)                                         Business Unit Activity - PIT >
                                                                                              Unit Activity - Point in Time

AR60004P   AR60004P Item            Shows a picture of business unit activity for a           Accounts Receivable >          Report
           Activities by Activity   selected date range summarized by activity type,          Receivables Analysis >
           Type                     such as Billing or Cash Applied. You specify a point in   Receivables Reports >
                                    time when you run the report. (Crystal)                   Business Unit Activity - PIT >
                                                                                              Unit Activity - Point in Time




                                                                                                                                      8
                                                                            Cardinal Delivered Reports Job Aid - Accounts Receivable


AR60005P   AR60005P Item            Shows a picture of business unit activity for a             Accounts Receivable >          Report
           Activities by Activity   selected date range summarized by activity type,            Receivables Analysis >
           Type/Origin              such as Billing or Cash Applied, and origin ID. You         Receivables Reports >
                                    specify a point in time when you run the report.            Business Unit Activity - PIT >
                                    (Crystal)                                                   Unit Activity - Point in Time

BIAART01   BIAART01 AR              A reprint that displays all of the pending items that are   Billing > Generate Invoices > Report
           Pending Items            processed in a specified accounts receivable (AR)           Reproduce Reports > AR
           (accounts receivable     entry date range. For example, you may want to              Pending Item Report
           pending items)           regenerate lost reports that previous Load AR
                                    processes created.                                          Billing > Generate Invoices >
                                                                                                Reproduce Reports > Consol
                                                                                                AR Pending Item Report >
                                                                                                Consolidated AR Pending
                                                                                                Item

AR33001    AR33001-Level One Query listings all Level One Dunning Letters and                   Reporting Tools > Query >       Query
           Dunning Ltr       corresponding information per specified operator.                  Query Manager


AR33001    AR33001 Level 1          Dunning letter model that you may modify as                 Accounts Receivable >          Report
           Dunning Letter           necessary. As delivered with the system, this letter        Customer Interactions >
                                    includes only items in the age range for dunning level      Dunning Letters > Print Letter
                                    one. (Crystal)                                              > Dunning Letter Print

AR33002    AR33002-Level Two Query listings all Level Two Dunning Letters and                   Reporting Tools > Query >       Query
           Dunning Ltr       corresponding information per specified operator.                  Query Manager

AR33002    AR33002 Level 2          Dunning letter model that you may modify as                 Accounts Receivable >          Report
           Dunning Letter           necessary. As delivered with the system, this letter        Customer Interactions >
                                    includes only items in the age range for dunning level      Dunning Letters > Print Letter
                                    two. (Crystal)                                              > Dunning Letter Print

AR33003    AR33003-Level            Query listings all Level Three Dunning Letters and          Reporting Tools > Query >       Query
           Three Dunning Lr         corresponding information per specified operator.           Query Manager

AR33003    AR33003 Level 3          A dunning letter model that you may modify as               Accounts Receivable >          Report
           Dunning Letter           necessary. As delivered with the system, this letter        Customer Interactions >
                                    includes only items in the age range for dunning level      Dunning Letters > Print Letter
                                    three. (Crystal)                                            > Dunning Letter Print


AR33005    AR33005 Dunning       Shows the dunning letters that were printed from all           Accounts Receivable >          Report
           Letter Control Report dunning runs. For example, use to see which letter             Customer Interactions >
                                 was last sent to a customer. (Crystal)                         Dunning Letters > Print Letter
                                                                                                > Dunning Letter Print




                                                                                                                                        9
                                                                       Cardinal Delivered Reports Job Aid - Accounts Receivable


BIIVCLC   BIIVCLC Pro forma   Consolidated Invoice - Landscape Orientation. All          Billing > Generate Invoices > Report
          or Invoice          bills that are attached to a consolidated header must      Consolidated > Finalize and
                              have the same orientation layout as the consolidated       Print Invoices > Consolidated
                              header, although they may have different forms.            Final and Print

                              This program prints either a pro forma or an invoice,
                              depending on which menu option you select. This
                              program prints pro formas only for bills with a status
                              other than INV and prints invoices only for bills with a
                              status of INV.

BIIVCLN   BIIVCLN Pro forma   Regular Invoice - Landscape Orientation. There are         Billing > Generate Invoices > Report
          or Invoice          two delivered standard landscape layouts:                  Non-Consolidated > Single
                              LANDSCAPE and ORDERMGMT. This program                      Action Invoice
                              prints either a pro forma or an invoice, depending on
                              which menu option you select. This program prints
                              pro formas only for bills with a status other than INV
                              and prints invoices only for bills with a status of INV.

AR32000   AR32000 Customer    The Open Item Statement is a statement that                Accounts Receivable >        Report
          Statement           provides detailed information for all open items for a     Customer Interactions >
                              specific customer. The Open Item Statement lists all       Statements > Create
                              open items for a customer, the total amount open,          Customer Statements
                              and the aging of open items.
AR32001   AR32001 Balance     The Balance Forward Statement is a statement that          Accounts Receivable >        Report
          Forward             provides a list of all the items and payments in the       Customer Interactions >
                              current statement period. It also provides a balance       Statements > Create
                              forward amount from the previous statement period          Customer Statements
                              and the ending balance for the current statement
                              period




                                                                                                                                  10
                                                                     Cardinal Delivered Reports Job Aid - General Ledger


  Report                                                                            Report Navigation
              Report Name                       Report Description                                     Query / Report      Comments
  Number                                                                                    Path
GLS7002    Ledger Activity        Lists the beginning and ending ledger balances Main Menu > General Report
                                  by ChartField combination and account. Also      Ledger > General
                                  lists the detailed journal line activity that is Reports > Ledger
                                  posted against the ledger for the accounting     Activity
                                  periods that are specified.




GLS7016    Ledger Activity with   Lists the journal activity and the associated       Main Menu > General Report
           Attribute              attributes for one or more specific ChartFields     Ledger > General
                                  in a ledger for one or more periods, including      Reports > Ledger
                                  beginning and ending balances.                      Activity with Attribute

FIN2001    Journal Entry Detail   Displays all journal entries that were entered in   Main Menu > General Report
                                  the system for a business unit and ledger within    Ledger > General
                                  the date range specified. Prints the journal        Reports > Journal
                                  entries in ascending ID order within the ledger     Entry Detail
                                  and shows the journal date, the source,
                                  whether a reversal entry was created, journal
                                  status, posted date (if any), and a description.
                                  For each line that is included in the journal
                                  entry, lists the line number of the entry, the
                                  account number, a description, the department,
                                  product, and project ChartField values, and
                                  debit and credit detail. Also prints statistical
                                  information where included in a journal entry.


GLS7010    Ledger vs Journal      Checks for any discrepancy between Ledger           Main Menu > General Report
           Integrity              and Journal tables within a specified period        Ledger > General
                                  range.                                              Reports > Ledger vs
                                                                                      Journal Integrity

GLS7001    Standard Journals      Lists standard journal entries and their status.Main Menu > General Report
                                                                                  Ledger > General
                                                                                  Reports > Standard
                                                                                  Journals
GLS3001    InterUnit Activity     Displays reconciliation information by business Main Menu > General Report
                                  unit, ChartField, primary and balancing values, Ledger > General
                                  and variance.                                   Reports > InterUnit
                                                                                  Activity




                                                                                                                                      11
                                                                   Cardinal Delivered Reports Job Aid - General Ledger


  Report                                                                            Report Navigation
              Report Name                     Report Description                                         Query / Report   Comments
  Number                                                                                    Path
GLS7012    Trial Balance        Combines detail and summary balance                Main Menu > General Report
                                information. Shows the ending ledger balances Ledger > General
                                for the specified year and period by ChartField Reports > Trial
                                combination. Also displays subtotals by            Balance
                                ChartField. Prints a final total for debits and
                                credits.
GLS7003    Ledger Summary       Summarizes journal totals within a ledger by       Main Menu > General Report
                                ChartField.                                        Ledger > General
                                                                                   Reports > Ledger
                                                                                   Summary
FIN2005    Journal Entry with   This report is similar to the Journal Entry Detail Main Menu > General Report
           Attributes           Report, except that this report also lists the     Ledger > General
                                ChartField attribute values.                       Reports > Journal
                                                                                   Entry with Attributes




GLS8012    Journal Line/Acctg   Compares journal entry lines with accounting        Main Menu > General Report
           Reconciliation       entries.                                            Ledger > General
                                                                                    Reports > Journal
                                                                                    Line/Acctg Reconcil




GLS3000    Open Item Listing    Lists open Items for the accounts specified,        Main Menu > General Report
                                including a description of the accounts, the        Ledger > Open Items
                                OpenItem key field, and a detailed listing of the   > Open Item Listing
                                journal lines that have an open status up to the    Report
                                as of date. The journal lines are subtotaled by
                                key field value. Journal lines containing
                                OpenItem accounts are matched together
                                based on the OpenItem edit field.




GLS5500    ADB Definition       Prints ADB details, including description,          Main Menu > General Report
                                purpose, and ChartField information.                Ledger > Average
                                                                                    Daily Balance > ADB
                                                                                    Definition Report




                                                                                                                                     12
                                                                 Cardinal Delivered Reports Job Aid - General Ledger


  Report                                                                          Report Navigation
              Report Name                  Report Description                                          Query / Report   Comments
  Number                                                                                  Path
GLC5501    ADB Calculation   Lists ADB calculation details, including            Main Menu > General Report
                             averaged period, date, and time.                    Ledger > Average
                                                                                 Daily Balance > ADB
                                                                                 Calculation Report




GLS1002    Closing Rule      Displays information about closing set rules. It    Main Menu > General Report
                             prints a description of the close set, identifies   Ledger > Close
                             the name of the account ChartField, and shows       Ledgers > Closing
                             the ChartField to which that profit and loss        Rule Report
                             account will be closed. Also shows the option
                             for retaining earnings in the ChartField.


GLS1003    Closing Trial     Summarizes all entries on the ledger by             Main Menu > General Report
           Balance           account type. Prints beginning and ending           Ledger > Close
                             balances for the year, totals for the period,       Ledgers > Closing
                             adjustments, and closing entries.                   Trial Balance

GLS1004    Journal Closing   Displays the journal line details for journal lines Main Menu > General Report
           Status            with various closing statuses.                      Ledger > Close
                                                                                 Ledgers > Journal
                                                                                 Closing Status
                                                                                 Report
GLS1001    Summary Ledger    This is a template for designing reports based Main Menu > General Report
           Detail            on user-specific ledger definitions. This is        Ledger > Summary
                             based on the summary ledger                         Ledgers > Summary
                             (PS_S_LEDGER_SUM), which you can find in Ledger Detail Report
                             the DEMO database. The record definition set
                             consists of the following ChartFields: ACCT,
                             OPERATING_UNIT, DIVISION,
FIN0023    Template          Displays the records and fields included in         Main Menu > General Report
                             detail ledger templates.                            Ledger > Ledgers >
                                                                                 Template Report




FIN0022    Detail Ledger     Displays general information about detail        Main Menu > General Report
                             ledgers. Includes a description, error handling Ledger > Ledgers >
                             options, accounting periods, record names, and Detail Ledger Report
                             a listing of the ChartFields associated with the
                             ledger.




                                                                                                                                   13
                                                                    Cardinal Delivered Reports Job Aid - General Ledger


  Report                                                                              Report Navigation
              Report Name                      Report Description                                          Query / Report   Comments
  Number                                                                                     Path
GLC1001    Ledger Codes          List Ledger Codes with associated Book Code         Main Menu > General Report
                                 and provides description.                           Ledger > Ledgers >
                                                                                     Ledger Codes Report




GLS7011    Journal Edit Errors   Provides detailed information about journal edit Main Menu > General Report
                                 errors: period, journal ID, date, source,        Ledger > Journals >
                                 reference number, error type, line, line         Process Journals >
                                 description, field name, and error message.      Journal Edit Errors
                                                                                  Report
GLS7009    Posted Journal        Provides the ability to report on journals that  Main Menu > General Report
           Summary               were posted during a specific run of the Journal Ledger > Journals >
                                 Post process. The Journal Post process           Process Journals >
                                 updates all journals that were posted with the   Posted Journal
                                 value of the Process Instance. The Process       Summary Report
                                 Instance is part of the search criteria that is
                                 used by the Posted Journals - Summary report.


GLC4008    Class                 Displays the journal class name and a               Main Menu > Set Up Report
                                 description of each for a selected setID.           Financials/Supply
                                                                                     Chain > Common
                                                                                     Definitions > Journals
                                                                                     > Class Report




FIN0008    Source                Displays valid journal entry sources. Source        Main Menu > Set Up Report
                                 codes describe the origination of journal entries   Financials/Supply
                                 or the party responsible for generating the         Chain > Common
                                 journal, define special processing, and make        Definitions > Journals
                                 financial transactions easier to identify and       > Source Report
                                 report.

GLC4003    Combination Group     Displays information on ChartField combination Main Menu > Set Up Report
           Report                edit groups for a selected setID.              Financials/Supply
                                                                                Chain > Common
                                                                                Definitions > Design
                                                                                ChartFields >
                                                                                Combination Editing
                                                                                > Combination Group
                                                                                Report




                                                                                                                                       14
                                                                     Cardinal Delivered Reports Job Aid - General Ledger


   Report                                                                              Report Navigation
               Report Name                      Report Description                                         Query / Report   Comments
  Number                                                                                       Path
FIN0007     SpeedTypes            Displays a valid list of SpeedTypes. A              Main Menu > Set Up Report
                                  SpeedType enables you to enter shorthand            Financials/Supply
                                  keys to trigger a system expansion into pre-        Chain > Common
                                  specified values for one or more fields on a        Definitions > Design
                                  page. For each SpeedType, the report prints a       ChartFields >
                                  description, the User ID or class, and              Reports >
                                  associated values for account, department,          SpeedTypes
                                  product, project, and statistics code.
FIN0004     Account Types         Displays all the account types, including the       Main Menu > Set Up Report
                                  long and short descriptive name, and indicates      Financials/Supply
                                  whether the system carries forward the balance      Chain > Common
                                  for that account type.                              Definitions > Design
                                                                                      ChartFields >
                                                                                      Reports > Account
                                                                                      Types

FIN0061     Chartfield Attributes This report lists all or a selected list of         Main Menu > Set Up Report
                                  ChartFields and their associated attributes,        Financials/Supply
                                  attribute descriptions, and attribute values.       Chain > Common
                                                                                      Definitions > Design
                                                                                      ChartFields >
                                                                                      Reports > Chartfield
                                                                                      Attributes

FIN0010     Account               Displays the valid general ledger accounts by       Main Menu > Set Up Report
                                  SetID. For each account, the report prints a        Financials/Supply
                                  description, short name, and the account type.      Chain > Common
                                  Shows if the account is a statistical account       Definitions > Design
                                  and if so, what unit of measure is used. If the     ChartFields >
                                  account contains open items, lists their            Reports > ChartField
                                  descriptions as well as the edit record and field   Reports
                                  that apply.
FIN0011     Department ID         Displays valid department codes by SetID.           Main Menu > Set Up Report
                                  Prints the department ID and its description,       Financials/Supply
                                  along with each department manager’s name.          Chain > Common
                                                                                      Definitions > Design
                                                                                      ChartFields >
                                                                                      Reports > ChartField
                                                                                      Reports

FIN0012     Product               Displays valid product codes by SetID. Prints    Main Menu > Set Up Report
                                  the product ID and its description, in ascending Financials/Supply
                                  order by ID.                                     Chain > Common
                                                                                   Definitions > Design
                                                                                   ChartFields >
                                                                                   Reports > ChartField
                                                                                   Reports




                                                                                                                                       15
                                                                 Cardinal Delivered Reports Job Aid - General Ledger


   Report                                                                      Report Navigation
               Report Name                 Report Description                                      Query / Report      Comments
  Number                                                                               Path
FIN0013     Project ID       Displays valid projects by SetID. For each       Main Menu > Set Up Report
                             project, prints the description, manager’s name, Financials/Supply
                             and the project start and end dates.             Chain > Common
                                                                              Definitions > Design
                                                                              ChartFields >
                                                                              Reports > ChartField
                                                                              Reports

FIN0037     Chartfield 1     Displays the valid values for a selected setID.     Main Menu > Set Up Report
                                                                                 Financials/Supply
                                                                                 Chain > Common
                                                                                 Definitions > Design
                                                                                 ChartFields >
                                                                                 Reports > ChartField
                                                                                 Reports

FIN0038     Chartfield 2     Displays the valid values for a selected setID.     Main Menu > Set Up Report
                                                                                 Financials/Supply
                                                                                 Chain > Common
                                                                                 Definitions > Design
                                                                                 ChartFields >
                                                                                 Reports > ChartField
                                                                                 Reports


FIN0039     Chartfield 3     Displays the valid values for a selected setID.     Main Menu > Set Up Report
                                                                                 Financials/Supply
                                                                                 Chain > Common
                                                                                 Definitions > Design
                                                                                 ChartFields >
                                                                                 Reports > ChartField
                                                                                 Reports

FIN0050     Fund Code        Displays a list of all valid fund code ChartField   Main Menu > Set Up Report
                             values.                                             Financials/Supply
                                                                                 Chain > Common
                                                                                 Definitions > Design
                                                                                 ChartFields >
                                                                                 Reports > ChartField
                                                                                 Reports




                                                                                                                                  16
                                                                       Cardinal Delivered Reports Job Aid - General Ledger


   Report                                                                             Report Navigation
               Report Name                      Report Description                                        Query / Report     Comments
  Number                                                                                      Path
FIN0053     Class                 Displays a list of all valid class ChartField      Main Menu > Set Up Report
                                  values                                             Financials/Supply
                                                                                     Chain > Common
                                                                                     Definitions > Design
                                                                                     ChartFields >
                                                                                     Reports > ChartField
                                                                                     Reports


GLS8002     Budget Ledger         Displays budgets and their budget journals.        Main Menu >        Report
            Details                                                                  Commitment Control
                                                                                     > Post Control
                                                                                     Budget Journals >
                                                                                     Budget Ledger
                                                                                     Details Report

GLS1200     Closing Rules         Displays all details that define a closing rule.   Main Menu >          Report
                                                                                     Commitment Control
                                                                                     > Close Budget >
                                                                                     Closing Rules Report

GLS1222     Closing Calculation   Displays the results of the Budget Close           Main Menu >         Report
            Log                   process.                                           Commitment Control
                                                                                     > Close Budget >
                                                                                     Closing Calculation
                                                                                     Log Report


GLS1220     Closing Status        Displays the budget close status of the budgets Main Menu >        Report
                                  you request.                                    Commitment Control
                                                                                  > Close Budget >
                                                                                  Closing Status
                                                                                  Report
GLC8570     Activity Log          Displays budget-checking activity by            Main Menu >        Report
                                  Commitment Control Transaction Date,            Commitment Control
                                  Commitment Control Transaction ID, source       > Budget Reports >
                                  transaction type, Commitment Control ledger     Activity Log
                                  group, and ledger type (amount type).

GLC8110     Associated Budgets Displays all associations between expenditure         Main Menu >        Report
                               and revenue budgets for a business unit,              Commitment Control
                               including the budgets’ Commitment Control             > Budget Reports >
                               ledger groups and ChartField combinations,            Associated Budgets
                               along with the revenue linking method, revenue        Report
                               cap, and revenue percentage.




                                                                                                                                        17
                                                                  Cardinal Delivered Reports Job Aid - General Ledger


  Report                                                                        Report Navigation
              Report Name                    Report Description                                     Query / Report      Comments
  Number                                                                               Path
GLS8010    Budgets/Actuals     Reconciles budget-checking transaction activity Main Menu >        Report
           Reconciliation      with Commitment Control ledgers                 Commitment Control
                               (LEDGER_KK) and general ledger actuals          > Budget Reports >
                               ledgers.                                        Budgets/Actuals
                                                                               Reconciliation



GLC8100    Budget Attributes   Displays the attributes of all budgets in a        Main Menu >        Report
                               business unit as of the date that you enter.       Commitment Control
                                                                                  > Budget Reports >
                                                                                  Budget Attributes
                                                                                  Report
GLC8530    Budget Checking     Displays the budget checking status of source      Main Menu >        Report
           Status              transactions that have been budget-checked.        Commitment Control
                               Select reports by source transaction type,         > Budget Reports >
                               process instance, and process status.              Budget Checking
                                                                                  Status
GLS8007    Budgetary Control   Audits all budget key ChartField translation       Main Menu >        Report
           Tree Audit          trees for completeness and accuracy and            Commitment Control
                               displays various error and warning messages.       > Budget Reports >
                               The report verifies the tree structure and         Budgetary Control
                               definition options and identifies all ChartField   Tree Audit
                               values not defined as tree nodes or
                               represented as tree details.

GLC8051    Budget Control      Displays the Ruleset ChartField, Control           Main Menu >         Report
                               ChartField, and Commitment Control Option for      Commitment Control
                               each Ledger Group in a setID, as of the date       > Budget Reports >
                               you specify.                                       Budget Control
                                                                                  Report
GLC8050    Budget Key          Displays each key ChartField for each Ruleset      Main Menu >         Report
           Translations        in each Commitment Control ledger group in a       Commitment Control
                               setID, along with the ChartField’s translation     > Budget Reports >
                               tree name and budgetary tree level.                Budget Key
                                                                                  Translations Report

FIN0054    Budget Periods      Displays all valid Budget Period Calendars in a    Main Menu >        Report
                               setID, including the budget periods for each       Commitment Control
                               calendar and the budget period start and end       > Budget Reports >
                               dates.                                             Budget Periods
                                                                                  Report




                                                                                                                                   18
                                                                  Cardinal Delivered Reports Job Aid - General Ledger


  Report                                                                            Report Navigation
              Report Name                     Report Description                                        Query / Report   Comments
  Number                                                                                  Path
GLS8020    Budget Status        Displays all Commitment Control ledger             Main Menu >        Report
                                amounts (budgeted, pre-encumbrance,                Commitment Control
                                encumbrance, expense, collected, recognized) > Budget Reports >
                                and the available balance for the budgets you Budget Status
                                select.
                                When using the ChartField selection grid all
                                selected sub-total check boxes must be in
                                sequence and there must be no gaps in the
                                sequence. For example, to report subtotals for
                                given accounts within a given budget reference,
                                you sequence the ChartField Budget Reference
                                as 1 and Account as 2 and check the Subtotal
                                check box for each. This produces a Budget
                                Status report with subtotals for all accounts that
                                you specify within the specified budget
                                reference subtotal.

GLS8005    Budget Transaction   Displays transaction line details (budget postMain Menu >        Report
           Detail               date, source transaction type, document ID,   Commitment Control
                                ledger amounts, override user ID) for budgets.> Budget Reports >
                                                                              Budget Transaction
                                                                              Detail
GLS8510    Ledger Details       Displays such details as amounts and currency Main Menu >        Report
                                for each ledger (amount type) in the control  Commitment Control
                                budgets you select, as well as the available  > Budget Reports >
                                amount for the budget.                        Ledger Details

GLC8043    Project Expiration   Identifies expired projects and displays such    Main Menu >        Report
                                information as project dates and managers.       Commitment Control
                                                                                 > Budget Reports >
                                                                                 Project Expiration




                                                                                                                                    19
                                        Cardinal Delivered Reports Job Aid - General Ledger


Report                                                 Report Navigation
         Report Name   Report Description                                       Query / Report   Comments
Number                                                       Path




                                                                                                            20
                                        Cardinal Delivered Reports Job Aid - General Ledger


Report                                                 Report Navigation
         Report Name   Report Description                                       Query / Report   Comments
Number                                                       Path




                                                                                                            21
                                                                  Cardinal Delivered Reports Job Aid - Procurement


  Report
              Report Name                       Report Description                        Report Navigation Path          Query / Report   Comments
  Number
PORC700    Receipt Accrual     Lists all received items that have been posted but not Main Menu > Purchasing > Receipts Report
           Report              fully invoiced                                         > Reports > Receipt Accrual

POY5020    Receipt Account     Update requisition information, view status of        Main Menu > Purchasing > Receipts Report
           Detail              requisitions in the process flow                      > Reports > Receipt Account Detail




POY5030    Receipt Delivery    Receiver Delivery and Shop Floor Receipt Delivery     Main Menu > Purchasing > Receipts Report
                               reports                                               > Reports > Receipt Delivery




POY5001    Receiver Summary    Provides a summary of Receivers                       Main Menu > Reporting Tools >     Query
                                                                                     Query > Query Viewer >
                                                                                     POY5001_RECEIVER_SUMMARY



POY5010    Receiver Ship to    Provides receipt ship to details                      Main Menu > Reporting Tools >     Query
           Detail                                                                    Query > Query Viewer >
                                                                                     POY5010_RCV_SHIPTO_DETAIL




POY5035    SF Receipt Detail   Provides detailed Receipt information                 Main Menu > Reporting Tools >     Query
                                                                                     Query > Query Viewer >
                                                                                     POY5035_SF_RECEIPT_DETAIL




POY4010    PO Date Report      Creates a purchase order listing by PO date           Main Menu > Purchasing >          Report
                                                                                     Purchase Orders > Reports >
                                                                                     Listings
POY4011    PO Listings by      Creates a purchase order listing by Vendor            Main Menu > Purchasing >          Report
           Vendor Report                                                             Purchase Orders > Reports >
                                                                                     Listings




                                                                                                                                                      22
                                                                   Cardinal Delivered Reports Job Aid - Procurement


  Report
              Report Name                        Report Description                        Report Navigation Path         Query / Report   Comments
  Number
POY4012    PO Listings by Buyer Creates a purchase order listing by Buyer             Main Menu > Purchasing >          Report
           Report                                                                     Purchase Orders > Reports >
                                                                                      Listings

POY4013    PO Listings by       Creates a purchase order listing by Status            Main Menu > Purchasing >          Report
           Status Report                                                              Purchase Orders > Reports >
                                                                                      Listings
POY4040    Schedule Listings by Creates a PO Schedule listing by PO Date              Main Menu > Purchasing >          Report
           PO Date                                                                    Purchase Orders > Reports >
                                                                                      Schedule Listings
POY4041    Schedule Listings by Creates a PO Schedule listing by Vendor               Main Menu > Purchasing >          Report
           Vendor                                                                     Purchase Orders > Reports >
                                                                                      Schedule Listings



POY4042    Schedule Listings by Creates a PO Schedule listing by Buyer                Main Menu > Purchasing >         Report
           Buyer                                                                      Purchase Orders > Reports >
                                                                                      Schedule Listings
POPO005    PO Dispatch/Print    Dispatches or Prints a Purchase Order                 Main Menu > Purchasing >         Report
                                                                                      Purchase Orders > Add/Update Pos




POPO008    PO Reconcilliation   Closes out Completed Purchase Orders                  Main Menu > Purchasing >          Report
           Report                                                                     Purchase Orders > Reconcile Pos >
                                                                                      Close Purchase Orders



POPO009    Activity Report      Provides PO activity details                          Main Menu > Purchasing >          Report
                                                                                      Purchase Orders > Reports >
                                                                                      Activity
PORO1001   Open PO Report       Lists open purchase orders for the budget year-end    Main Menu > Purchasing >          Report
                                process                                               Purchase Orders > Budget Year
                                                                                      End Processing > Open Purchase
                                                                                      Order Report

POS8001    Budgetary Activity   Provides Requisition and Purchase Order budgetary     Main Menu > Purchasing >          Report
           Report               activity                                              Purchase Orders > Reports > Req
                                                                                      and PO Budgetary Activity
POY4100    PO XREF Report       Lists cross-reference between requisitions and        Main Menu > Purchasing >          Report
                                associated purchase orders                            Purchase Orders > Reports >
                                                                                      Requisition/PO Xref
POY4006    Expediting Report by Provides and expediting report by buyer               Main Menu > Purchasing >          Report
           Buyer                                                                      Purchase Orders > Reports >
                                                                                      Expediting




                                                                                                                                                      23
                                                                  Cardinal Delivered Reports Job Aid - Procurement


  Report
              Report Name                       Report Description                         Report Navigation Path             Query / Report   Comments
  Number
POY4007    Expediting Report by Provides and expediting report by vendor             Main Menu > Purchasing >               Report
           Vendor                                                                    Purchase Orders > Reports >
                                                                                     Expediting
POY4008    Expediting Report by Provides and expediting report by due date           Main Menu > Purchasing >               Report
           Due Date                                                                  Purchase Orders > Reports >
                                                                                     Expediting
POY4020    Order Status by      Provides an order status by vendor                   Main Menu > Purchasing >               Report
           Vendor                                                                    Purchase Orders > Reports > Status
                                                                                     Listings
POY4021    Order Status by Item Provides an order status by item                     Main Menu > Purchasing >               Report
                                                                                     Purchase Orders > Reports > Status
                                                                                     Listings
POY3031    Contract Activities  Provides the Contract Activities of contract related Main Menu > Procurement                Report
           Report               documents by vendor                                  Contracts > Reports > Activities
                                                                                     Report
POCNT200   Internal Contracts   Lists all Internal Contracts                         Main Menu > Procurement                Report
           Report                                                                    Contracts > Reports > Internal Order
                                                                                     Contracts
POCNT100   Vendor Contracts     Lists vendor contract details for order contracts    Main Menu > Procurement                Report
           Report                                                                    Contracts > Reports > Order
                                                                                     Contracts
POY8031    Purchase Details     Lists the purchase detail by employee, merchant, and Main Menu > Purchasing                 Report
           Report               vendor                                               >Procurement Cards > Reports >
                                                                                     Order Contracts
POY8020    Expected Credits     Lists open disputed transactions for a prior period  Main Menu > Purchasing                 Report
           Report                                                                    >Procurement Cards > Reports >
                                                                                     Expected Credits




                                                                                                                                                          24
                                                                    Cardinal Delivered Reports Job Aid - Project Accounting


  Report                                                                                                                     Query /
              Report Name                         Report Description                        Report Navigation Path                        Comments
  Number                                                                                                                     Report
PCY1030    Active Analysis      View the definition of each analysis group in the         Project Costing > Reports>      Report
           Groups               system                                                    Definition>Active Analysis
                                                                                          Groups




PCY8020    Analysis Types by    View a list of all active analysis types for a specific   Project Costing > Reports>   Report
           SetID                setID as of a specific date                               Definition>Analysis Types by
                                                                                          SetID


PCY8030    Activity Types by    View a list of all active activity types for a specific   Project Costing > Reports>      Report
           SetID                setID as of a specific date                               Definition>Activity Types by
                                                                                          SetID




PCY8080    Linked Transaction   View a list of all user-defined links between source      Project Costing > Reports>    Report
           Elements             types, categories, and subcategories                      Definition>Linked Transaction
                                                                                          Elements



N/A        Manager              Review cost, billing, and shared transactions             Project Costing > Interactive   Online Report
           Transaction Review                                                             Reports > Manager
                                                                                          Transaction Review

N/A        Transactions in      Review all transactions transmitted to Projects that   Project Costing > Interactive      Online Report
           Progress             are not costed or priced                               Reports > Transactions in
                                                                                       Progress
N/A        Projects Recon       Used to review Project Costing transactions from the Project Costing > Interactive        Online Report
           Workbench            other Cardinal modules                                 Reports > Projects Recon
                                                                                       Workbench
N/A        Flexible Analysis    Flexible Analysis is a method of analyzing a project's Project Costing > Interactive      Online Report
                                costs at the Project, Summary activity, activity,      Reports > Flexible Analysis
                                source type or category(if applicable) levels

CA_PP      Prepaid              Displays details on prepaid balances, including the       Customer Contracts >            Report
           Management           status, the date the balances are expected to expire,     Reports > Prepaid
                                and the amount remaining                                  Management




                                                                                                                                                     25
                                                               Cardinal Delivered Reports Job Aid - Project Accounting


  Report                                                                                                               Query /
              Report Name                       Report Description                      Report Navigation Path                   Comments
  Number                                                                                                               Report
CA_REV     Revenue              Displays revenue plans, including the status of these Customer Contracts >          Report
           Management           plans and the events associated with them. The        Reports > Revenue
                                report also displays the status of the events and the Management
                                amount of future revenue




CA_LMT     Limit Amount         Displays details of a contract's limits and the amount Customer Contracts >         Report
                                of the limit remaining                                 Reports > Limit Amount




CA_BILL    Billing Management   Displays details of billing plans, including the events Customer Contracts >        Report
                                associated with those plans, the status of the events, Reports > Billing
                                and the amount of future billings.                      Management




                                                                                                                                            26
                                    Cardinal Delivered Reports Job Aid - Project Accounting


Report                                                                                        Query /
         Report Name   Report Description                   Report Navigation Path                      Comments
Number                                                                                        Report




                                                                                                                   27
                                                          Cardinal Delivered Reports Job Aid - Time and Attendance


  Report                                                                                                          Query /
              Report Name                   Report Description                     Report Navigation Path                   Comments
  Number                                                                                                          Report
TL001      Payable Status    Lists all Payable time for a range of dates, sorted by Cardinal HCM > Main Menu > Report
           Report            the chosen Payable Statuses on the run control, to     Time and Labor > Reports>
                             provide the manager with a picture of processed and Payable Status
                             unprocessed time.
TL002      TimeCard Report   Displays all elapsed time rows, payable time, and      Cardinal HCM > Main Menu > Report
                             unresolved exceptions for an individual employee for Time and Labor > Reports>
                             the period selected on the run control. The report can TimeCard
                             be run by either an individual employee, or by a
                             group.
TL004      Scheduled Hours   Provides information about a time reporter’s           Cardinal HCM > Main Menu > Report
           Report            scheduled time, including details such as duration of Time and Labor > Reports>
                             work hours for employees.                              Scheduled Hours




                                                                                                                                       28

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:8
posted:5/16/2012
language:
pages:28
fanzhongqing fanzhongqing http://
About