Nvision layouts

Document Sample
Nvision layouts Powered By Docstoc
					b3363e9c-a3ef-4edd-9f46-52ec28618ea9.xls                                                                                                                                            nVision Layouts



These layouts are specifically for the PALMR business unit.

LAYOUT NAME                                WHAT IT PROVIDES                                            SCOPE?                             Notes
3-YR COMPARISON                            last three years ACTUALS and current year's budget          any
5-5 UNR                                    last 5 years budget and actuals for the 5000 accounts for   any scope that contains Dept
                                           Unrestricted (0000000) only                                 number
5-5 WITH LOTTERY                           last 5 years budget and actuals for the 5000 accounts for   any scope that contains Dept
                                           Unrestricted (0000000) and Lottery combined                 number
ACCOUNT_REPORT                             annual budget amounts and current month & year-to-date      any
                                           expenses/revenues for all accounts including
                                           encumbrances, pre-encumbrances, remaining budget,
                                           and percent of budget spent year-to-date
ACCOUNT_REPORTVS2                          ACCOUNT_REPORT with a Net Income line                       any
ACCOUNTBYDEPARTMENT_REPORT                 expenses/revenues (no budget) for all accounts down the     any scope that does NOT
                                           side and range of departments across the top                contain a specific department
                                                                                                       code
ACCOUNTBYPROGRAM_REPORT                    expenses/revenues (no budget) for all accounts down the     any scope that does NOT
                                           side and range of programs across the top                   contain a specific program
                                                                                                       code
ACCOUNTBYPROJGRANT_REPORT                  expenses/revenues (no budget) for all accounts down the     any scope that does NOT
                                           side and range of project/grants across the top             contain a specific project/grant
                                                                                                       code
ACCOUNTBYPROJGRANT_REPORT WITH             ACCOUNTBYPROJGRANT_REPORT with the Beginning                any scope that does NOT
BEG BAL                                    Balance and Ending Balance for each Project/Grant           contain a specific project/grant
                                                                                                       code
BUDGETBYDEPARTMENT_REPORT                  budget for all accounts down the side and range of          any scope that does NOT
                                           departments across the top                                  contain a specific department
                                                                                                       code
BUDGET COMPARE                             last year's budget, expenses, & revenues and this year's    any                              This layout is used for the Budget Book.
                                           budget for all accounts
DISCRETIONARY                              ACCOUNT_REPORT for the 23's, 24's, 4's, 5's, & 6's          any                                Use this layout to see only those accounts that you have
                                                                                                                                          control over.
MONTHLY EXP&REV                            year-to-date expenses/revenues broken down by month         any
                                           with budget and percent of budget spent
MONTHLY VARIANCE                           monthly & year-to-date expenses/revenues and budget         any
                                           for all accounts (no encumbrances) and monthly & year-to-
                                           date variances between budget & actuals
PROJ_GRANT_REPORT                          TOTAL budget, revenues, expenses, encumbrances, pre-        any scope that does NOT
                                           encumbrances, and beginning balances across the top for     contain a specific project/grant
                                           a range of project/grant numbers down the side              code

PROJECT GRANT                              detail revenue info and rolled up expense info for last     any scope that contains ONLY You'll need to delete the second (duplicate) XX9999 row
                                           three years ACTUALS and next year's budget for a            Fund and Project/Grant       in the Revenue section. The totals will be correct, but
                                           particular Project/Grant number                                                          the row will be in there twice.
PROP M                                                                                                 use the Project/Grant number
                                           account_report for Prop M projects                          as the Scope name
PROP M SERIES A                            budget, life-to-date expenses, and amount remaining for
                                           all projects for Prop M Series A bonds                      <none>                             the ICOC report (AKA the report with the shaded lines)




                                                                                            Page 1
b3363e9c-a3ef-4edd-9f46-52ec28618ea9.xls            nVision Layouts




                                           Page 2
b3363e9c-a3ef-4edd-9f46-52ec28618ea9.xls                                                                                                                                           nVision Layouts




These layouts are specifically for the ASGPC business unit.

LAYOUT NAME                                WHAT IT PROVIDES                                             SCOPE?                         Notes
ACCOUNT_RPT_ASG_BEG_END                    ACCOUNT_REPORT for ASG including beginning and               any ASGPC scope that
                                           ending balances                                              specifies Project/Grant
                                                                                                        code(s)
