Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
This page is maintained by Shae Chiandet, so if you have any questions, please email

...

shae.chiandet@uci.edu.

...

About the Recommendations and Decisions
  • Items will be updated each Friday, by extracting recommendations and decisions from new meeting minutes
  • Accounting Systems leads should designate a section on each meeting minutes document to record new items
  • Additional items will be linked to the JIRA system (closed Business Analysis items), and will be identified as XBA for the module

Recommendations & Decisions

Excel
col4
nameFocus Group Comments-Decisions.xlsx
sheetComments and Decisions

 

...

  • appearing in this table were extracted from the meeting minutes of the focus groups and fit-gap sessions
  • Additional items (closed Business Analysis JIRAs) are identified as XBA for the module
  • This list was archived as of December 14, 2012, as there are no further focus groups or fit-gap sessions
  • More recent decisions are documented through the Business Analysis JIRAs (captured in the Decision Matrix: Business Analysis)

...

Archived Recommendations & Decisions

ModuleFeatureDateRecommendation or decision?MatchDetailsAnticipated Decision Date
CGAward close out2012.07.20RecommendationNot finalizedAward close out---Currently, CG notifies the departments 4 months in advance the award is closing.  Can we set-up the alert in KFS?2012.01.15
CGAward routing2012.09.20RecommendationNot finalizedAfter the CG central assigns the Account from the account maintenance on the Award, can the award route to SPA as FYI?
Possible Decision:  SPA will retrieve the information through DW
2012.01.15
       
CGAccount Creation2012.06.21A1-RecommendationKFSI-717Team recommendation for C&G Account creation: 1) C&G finds out new award from the SPA e-Synopsis page. 2) C&G searches for new award on the Award Document. 3) C&G Initiates account maintenance document. 4)  FO/acct Mgr/Supervisor will default to the defaults defined on Organization (this will be an enhancement request). This will be a similar strategy built for KC to KFS Integration. 5) UC account will be 440000, etc. 6) C&G Department reviews the account maintenance document as an Organization Reviewer. 7)  RAS process will be the same in the new process. 
CGControl Accounts2012.07.20A-1 RecommendationKFSI-717Control Account number – use Fund name; Sibling account – use Account name 
XBA - CGRecommend the Use of Control Accounts for C&G accounts2012.11.01A-1 Decision KFSI-717 
       
CGBudget Adjustment2012.07.30A-2 RecommendationKFSI-718The Group suggests:  CG office will do budget adjustment on Control Account.  Then the dept will move from control account to allocate to different accounts.

Decision:
Maria LIEGGI added a comment - 08/Nov/12 11:14 AM
C&G will be using Control Account to allocate the budget, the departments will deallocate and move the budget to their accounts if needed. They will use BA document and Current Budget field in KFS
 
XBA - CGKFSI-717 Should we use Control Account to store 'base' budget for C&G?2012.11.08A-2 Decision KFSI-718 
       
CGContinuation Account2012.07.30A-3 RecommendationKFSI-735The group recommends if they can default the account by Organization on the continuation account like how the PAL Card does. (Trini will email Brenda to suggest to bring this topic to the MAABO group).

Decision:  
Troy FLUHARTY added a comment - 07/Sep/12 4:18 PM
Discussed with Rebecca on issues related to enforcement of continuation accounts, she agrees with direction of using the delivered expiration functionality. Had conversation with Rich to confirm we can proceed, we can and if formal policy is necessary we will complete. As far as KFS project is concerned issue is closed and delivered functionality will be used.
 
CGContinuation AccountN/AA-3 RecommendationKFSI-735Can we set up a dummy account for the continuation account? 
XBA - CGContinuation Account2012.09.14A-3 Decision KFSI-735 
       
PURAPPurchase Order2012.08.30A-4 Recommendation & DecisionKFSI-7153-way POs matching have been recommended. Further detail conversion on this topic will continue in future meeting to flush out details.

DECISION: (1) Systemwide receiving threshold: $10,000
(2) Exceptions will be defined, using receiving threshold table by various attributes (org, vendor number, commodity code, etc)
(3) All invoices must be approved by fiscal officer regardless of PO type (this includes sub-awards and plant invoices)
See attached meeting minutes describing the discussion 
 
