SAM II Financial Scheduled Upgrades

Effective Friday, October 7, 2016

This upgrade includes the following changes to the SAM II Financial system for the interface with the MissouriBUYS application.

SAM II Financial changes:

  1. MissouriBUYS documents RXB (Request), PCB (Purchase Order), RCB (Receiver) and PVB (Invoice/Payment Voucher) can be viewed on SUSF but are not on the GoTo Menu. They cannot be modified or submitted from the SUSF window. All drop-downs and radio buttons have been changed to text fields. Help panels for each are generic since the documents can only be viewed.
  2. VENE - New window VENE – Vendor Number Crosswalk added. This window crosswalk MissouriBUYS vendor codes to SAM II Vendor codes for reference and transaction processing. Window help was added.
  3. ORQH Open Requisition Header Inquiry window – Control Tab – Requisition Type will show B if the document originated from MissouriBUYS
  4. ORQC Open Requisition Commodity Line Inquiry window. Current type will show B if the document originated from MissouriBUYS.
  5. OPPH Open Purchase Order Header Inquiry window – Control Tab – Order Type field. Two new types were added, A for Order by Amount, and Q for Order by Quantity. Both types will only originate from MissouriBUYS.
  6. ORCH Open Receiver Header Inquiry window – Note Pad Text will shows MissouriBUYS if the receiver came from WebProcure. Help panel updated to show the new entry.
  7. ORCL Open Receiver Line Inquiry window – Text Flag will shows MissouriBUYS if the receiver came from WebProcure. Help panel updated to show the new entry.
  8. OPVH Open Payment Voucher Header Inquiry window - Voucher Type field will show B if the payment voucher came from WebProcure. OPVH.hlp - Help panel updated accordingly.
  9. TINF help – Income Box 13, new category Bond Premium on Tax Exempt Bond added
  10. CINF help – Income Box 13, new category Bond Premium on Tax Exempt Bond added
  11. VINC help – Type of Income field – For 1099-INT returns, new category 13 added Bond Premium on Tax Exempt Bond
  12. VIC2 help – Type of Income field – For 1099-INT returns, new category 13 added Bond Premium on Tax Exempt Bond
  13. SOBJ help – Type of Income field – For 1099-INT returns, new category 13 added Bond Premium on Tax Exempt Bond
  14. OBJ2 help – 1099 Type of Income field – For 1099-INT returns, new category 13 added Bond Premium on Tax Exempt Bond
  15. BAC2 help – Type of Income field – For 1099-INT returns, new category 13 added Bond Premium on Tax Exempt Bond

Please contact the Financial Technical Help desk at 522-1500 (Option 1) or email us at Financial@oa.mo.gov if you have any questions.

Effective Monday, June 1, 2015

This upgrade includes multiple changes to the SAM II Financial system and desktop as well as the SAM II Financial Data Warehouse. Brief descriptions of the changes are included below.

SAM II Financial changes:

  1. A Demo ID field associated with FHWA funding resources has been added to the Project Participation (PZ) document and the Project Funding Source Inquiry (PFST) window. Window help has been updated to include information about this field.
  2. Uncommitted and Unexpended amounts for allotments have been added to the Appropriation Inquiry (EAP2) screen. Window help has been updated to include descriptions of these fields and how they are calculated.
  3. The Pre-Encumbered Amount column has been removed from the Allotment Inquiry (EALL) window. Window help has been updated.
  4. Amount boxes for income types 10 and 11 have been added to the Original 1099 Information (TINF) and Corrected 1099 Information (CINF) windows. These income types apply to 1099-I forms. Window help for both windows has been updated.
  5. Window help for the windows listed below has been updated to include information for income types 10 and 11 on the 1099-I form:
    • BAC2 – Balance Sheet Account
    • OBJ2 – Object
    • SOBJ – Sub-Object
    • TINF – Original 1099 Information
    • CINF – Corrected 1099 Information
    • VINC – Vendor Income
    • VIC2 – Vendor Income Corrections