ASG BUDGET COMPARE                         BUDGET COMPARE report for ASG                                any ASGPC scope
ASG_ALL_ON_ONE                             PROJ_GRANT_REPORT for ASG                                    any ASGPC scope that does
                                                                                                        NOT contain a specific
                                                                                                        project/grant code




These reports are most useful for Administrative Services staff.

LAYOUT NAME                                WHAT IT PROVIDES                                             SCOPE?                         Notes
311 50 PERCENT LAW                         the 50% law page of the 311                                  <none>
311 50 PERCENT LAW BUDGET                  the 50% law page of the 311 - BUDGET figures only            <none>
311 50 WORKSHEET                           figures used to fill out the 50% Law page of the 311         <none>                         last column (before totals) must be filled out manually
311 ACTIVITY REPORT                        the Activity pages of the 311                                <none>
311 ACTIVITY REPORT BUDGET                 the Activity pages of the 311 - BUDGET figures only          <none>
311 FUND10 REVENUES                        the Detail of General Fund Revenues pages of the 311         <none>
311 FUNDS GROUP - ##                       the Funds Group pages of the 311                             <none>                         replace ## with the desired fund group number
                                                                                                                                       Fund Group 70 is split between 70A & 70B
BALANCE SHEET                              Balance Sheet for an entire Fund                             any scope that contains one or To run this report for ALL funds at once, use the
                                                                                                        more Funds ONLY                ALL_FUNDS scope and add %sfv.fund_code% to both
                                                                                                                                       the File Template and Content Description Template on
                                                                                                                                       the third page of your Report Request.
DIVISION COMPARE                           budget & actuals for three years plus budget for this year   any                            amounts may need to be manually adjusted to account
                                           with year vs. year variances                                                                for lottery expenditures
FUNCTIONAL EXPENSE                         Groupings of Accounts across the top and groupings of        <none>                         This layout is used to run the Expenditures by Function
                                           Programs down the side for all Funds, including                                             report for the auditors. (The auditors used to have to
                                           Depreciation expense.                                                                       create this report from scratch.)
FUND BALANCE                               actual revenue & expense figures for last year and budget    any scope that has Fund only Beginning balance for Actuals needs to be manually
                                           revenue and expense figures for this year                                                   added. Figure can be found by running BALANCE
                                                                                                                                       SHEET for the previous year.
FUND BALANCE 11                            last year's actual revenue & expense figures for             <none>                         Beginning balance for Actuals needs to be manually
                                           unrestricted and designated and last year's budget                                          added. Figure can be found by running BALANCE
                                           revenue and expense figures for unrestricted and                                            SHEET for the previous year.
                                           designated
INTERFUND TRANSFER                         Budget and Actuals figures by Fund/Project for interfund     <none>                        Fund 71 figures need to be manually added and can be
                                           transfers                                                                                  obtained by running two queries -
                                                                                                                                      PAL_ASG_INTERFUND_BUDGET and
                                                                                                                                      PAL_ASG_INTERFUND_ACTUALS.
M BUDGET COMPARE                           last year's budget, expenses, & revenues and this year's     a scope that has only Fund 42 This layout is used for the Budget Book.
                                           budget for all accounts for Prop M monies                    in it
PROPM_LIFETODATE_REPORT                    life-to-date actuals for each Prop M project                 <none>                        Report ID is PROPMLTD
PROPM_YEARTODATE_REPORT                    year-to-date actuals for each Prop M project                 <none>                        Report ID is PROPMYTD



                                                                                          Page 3
b3363e9c-a3ef-4edd-9f46-52ec28618ea9.xls                                                                                                               Queries


These queries are universally useful for many people on campus.

QUERY NAME                          WHAT IT PROVIDES                              PROMPTS                                  Notes
PAL_AP_JRNL_DETAIL                  Journal ID, Voucher ID, Vendor Name,          AP Journal ID
                                    and voucher amount
PAL_CALCARD_EXPENSES                Voucher ID, cardholder name,                  Department number (full or partial)      If you want results for multiple
                                    chartfields, amount charged, and                                                       departments that all start with the
                                    whether there was enough money in the                                                  same numbers, enter the common
                                    budget to cover the charge                                                             numbers then a % sign
                                    Voucher ID, PO ID, Invoice Number,            Fiscal Year and AP Journal ID
                                    Vendor Name, chartfields, and voucher
PAL_INVOICES_BY_JOURNAL             amount
                                    Voucher ID, PO ID, Invoice Number,            Project/Grant number and Fiscal Year
                                    Vendor Name, chartfields, and voucher