XBA - PURAPInvoicing and receiving rules2012.09.05A-4 Decision KFSI-715 
       
CAMInventory2012.09.26Recommendation & Decision Helen suggested if the departments can do the inventory with iPhone, and her office will be able to edit the scanned inventory and upload.  Then, it will go through the decision support to validate.  For the iPhones, Helen’s office will purchase all the iPhones and loan out to the departments

DECISION: Future Phase
 
CGAccount Lookup2012.07.20Recommendation & Decision Account lookup – Search by Control Account: The account name is included the A/F -- The group recommends to remove the A/F when we go live.

DECISION: KFS Expense Accounts  will  have the FS Account Title.  KFS Control Accounts will hve the FS Fund Title.
 
CGGeneral Error Correction  2012.07.25Recommendation & Decision GEC – Error Certification Tab, the group recommends that it will be a training issue for the FO do not click “Disapproved” when the explanations for the extramural fund is not clear.  The initiator can edit to avoid audit trail.

DECISION: Internal C&G business process change
 
CGNSF2012.07.30Recommendation & Decision Keiko will be able to program using the following info for CAFP to report to UCOP:

DECISION: JIRA KFSI-605 completed 2012-07-20
 
CGTransaction fund changes2012.07.30Recommendation & Decision If the transaction is move within the same funds, Can it be set to auto approve? For instance:  Move State to State fund (auto approve). If from State to Federal fund, then CG office needs to review/approve (Rebecca will talk to Rich, why CG has to approve all transactions in regardless on amount on CG fund)

DECISION: C&G will not be in the workflow.  Audit can be after the fact through DS.
 
CGAccount expiration date2012.08.13Recommendation & Decision The group suggests, central CG does not have to input the account expiration date at the time of account creates, they can input the date upon review of the account or toward the end of financial reporting.  Or use the sufficient fund check functionality in KFS

DECISION: Internal C&G business process change
 
CGDisbursement Voucher2012.08.13Recommendation & Decision Disbursement voucher will route to CG on certain object codes  (CG office will provide a list of object codes)

DECISION: Global object Edit will handle this routing.
 
CGGeneral Error Correction2012.08.13Recommendation & Decision GEC, PI needs to certify and approve from the Ad Hoc routing
Decision: C&G office will not approve any GEC documents tha have not been ADHoced to PI (Account Manager)

DECISION: Training - See C&G Powerpoint
 
CGAward Budget PeriodN/ARecommendation & Decision Can we have each year's Budget period on the award- Budget Period tab?
C&G will be manually inputing subsequent budget periods in the AwardDoc

DECISION: Internal C&G business process change
 
CGPacking slipN/ARecommendation & Decision Can the department destroy the original packing slip after it has been scanned and attached or shreded from DDM? If so, need written agreement.

DECISION: Closed JIRA KFSI-716
Troy FLUHARTY added a comment - 08/Oct/12 1:42 PM
We have reviewed the University of California Accounting Manual and there is no policy requirement for retaining packing slips for purchases. Purchases are required to have proof of receipt of goods, "a departmental certification acknowledging receipt may be recorded on the invoice or a copy of the receiving document on-line." is referenced in both in policy A-000-7 as well as D-371-36. Current practice may have been required due to system limitations to obtain the required information however in KFS the receiving document for payment requests and the initiation/approval of the DV should be sufficient to show the requireed certification. I have discussed this with Rich and he concurs, with KFS there is no need to retain packing slips for any purchases, C&G or not. Departments may keep them if they desire but it will not be required by UCI.
 
CG General Error Correction - General Ledger importing2012.08.27Recommendation & Decision The group suggests, GEC – GL importing – when the departments copy the “From” to “To” line, the line descriptions must be the same. Can the line descriptions default from the original charge and not an editable field?

DECISION: KFSI-384 resolved 2012-11-26
 
CG General Error Correction - Error Certification tabN/ARecommendation & Decision Can the Fiscal Office be trained not to "Disapprove" the document if the explanations in this tab are not clear, for audit trail purpose?

