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):
Accounts Receivable
Request: CS0091622
Request to update Custom Char field with Billed Department BU as part of InterUnit Invoice Portal.
Enhancement/Solution
SQL to update Custom Char 10D field with Business Unit GL value of Billed BU on Customer Record.
Request: CS0277401
Grant access to the All Payments and Direct Journal Accounting Entries for SCO AR Deposit Approver:
Navigation: AR > Payments > Review Payments > All Payments
Navigation: Main Menu > Accounts Receivable > Payments > Direct Journal Payments > Create Accounting Entries/Modify Accounting Entries
Enhancement/Solution
Added access to “All Payments” and “Direct Journal Accounting Entries” for Z_SCO_AR_DEPOSIT_APPROVER role.
Request: CS0311847
1) Request Type on the Create Accounting Page should be available for user based on Cash Type selected on the Payment page. This validation will be controlled via the Request Type Configuration page. Configuration should be similar to the Location Type on the Request Type Configuration page. This should also be implemented for both DJP & CIP.
2) Update the logic to restrict Fund Code based on Request Type selected on the CTS & Non CTS Fund values configured on the “Approval Rule Configuration” page. Navigation: Main Menu > Accounts Receivable > Payments > Apply Payments > Item Payment Details.
Enhancement/Solution
Code Changed – Added three new records:
1) ZZ_AR_CSH_TYP
2) ZZ_CTSFUND_VW
3) ZZ_NONCTS_VW
Updated following PeopleCodes:
1) ZZ_ACC_ENTR_WRK.ZZ_ACC_ENTR_ACT.FieldChange
2) ZZ_ACC_ENTR_WRK.ZZ_ACC_ENTR_ACT.RowInit
3) ZZ_ACC_ENTR_WRK.ZZ_ACC_ENT_ACT.FieldChange
4) ZZ_ACC_ENTR_WRK.ZZ_ACC_ENT_ACT.RowInit
5) ZZ_AR_CSH_TYP.ZZ_CASH_TYPE.FieldEdit
6) ZZ_AR_CSH_TYP.ZZ_CASH_TYPE.SaveEdit
7) PAYMENT_MISC_DST.Activate
Request: CS0277401
Request to modify AR Remittance TC47 Outbound Interface process for the following:
1) For Deposit Slips, the CIP if required approval, should not be interfaced until approved and posted to GL successfully.
2) For ZDD, all the Payment Sequences within a ZDD should be interfaced when all the sequences are approved and posted to GL successfully; it should not be interfaced individually.
Enhancement/Solution
Modified application engine ZZ_AR_OBTC47 for CIP and ZDD to include the following changes:
1) For Deposit Slips, the CIP if required approval, will not be interfaced until approved and posted to GL successfully.
2) For ZDD, all the Payment Sequences within a ZDD will be interfaced when all the sequences are approved and posted to GL successfully; it will not be interfaced individually.
Request: CS0277401
Request to modify the JGEN template for CIP (ARDEFN) to prevent GL posting of CIP A/C entries until DJPs CIPs in ZDD are approved by SARD, budget checked, and CVCVAC.
Request to modify code to prepopulate Legal Authority according to Receipt Type.
Enhancement/Solution
Created and added ZZ_ITM_DSTCC_VW to ARDEFN accounting entry definition to modify the JGEN template for CIP (ARDEFN) to prevent GL posting of CIP A/C entries until DJPs CIPs in ZDD are approved by SARD, budget checked, and CVCVAC.
Enabled Legal Authority to be prepopulated based on Receipt Type.
Request: CS0277401
Modify the AR Remittance Correction/Adjustment (TC35/TC38) Outbound Interface process for the following:
1) For ZDD, all the Payment Sequences within a ZDD should be interfaced when all the Sequences are approved, if approval required, and posted to GL successfully.
2) For ZDD with all the Sequences on CIP, interface the ZDD only once approved and posted to GL successfully. If the ZDD with all CIPs does not require approval, it should not be interfaced.
Navigation: Main Menu > FI$Cal Processes > FI$Cal Interfaces > GL > Outbound TC Interface > Outbound TC Interface
Enhancement/Solution
Modified application engine ZZ_AR_OBTC35 and ZZ_AR_OBTC38 for CIP and ZDD to include the requested changes:
1) For ZDD, all the Payment Sequences within a ZDD will be interfaced when all the sequences are approved by SCO and are posted to GL successfully.
2) For ZDD with all the Sequences on CIP, interface the ZDD only once approved by SCO and posted to GL successfully.
Request: CS0277401
Update Mass Completion page to allow the following actions for Payment Sequence marked as CIP (TC47/35/38): Assign Request Type/Required Document, Certify, and Submit for Approval.
Navigation: Main Menu > Accounts Receivable > Payments > Direct Journal Payments > Mass Completion
Enhancement/Solution
Modified Mass Completion page to add Transaction Type ‘CIP’ and Accounting Actions for CIP:
00 – Assign Request Type & Docs
01 – Certify
02 – Submit For Approval
Request: CS0277401
Grant permission to the following roles:
Z_BI_AR_APPROVER (BI/AR Approver), Z_CA_FUNC_DEPT_SUPPORT (Dept Prod Support Role), Z_CA_FUNC_PROD_SUPPORT (Product Support Role), Z_DEPT_AR_PAYMENT_APPR (Department AR Payment Approver), Z_AR_PAYMENT_PROCESSOR (AR Payment Processor), Z_CA_FUNC_DEPT_SUPPORT (Dept Prod Support Role), Z_CA_FUNC_PROD_SUPPORT (Product Support Role), Z_DEPT_AR_PAYMENT_PROC (Department AR Payment Processor), Z_SCO_AR_AGENCY_PYMNT_PROC (SCO AR Agency Payment Proc), and Z_SCO_AR_DEPOSIT_APPROVER (SCO AR Deposit Approver) under the Permissions List object to access the following:
Navigation: Main Menu > Accounts Receivable > Payments > Apply Payments > Item Payment Details
Enhancement/Solution
The following users are able to access Item Payment Details component pages:
Z_BI_AR_APPROVER (BI/AR Approver), Z_CA_FUNC_DEPT_SUPPORT (Dept Prod Support Role), Z_CA_FUNC_PROD_SUPPORT (Product Support Role), Z_DEPT_AR_PAYMENT_APPR (Department AR Payment Approver), Z_AR_PAYMENT_PROCESSOR (AR Payment Processor), Z_CA_FUNC_DEPT_SUPPORT (Dept Prod Support Role), Z_CA_FUNC_PROD_SUPPORT (Product Support Role), Z_DEPT_AR_PAYMENT_PROC (Department AR Payment Processor), Z_SCO_AR_AGENCY_PYMNT_PROC (SCO AR Agency Payment Proc), Z_SCO_AR_DEPOSIT_APPROVER (SCO AR Deposit Approver).
Request: CS0277401
Update the existing Deposit Approval Review page to accommodate the Mass Approval.
Navigation: Main Menu > Accounts Receivable > Payments > Deposit Approval Review
Enhancement/Solution
Added the Approval button on the main page similar to Deny button.
Request: CS0317430
Add Attachment as Required Document on CTS Request Type configuration.
Navigation: Main Menu > FI$Cal Processes > FI$Cal Extension > AR > Deposit Approval > Request Type Config
Enhancement/Solution
Updated ZZ_AR_DBU_TBL record and ZZ_AR_RCPT_CFG page to add new field for “Attachment Required.” Updated code to check if Attachment is added as Required Document on CTS Request Type.
Request: CS0277401
Request to implement Approval process on Remittance and Remittance & Correction CIP Deposit Payments. Requires Request Type/Required Documents/Legal Authority & Reason for Request and Certification similar to DJP for the SCO Approval process.
Enhancement/Solution
1) Created new Item Payment Details page for CIP Transactions route for approval.
Navigation: Main Menu > Accounts Receivable > Payments > Apply Payments > Item Payment Details
2) Modified application engine ZZ_GL_CVWACT to allow only Approved TC35/38/47 transactions to go for CV/CVAC validation. Also, this application engine is modified to process both Warrant and Non-warrant CIP transactions and their CVAC.
3) Remove CV/CVAC validation from ZZ_GL_CSHCIP application engine and it will process only Cash Reclassification of CIP transactions.
4) Modified Deposit Pre-approval process to include CIP transactions in Approval workflow.
Request: CS0277401
1) Add Accounting Entries (Collected Revenue(AR_CC_TRAN_TBL) line and Cash line (ITEM_DST)) to the All Payments page.
Navigation: Main Menu > Accounts Receivable > Payments > All Payments
On the Deposit Approval Review page under Deposit Approval tab, when the user clicks on CIP link, the All Payments page should open.
3) When SCO Approver Denies with Unpost, the Approval Status should show “Denied with Unpost” instead of only showing “Denied” as the Approval Status on the Approval Review page.
Navigation: Main Menu > Accounts Receivable > Payments > Deposit Approval Review
Enhancement/Solution
Modified ZZ_DEP_MAPR_VW to include Denied and Unpost status and update ZZ_AR_CIPALL_VW to display Accounting Entries (Collected Revenue (AR_CC_TRAN_TBL) line and Cash line (ITEM_DST)) to the All Payments page.
Request: CS0277401
Modify the following reports as part of CIP Enhancement:
1) RPTAR075: Modify the Outbound Remittance Recon Report to update ChartField values, all Approval Details and Journal Details for all CIP Payments.
Navigation: Main Menu > FI$Cal Processes > FI$Cal Report > AR Reports > AR Remittance Recon Report
2) RPTAR088: Modify the SCO AR Transaction Pre-Approval Report to provide the list of AR Remittances or AR Correction & Remittances and should identify if the Transaction is Pre-Approved or requires SCO Approval. If the transaction is Pre-approved, the report will specify which Approval rule is applied for CIP Payments.
Navigation: Main Menu > FI$\Cal Processes > FI$Cal Report > AR Reports > SCO AR Transac Pre-Approv Rpt
Enhancement/Solution
Updated ZZ_AR_RMTRPT and ZZ_AR_PARPT application engines to include CIP:
1) ZZ_APR_HIST_VW
2) ZZ_AR_RPPYM_VW
3) ZZ_AR_APR_TAO
General Ledger
Request: CS0363293
Add Non-FI$Cal departments to Transparency Website, excluding Accruals.
Enhancement/Solution
Added Non-FI$Cal departments to the Transparency data extract, excluding Accruals.
Procurement
Request: CS0262925
EXTPO235 Requirements: New Procurement Contract Release functionality to allow Procurement Contract Buyers to set up the future dates for Contract Releases to have POs automatically created on the Release Dates specified by the Contract Buyer. It will automate the PO creation by the system from the staged Contract Releases scheduled on future dates, so PO Buyers will not need to manually create POs one by one by copying from the Contract ID. PO Buyers will only need to review, make any necessary changes, and then further submit POs for Approval and Dispatch. Email notification will be sent to the Contract Buyer and PO Buyer when a PO has been released from the Contract.
Enhancement/Solution
Code change in multiple objects:
Change in PO_AUTO_SRC Run Control page and developed two new custom App Engines –
1) To preset Current Date in PO_AUTO_SRC Run Control and
2) To send the email after POs are created and change in field xlat properties.
Create new Job to run all processes in series for users and batch.
Change fields on Auto Source Run Control page to be Disabled, Defaulted, or Required.
Request: EPIC 90316
Enhancement to prevent inadvertent reopening of all PO’s/Requisitions by Business Unit.
Enhancement/Solution
Changed PeopleCode to enhance the Reopen POs/Requisitions Run Control page:
1) Reopen Request dropdown list – removed the ‘Specific Business Unit’ option.
2) Reopen Request dropdown list – removed the ‘Range of Documents’ option for all users except PO Central User role defined in Strings table.
3) Last Close PO/Requisition Run option is only available to PO Central User Role defined in Strings table.
4) One-time SQL was done to clear PS_RUN_CNTL_PO_AE.REOPEN_RUN_IND, PS_RUN_CNTL_PO_AE. PO_DT_OPTN, and PS_RUN_CNTL_PO_AE. REQ_DT_OPTN.