PAL_INVOICES_BY_PROJECT             amount
PAL_JOURNAL_REF                     Voucher ID for a given AP Journal             AP Journal ID                            Ref = Voucher ID
PAL_JRNL_DETAIL                     Line detail from any journal, including       Journal ID and chartfields
                                    Payroll adjustment journals.
PAL_MESSAGE_LOG                     contents of the Message Log for a             Process Instance number                  This query is useful when you
                                    particular Process Instance                                                            want to know what the message
                                                                                                                           log said for a process that's been
                                                                                                                           deleted from the Process Monitor.

PAL_OPEN_ENC_BY_DEPT                a list of POs with chartfields and            Fiscal Year and Department number        If you want results for multiple
                                    Vendor name, and the amount of                (full or partial)                        departments that all start with the
                                    money left on each PO line                                                             same numbers, enter the common
                                                                                                                           numbers then a % sign
PAL_OPEN_ENC_BY_PO                  all the PO lines with chartfields and         PO number
                                    Vendor name, and the amount of
                                    money left for each chartfield string
PAL_PAYROLL_JRNL_DEPT               employee name and ID for a specified          Department number and date range
                                    department
PAL_PAYROLL_JRNL_DETAIL             employee name and ID                          payroll journal number and chartfields
PAL_PAYROLL_JRNL_PROJ               employee name and ID for a specified          Project/Grant number and date range
                                    Project/Grant number




                                                                         Page 4
b3363e9c-a3ef-4edd-9f46-52ec28618ea9.xls                                                   Queries


PAL_ROLLED_POS_BY_DEPT              PO ID, Vendor name, chartfields, dollar      Dept ID
                                    amount, and whether the line has
                                    passed budget checking in the new
                                    year for previous year POs that have
                                    been carried forward into the new year




                                                                        Page 5
b3363e9c-a3ef-4edd-9f46-52ec28618ea9.xls                                                                                                            Queries




These queries are most useful for Administrative Services staff.

QUERY NAME                          WHAT IT PROVIDES                                PROMPTS                            Notes
PAL_1099_VENDOR_TOTALS              Vendor ID and name; Control ID; tax ID          Acctg Date From and To             use first and last dates of the
                                    and type; Voucher ID, date, line                                                   calendar year for the accounting
                                    number, and amount; and withholding                                                dates
                                    applicable flag
PAL_ACCT_DETAIL                     Journal ID, chartfields, amounts of all         Account number and Journal dates
                                    journals that hit a specific account            (from and to)
                                    number in the GL
PAL_AP_RECON                        Vendor Info, chartfields, amounts for           range of acctg dates
                                    unpaid vouchers
PAL_APPMSG_PAYROLL                  Publication ID and Status of payroll            run date                           When all the Statuses = DONE,
                                    interface                                                                          then it's safe to continue to the
                                                                                                                       next step of the interface process

PAL_APPMSG_REFUNDS                  Publication ID and Status of Student            run date                           When all the Statuses = DONE,
                                    Refunds interface                                                                  then it's safe to continue to the
                                                                                                                       next step of the interface process

PAL_APPMSG_SFDR                     Publication ID and Status of SF and DR          run date                           When all the Statuses = DONE,
                                    journal interfaces                                                                 then it's safe to continue to the
                                                                                                                       next step of the interface process

PAL_APPMSG_VENDOR_ERRORS            Vendor ID and name, publication ID              run date                           Errors must be corrected before
                                    and error message                                                                  continuing to the next step of the
                                                                                                                       interface process
PAL_ASG_INTERFUND_ACTUALS           Journal ID, chartfields, amount, and line       Fiscal Year
                                    description for interfund transfer
                                    journals
PAL_ASG_INTERFUND_BUDGET            Journal ID, chartfields, amount, and line       Budget Period
                                    description for interfund transfer budget
                                    journals
PAL_DR_JRNL_DETAIL                  accounting entries for Departmental             DR Journal ID                      Line Descr = Receipt Number
                                    Receipts
PAL_EDD_VENDORS                     Vendor ID, SSN, Vendor Name, Last               <none>
                                    Name



                                                                           Page 6
b3363e9c-a3ef-4edd-9f46-52ec28618ea9.xls                                                                                    Queries


These queries are most useful for Administrative Services staff.

QUERY NAME                          WHAT IT PROVIDES                            PROMPTS                             Notes
PAL_PAYROLL_VENDOR                  Vendor ID, name, and short name for         <none>
                                    Payroll Vendors
PAL_PAYROLL_VENDORS                 Vendor ID, name, and address for            <none>
                                    Payroll Vendors