DECISION: Training - See C&G Powerpoint
 
CGLookup2012.09.10Recommendation & Decision The group suggests to create “How to” to look up inception-to-date and previous month in KFS.

DECISION: Training - See C&G Powerpoint
 
CGUC Account2012.09.10Recommendation & Decision For the UC account, if we use the HEFC and Organization code to be UC account, it doesn’t make any different if we use 44XXXX – the departments just need to be trained.

DECISION: KFSI-734 closed 2012-10-08
We will continue to create UC accounts as long as the crosswalk is necessary from the feeder systems and black box so that the crosswalk look up will not return duplicate KFS accounts. We will automate the creation of the UC account number on the UC Account Maintenance Document. The convention will be 2 digit Function Code + Alpha + 3 digit sequential number (UCOP requirement is 2 digit Function Code and the remainder can be anything). 
 
PURAPREQ2012.03.26Recommendation & Decision Is it possible to have a pop-up warning the requisitioner when selecting "must be received by" to warn them that there may be additional shipping charges for delivery?

DECISION: Wishlist: KFSI-1065
 
PURAPREQ2012.03.26Recommendation & Decision Is it possible to use keyboard shortcuts (e.g. Control + S) to accomplish functions instead of scrolling to the bottom past all tabs or have another "Save" button by the "hide" button (at the tab level)?

DECISION: Wishlist: KFSI-1066
 
PURAPREQ2012.03.26Recommendation & Decision It would be nice to have the tab that was most recently completed change color or turn bold or some sort of indicator to show where the user was last.

DECISION: Wishlist: KFSI-1067
 
PURAPREQ2012.03.26Recommendation & Decision Can there be a default for the percentage (especially since a singe account is already defaulted), so that 100% doesn't have to be entered every time.

DECISION: Wishlist: KFSI-1068
 
PURAPDV2012.04.16Recommendation & Decision Can we make the Currency Type a drop down menu?

DECISION: Wishlist: KFSI-1072
 
PURAPPCDO Document2012.09.13Recommendation & Decision Add FYI for Cardholder in the route node in the workflow before the Reconciler.

DECISION: KFSI-774 resolved 2012-09-22
 
PURAPPAL Card process flow2012.09.13Recommendation & Decision The group suggests if the users input $0 in the Enter Sales Tax, then the tax won’t be included.  But, they can use Tax Exempt indicator and add drop down (reason codes): Subscription, Membership, Software, Other (Enter notes).

DECISION: KFSI-913 resolved 2012-11-02
 
WorkflowInternal Billing for Fabrication 2012.07.18Recommendation & Decision Internal Billing Fabrication edoc:  the Fiscal Officer can only change the account; it should be revised so that the Fiscal Officer can also change the edoc to an asset.

DECISION: Wishlist: KFSI-1063
 
CGFund rules2012.07.20Declined The group recommends to set a template rule for each fund: 1) NSF  2) Training Grants 
CGPacking slip2012.07.20Declined Need written documentation for the packing slips: 1) Can the department destroy the original after it has been scanned through DDM? 2) Do they need to keep the original for Audit purpose? 
CG Control Accounts2012.08.27Declined Since we will be using Control Account, if General Accounting creates general fund, can they link it to Control Account

Scenario:  SPA will submit split funding to CG and GA.
 
