Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

nVision Layouts by xiuliliaofz

VIEWS: 9 PAGES: 12

									b11a285a-ab9b-4698-9842-e8e3ae7a8d5a.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
b11a285a-ab9b-4698-9842-e8e3ae7a8d5a.xls            nVision Layouts




                                           Page 2
b11a285a-ab9b-4698-9842-e8e3ae7a8d5a.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
b11a285a-ab9b-4698-9842-e8e3ae7a8d5a.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
b11a285a-ab9b-4698-9842-e8e3ae7a8d5a.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
b11a285a-ab9b-4698-9842-e8e3ae7a8d5a.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
b11a285a-ab9b-4698-9842-e8e3ae7a8d5a.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
b11a285a-ab9b-4698-9842-e8e3ae7a8d5a.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
b11a285a-ab9b-4698-9842-e8e3ae7a8d5a.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
b11a285a-ab9b-4698-9842-e8e3ae7a8d5a.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
b11a285a-ab9b-4698-9842-e8e3ae7a8d5a.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
b11a285a-ab9b-4698-9842-e8e3ae7a8d5a.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

								
To top