SAM II Financial Scheduled Upgrades
The SAM II Financial system will be unavailable from 6:00 pm Friday, April 13, until approximately 6:15 am Monday, April 16 for implementation of the system updates and enhancements described below.
Effective Monday, April 16, 2012
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:
- In the future we will begin designating payment and purchase order addresses for vendors. The current State field in the Alternate Address section of the VEN2 window will be used to store this designation. The field label on VEN2 will be changed to read “Usage” instead of “State” and help text will be updated accordingly. A column to display the address Usage value for each vendor record will be added to the VTIN (All Vendors by Taxpayer ID Inquiry) and VNAM (Vendor Name Inquiry) windows. Valid values for this field will be PV, PO or spaces.
- If the Usage field is set to spaces then the vendor may be referenced on any document type.
- If the Usage field is set to “PO”, meaning “Purchase Order”, the vendor address is considered to be a purchasing address. Edits have been added to the RC, AM, PCQ, PCT, PDQ, PGQ, SC, SCS, RXQ and NR document processors to only allow vendor codes that have a Usage value of “PO” or spaces to be referenced on these document types. A hard error will be issued if a vendor code with a Usage value of “PV” is referenced on any of these document types.
- If the Usage field is set to “PV”, meaning “Payment Voucher”, the vendor address is considered to be a payment address. Edits have been added to the VIQ, MP, MW, P1, PV, PVA, PVE, PVQ, PVS and PVV document processors and to the RPAT, ODCK and REPV table processors to only allow vendor codes that have a Usage value of “PV” or spaces to be referenced on these document types and tables. A hard error will be issued if a vendor code with a Usage value of “PO” is referenced on any of these document types or tables.
- No other document types or tables are impacted by this change.
- NOTE: Even though we are implementing program changes that include these edits on April 16, the edits will not be enforced until OA/Accounting begins updating the Usage field on VEN2 with values other than spaces so you will not see an immediate impact from these changes.
- The Grant field has been protected on the JB and JBR document windows. An edit was added to the document processors for these documents to issue a level 1 override error message if the value entered in the Extended Project field is not a valid project number on the PRBL (Project Budget Line) table.
- Purchase Order modification processing has been changed to not update the On Order quantity on INV2 (Inventory Inquiry 1 of 3) if the Final Receipt on OPPC (Open PO Commodity Line Inquiry) flag is already set to ‘F’.
- Help text for the Remaining Balance field on the PASM (Price Agreement Summary), PAEX (Price Agreement Expiration Inquiry), PASI (Price Agreement Summary Inquiry), and PAVC (Price Agreement Vendor/Commodity) windows has been updated.
- A field labeled Intercept Exempt has been added to the OBJ2 (Object), SOBJ (Sub-Object) and FUN2 (Fund) windows for future use. These fields will be used to identify funds, objects and/or sub-objects that are not eligible for warrant intercept processing. Payment line amounts referencing a fund, object or sub-object that has been marked as Intercept Exempt will not be included in the calculation of payment amount eligible to be intercepted. Code changes to implement this added functionality are planned for the future and have not been made yet.
- A field named MBE/WBE Excluded has been added to the OBJ2 (Object) and SOBJ (Sub-Object) windows. These fields will be used to identify object and sub-object codes that are not eligible to be included in the calculation of MBE/WBE payment amounts. Payment line amounts referencing an object or sub-object that has been marked as MBE/WBE Excluded will not be included in the calculations and amounts reported on the monthly MBE/WBE expenditures reports.
- A field labeled Intercept Amount has been added to the OPCH (Open Check Header) and WRE2 (Warrant Reconciliation 2 of 2) windows and tables to display the amount intercepted from check and EFT payments.
- Three 1-byte report Indicator fields have been added to the OBJ2 (Object) and SOBJ (Sub-Object) windows and four 1-byte report indicator fields have been added to the FUN2 (Fund) window. These fields are reserved for future use as needed.
- The Backup Withholding field on the VEN3 (Vendor 2 of 3) window has been changed from having selection buttons labeled Yes, No and Not Applicable to being a check box. If the box is checked then the vendor is eligible for backup withholding processing; if it is unchecked then the vendor is not eligible for backup withholding processing.
- The Sub-Project Description (2 of 2) window (SPD2) is being reinstated.
- On the Stimulus Program Master (STIM) table, the field label that reads as Federal Award Number has been changed to read as STIM360 Fed Award Num.
SAM II Financial Data Warehouse Changes:
- 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_FUND table
- REF_OBJECT table
- Two new tables have been added to the Data Warehouse
- REF_PR_AGR_HDR_MOD - DW equivalent of the SAM II MPAH table
- REF_PR_AGR_SUM_MOD - DW equivalent of the SAM II MPSM table
- The field description in the data dictionary for the ALT_STATE field on REF_VENDOR and REF_VENDOR_MAX will be updated to reflect that the field will be used to designate whether this vendor number/address indicator combination is to be used for purchasing documents or payment documents.
Please contact the Financial Technical Help desk at 522-1500 (Option
1) or email us if you have
any questions.
