Blue Ribbon Account Management ERP Nomenclature Financial Advisory Subcommittee Task Force
Issues/Recommendations needed:
- Object codes
- Currently 30 characters/GL account in SAP 20 – issues?
- HFS uses system that alter names for reporting
i. HFS will need to review current available object codes for use, prepare object forms to establish new object codes or modify names to maintain continuity.
UPDATE: Email sent to business offices and others regarding changes. HFS had several requests and depending on relationships with other departments, changes will be made.
Discuss Solutions
- Fund/Account title
- Any issues with fund titles?
- In SAP, account title is 20 characters. In FIAA, it is 40
- Need RFP to modify title for upload possibility
- Send spreadsheet to departments requesting modification to 20 characters (non-SPS accounts). Accounts not altered will be truncated.
- A modification was made to add a 255 character user field to cost centers in SAP. Long title in FMIS can now be converted.
UPDATE – RFS completed and ITaP has tested. Information Email has gone out to departments with the final spreadsheet for departments to go out the week of May 27 for conversions by the end of June.
Discuss Solutions
- DREF reporting
- Currently, departments budget and heavily utilize DREF’s (Continuing Education, Advancement, Ag)
- What is necessary now to prepare for implementation? (New accounts, etc)
STATUS –Due to legal reasons, Ag will be allowed to convert current DREF. Other areas will use Statistical Internal Orders in SAP.
Discuss Solutions
- Small balances
- 671 accounts - <$1,000? – $200?
- Gifts? Non 7xx funds?
- Report with account title conversion to business managers.
STATUS – Business as usual.
Discuss Solutions
- Inactive accounts
- Identify GL accounts not used in the prior two years?
- What accounts will be converted in SAP?
- Do we need to bother with these?
STATUS – Inactive accounts will be auto purged. If there are accounts to be kept active, email Ken Wilson those numbers.
Discuss Solutions
- Year-end accounts
- 19x funds/other FMIS year-end accounts
- 6/33 balance forwards/reversals at first update.
- Posting of transactions
STATUS – Met with SPS regarding A133 issues. We will need a year-end crosswalk table for FY2006 reversals.
Discuss Solutions
- September 30 cut-off issues
- Documents
- Becky White – SPS – Federal/AG year ends and document processing
- 9/15 for all FMIS documents to accounting
- Use September balances to load
- Suspense items?
PLAN – run 9/30 month end and bring balances into SAP week of 10/2/2006. Essential (cash documents, APC’s, PDC’s) to continue to post until month end. More information regarding process will be forthcoming.
Discuss Solutions
-
Bursar BRTP Account crosswalk
- New accounts after Finance go-live
- FMIS account numbers on-going maintenance
Discuss Solutions
- Field for CMIP tracking
Discuss Solutions
- Year-end FR entries that create cash
STATUS – Accounting Services needs to ID accounts and do 6/34 entries to clear.
Discuss Solutions
- TIF accounts
STATUS – Email has gone out to certain departments to begin spending dollars or CMIP will be cutoff.
Discuss Solutions
- Fringe benefit distribution
STATUS – SAP will mimic today’s rules.
Discuss Solutions
- Other?
Provide Discussion Topics