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 March (descriptions include ServiceNow case numbers):
P-Card
Request: CS0234037
EPIC 63990 – Flow tax or tax exempt status from purchase order (PO) lines to P-Card transaction when reconciling with PO.
Enhancement/Solution
Change the prorate percent to be determined at the PO line level (PO Line Monetary Amount/PO Line Merchandise Amount) when P-Card amount and PO total amounts are the same.
- Show the exact sales/use tax amount from associated PO line on P-Card transaction.
- Fix P-Card line and distribution regrouping issue with split PO line distributions scenario. Regrouping is updating incorrect amount for P-Card transaction distribution lines > 1.
Bill
Request: CS0331372
Criteria being requested in a new Power BI dashboard set: Cash Balance, Fund Type, All Appropr, Program, Project Activity vs Service Location, Customer Name, CAT Type, Taxable or Non-Taxable, Type of Cash, Time of Cash Activity, Real-Time EOM vs Real-Time Today Balance, Status of Deposit – Pending SCO Approval, Bank Account Number, Cash vs A/R, Whole Charge field value, Cash Type, Aging A/Rs, Deposit Detail, Ticket Number, Deposit Slip Number, Deposit ID, SCO Doc Number, SCO Date, Item ID for A/R, Receipt Type, Refund – Sourcing Information to Post Reverted or Refunded Amounts Sent Out – Need to Post Back, and Return to Agency Use Level.
Enhancement/Solution
Created Cash Management Dashboard in Power BI.
Customer Contracts
Request: CS0366493
No query exists for general use that allows departments to easily trace journals generated by customer contracts module to the billing invoice and the source transactions. This query will assist departments in researching revenue journals originating from the customer contracts module.
Enhancement/Solution
Created query to assist departments in tracing contract revenue journals to both the originating transactions and the billing invoice. Example query provided in separate tab with required fields.