Subledger Accounting for Discrete & EAM Cost Accounting

147 Pages·2013·5.66 MB·English

by  Douglas Volz

Subledger Accounting for Discrete & EAM Cost Accounting:
Product Line and Expense Accounting Made Easy Through SLA
April 10, 2013
Session 11387
Douglas A. Volz
Douglas Volz Consulting
[email protected]
www.volzconsulting.com
Helping people using Oracle Applications since 1990
Copyright ©2013 Douglas Volz Consulting, Inc.
Doug Volz
Helping people use Oracle since 1990 for Cost Accounting & related Financials, MFG and EAM modules
(cid:135) Professional Summary
(cid:131) 30+ years of industry, design and consulting experience, specializing in design,
implementation and project delivery for Cost Management business solutions
(cid:131) Specific areas of expertise:
• Profit in inventory • Multi-org inventory reporting
• Intercompany • Inventory reconciliation
• A/P accruals • Product Line & Margin analysis
• WIP analysis • Cost Rollup and Update
(cid:131) Presenter at Collaborate (OAUG) and UKOUG since 1996
(cid:131) Multi-national experience in twelve countries
[phone]
(cid:135) Qualification Summary [email protected]
www.volzconsulting.com
(cid:131) Former co-designer for Oracle Cost Management
(cid:131) Lead the OAUG Cost Management Special Interest Group
(cid:131) Prior Accounting and Cost Management industry experience
Helping people using Oracle Applications since 1990 Slide 2
Copyright ©2013 Douglas Volz Consulting, Inc.
Douglas Volz Consulting, Inc.
(cid:135) Douglas Volz Consulting started in 2005 to provide:
• Cost Accounting Business Solutions
• Cost Accounting System Designs
• Procure to Pay Business Improvements
• Project Management and Advisory Services
• Cost Reporting Solutions
Sample Project Experience:
Helping people using Oracle Applications since 1990 Slide 3
Copyright ©2013 Douglas Volz Consulting, Inc.
Learning Points
(cid:135) Review the business requirements for discrete product line
accounting and expense accounting
(cid:135) Understand how EAM requirements are similar to discrete expense
accounting
(cid:135) Understand basic concepts for Subledger Accounting (SLA)
(cid:135) Learn how to use SLA for product line accounting for inventory,
COGS and variance accounting
(cid:135) Learn how to use SLA for EAM and Cost Management
Helping people using Oracle Applications since 1990 Slide 4
Copyright ©2013 Douglas Volz Consulting, Inc.
Agenda
(cid:135) Overview for business requirements for product line accounting,
EAM and expense accounting
(cid:135) Which SLA approach is best? Mapping sets? Standard sources,
custom sources for expenses, inventory and variances? Use of
Category Accounts?
(cid:135) Primer for using Subledger Accounting
(cid:135) SLA solution for product line accounting
(cid:135) SLA solutions for EAM & expense accounting
(cid:135) Appendix
Helping people using Oracle Applications since 1990 Slide 5
Copyright ©2013 Douglas Volz Consulting, Inc.
Business Requirements Overview
Product Line Accounting
Helping people using Oracle Applications since 1990 Slide 6
Copyright ©2013 Douglas Volz Consulting, Inc.
Product Line Accounting (or PLA)
(cid:135) Suppose you make and sell different types of products
(cid:135) With subinventory & WIP you can account for inventory location or type
Production Distribution Sales
Raw Mat’ls California
s y
r r
e Semi-Finished o Colorado U.S.
i t
l n
p
e
p WIP/VMI/etc. v New Jersey
u
n
S
I
Finished Gds Ireland Europe
Helping people using Oracle Applications since 1990 Slide 7
Copyright ©2013 Douglas Volz Consulting, Inc.
Asset Subinventories
Menu path: Cost Management => Setup => Account Assignments => Subinventories
(cid:135) With subinventories you can account for location or type or product
Helping people using Oracle Applications since 1990 Slide 8
Copyright ©2013 Douglas Volz Consulting, Inc.
Asset WIP Classes
Menu path: Cost Management => Setup => Account Assignments => WIP Accounting Classes
(cid:135) With WIP you can account for location or type or product – but not all three
Helping people using Oracle Applications since 1990 Slide 9
Copyright ©2013 Douglas Volz Consulting, Inc.
But What About?
(cid:135) Profit and Loss Statements by Product Line with Location and Type?
(cid:135) Inventory Value by Product Line with Location and Type?
Printers Desktop PCs Laptops
Sales Sales Sales
g g g
n n n
i t COGS i t COGS i t COGS
t i t i t i
a f a f a f
o o o
r r r
r r r
e P Gross Margin e P Gross Margin e P Gross Margin
p p p
O O O
Op Expenses Op Expenses Op Expenses
Helping people using Oracle Applications since 1990 Slide 10
Copyright ©2013 Douglas Volz Consulting, Inc.