June Enhancements

by | Jul 7, 2021 | Newsletter

The Department of FISCal 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 June 2021:

Accounts Payable (AP)

Request:

Modify RPTAP029 – Unreimbursed ORF Payment report.

Enhancement/Solution:

Modified Report Run page, added three Radio buttons:

  • Unreplenished
  • Partial Replenished
  • Fully Replenished

Modified Application engine, code change to include Regular Voucher created with Refund Clearing Account (1200900) to close Prepaid Balance.

Accounts Receivable (AR)

Request:

Grey out and prevent users from changing the Accounting Date on the Regular Deposit page Totals tab when the Deposit is generated from the Deposit Slip. Also, eliminate a pop-up message that requires a “SAVE” before exiting a page when no changes are made.

Enhancement/Solution:

Modified the code logic on “Accounting Date” field on Regular Deposit page to disable (grey out) the “Accounting Date”  field if the Deposit is created through Deposit Slip. Also, eliminated the pop-up message.

Accounts Receivable (AR)

Request:

  • Department User should not be able to add Positive Payment Sequence on negative Control Amount AR Regular Deposit linked to a Deposit Slip.
  • Department User should not be able to add a CR Distribution Line to a Deposit Payment on negative Control Amount AR Regular Deposit linked to a Deposit Slip.
  • INFAR018 interface should give an error when adding a Positive Payment Sequence on negative Control Amount AR Regular Deposit linked to a Deposit Slip.
  • INFAR018 interface should give an error when adding a CR Distribution Line to a Deposit Payment on negative Control Amount AR Regular Deposit linked to a Deposit Slip.
  • INFAR018 interface should add Request Type and Required Documents when the Deposits are loaded with ‘NEXT’ and Deposit ID is assigned by the process.

Enhancement/Solution:

  • Added code logic on Regular Deposit page to restrict user from adding Positive Payment Sequence on negative Control Amount AR Regular Deposit linked to a Deposit Slip.
  • Added code logic on Regular Deposit page to restrict user from adding a CR Distribution Line to a Deposit Payment on negative Control Amount AR Regular Deposit linked to a Deposit Slip.
  • Added logic on INFAR018 interface to give an error when adding a Positive Payment Sequence on negative Control Amount AR Regular Deposit linked to a Deposit Slip.
  • Added logic on INFAR018 interface to give an error when adding a CR Distribution Line to a Deposit Payment on negative Control Amount AR Regular Deposit linked to a Deposit Slip.
  • Added logic on INFAR018 interface to add Request Type and Required Documents when the Deposits are loaded with ‘NEXT’ and Deposit ID is assigned by the process.

Cash Management

Request:

  • Add a delete button to Accounts Outside CTS/No Account Outside CTS (Report 14) pages.
  • Due to a defect, user was able to enter both an Accounts Outside CTS and No Accounts Outside CTS transaction for the same Fiscal Year.

Enhancement/Solution:

  • Added Delete button to Accounts Outside CTS/No Account Outside CTS (Report 14) pages, in order to delete the transaction when it is not in approved status.
  • Updated code so that user will not be able to enter both an Accounts Outside CTS and No Accounts Outside CTS transaction for the same fiscal year unless all accounts are closed for the BU.

General Ledger/YEC

Request:

As part of the new SCO M5 ledger architecture, a new Adjustment Period (996) is being created in FI$Cal to capture correction items between Department financial statement submission and FI$Cal system. Seven reports have been identified and require modification to provide the ability to include/exclude the new Adjustment Period 996 from report output.

Enhancement/Solution:

Modified seven reports providing the ability to include/exclude the new Adjustment Period 996 on the run control page and report output.

  • List of YEC reports modified as part of this request:
  • Final Budget Report (Report 6)
  • Pre-Closing Trial Balance (Report 7)
  • Post-Closing Trial Balance (Report 8)
  • Analysis of Change in Fund Balance (Report 9)
  • Statement of Financial Condition (Report 20)
  • Subsidiaries on File
  • Due to/Due From Supplemental

Also migrated new string table (Program_ID Z_70281) for the reports above.

Procurement

Request:

  • Update the email notification to indicate if the Dispatched PO is Duplicate or Amendment or Cancel.
  • Force the user to enter the PO ID if Dispatch checkbox is checked on PO Dispatch Run Control Page.

Enhancement/Solution:

  • Modified the PO Dispatch Application to indicate if the Dispatched PO is Duplicate or Amendment or Cancel.
  • Modified the Peoplecode to force the user to enter PO ID if Dispatch checkbox is checked on PO Dispatch Run Control Page.

Procurement

Request:

  • Customize Procurement Contracts WorkCenter as follows:
  • Create 14 new pages
  • Configure 19 existing pages
  • Create 2 new dashboards
  • Configure 2 existing queries
  • Configure 6 existing reports
  • Enable the configuration page where the links, reports, and queries can be configured online.
  • Security for the Procurement Contract WorkCenter should be provided to 2 roles and 2 permission lists.
  • Enable Access for the configuration page provided only Z_CNTRL_PO_CFG_MAINT role.

Enhancement/Solution:

  • Customized Procurement Contract WorkCenter as follows:
  • Created 14 new pages
  • Configured 19 existing pages
  • Created 2 new dashboards
  • Configured 2 existing queries
  • Configured 6 existing reports
  • Enabled the configuration page where the links, reports, and queries can be configured online.
  • Provided security for the Procurement Contract WorkCenter to 2 roles and 2 permission lists.
  • Enabled Access for the configuration page provided only Z_CNTRL_PO_CFG_MAINT role. Migrated the Initial configurations using a DMS script

Project Costing

Request:

Modify Project Financial Report (RPTPC036) to include report “Start Date”, “End Date”, and “Accounting Period.”  This information is required when submitting the Project Financial Report to Federal Government on a quarterly and yearly basis.

Enhancement/Solution:

  • Modified code to update Run Control page to include Prompt fields for Fiscal Year From/To, Accounting Period From/To, and check box for Period 998.
  • Hide As Of Date and Run Option from the page.
  • Modified the report Header to reflect the changes in run control parameters.
  • Fixed existing Bug by removing Analysis Type, Category, Sub Category, and Vendor Contract Nbr Chartfields to resolve the “duplicate” amounts issue on the report.

Project Costing

Request:

Customize Project Costing WorkCenter as follows:

  • Create 5 new pages
  • Configure 23 existing pages
  • Create 1 new dashboard
  • Configure 15 existing queries
  • Configure 29 existing reports

Enhancement/Solution:

Customized Project Costing WorkCenter as below:

  • Created 5 new pages
  • Configured 23 existing pages
  • Created 1 new dashboard
  • Configured 15 existing queries
  • Configured 29 existing reports