Customer Invoice Active Ledger

Document Sample
Customer Invoice Active Ledger Powered By Docstoc
					                                                                University of Missouri - Columbia
                                                                 PS Financial Reporting - FSRPT88
                                                                       Reporting Tools - Query

                                                                        GENERAL LEDGER
                                                                                                                            These queries are under Reporting Tools - Query (either
                                                                                                                            Manager or Viewer). Search by the name, select your choice
                                                                                                                            of HTML or Excel) and fill in the prompts.

          Query Name                            Group                            Description - Purpose                                              How to Run

                                                                      This is a query to use to get a detailed list of      Prompts for: Division is required, Dept/SubDept are optional
                                                                      authorized signers under the WEB Application PS       but must be filled minimally with the variable % for all under
CGL_AUTHSIGNER_PROJECT           Authorized Signer Review             Authorized Signers for Project in a specified Node    the designated Division.
                                                                      This is a query to use to get a detailed list of
                                                                      authorized signers under the WEB Application PS
                                                                      Authorized Signers for Programs in a specified        This query only requires you to denote the Node you want to
CGL_AUTH_SIGNERS_PROGRAMS        Authorized Signer Review             Node                                                  review; i.e. VC/VP or Divison or Dept or SubDept.
                                                                      This is a query to use to get a detailed list of
                                                                      authorized signers under the WEB Application PS       Prompts for: Division is required, Dept/SubDept are optional
                                                                      Authorized Signers for DeptIDs/Globals in a           but must be filled minimally with the variable % for all under
CGL_WEB_CFS_AUTH_SIGNERS         Authorized Signer Review             specified Node                                        the designated Division.
                                                                      This query is usted to review Net Assets for
CGL_ENDOWMENTS or                                                     Endowments in a given Division for any given
CGL_BS_ENDOWMENTS                Endowment                            Accounting Period in a Fiscal Year                    Prompts for: Division node, Fiscal Year, Accounting Period
                                                                      This query is used to review WEB Application
                                                                      Checklist items for a Department and/or               Prompts for Beginning/Ending Journal Dates and Department
CGL_DEPART_MONTHLY_CHECKLIST     Checklist Review/WEB Apps            SubDept(s)                                            and/or Sub-Dept
                                                                      This query is used to review WEB Application
                                                                      Checklist items by the Division for verification of
                                                                      transactions +/- $20,000 per APM 2.25.70 -
CGL_JRNL_CHECKLIST_ACCTG_POLIC   Review Checklist +/- $20,000         Transaction Authorization                             Prompts for Division and Beginning/Ending dates
                                                                      This query provides summary ledger detail for
                                                                      Endowed Scholarships. With the aid of a Pivot
                                                                      Table in EXCEL the YTD activity and balance of        Prompts for Fiscal Year, Accounting Period, Business Unit,
CGL_ENDOWED_SCHOLARSHIPS         Scholarships/Endowed                 these scholarships can be viewed.                     and Division Node
                                                                      This query provides summary ledger detail for
                                                                      NON-Endowed Scholarships. With the aid of a
                                                                      Pivot Table in EXCEL the YTD activity and             Prompts for Fiscal Year, Accounting Period, Business Unit,
CGL_NON_ENDOWED_SCHOLARHIPS      Scholarships/Non-Endowed             balance of these scholarships can be viewed.          and Division Node
                                                                      This query provides Net Asset balance for all
                                                                      Chartfields under the Scholarship PCS code 8%         Prompts for Fiscal Year, Accounting Period for COLUM or for
CGL_SCHOLARSHIPS                 Scholarships based on PCS code       for Columbia Campus or for a Division                 a Division Node
                                                                      This query provides a list of ACTIVE MoCodes
CGL_MOCODE_DEPTID_SELECTION      MoCode/Chartfield list               and Chartfield strings for a DeptID                   Prompts for DeptID
                                                                      This query provides a list of ACTIVE MoCodes
                                                                      and Chartfield strings with Division, Dept, and
CGL_MOCODE_DIV_DEPT_LOOKUP       MoCode/Chartfield list               SubDept.                                              Prompts for Division, Department, or SubDepartment Node(s)


                                                                               Page 1                                               69020a03-51ff-4359-b387-95a9a8a5ff16.xls
                                       This query provides Payroll Detail including PCEs
                                       for a Department Node for a given Fiscal Year and