PAL_PYMT_VOUCHER_JOURNAL            Pymt = what Voucher, what Jrnl              check number
PAL_SF_JOURNAL_DETAIL               SF journal in Excel format                  Journal date
PAL_WELLS_CANCEL                    Cancelled checks in the format that         bank information and cancel date
                                    Wells Fargo requires
PAL_WELLS_NEW_REGISTER              Newly created checks in the format that     bank information and payment date
                                    Wells Fargo requires




                                                                       Page 7
b3363e9c-a3ef-4edd-9f46-52ec28618ea9.xls                                                                                                                      PS Reports



These reports are universally useful for many people on campus.

REPORT NAME           NAVIGATION                     WHAT IT PROVIDES                             PARAMETERS                Notes
Purchase Order        Purchasing > Review PO         Prints a hard copy of the purchase           Business Unit
                      Information > Print POs        order.                                       PO number
PO Activity           Purchasing > Purchase Orders   All the invoices that have been paid         Business Unit
                      > Reports > Pal Purchase       against a PO, listed by PO line.             PO number
                      Order Activity
PO Details            Purchasing > Purchase Orders   All the distributions for all the lines on   Business Unit and         If you run this by req number, you must use
                      > Reports > Palomar PO         a PO all in one place.                       PO number OR              % signs before and after the req number.
                      Details Report                 *This is a good way to see how much          Req number
                                                     sales tax is charged per account
                                                     string.
Procurement Budgetary Purchasing > Purchase Orders   This report provides budgetary               Business Unit,            You can put in a remaining encumbrance
Activity Report       > Reports > Req and PO         amount information (original PO              from and to Dates,        amount with a variety of operators, you can
                      Budgetary Activity             amount, liquidated amount, and               any chartfield you want   use multiple chartfields if you want, but you
                                                     remaining encumbrance) for purchase          to use                    may not use the % wildcard
                                                     orders according to report request                                     NOTE: for ease of reading, use only one or
                                                     parameters.                                                            two chartfields
PO To Requisition     Purchasing > Purchase Orders   Provides a cross-reference between           Business Unit,            This report will be useful when we start
XREF                  > Reports > Requisition/PO     requisitions and the purchase orders         from and to Dates         using PeopleSoft requisitions.
                      Xref                           created from those requisitions.

Budget Status         Commitment Control > Budget    a report version of the Budgets              Business Unit, Ledger     Click the Refresh button to allow for
                      Reports > Budget Status        Overview                                     (PROJ_GRT or              chartfield entry. The Sequence number
                                                                                                  REVENUES), and            determines the order in which the
                                                                                                  chartfield values         chartfields display on the report. The
                                                                                                                            Include CF checkbox must be checked in
                                                                                                                            order for the chartfields to be included on
                                                                                                                            the report. Enter a single chartfield value
                                                                                                                            or a range of values or you may leave a
                                                                                                                            field blank to include ALL values.
                                                                                                                            Remember to use budget POOL account
                                                                                                                            numbers and to enter a Budget Period.
                                                                                                                            Click the Subtotal box to subtotal amounts
                                                                                                                            by that particular chartfield.




                                                                               Page 8
b3363e9c-a3ef-4edd-9f46-52ec28618ea9.xls                                                                                                                              PS Reports



Budget Transaction       Commitment Control > Budget    Displays transaction line details           Business Unit, Ledger         Be sure the User Budget Overrides
Detail                   Reports > Budget Transaction   (budget post date, source transaction       (PROJ_GRT or                  checkbox is un-checked. Click the Refresh
                         Detail                         type, document ID, ledger amounts)          REVENUES),                    button to allow for chartfield entry. The
                                                        for a specified budget.                     Commitment Control            Sequence number determines the order in
                                                                                                    Date Option of All, and       which the chartfields display on the report.
                                                                                                    chartfield values             The Include CF checkbox must be
                                                                                                                                  checked in order for the chartfields to be
                                                                                                                                  included on the report. Enter a single
                                                                                                                                  chartfield value or a range of values.
                                                                                                                                  Remember to use budget POOL account
                                                                                                                                  numbers and to enter a Budget Period.

Budget History Report    Commitment Control > Budget    This report provides a list of all budget   Business Unit, Account        This report is similar to the old Crystal
                         Reports > Palomar Budget       journals (original and transfers) for a     (one or all), Dept (full or   report in Analyze Controlled Budgets.
                         History Report                 specified budget.                           partial), Project/Grant
                                                                                                    (one or all), Budget
                                                                                                    Period


