SPECTRUM

Document Sample
SPECTRUM Powered By Docstoc
					  SPECTRUM
The Complete Treasury System



   Release Notes
      Version 8.10.6
       July 12, 1999




Financial Software Systems, Inc.
    2300 Computer Avenue
           Suite M-66
    Willow Grove, PA 19090
INTRODUCTION

Financial Software Systems Inc., is providing these Release Notes to assist users in identifying changes
to Spectrum and understanding how these changes will affect their use of Spectrum.
This document lists and describes all enhancements made to version 8.10.6 of Spectrum. These
changes and enhancements will improve functionality and usability of the system.

The Release Notes are organized as follows:
                                                                         Page
        At-a-glance overview of all enhancements included                 3
        Detailed list of changes                                          5

These Release Notes include a description of the change/enhancement, lists the menu path where the
change is located, and provides the Filename(s)/Executable(s), if applicable.
Please direct any questions regarding these notes or requests for additional notes to Jeremy Bach at
(215) 784-1100.




RN8.10.6                                        2
AT-A-GLANCE OVERVIEW

The following is a brief list of the changes/enhancements that are covered in more detail later in this
document.
   1.   Vostro Accounting                     Vostro entry modules were enhanced to provide Euro
                                              functionality.

   2.   Sub-Ledger Accounting                 The money market segment of sub-ledger accounting
                                              was updated to include an additional event to capture
                                              accrued interest amounts at closing. Additional attributes
                                              have been added to the Account Construction
                                              functionality for Account Revaluation and Account
                                              Clearing.

   3.   Corporate Entry                       Corrections have been made to the templating
                                              functionality within the Corporate Entry module.

   4.   SWIFT MT-202 Message                  The MT-202 message format has been enhanced to
                                              include euro functionality.

   5.   Remote Teller Wires                   The Remote Teller wire entry modules were modified to
                                              default the SWIFT setting cover/serial to serial.

   6.   All Entry Modules                     Auxiliary Data fields in entry modules were enhanced to
                                              allow users to use apostrophe characters in the text
                                              fields.

   7.   Rollover with Breakdown               The Rollover with Breakdown module was enhanced to
                                              enable users to roll existing “In” currency positions
                                              through the EUR and break the positions back down into
                                              the original “In” currency positions.

   8.   Generic Export                        The Trade Export segment of the Generic Export module
                                              was updated two ways: The section where users can
                                              define export criteria was enhanced to support wildcard
                                              filtering; the second enhancement enables users to
                                              select field formats for amount fields based on currency
                                              definitions.

   9.   Rate Import Editor                    The terms field in the Rate Import Editor was modified to
                                              allow users to edit the field.

   10. Security Profile Report                A new report has been added to Spectrum that displays
                                              the menu permissions on User ID basis.

   11. Trade Blotter                          The Trade Blotter was enhanced to enable users to filter
                                              on external trade sources within the base view of the
                                              Trade Blotter.
                                              Changes have been made to the Front-Office report
   12. Option Statistics Report
                                              menu.




RN8.10.6                                         3
   13. Asset Liability Blotter   The Analytic Blotter display “Asset/Liability” was modified
                                 to use the initial yield to maturity on money market trades
                                 when determining the average weighted rate for a given
                                 position.

   14. Vostro Entry              Some restrictions have been relaxed in the Vostro entry
                                 modules.

   15. Payments                  A modification has been made to the Payments module
                                 to enable users to manage payments for customers that
                                 are classified as DVP (Delivery vs. Payment).

   16. Batch Reporting           An enhancement has been made that allows users to
                                 select from any of the available trade states when adding
                                 a report to a batch

   17. Trade Verifier            The trade verification module has been modified to help
                                 reduce the number of deadlock situations occurring as a
                                 result of Sybase deadlock handling.




RN8.10.6                            4
CHANGES - VERSION 8.10.6

1. Vostro Accounting
   (BO: 1. Transaction Accounting | 06. Vostro Accounts)

   Vostro entry modules were enhanced to provide Euro functionality. With these enhancements users
   may record transactions for national currency vostro accounts where funds are paid or received in
   euro’s. In addition, users may record transactions against euro vostro accounts where funds can be
   denominated in euro or any other national currency that is part of the EMU.

   Filename(s)/Executable(s): VOSDRFPR, VOSDRFIS, VOSDRFWT, VOSDRFAD, VOSEDIT,
   VASTREP

