The Department of FISCal (FI$Cal) continually makes updates and enhancements to the system based on feedback from our end users. Our goal is to improve usability while maintaining the highest level of security for the state’s data.

FI$Cal released the following enhancements in October (descriptions include ServiceNow case numbers):

Purchase Orders

Request: CS0371818

Requested to create a new Custom Encumbrance Aging Report to track encumbrance aging by purchase orders (PO). The need was to view detailed information for all open encumbrances and group them into 0-60, 61-180, 181-360, and 360+ days aging categories. The report/query should have the following information:

• PO ID and date
• Supplier name and ID
• Starting and remaining balances
• Invoice ID, amount, and date
• Voucher ID, amount, and date
• Payment reference and date

Enhancement/Solution

A new Custom PO Encumbrance Aging Report was developed.

General Ledger

Request: CS0432712

Requested to populate the information under column KK_DOC_ID(ZZ_FIS_DOC_ID) for Tran Type ‘ZZCLMALLC’ and ‘ZZVCHALLC’ on the query DFQ_GL_05_REC_KK_APPROP_LEVEL . The data was not populated under the column KK_DOC_ID(ZZ_FIS_DOC_ID) for Tran Types ‘ZZCLMALLC’ and ‘ZZVCHALLC’.

Enhancement/Solution

Modified the required code changes for the enhancement.

Request: CS0461572

This request was to enhance the PDA report to include journal voucheruUnpost KK source (ZZVCHUNPST). The PDA did not include the commitment control (KK) source (ZZVCHUNPST), which caused the PDA to not sync with multiple KK reports. For example: DFQ_KK_01_ACTIVITYLOG_SUP_PROJ.

Enhancement/Solution

An enhancement to the PDA Report was created to include ZZVCHUNPST KK source transactions.