OSP is hiring a Functional Test Analyst
The Office of State Procurement (OSP) at Minnesota Department of Administration is hiring a Functional Test Analyst.
The position is a part of the operations/functional support unit. In this position, you will lead project-level functional system testing and upgrade support within the SWIFT Procurement Module Support Team.
The Office of State Procurement (OSP) is one of the largest divisions with the agency. This division oversees $2.1 billion in goods and services purchased annually. The division offers volume discounts to state agencies and local units of government through 1,600 enterprise contracts and the two (2) largest multi-state cooperative purchasing programs in the nation. This team also oversees vendor relations for the State and administers business development programs that help economically disadvantaged and legislatively-targeted companies doing business with the State.
This position is eligible for a hybrid telework arrangement. Working for the State of Minnesota means a great work-life balance, affordable benefits, and many great opportunities for advancement in 100 State agencies. The Job ID is 69846.
Message Center on the Administrative Portal
Do you use the Message Center on the Administrative Portal? It shows the latest SWIFT Newsletter and lists the current training options for SWIFT and the EPM Data Warehouse for SWIFT. It also displays any messages from Minnesota Management and Budget. To view available messages, select the Message Center tile.
The Message Center page displays. Select an item from either the left-hand menu or from the center of the page.
For example, you can easily find the SWIFT Training and EPM Data Warehouse Labs Calendar.
SWIFT Hot Topic: Bilateral Netting
SWIFT Hot Topics feature Frequently Asked Questions (FAQs) answered by the SWIFT Training and Help Desk team. Use these as a friendly reminder of a process or as an opportunity to learn something new!
Q. What is bilateral netting, and how I troubleshoot issues related to this process in SWIFT?
A. Bilateral netting refers to processing interagency transactions in SWIFT by automatically offsetting interagency Accounts Payable (AP) vouchers against open interagency Accounts Receivable (AR) invoices.
Interagency vouchers net when the following criteria are met.
- The Supplier ID on the voucher matches the Business Unit that sent the invoice (bill), and the Customer Number on the invoice matches the Business Unit generating the voucher/payment.
- The Invoice Number on the voucher and the bill match. Bilateral netting requires a case-sensitive match.
- The Amount on the voucher and the bill match. Do not submit a voucher for a partial payment.
How to identify interagency vouchers that fail to net and pay
- Run the following query: Unpaid Interagency Vouchers query: M_CM_GBL_INTAGCYAP_UNPAID
How to identify why interagency vouchers are failing to net
Run the following two queries to return a list of open SWIFT AR interagency invoices, for which an agency is the customer:
- Interagency Netting by Budget Year: M_CM_GBL_INTERAGENCYPMTS_BFY
- Interagency Netting by Fiscal Year: M_CM_GBL_INTERAGENCYPMTS_FY
You can compare the results of these two queries against the results of the Unpaid Interagency Vouchers query to identify mismatches in Amounts or Invoice Numbers, which may prevent vouchers from netting. Vouchers will also fail to net if the billing agency fails to create an AR transaction or closes the AR invoice in SWIFT.
Make sure to reach out to the contact listed on the invoice or the billing agency if a voucher is failing to net due to a missing AR transaction.
For further assistance to resolve any bilateral netting issues, please contact the SWIFT Help Desk.