CGAccount Expiration2012.09.06Declined Can CG control the Account Expiration date? 
PURAPGeneral2012.03.15Declined Can we select what type of documents we can get reminder emails? 
PURAPREQ2012.03.26Declined Can the accounting lines appear already open instead of initially appear hidden? 
CAMAsset EditN/ADecision Department users can only allow to edit the following fields:  Requestor Name/P.I, Responsible Person, Warranty, Alternate Description, Notes and attachments, Serial number, Maintenance date, Asset location (Building &Room), Usage Percentage, Repair. 
CAMAsset FabricationN/ADecision The department will request the Fabrication through the Asset Fabrication document.  It will route to Equipment Management Office for approval.  Justification is needed from PI. 
CAMAsset Loan (property leaving the campus)N/ADecision The lending deparment initiate the loan document and attached the Loan Form with Fiscal officer/Department's Chair signature. 
CAMAsset Loan (within UCI department)N/ADecision The lending department initiate the Loan document if loan within the campus. 
CAMInternal Billing Fabrication (UCI)N/ADecision Physical & Bio Sci, Machine Shop, Glass shops departments use the IB Fab document for Labor charge/recharge on Fabrication 
CAMAccumulated Depreciation2012.09.20Decision The team has decided to replicate the current logic as it has been working with SMS and UCOP.  The treatment of 119710 (Net Renewal and Replacement) Balance Sheet account discussion is still undergoing between MC and General Accounting, however, KFS will be modified in such a way that any account number can be used to track  “accumulated depreciation.” 
CAMMemo cap process2012.09.27Decision Memo cap process will remain manual, however reports will need to be provided to Sam Phan. 
CGAward documentN/ADecision SPA's new award /RAS information from the E-synopsis will be loaded to the KFS award document. 
CGBudget AdjustmentN/ADecision 

