Primary navigation

    12 12 2012 A

    While work continues on the development of the SWIFT Data Warehouse OBIEE subject areas, additional financial reporting resources have been made available for the interim solution provided for agencies to report or pull data directly from SWIFT. A new version of the Expenditures report is available. Also, a new Receipts report has been added.

    Users with the appropriate SWIFT FMS (financial / procurement) inquiry roles have access to the 2 new Crystal Reports.

    Reports
    • Expenditures Detail X2- This is a new version of the Expenditures report, redeveloped to utilize a new table created in the warehouse to provide faster response time. If you used the previous version of the Expenditures report, you should discontinue use of the old report and switch to the new version. The old Crystal 8.5 and Crystal 11 versions of the EXPENDITURES Detail report have been removed from the web page and new versions added for both Crystal 8.5 and Crystal 11.
    • Data includes expenditure transactions from all sources.
    • Time period selection is by GL Posted Date.
      • To reconcile to current budget totals choose 'Posted To' = today's date to include transactions not yet posted to GL. (these are transactions with posted date = Null or the default date 1/1/1753).
    • Display includes:
      • Transaction ID
        • Voucher ID for A/P source
        • Deposit ID for A/R source
        • Item for BI source
        • Journal ID for other sources
      • GL Posted Date
      • Accounting Date
      • Vendor ID and Vendor Name
      • Purchase Order Number
      • Invoice Number
      • Line Description
      • Warrant/EFT Number
      • Paid Amount
      • And more…
    • Sub-totaled by GL Account
    • Totaled by Expense Budget Fin Dept ID.
    • Main source is PS-X2-EXPENDITURES.
    Receipts Detail X2- A new Receipts report has been added
    • Data includes collected revenue transactions from all sources.
    • Time period selection is by GL Posted Date.
      • To reconcile to current budget totals choose 'Posted To' = today's date to include transactions not yet posted to GL. (these are transactions with posted date = Null or the default date 1/1/1753).
    • Display includes:
      • Transaction ID
        • Voucher ID for A/P source
        • Deposit ID for A/R source
        • Journal ID for other sources
      • GL Posted Date
      • Accounting Date
      • Customer ID
      • Customer Name
      • A/R Item Number
      • Line Description
      • Customer Payment ID
      • Paid Amount
      • and more…
      • Sub-totaled by GL Account/Sub Account (Class)
    • Totaled by Revenue Budget Fin Dept ID
    • Main source is PS-X2-RECEIPTS

    These reports were developed using Crystal Reports v 8.5 and can be run in Crystal Reports v 8.5 and later. Agencies may run the reports as presented, or they may modify the reports to meet their individual needs.

    The reports, along with documentation on system requirements and instructions for accessing them, are available via the link on the SWIFT Data Warehouse (SDW) web page, SDW Crystal Reports.

    If you are a new user of the SWIFT Warehouse Crystal Reports, as a first step you should review the following document: SWIFT Data Warehouse Crystal Reports - Prerequisites and Step by Steps . This document provides important preliminary information.

    If you have any questions regarding the new SWIFT Data Warehouse Crystal reports, please contact the SWIFT Help Desk by phone at 651-201-8100, option 2.

    back to top