These reports are most useful for Administrative Services staff.

REPORT NAME              NAVIGATION                     WHAT IT PROVIDES                            PARAMETERS                    Notes
PO Listing               Purchasing > Purchase Orders   Provides purchase order information         Business Unit and from        You choose how you want the report sorted
                         > Reports > Listings           sorted by PO date, vendor, buyer, or        and to Dates are              after you click the Run button.
                                                        status.                                     required
                                                                                                    Vendor, Buyer, status
                                                                                                    are optional
Palomar Board Report   Purchasing > Purchase Orders     PO number, date; Vendor name;               a range of dispatch           need to print landscape
                       > Reports > Palomar Board        Category; Dept name; and dollar             dates
                       Report                           amount
Match Exception Report Accounts Payable > Reports >     Lists the match exceptions with             none
                       Vouchers > Match Exceptions      voucher data, PO data, receiver data,
                                                        and match error information.
Check Register (Detail   Accounts Payable > Reports >   Provides a register of payments by          Pay Cycle, Payment
or Summary)              Payments > Payment History     Pay Cycle and run date.                     Method, date range,
                         by Payment                                                                 summary or detail
Payment History by       Accounts Payable > Reports >   Provides a register of payments for a       Date range, detail or         Detail includes Voucher number and
Vendor (Detail or        Vendor > Payment History by    vendor.                                     summary, SetID and            Invoice number.
Summary)                 Vendor                                                                     Vendor ID




                                                                                 Page 9
b3363e9c-a3ef-4edd-9f46-52ec28618ea9.xls                                                                                                                         PS Reports



These reports are most useful for Administrative Services staff.

REPORT NAME              NAVIGATION                      WHAT IT PROVIDES                           PARAMETERS                Notes
Trial Payment Register   Accounts Payable > Reports >    Provides a printable summary of            Pay Cycle ID              This report is used as part of running a Pay
                         Payments > Trial Register       payments by bank account after                                       Cycle.
                                                         payment selection and creation, but
                                                         before you print checks..
Vendor Withholding       Vendors > 1099/Global           Lists withholding activity for internal    SetID, Control ID (same   PeopleSoft recommends that this report be
Balances Control         Withholding > General Reports   audits.                                    as SetID), date range     run on a regular basis to check the
Report                   > Withhold Control Report                                                                            withholding summaries.

Duplicate Vendors        Vendors > Vendor Information    Shows potential duplicate vendors.         SetID                     You can search for duplicate TIN,
                         > Maintain > Duplicate Vendor                                                                        withholding name or address, or duplicate
                         Report                                                                                               vendor name, address, or short name.

Withholding               Accounts Payable > Reports >   Shows calculations made during the         Pay Cycle ID              For each voucher, the report lists detail
Calculations Verification Payments > Withhold            pay cycle that pertain to withholding.                               withholding calculation information,
Report                    Calculation                                                                                         including withholding entity, type, and rules
                                                                                                                              that applied to the voucher.
1099 Withholding to      Vendors > 1099/Global           Lists all the information created by the   SetID, Control ID (same
Send Detail Report       Withholding > 1099 Reports >    1099 reporting process and is a            as SetID), Fiscal Year
                         1099 to Send Detail             replica of the data in the file you are
                                                         sending to the IRS.
Withholding Mismatch     Vendors > 1099/Global           Identifies all voucher lines on which      From and to dates are     The report does not compare the
Report                   Withholding > General Reports   the withholding applicable flag does       required, BU, SetID,      withholding code on the vendor to the
                         > Wthd Voucher/Vendor           not match the withholding flag on the      and Vendor ID are         withholding code on the voucher lines. It
                         Mismatch                        vendor.                                    optional.                 only checks the withholding flag.
Closing Rules            General Ledger > Close          Displays information about closing set     SetID, Closing Rule
                         Ledgers > Closing Rule Report   rules. It prints a description of the      name, and As Of Date
                                                         close set, identifies the name of the
                                                         account ChaftField, and shows the
                                                         ChartField to which that profit and loss
                                                         account will be closed. Also shows
                                                         the option for retaining earnings in the
                                                         ChartField.
Closing Trial Balance    General Ledger > Close          Summarizes all entries on the ledger       Business Unit, Ledger
                         Ledgers > Closing Trial         by account type. Prints beginning and      and Fiscal Year
                         Balance                         ending balances for the year, totals for
                                                         the period, adjustments, and closing
                                                         entries.




                                                                                  Page 10