2. Sub-Ledger Accounting
   (BO: 1. Transaction Accounting | 14. Sub-Ledger Accouning)

   The money market segment of sub-ledger accounting was updated to include an additional event to
   capture accrued interest amounts at closing. The event name is “Total Interest at Closing”. Interest
   at closing is calculated based on the settlement and closing dates of the trade. This event applies to
   trades that are closed prior to maturity date.
   Additional attributes have been added to the Account Construction functionality for Account
   Revaluation and Account Clearing. The complete list of attributes now includes:
        • Portfolio
        • Purpose
        • Trader
        • Broker
        • Counterparty

   Filename(s)/Executable(s): ACCTGEN, ACCTASGN

3. Corporate Entry
   (FO: 1. Transaction Accounting | Enter/Edit Transactions | FX Spot-Forward-Swap | Corporate
        Dealing)

   Corrections have been made to the templating functionality within the Corporate Entry module.
   Previously, users were unable to create templates for corporate deals valuing on Spot.

   Filename(s)/Executable(s): FXCRPENT

4. SWIFT MT-202 Message
   (BO: 5. Payments)

   The MT-202 message format has been enhanced to include euro functionality. Field 72 will display
   the original currency and amount on a trade that has been paid in a currency other than the original
   currency on the trade. There is a system setting that controls whether field 72 will be incorporated in
   the message or not. Use the system setting EURERI to determine whether to include the original
   currency in field 72 or not. Possible settings are as follows. INCLUDE = include currency in field 72.
   EXCLUDE = exclude currency from field 72.

   Filename(s)/Executable(s): PAYEXPRT, spectrum.sql


RN8.10.6                                        5
5. Remote Teller Wires
   (BO: 1. Transaction Accounting | 07. Client Cash-Drafts-Wires)

   The Remote Teller Wire entry modules were modified to default the SWIFT cover/serial setting to
   serial.

   Filename(s)/Executable(s): DRFTSALE

6. All Entry Modules
   (FO/BO: Transaction Accounting | Enter/Edit Transactions)

   Auxiliary Data fields in entry modules were enhanced to allow users to use apostrophe characters in
   the text fields.

   Filename(s)/Executable(s): All Entry Modules

7. Rollover with Breakdown
   (BO: Transaction Accounting | Enter/Edit Transactions | FX Spot-Forward-Swap | Rollover with
        Breakdown)

   The Rollover with Breakdown module was enhanced to enable users to roll existing “In” currency
   positions through the EUR and break the positions back down into the original “In” currency positions.
   This enhancement enables users to enter a single USD/EUR rate along with points. This rate is used
   to derive the “In” currency roll rates based on the rates defined by EMU participants.

   Filename(s)/Executable(s): FXROVENT

8. Generic Export
   (FO/BO: File Transfers | Generate/Define Export Files)

   The Trade Export segment of the Generic Export module was updated in two (2) ways:
   The section where users can define export criteria was enhanced to support wildcard filtering within
   the following value fields.
        • Portfolio
        • Purpose
        • Trader
        • Broker
        • Counterparty
   This enhancements allows users to either include or exclude multiple codes based on a single
   wildcard filter.
   The second enhancement enables users to select field formats for amount fields based on currency
   definitions. Previously, the field formats were inflexible for amount fields and users were required to
   select a fixed number of decimal places across all currencies. The new options enable the exporter
   to be sensitive to the decimal precision selected within the currency definition and to create export
   files based the defined precision. The new amount field options are:
        • “Cur Decimal”
        • “Cur Decimal, (Dec Implied)”
        • “Zero-Filled Cur Decimal”
        • “Zero-Filled Cur Dec, (Dec Implied)”



RN8.10.6                                         6
    The lay out of the Definition screen was modified to accommodate a growing list of record formats.
    Record formats can be viewed by using the [F3] key to toggle through the different views.
    An export type has been added for Reconciliation exports. The reconciliation export compares
    previously-exported trades with current Spectrum data. The purpose is to identify any discrepancies
    between previous exports and the current state of trade data.

    Filename(s)/Executable(s): EXPRTER, EXPORTER, EXPDRIVE