SAM II Financial Data Warehouse Changes:

  1. A new field has been added to the REF_PROJ_FUND_SRC table and the OAAMS.DWPROD.LFSEQ.PFST(0) file. The field was added to the end of the current record layout.
    • REF_PROJ_FUND_SRC table
      • New field added:
        • DEMO_ID                             CHAR(05)
      • Delta file record changes are already included in file OAAMS.DWPROD.ODW220IH. The record length of this file did not change. Record layout is at OAAMS.DWPROD.ODW220IH.PFST
      • Full table layout record layout is at: OAAMS.DWPROD.LFSEQ.PFST.
      • The OAAMS.DWPROD.LFSEQ.PFST(0) file is now 271 characters in length.

Please contact the Financial Technical Help desk at 522-1500 (Option 1) or email us at Financial@oa.mo.gov if you have any questions.

Effective Monday, June 9, 2014

This upgrade includes multiple changes to the SAM II Financial system and desktop as well as the SAM II Financial Data Warehouse. Brief descriptions of the changes are included below.

SAM II Financial changes:

  1. The initial SAM II Financial Desktop Sign-on screen has been repositioned so the Version and Build Date fields on the splash screen can be easily identified by system users.
  2. The field help wording for the Document Number field on DHIS has been modified to show a detailed example of how the Document ID field should be entered.
  3. The Funding Method dropdown list on the FM document has been modified to allow the option to remove the funding method for an existing Federal Aid Master record.
  4. Field help for one of the 1099 Types of Income has been changed from “Alternative Trade Adjustment Assistance (ATAA) Payments [5]” to “Reemployment Trade Adjustment Assistance (RTAA) Payments [5]”. Field help wording has been modified on the following screens:
    • BAC2 – Balance Sheet Account
    • OBJ2 – Object
    • SOBJ – Sub-Object
    • TINF – Original 1099 Information
    • CINF – Corrected 1099 Information
    • VINC – Vendor Income
    • VIC2 – Vendor Income Corrections

  5. A new field has been added to Appropriations. The field name is Restrictions and will be used to store expenditure restrictions placed in effect by the Governor. Expenditure restrictions and Reverted amounts are currently stored as a combined amount in the Reverted field. The new field will allow them to be stored and identified separately. The Restricted amount for each appropriation will be displayed on the Appropriation Inquiry (EAP2) window.

    The field label on the SAM II AP (Appropriation) document that currently reads as “Revision/Beginning Cash Balance” will now read “Reversion/Restriction/Beginning Cash Balance”. A new option has been added to the dropdown list. The dropdown list will now include these options:

    1. Neither
    2. Reversion
    3. Restriction
    4. Beginning Cash Balance

SAM II Financial Data Warehouse Changes:

  1. New fields have been added to the following tables. All fields have been added to the end of the current record layout for those tables. Keep in mind that the record lengths of the files have changed.
    • REF_APPROPRIATION table
      • New fields added:
        • RESTRICTED_AMT                             DECIMAL(15, 2)
      • Delta file record changes are already included in file OAAMS.DWPROD.ODW220IF.  Record layout is at OAAMS.DWPROD.ODW220IF.APPR
      • Full table layout record layout is at: OAAMS.DWPROD.LFSEQ.APPR
    • LED_APPROPRIATIONS table
      • New fields added:
        • RESTRICTED_AMT                             DECIMAL(15, 2)
      • Ledger file record changes are already included in file OAAMS.DWPROD.ODW120I1.  Record layout is at OAAMS.DWPROD.ODW120I1
    • SUM_APPROPRIATIONS table
      • New fields added:
        • APPR_RESTRICT_AMT                      DECIMAL(15, 2)

Please contact the Financial Technical Help desk at 522-1500 (Option 1) or email us at Financial@oa.mo.gov if you have any questions.