Version 1.0
Internal Orders
FI-CO-002 August 19, 2008
Internal Orders Internal Orders
FI FI-
- CO
CO-
- 002
002 August 19, 2008 August 19, 2008
LaGOV LaGOV Version 1.0 Agenda Logistics, Ground Rules & - - PowerPoint PPT Presentation
Internal Orders Internal Orders Internal Orders FI- -CO CO- -002 002 FI FI-CO-002 August 19, 2008 August 19, 2008 August 19, 2008 LaGOV LaGOV Version 1.0 Agenda Logistics, Ground Rules & Introduction Project Timeline
Version 1.0
Internal Orders
FI-CO-002 August 19, 2008
Internal Orders Internal Orders
FI FI-
CO-
002 August 19, 2008 August 19, 2008
2
Agenda
– Process overview – AS-IS process flow – Current system alignment – Process improvement opportunities – SAP terms glossary – SAP concepts & functionality – Business process flow – Leading practices – Enterprise readiness challenges
3
Before we get started ... Logistics
4
Ground Rules
spectator sport
close laptops
5
Introduction
facilitate the discussions and drive design decisions
meeting minutes to be sent by the Process Analyst to all participants for review and feedback
discussions, address key integration touch points
detailed business process and participate in the decisions required to design the future state business process
Round the Room Introductions Name Position Agency
6
Project Phases
Five Key Phases
Project Preparation Business Blueprint Realization Go Live and Support Final Preparation
7
Functionality Tentative Implementation Date Budget Prep October 2009 DOTD February 2010 Core Modules All Agencies July 2010 Additional Modules January 2011
Tentative Project Timeline
Project Start-Up
May – June 2008 July 2008 August – Dec 2008 January 2009
Blueprint
Phased deployment will be confirmed/updated before completion
8
Finance Leads Beverly Hodges – Finance Lead Drew Thigpen – Finance Lead Mary Ramsrud – Consulting Lead Logistics Leads Belinda Rogers – Logistics Lead Jack Ladhur – Logistics Lead Brad Denham – Consulting Lead Linear Assets Leads Mark Suarez – Agile Assets Lead Charles Pilson – Consulting Lead General Ledger Accts Receivable Cost Accounting Grants Mgt Asset Accounting Real Estate Management
Linn McNary Patrick Johnson Abdulla Meer
Accounts Payable Cash Management Funds Management Project Systems Budget Prep
Project Organization - Functional Teams
Grantor
9
Blueprint Objectives
Business requirements
integration points with other processes
conversion, enhancement, or workflow (FRICE-W)
Readiness challenges
requirements
10
Controlling Workshops
Session ID Date Business Process Goals FI-CO-001 08/05/08 Cost Centers
FI-CO-002 08/19/08 Account Code Structure – Internal Orders
FI-CO-003 08/26/08 Time Entry Postings
FI-CO-004 09/17/08 – 09/18/08 Inter-Agency Transfers
FI-CO-005 09/30/08- 10/02/08 Periodic Processing/ Cost Allocations
FI-CO-006 10/16/08 Management Reporting
FI-CO-Validation 11/17/08- 11/18/08 CO Validation
11
Work Session Objectives Session Topics:
Controlling (CO)
map to SAP Internal Orders?
Maintenance
12
SAP Glossary
allocate costs collected in an Internal Order to one or more Cost
is an organizational unit within a controlling area that represents a revenue and cost collector for more permanent activities or areas of
Element is a Master Data
and record costs. CO.
the actual costs of discrete, short- term tasks. Costs collected in Internal Orders can be allocated to one or more Cost Centers. CO.
13
Financial Accounting
Receivable
14
Funds Management
Reporting
Accounting
15
(CCA)
(G/L Accounts P&L)
and distributions Controlling
Financial Accounting Codes Cost Accounting Codes Budgetary Control Codes
Mid-Level Accountability High-Level Reporting Detailed Visibility
11/12/2008 Page 16
SAP Integration
FI FM CO
17
that represents a revenue and cost collector for more permanent activities or areas of responsibility.
a functional area, a fund, and a fund center allowing all these codes to be automatically defaulted when a user enters a cost center in a document.
area and is used by drill-down reports. Each level or node of the standard hierarchy is a cost center group. In addition Cost Centers may optionally belong to additional alternative hierarchies that can also be used by drill-down reports.
Controlling (CO) Master Data Cost Center
18
Cost Centers: State of Louisiana Proposed Numbering Convention W-I-P
(1) (2) (3) (4) (5) (6) (7) (8) (9) (10)
(1) – (3) Business Area = Agency (4) – (5) Program (6) – (7) AFS Division
DOTD District
(8) – (10) AFS Section
(8) – (10) DOTD (see note)
Note: Last 3 digits of the cost center number is still being finalized for DOTD.
19
Example: Dept of Justice, Office of Attorney General
Office Of Attorney General Agency (141) Administrative Program (1000) Civil Program (2000)
Division (1) Civil Division (1) Public Protection Division (2) Finance Section (1)
Section (1) Tobacco Section (1) Property/Rec/Fleet Section (2) Budget & Accountability Section (3) Public Finance & Contract Section (2) Equal Opportunity Section (2)
Agency Program Division Section Administrative Services Program
1410101001 Finance 141 01 01 001 1410102002 Property/Rec/Fleet 141 01 02 002 1410103003 Budget & Acct. 141 01 03 003 Civil Program Civil Division 1410201001 Gov. Litigation 141 02 01 001 1410201002 Public Fin. & Contract 141 02 01 002 Public Protection Division 1410201001 Tobacco 141 02 01 001 1410201002 Equal Opportunity 141 02 01 002
Organizational Structure Cost Center Number
20
Controlling (CO) Financial Accounting (FI) Funds Management (FM)
Cost Center Funds Center Business Area
Finance Integration
21
Group” for reporting.
Controlling (CO) Master Data Cost Elements
22
They are linked to P&L type GL accounts on a one-for-one basis and have the same number and description. Primary cost elements will be set up for all P&L GL accounts.
Elements in CO
Examples:
– Assets: 100000-199999 – Liabilities: 200000-299999 – Fund Balance: 300000-399999 – Expenses: 500000-599999
Controlling (CO) Master Data Primary Cost Elements
23
a Controlling Area, such as overhead. These Cost Elements are not directly linked to a nominal GL account.
Examples: – Secondary Costs: 900000-999999
Controlling (CO) Master Data Secondary Cost Elements
24
in CO.
Example: – Revenues: 400000-499999
Controlling (CO) Master Data Revenue Elements
25
Controlling (CO) Financial Accounting (FI) Funds Management (FM)
Cost Center Funds Center Business Area
Finance Integration
Cost Element Commitment Item G/L Account
26
costs of discrete, short-term tasks. Costs collected in Internal Orders can be allocated to one or more Cost Centers.
nature that are not handled by SAP’s Project System (SAP-PS) module are set up as Internal Orders.
Katrina, Rita, National Fisheries Conference
Controlling (CO) Master Data Internal Order
27
area allowing them to be automatically defaulted when a user enters an Internal Order in a document.
Group”.
Controlling (CO) Master Data Internal Order (contd.)
28
such as: one or more Cost Centers.
State Resources. Funding situation for Katrina is available but it not clearly defined by Cost Center. State Administrators decide to mobilize resources.
“Internal Order Katrina”.
where funding is available.
Controlling (CO) Master Data True Orders
29
must also be posted to a real CO object . Used by individual agencies/departments to meet their reporting and evaluation needs.
including a “Special Project” XYZ. Funding for all activities comes from Cost Center ABC’s budget. Director of the Cost Center wants to track and report on revenues and expenses incurred towards the Special Project XYZ.
and Secondary Internal Order “XYZ” simultaneously. For all other postings, only Cost Center ABC is charged.
Management Reports clearly identify all revenues and expenses associated with Special Project “XYZ”. No further settlement of cost expenses occurs.
Controlling (CO) Master Data Statistical Orders
30
Controlling (CO) Financial Accounting (FI) Funds Management (FM)
Cost Center Funds Center Business Area
Finance Integration
Cost Element Commitment Item G/L Account Internal Order FM Object
As Is – Internal Orders
replacement by Internal Orders (other SAP object will be used as well): – Sub-Object & Sub-Revenue Source – Reporting Category – Activity
Object Usage Technical Sub-Object & Sub- Revenue Source
Length: 2 Format: Alphanumeric
Reporting Category
Length: 4 Format: Alphanumeric
Activity Code
Length: 4 Format: Alphanumeric
Sample Usage – Sub-Object
DEPT OF WILDLIFE AND FISHERIES:
For DWF, these Sub-Objects apply to all Objects
WB WH TD TC SF OW OR OJ NF LC LR LA LD IS GC ED BS BC AC
SubObject Code
White Boot Brigade Washington Hill Tourism Day Tales of the Cocktails Seafood Festival Oyster Week Oyster Reception Oyster Jubilee National Fisheries Conference (NFI) Louisiana Seafood Cookoff Louisiana Restaurant Expo Louisiana Alive Legislative Day International Shellfish Sanitation Conference Great American Seafood Cookoff Education Day Boston Seafood Show Bonne Crevette Alligator Cookoff
Event
WB WH TD TC SF OW OR OJ NF LC LR LA LD IS GC ED BS BC AC
SubObject Code
White Boot Brigade Washington Hill Tourism Day Tales of the Cocktails Seafood Festival Oyster Week Oyster Reception Oyster Jubilee National Fisheries Conference (NFI) Louisiana Seafood Cookoff Louisiana Restaurant Expo Louisiana Alive Legislative Day International Shellfish Sanitation Conference Great American Seafood Cookoff Education Day Boston Seafood Show Bonne Crevette Alligator Cookoff
Event
Sample Usage – Sub-Revenue Source
DEPT OF WILDLIFE AND FISHERIES:
For DWF, Sub-Revenue Sources can be unique to a given Revenue Source
ATTORNEY GENERAL’S OFFICE: Sample Usage – Reporting Category
– Object 3650 Other Charges, use Reporting Category 7136 for “Court Filing Fees”
– There are 15 agreements and 1 object and 1 org – Use reporting category to define which agreement – Ex., 0017 – SG – Office of Risk Management
Division of Administration: Sample Usage – Sub Revenue Source
HOUSING AUTHORITY - BERWICK SG BV H05 HOUSING AUTHORITY - BOGALUSA SG BU H04 HOUSING AUTHORITY - ALEXANDRIA SG BT H03 HOUSING AUTHORITY - COLFAX SG BS H02 HOUSING AUTHORITY - ABBEVILLE SG BR H01 BOARD OF EXAMINERS - SANITARIANS SG BP B53 BOARD OF EXAMINERS - CHIROPRACTORS- DHH SG BO B06 BOARD OF HEARING AID DEALERS SG BN B33 BOARD OF EXAMINERS - WHOLESALE DISTRIBUTORS SG BM B36 HOUSING AUTHORITY - HAYNESVILLE SG BL H86 BOARD OF VETERINARY MEDICINE SG BK B34 BOARD OF BARBER EXAMINATION SG BJ B46 BOARD OF PLUMBERS SG BI B16 COMMISSION - TAX FREE SHOPPING SG BH A40 HOMELAND SECURITY & EMERGENCY PREPAREDNESS IAT 8D 111 DIVISION OF ADMINISTRATION - STATE REGISTER IAT FH 107 DIVISION OF ADMINISTRATION IAT 02 107 MENTAL HEALTH ADVOCACY IAT 01 103 INDIAN AFFAIRS IAT 6B 101 EXECUTIVE OFFICE IAT 6A 100 AGENCY NAME TYPE SUB REV AGCY HOUSING AUTHORITY - BERWICK SG BV H05 HOUSING AUTHORITY - BOGALUSA SG BU H04 HOUSING AUTHORITY - ALEXANDRIA SG BT H03 HOUSING AUTHORITY - COLFAX SG BS H02 HOUSING AUTHORITY - ABBEVILLE SG BR H01 BOARD OF EXAMINERS - SANITARIANS SG BP B53 BOARD OF EXAMINERS - CHIROPRACTORS- DHH SG BO B06 BOARD OF HEARING AID DEALERS SG BN B33 BOARD OF EXAMINERS - WHOLESALE DISTRIBUTORS SG BM B36 HOUSING AUTHORITY - HAYNESVILLE SG BL H86 BOARD OF VETERINARY MEDICINE SG BK B34 BOARD OF BARBER EXAMINATION SG BJ B46 BOARD OF PLUMBERS SG BI B16 COMMISSION - TAX FREE SHOPPING SG BH A40 HOMELAND SECURITY & EMERGENCY PREPAREDNESS IAT 8D 111 DIVISION OF ADMINISTRATION - STATE REGISTER IAT FH 107 DIVISION OF ADMINISTRATION IAT 02 107 MENTAL HEALTH ADVOCACY IAT 01 103 INDIAN AFFAIRS IAT 6B 101 EXECUTIVE OFFICE IAT 6A 100 AGENCY NAME TYPE SUB REV AGCY HOUSING AUTHORITY - BERWICK SG BV H05 HOUSING AUTHORITY - BOGALUSA SG BU H04 HOUSING AUTHORITY - ALEXANDRIA SG BT H03 HOUSING AUTHORITY - COLFAX SG BS H02 HOUSING AUTHORITY - ABBEVILLE SG BR H01 BOARD OF EXAMINERS - SANITARIANS SG BP B53 BOARD OF EXAMINERS - CHIROPRACTORS- DHH SG BO B06 BOARD OF HEARING AID DEALERS SG BN B33 BOARD OF EXAMINERS - WHOLESALE DISTRIBUTORS SG BM B36 HOUSING AUTHORITY - HAYNESVILLE SG BL H86 BOARD OF VETERINARY MEDICINE SG BK B34 BOARD OF BARBER EXAMINATION SG BJ B46 BOARD OF PLUMBERS SG BI B16 COMMISSION - TAX FREE SHOPPING SG BH A40 HOMELAND SECURITY & EMERGENCY PREPAREDNESS IAT 8D 111 DIVISION OF ADMINISTRATION - STATE REGISTER IAT FH 107 DIVISION OF ADMINISTRATION IAT 02 107 MENTAL HEALTH ADVOCACY IAT 01 103 INDIAN AFFAIRS IAT 6B 101 EXECUTIVE OFFICE IAT 6A 100 AGENCY NAME TYPE SUB REV AGCY HOUSING AUTHORITY - BERWICK SG BV H05 HOUSING AUTHORITY - BOGALUSA SG BU H04 HOUSING AUTHORITY - ALEXANDRIA SG BT H03 HOUSING AUTHORITY - COLFAX SG BS H02 HOUSING AUTHORITY - ABBEVILLE SG BR H01 BOARD OF EXAMINERS - SANITARIANS SG BP B53 BOARD OF EXAMINERS - CHIROPRACTORS- DHH SG BO B06 BOARD OF HEARING AID DEALERS SG BN B33 BOARD OF EXAMINERS - WHOLESALE DISTRIBUTORS SG BM B36 HOUSING AUTHORITY - HAYNESVILLE SG BL H86 BOARD OF VETERINARY MEDICINE SG BK B34 BOARD OF BARBER EXAMINATION SG BJ B46 BOARD OF PLUMBERS SG BI B16 COMMISSION - TAX FREE SHOPPING SG BH A40 HOMELAND SECURITY & EMERGENCY PREPAREDNESS IAT 8D 111 DIVISION OF ADMINISTRATION - STATE REGISTER IAT FH 107 DIVISION OF ADMINISTRATION IAT 02 107 MENTAL HEALTH ADVOCACY IAT 01 103 INDIAN AFFAIRS IAT 6B 101 EXECUTIVE OFFICE IAT 6A 100 AGENCY NAME TYPE SUB REV AGCY
IAT = Inter-Agency Transfer SG = Self Generated Sub-Revenue Sources don’t change across Revenue Sources
Division of Administration: Sample Usage – Reporting Category
– Ex.
CDBG FFY '08 TECHNICAL ASSIST 08TA CDBG FFY '08 PROGRAM INCOME 08PI CDBG FFY '08 PUBLIC FACILITIES 08PF CDBG FFY '08 LASTEP 08LS CDBG FFY '08 HOUSING 08HS CDBG FFY '08 ECONOMIC DEVELOP 08ED CDBG FFY '08 DEMONST NEEDS 08DN CDBG FFY '08 COMMUNITY CENTERS 08CC CDBG FFY '08 ADMIN COST 08AD Description Reporting Category CDBG FFY '08 TECHNICAL ASSIST 08TA CDBG FFY '08 PROGRAM INCOME 08PI CDBG FFY '08 PUBLIC FACILITIES 08PF CDBG FFY '08 LASTEP 08LS CDBG FFY '08 HOUSING 08HS CDBG FFY '08 ECONOMIC DEVELOP 08ED CDBG FFY '08 DEMONST NEEDS 08DN CDBG FFY '08 COMMUNITY CENTERS 08CC CDBG FFY '08 ADMIN COST 08AD Description Reporting Category
Division of Administration: Sample Usage – Reporting Category (cont’d)
projects
– Ex.
OIS- PC/LAN SOFTWARE BL75 OIS- PC/LAN HARDWARE-EXCL PRNT BL71 OIS-TCP/IP APPLICATIONS SUPPT BL70 OTM / BILLING AN07 PAYROLL EXPENDITURE CLEARING 8888 ARSENAL 1374 WOODDALE TOWER 1373 Description Reporting Category OIS- PC/LAN SOFTWARE BL75 OIS- PC/LAN HARDWARE-EXCL PRNT BL71 OIS-TCP/IP APPLICATIONS SUPPT BL70 OTM / BILLING AN07 PAYROLL EXPENDITURE CLEARING 8888 ARSENAL 1374 WOODDALE TOWER 1373 Description Reporting Category
38
As Is – Additional Information
Leading Practices
reporting requirements
facilitate reporting
numbering scheme and derivation strategy are properly maintained
various reporting requirements of an organization
as allow for future growth
Process Improvement Opportunities
Cost & Revenue Object codes and other Master Data – across the State…..
need for their internal reporting.
needed for the agencies.
needs of the State.
41
Example:
Internal Order Types (W-I-P)
Classification used to identify Internal Orders for different purposes Q: What are the Internal Order Types that make sense for LaGov?
42
SAP Numbering Considerations
(1) (2) (3) (4) (5) (6) (7) (8)
Internal Orders? And Internal Order Types?
43
Internal Orders: State of Louisiana Proposed Numbering Convention W-I-P
(1) (2) (3) (4) (5) (6) (7) (8) (1)– (2) IO Type (3)– (8) Internal Order Number
Z10 – True Internal Orders
– 10: True Internal Order
contain Agency and the relevant Legacy account code. May also have the FM Object needed to control the Budget (i.e. Funded Program) on the master record. “Cost Center” field may be “Optional”(TBD).
The
10000000 to 109999999
Number Range:
Z20 – Statistical Internal Orders
– 20: Statistical Internal Order
contain Legacy account code and Cost Center respectively (TBD).
20000000 to 209999999
Number Range:
Business Process Flow (W-I-P)
State of Louisiana Process: Create New Internal Orders
OPB Department/Agency OSRAP
New requirement identified for new Internal Order Start Complete Master Data Request Form Email completed form to Internal Order Creation mailbox Email request received Is request valid? Is new Internal Order necessary? Decline request and notify requestor Code entries to existing Internal Order NO YES Create Internal Order in SAP Notify Budget for Funds Management Object creation Create Funds Management Object in FM Update FM and GM Derivation Strategies Code entries to new Internal Order Post entries to Cost Center End Post budget for new FM Object Is budget control necessary for this Internal Order? Yes No47
Business Process Flow (W-I-P)
OPB OSRAP Department/ Agency
48
Numbering and proper usage.
elements and identifying valid Internal Orders and Order Types.
Process.
maintenance process.
Enterprise Readiness Challenges
49
ensure all to-do’s are appropriately documented.
interest by Agency/Department as needed.
Next Steps
Questions?
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
51
Thank You for Your Participation!