9. Rate Import Editor
   (FO/BO: 2. Data Update | 4. Interest Rate Points Editor)

    The terms field in the Rate Import Editor was modified to allow users to edit the field. To change the
    terms displayed next to a currency code, highlight the terms field and press the space bar. Press
    [F10] to save the change.

    Filename(s)/Executable(s): FXRATEDT

10. Security Profile Report
    (FO/BO: 4. Report Production | 01. Report Menu | Outstanding Premium Long/Short Report)

    A new report has been added to Spectrum that displays the menu permissions on a User ID basis.
    The Security Profile Report can be generated on a single group or user basis as well as across all
    groups and users. The report will list all available menu selections by User ID. The report can be
    found on both the Back- and Front-office menu’s.
         • Front-Office - 338
         • Back-Office - 418The Outstanding Premium Report was modified to correct an error in the
           display of premium amounts.

    Filename(s)/Executable(s): SECREP

11. Trade Blotter
    (FO: 5. Portfolio Analysis | 18. Report Blotter)

    The Trade Blotter was enhanced to enable users to filter on external trade sources within the base
    view of the Trade Blotter. Blotter Base Views are defined using the menu selection Define Analytic
    Blotter.

    Filename(s)/Executable(s): FXTRDBLT, FXMENU.bcp, FXBLMAIN

12. Option Statistics Report
    (FO/BO: 4. Report Production | 01. Report Menu | Option Statistics)

    The following changes have been made to the Front-Office report menu.
         • Selection 29. “Option Statistics” was renamed to “Option Stat w/US Theo”. The report that is
           generated from selection 29 has not changed.
         • A new selection has been added to position 30. “Option Statistics”

    Filename(s)/Executable(s): FXREPINF.bcp




RN8.10.6                                         7
13. Asset Liability Blotter
    (FO: 5. Portfolio Analysis | 11. Analytic Blotter)

    The Analytic Blotter display “Asset/Liability” was modified to use the initial yield to maturity on money
    market trades when determining the average weighted rate for a given position. Previously, the
    blotter used the coupon rate of the trade for this calculation.

    Filename(s)/Executable(s): FXANABLT

14. Vostro Entry
    (BO: 1. Transaction Accounting | 06. Vostro Accounts | 01. Activity Entry)

    Some restrictions have been relaxed in the Vostro entry modules. For “incoming” vostro wire trades
    the user is no longer required to enter a remitting bank, remitting party, or remitting party account.

    Filename(s)/Executable(s): VOSDRFWT

15. Payments
    (BO: 5. Payments)

    A modification has been made to the Payments module to enable users to manage payments for
    customers that are classified as DVP (Delivery vs. Payment). It is a requirement for DVP customers
    that incoming payments be received before outgoing payments are made. A new toggle has been
    added to the Payments module to allow users to either include or exclude DVP payments from the
    selection of payments displayed. This gives the user the ability to selectively process payments for
    DVP customers. The DVP status of a client is determined from the Counterparty definition Early
    Payment field. If Early Payment is set to YES the customer is considered DVP. If Early Payment is
    set to NO, the customer is not DVP.

    Filename(s)/Executable(s): PAYMNT

16. Batch Reporting
    (FO/BO: 4. Report Production | 02. Batch Report Menu)

    When defining batch reports, users were restricted to the default “Trade State” fields displayed on
    the filter screens of reports. An enhancement has been made that allows users to select from any of
    the available trade states when adding a report to a batch.

    Filename(s)/Executable(s): SYBATREP

17. Trade Verifier
    (BO: 1. Transaction Accounting | 01. Accept-Verify-Reconcile-Review)

    The trade verification module has been modified to help reduce the number of deadlock situations
    occurring as a result of Sybase deadlock handling.

    Filename(s)/Executable(s): FXVERIFY




RN8.10.6                                          8
SYSTEM ADMINISTRATION CHANGES - VERSION 8.10.6
Release 8.10.6 includes changes to the Spectrum data model. In addition, new system settings have
been added. Therefore, to use this release, any and all existing Spectrum databases must be upgraded
using Spectrum.sql v8.10.6.




RN8.10.6                                      9

				
DOCUMENT INFO