CGL_PAYROLL_DETAIL_BY_NODE   Payroll   Accounting Period                                 Promts for Department, Fiscal Year, and Accounting Period




                                                Page 2                                          69020a03-51ff-4359-b387-95a9a8a5ff16.xls
                                                         University of Missouri - Columbia
                                         PS Financial Reporting - FSRPT88 & PS Financial Product
                                                                 Reporting Tools - Query

                                                                         ARBI




            Query Name                        Group

AR_ACTIVITY_DEPTID             DeptID

AR_ACTIVITY_TYPE               Type




AR_CUSTOMER_ACCOUNT            Customer




AR_OPEN_INVOICES               Invoice




AR_OPEN_ITEMS_BI_SPECIALIST    Specialist

AR_PAYMENT_SEARCH              Payment




AR_WORKC_LEDGER_BAL            Ledger



ARBI_ALL_INVOICES_OPRID        Invoice


ARBI_CREDIT_REVIEW_BY_BILLER   Credit
ARBI_PROJECT_LOOKUP              Project



ARBI_WRITEOFFS                   Writeoff



BCM_ERRORS_BI                    Errors

BI_INVOICE_CANCEL_ADJUST         Cancel/Adjust



BI_INVOICES_NOT_PRINTED          Print


BILL_PAYMENT_SEARCH              Payment


CUSTOMER_BALANCE_BU              Customer



DETAIL_INC_STMNT_FINANCIALS      Detail


PAYMENT_SEARCH_BY_CK_NUMBER      Payment

PAYMENT_SEARCH_BY_CUSTID         Payment


WRITE_OFF_REVWO_PROMPT_DTRANGE   Writeoff
  University of Missouri - Columbia
eporting - FSRPT88 & PS Financial Production - FSPRD88
          Reporting Tools - Query

                    ARBI




                    Description - Purpose
          This query produces a list of all AR activity by
         DeptID for a particular Business Unit.
          This query produces a list of all AR activity by Bill
         Type for a particular Business Unit.
         Returns a list of invoices and OA’s sorted by group
         id. It is useful in identifying OA matches to
         invoices without having to use PS panels and also
         returns ck numbers when the payment was directly
         applied. This may be beneficial when researching
         a customer’s payment history and needing a
         breakdown by invoice.

          Provides the user with a current list of all open AR
         items in the system (not including on accounts or
         credit invoices). This can be a useful tool when
         searching for an invoice solely by amount.

          This query lists outstanding invoices and prompts
         by Billing Specialist. An alternative report would
         be the Aging Report located in the PS Search
         Options on the MIS Web Applications site.
          This query allows you to search for a payment by
         amount.

          This query is to be run monthly to determine
         which items remain in the BU WORKC at the end
         of every month. The items listed in the query
         results must be transferred to a campus BU at the
         end of every month in order for the month to close
         with WORKC in balance. The Ledger query
         identifies the amount. The Customer query
         identifies the customer(s). The campuses are to
         run these queries periodically throughout the
         month to keep the balance at a minimum.
           Prompts for Business Unit, Invoice Dates, and
         Operator Id. Provides the user with a list of
         invoices created by the operator id within the time
         frame specified.
          Query prompts for billings specialist and date
         range and returns all credit invoices within that
         date range.
 Provides the user with project end dates based on
the active or inactive file in PS.
 Prompts for business unit and returns a list of all
Write Offs and Reverse Write Offs done in PS.
May sort by business unit for locating the write offs
of an individual department.
 This query produces a list of all invoices
containing BCM errors. These errors must be
corrected prior the invoice printing or posting to the
GL.
 This query produces a list of all invoices that have
been either cancelled or adjusted.
 This query produces a list of all non-cancelled
invoices that have not been printed. This would
mean the invoice has just been created, has a
BCM error, or is in hold status.
  This query allows you to search for an invoice
amount in the event you don’t know the invoice
number.
 This query produces a list of current balances.
The BU is prompted, therefore it can be used for
any BU.
 Prompts for DeptId and returns all ACTUALS
income statement detail by date and account.
Includes all chartfields where the DeptId is
included in the string.
  This query allows to you search for a payment by
entering the check number, which needs to be 15
characters starting with CK or CC.
This allows you to search for all payments that
have posted to the customer number.
 Prompts for Date Range and Campus and