b3363e9c-a3ef-4edd-9f46-52ec28618ea9.xls                                                                                                                       PS Reports



These reports are most useful for Administrative Services staff.

REPORT NAME              NAVIGATION                     WHAT IT PROVIDES                          PARAMETERS                 Notes
Ledger Activity Report   General Ledger > General       Lists the beginning and ending ledger     Business Unit, Ledger,     Click the Refresh button to allow for
                         Reports > Ledger Activity      balances by ChartField combination        Fiscal Year, from and to   chartfield entry. The Include CF checkbox
                                                        and account. Also lists the detailed      accounting periods, and    must be checked in order for the chartfields
                                                        journal line activity that is posted      desired chartfields        to be included on the report. Enter a single
                                                        against the ledger for the accounting                                chartfield value, a range of values, or check
                                                        periods that are specified.                                          the box for All Values. Click the
                                                                                                                             Summarize or Detail checkbox for each
                                                                                                                             chartfield depending on your detail
                                                                                                                             preferences.
Ledger Summary           General Ledger > General       Lists the beginning and ending ledger     Business Unit, Ledger,     Click the Refresh button to allow for
Report                   Reports > Ledger Summary       balances by ChartField combination        Fiscal Year, "thru"        chartfield entry. The Include CF checkbox
                                                        and account. Also lists the journals      accounting period, and     must be checked in order for the chartfields
                                                        that have posted against the ledger.      desired chartfields        to be included on the report.

Trial Balance            General Ledger > General       Combines detail and summary               Business Unit, Ledger,     Click the Refresh button to allow for
                         Reports > Trial Balance        balance information. Shows the            Fiscal Year, "thru"        chartfield entry. The Include CF checkbox
                                                        ending ledger balances for the            accounting period, and     must be checked in order for the chartfields
                                                        specified year and period by              desired chartfields        to be included on the report. Click the
                                                        ChartField combination. Also displays                                Descr checkbox to display the description
                                                        subtotals by ChartField. Prints a final                              of the chartfield on the report. Click the
                                                        total for debits and credits.                                        Subtotal checkbox if you want subtotals for
                                                                                                                             that particular chartfield. Enter a single
                                                                                                                             chartfield value or a range of values.

GL Detail Report         General Ledger > General       Lists the beginning and ending ledger     Business Unit, "thru"      You need to choose the report type of GL
                         Reports > Palomar GL Reports   balances, Journal ID, reason for          accounting period,         Detail both before and after clicking the
                                                        journal, reference (ex. Voucher ID),      Fund Code(s),              Run button.
                                                        chartfields, and dollar amount for all    Account(s), and Fiscal
                                                        journals that posted to the General       Year.
                                                        Ledger for the specified account and
                                                        fund combination.
GL Detail by             General Ledger > General       Lists the beginning and ending ledger     Business Unit, "thru"      You need to choose the report type of GL
Project/Grant Report     Reports > Palomar GL Reports   balances, Journal ID, reason for          accounting period,         Detail by Project/Grant both before and
                                                        journal, reference (ex. Voucher ID),      Fund Code(s),              after clicking the Run button.
                                                        chartfields, and dollar amount for all    Account(s),
                                                        journals that posted to the General       Project/Grant
                                                        Ledger for the specified Project/Grant.   number(s), and Fiscal
                                                                                                  Year.




                                                                               Page 11
b3363e9c-a3ef-4edd-9f46-52ec28618ea9.xls                                                                                                               PS Reports



These reports are most useful for Administrative Services staff.

REPORT NAME           NAVIGATION                     WHAT IT PROVIDES                        PARAMETERS               Notes
GL Summary Report     General Ledger > General       Lists the beginning and ending ledger   Business Unit, "thru"    You need to choose the report type of GL
                      Reports > Palomar GL Reports   balances, Journal ID, reason for        accounting period,       Summary both before and after clicking the
                                                     journal, and dollar amount for all      Fund Code(s),            Run button.
                                                     journals that posted to the General     Account(s), and Fiscal
                                                     Ledger for the specified account and    Year.
                                                     fund combination.
                      Accounts Payable > Reports >   Lists any Prepaid Vouchers which
                      Prepayments > Open             have not been matched up with           Vendor SetID, From       This report can be run for one vendor or a
Open Prepayments      Prepayments                    Regular Vouchers                        and To Vendor IDs        range of vendors.




                                                                           Page 12

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:6
posted:2/24/2012
language:English
pages:12