Bitmap CG office will input the Budget allocation for CG fund.  The Non CG will be fed through from FMW.

 
CGCost ShareN/ADecision CG office will create the CG subaccount.  Non-payroll will be processed through KFS cost share.  Payroll of cost share will be done using the current cost share system.  For reporting, the current cost share system will combine both current and KFS cost share system. 
CGSubawardN/ADecision The subward will be processed through the PURAP. 
CG AccountN/ADecision CG office will create Control account to link to each KFS account for multi-year award 
CGE-verify field2012.09.12Decision E-verify field will add back onto the Award.  If the award is subject to E-verify, the officer checks the e-verify box in the SPA database award screen. When the award is "finalized", the e-verify data is there and can pass to KFS. 
COAAccountsN/ADecision KFS accounts will be 7 random digits and will be created for each Account&Fund with a balance as of June 30, 201 
COAObject CodesN/ADecision Object codes have been reviewed and will not include consolidations for OP subs, 5 & 7. 
COAProject CodeN/ADecision Project code will be a combination of the 4 digit ORG number & 6 characters assigned by the ORG. 
COASub-ObjectsN/ADecision Sub-Objects will be 3 characters except for Central Office transaction codes functions which will be 4 digits. 
DWCognosN/ADecision Cognos is and will be the sole, financial reporting tool starting July, 2013. 
DWCognosN/ADecision Cognos has been installed and is operational, with sample KFS data. 
DWConsultantN/ADecision An outside consultant has been assigned to the data warehouse project. 
DWConsultantN/ADecision A data warehouse project plan has been submitted from an outside consultant. 
DWCurrent FS reportsN/ADecision Current FS standard reports are under evaluation, and data requirements are currently being gathered. 
DWFocus groupN/ADecision Data warehouse focus groups will commence shortly. 
DWKFS standard reportsN/ADecision Standard KFS built-in reports are being evaluated, and modifications, if any, will be proposed. 
PURAPVendor2012.08.30Decision The Vendor Onboarding(VOB) "Disclosure Form" will come to purchasing and purchasing will manage this form outside of KFS. 
PURAPVendor2012.08.30Decision Accounts payable "Vendor Administrator" will not cancel VOB transaction. Vendor administrator will work with vendor and/or internal requestor to true-up data for final approval.  
PURAPVendor2012.08.30Decision VOB website will have purchasing e-mail and contact information for help questions. 
PURAP 2012.09.05Decision Set configuration where transactions will “Auto Approved” after 14 business days. 
PURAP 2012.09.05Decision Only ‘Active” employees will be available in KFS. 
WorkflowMaintenance eDocs2012.06.27Decision Maintenance eDocs: Added 2 workflow route nodes to the standard delivered KFS workflow: Budget Office review of account set up; central Accounting review of C&G sub-accounts. 
WorkflowAlln/aDecision Engineering, Biological Sciences, Physical Sciences and Administration and Financial Services will be the “beta” sites for KFS Access and Workflow implementation. 
XBA - CGICR type2012.02.21Decision KFSI-348 
XBA - COAFund Group Code 2012.09.07Decision KFSI-700 
XBA - CGC&G Accounts - expiration date and continuation account2012.09.07Decision KFSI-736 
XBA - CAMBlank Loan Code to UCOP via EFA1002012.09.12Decision KFSI-699 
XBA - GLFS810 & FS 8152012.09.12Decision KFSI-741 
XBA - COAFund Group code, Sub-Fund Group code, ICRE Credit Default Account2012.09.12Decision KFSI-756 
XBA - GLTERM info for feeders2012.09.13Decision KFSI-753 
XBA - CGDetermine if equipment related data is needed on Award2012.09.17Decision KFSI-808 
XBA - CGDetermine if e-Verify flag can be passed from SPA to Award2012.09.17Decision KFSI-807 
XBA - COAFinalize Balance Sheet Object Code crosswalk logic for feeder systems2012.09.19Decision KFSI-827 
XBA - PURAPFinalize Purchase Order Types2012.09.19Decision KFSI-832 
XBA - PDPCreate a comprehsnsive list of ACH transactions between PAL and banks2012.09.19Decision KFSI-745 
XBA - COADefine Net Expense Object Code and Annual Closing Fund Balance Object Code2012.09.20Decision KFSI-831 
XBA - COAVerify organization code for MC2012.09.20Decision KFSI-814 
XBA - CGDetermine if ICR Credit Account can be defined by Sub-Fund Group Code (UCOP Fund Group Code)2012.09.21Decision KFSI-849 
XBA - CGKFSI-717 Resolve the the way to group C&G accounts by 'award'2012.09.21Decision KFSI-719 
XBA - FTDetermine if we need Cash Manager route node in AD and CCR2012.09.21Decision KFSI-773 
XBA - SystemAnalyze if GOE (Global Object Edit) will be needed by UCI2012.09.21Decision KFSI-751 
XBA - PURAPKFSI-816 Ensure that Med Center can manage vendor in the new KFS environment2012.09.23Decision KFSI-819 
XBA - COAFinalize and obtain approval of Medical Center chart of accounts2012.09.23Decision KFSI-744 
XBA - CAMKFSI-869 Resolve the way to post medical center depreication2012.09.23Decision KFSI-721 
XBA - CGResolve if Cost Share transaction must have the original object code2012.09.24Decision KFSI-848 
XBA - SystemEnsure that KFS has accounted for all of the UCOP required out-bound and in-bound feed files2012.09.24Decision KFSI-802 
XBA - GLKFSI-750 Review GL black box in regards to cash offsets/bank offsets2012.09.26Decision KFSI-877 
XBA - CAMEnsure that Equipment Barcode project gets processed as IT project2012.09.26Decision KFSI-747 
XBA - GLAnalyze OPAL feed to ensure that the necessary banking transactions are fed to KFS2012.09.27Decision KFSI-750 
XBA - PURAPFinalize Vendor Conversion Strategy in light of KVO and Open PO Vendor conversion2012.09.28Decision KFSI-836 
XBA - PURAPRequirement gathering for invoice amount threshold business rules2012.09.28Decision KFSI-784 
XBA - CAMKFSI-869 Determine how we are going to handle Memo Cap2012.09.28Decision KFSI-871 
XBAKFSI-781 Eliminated Org code2012.09.28Decision KFSI-839 
XBA - CAMDefine eliminated EQS orgs to be converted into CAM2012.10.01Decision KFSI-781 
XBA - PURAPDetermine if AP needs On-Demand checks for employee final check2012.10.04Decision KFSI-770 
XBA - GLInvestigate which feeder deparments might want to use IO (Internal Order) documents2012.10.04Decision KFSI-737 
XBA - CGEnsure that SPA --> Award --> Account --> CAFP mapping is complete2012.10.05Decision KFSI-800 
XBA - GLUCI Implementation of Trans Code2012.10.05Decision KFSI-720 
XBAKFSI-749 sub-fund group type expand to 2 characters2012.10.06Decision KFSI-918 
XBA - COAKFSI-930 Determine UC Account Number Scheme for brand new KFS Accounts (excluding converted accounts)2012.10.08Decision KFSI-734 
XBA - PURAPInvestigate if packing slips are required to be retained for C&G purchases2012.10.08Decision KFSI-716 
XBA - GLFinalize GL_BALANCE_T to CSF File Submission Logic2012.10.08Decision KFSI-801 
XBA - PURAPDetermine approach to resolve address change after PREQ has been approved before it is extracted to PDP2012.10.08Decision KFSI-708 
XBA - COAKFSI-930 Finalize which attributes should be on UC Fund Number vs Award Document2012.10.08Decision KFSI-799 
XBA - COAFinalize Account Number scheme2012.10.09Decision KFSI-749 
XBA - CABLibrary book capitalization2012.10.09Decision KFSI-758 
XBA - PURAPDefine PO Cost Source to determine Payment Request amount threashold2012.10.09Decision KFSI-923 
XBA - FTFinalize GEC Business Rule relating to UCOP requirements2012.10.12Decision KFSI-824 
XBA - PURAPDetermine if we are implementing Payment Plus as a payment method and how to handle it in KFS2012.10.17Decision KFSI-955 
XBA - ARDetermine if we need to automate PI Cash Advance tracking2012.10.19Decision KFSI-851 
XBA - CGKFSI-800 Research if A21 fields is required for CG year-end processing2012.10.30Decision KFSI-806 
XBA - COADefine Inception-to-Date and Fiscal Year style fund group codes2012.10.30Decision KFSI-906 
XBA - FTKFSI-825 Check with UCOP if we can combine all Financial Transactions as one type entry or we need to separate them out.2012.10.30Decision KFSI-847 
XBA - PDPDefine PDP Customer Profiles for all feeder systems2012.10.30Decision KFSI-804 
XBA - TEMDetermine the process to remove personal credit card charges off the Imported Expense table2012.11.01Decision KFSI-858 
XBA - COAFianalize how UCI is going to use HEFC2012.11.01Decision KFSI-766 
XBA - COAKFSI-930 Finalize which attributes should be on which table between UC Account and KFS Account2012.11.01Decision KFSI-798 
XBA - FTFinalize Intercampus Transfer method2012.11.01Decision KFSI-748 
XBA - PDPDefine PDP Customer Profiles for all feeder systems2012.11.02Decision KFSI-804 
XBA - CAMResolve equipment tag printing issue for Helen2012.11.02Decision KFSI-885 
XBA - FTFinalize Intercampus Transfer method2012.11.05Decision KFSI-748 
XBA - PURAPCome up with UCI Vendor policy that works with KFS vendor table (how to store address, etc)2012.11.05Decision KFSI-757 
XBA - PDPKFSI-860 AMS Integration Work Plan2012.11.06Decision KFSI-861 
XBA - COAFinalize account types2012.11.08Decision KFSI-1010 
XBA - COAVerify COA Translation Cheat Sheet2012.11.08Decision KFSI-1014 
XBA - GLDetermine if we need to calculate ICR on the encumbrances2012.11.08Decision KFSI-1002 
XBA - CAMFigure out the exact logic of depreciation to convert Med Center asset with correct starting depreciation amount2012.11.09Decision KFSI-954 
XBA - COAFinalize account types2012.11.20Decision KFSI-1010 
XBA - COAReview all UC Tables and determine which ones UCI will use2012.11.21Decision KFSI-930 
XBA - COADefine Default Account Number of the Organization Table2012.11.29Decision KFSI-1047 
XBA - GLResolve missing KFS converted accounts due to missing account/links in the data warehouse (accounts without funds)2012.11.29Decision KFSI-740 
XBAKFSI-743 Reconciliation of 10/10/12 load2012.11.30Decision KFSI-951 
XBAKFSI-743 Reconciliation of 10/11/12 load2012.11.30Decision KFSI-957 
XBA - GLAnalyze if Standard Reports are sufficient for UCI System of Reports2012.12.03Decision KFSI-778 
XBA - PDPKFSI-745 Investigate if Xerox still requires EDI EFT Advice confirmation EDI2012.12.11Decision KFSI-887