GENERATES a list of WRITE OFFS and
REVERSE WRITE OFFS.
ction - FSPRD88



         These queries are under Reporting Tools - Query (either
         Manager or Viewer). Search by the name, select your choice
         of HTML or Excel) and fill in the prompts.

                                 How to Run

         Run query-it will Prompt for a DeptID

         Run query-it will prompt for a Bill Type ID (i.e. CGS, CAA, etc)




         Query must be run in Production. This query prompts for
         customer number




         Run query - no prompts




         Run query - prompts for Billing Specialist (i.e.CACCTGSV)

         Run query - prompts for Payment Amount




         Run query-prompts for Business Unit, Invoice Date Range;
         and Last Operator ID

         Run query-prompts for Billing Specialist and Invoice Date
         Range
Run query-prompts for ProjectID


Query must be run in Production. Query Prompts for
Business Unit



Run query - no prompts

Run query - no prompts



Run query - prompts for Business Unit


Run query - prompts for Invoice Amount


Run query - prompts for Business Unit.



Run query - prompts for DeptID


Run query - prompts for PaymentID

Run query - prompts for CustomerID

Run query - prompts for Business Unit and Accounting Date
Range
                                                   University of Missouri - Columbia
                                                    PS Financial Reporting - FSRPT88
                                                          Reporting Tools - Query

                                                               AP-NONPO




          Query Name                       Group


C_AP_AGED_VOUCHERS_BY_DIVNODE   AGE



C_AP_VCHR_SENDBACK_CSD          SENDBACK
University of Missouri - Columbia
 PS Financial Reporting - FSRPT88
       Reporting Tools - Query

             AP-NONPO




                 Description - Purpose
      Division could run this query to monitor if they
      have vouchers that have been entered but not
      released for XX # of days.
      Divisions could run this query to monitor the
      departments within their divisions that have
      vouchers returned and why.
These queries are under Reporting Tools - Query (either
Manager or Viewer). Search by the name, select your choice
of HTML or Excel) and fill in the prompts.

                      How to Run


Prompts for Div-nde & days old

Prompt For use by Div F. O. – Prompts for Beginning Due
Date/Ending Due Date/CSD
                                         University of Missouri - Columbia
                                          PS Financial Reporting - FSRPT88
                                                Reporting Tools - Query

                                                        AP-PO




         Query Name              Group


CAP_AGED_VOUCHERS_PO   VOUCHER
University of Missouri - Columbia
 PS Financial Reporting - FSRPT88
       Reporting Tools - Query

                AP-PO




                 Description - Purpose
      Division could run this query to monitor if they
      have PO vouchers that have been entered but
      not released for XX # of days.
These queries are under Reporting Tools - Query (either
Manager or Viewer). Search by the name, select your choice
of HTML or Excel) and fill in the prompts.

                      How to Run


Prompts "Date entered prior to" date
                                              University of Missouri - Columbia
                                               PS Financial Reporting - FSRPT88
                                                     Reporting Tools - Query

                                                            BUDGET
                                                                                                           These queries are under Reporting Tools - Query (either
                                                                                                           Manager or Viewer). Search by the name, select your choice
                                                                                                           of HTML or Excel) and fill in the prompts.

            Query Name                Group                    Description - Purpose                                              How to Run

BD_XCP_GL                BCM                        This query provides a list of GL budget exceptions     Prompts for Business Unit
                                                    This query provides a list of Accounts
BD_XCP_ARBI              BCM                        Receivable/Billing budget exceptions                   Prompts for Business Unit
                                                    This query provides a list of Requisitions in budget
BD_XCP_REQ               BCM                        exception status                                       Prompts for Business Unit; works best in PRD
                                                    This query provides a list of Accounts Payable         Prompts for Business Unit; works best in PRD after deleting
BD_XCP_AP                BCM                        (voucher) budget exceptions                            Business Unit prompt
                                                    This query provides a list of Purchase Orders in
BD_XCP_PO_NEW            BCM                        budget exception status                                Prompts for Business Unit
ROUND1_BUDGET            Round 1 budget             Provides budgets loaded in Round 1                     Prompts for CSD; revise scenario after Round2 starts

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:16
posted:2/14/2011
language:English
pages:15
Description: Customer Invoice Active Ledger document sample