collaborate 2015 - flex accounting presentation

#C1

5LV

REMINDERCheck in on the

COLLABORATE mobile app

You DON’T need another Branch Plant!

Prepared by:Benjamin Gallaher and Ryan MaloneyBusiness Systems AnalystsAmway Corporation

Flex Accounting for Manufacturing using JD Edwards EnterpriseOne

Session ID#: 109430

@Amway

#C1

5LV

• Silence Audible Devices• Note Fire Exits• Partake of Refreshments• Note Quest Staffers (green shirts) and

Room Monitors• Complete Feedback Form• Ask Questions

Administrative Notes

Please:

#C1

5LV

Overview

• About Us• The Business Case• Possible Solutions• What is Flex Accounting? • Walk Through• Configuration Requirements • Challenges/Successes• Questions

3

#C1

5LV

Key Takeaways

• What Flex Accounting is

• How Flex Accounting can benefit your organization

• How to configure and implement Flex Accounting within JD Edwards EnterpriseOne

4

#C1

5LV

5

About Us

#C1

5LV

■ Michigan State University Graduate

■ Supply Chain Center of Excellence - Make

■ Michigan State University Graduate

■ Supply Chain Center of Excellence - Design

6

Benjamin GallaherBusiness Systems Analyst

Ryan MaloneyBusiness Systems Analyst

#C1

5LV

7

#C1

5LV

Supply Chain Center of Excellence for Business Process and Technology

■ Primary applications supported: ▪ JD Edwards▪ JDA Planning ▪ JDA WMS▪ JDA TMS▪ DSI▪ TradeSphere

8

■ Roles include: ▪ Global Process Owners▪ Business Systems Analysts▪ Supply Chain Analysts▪ Project Managers

#C1

5LV

9

Business Case

#C1

5LV

Business Problem

10

■ Buena Park Nutrition Facility▪ Manufacturing Variance▪ Plant Management

Staging Area

Staging AreaTableting Soft Gels

Packaging

Bulk Storage

#C1

5LV

Business Opportunity

11

■ Spaulding Nutrition Facility▪ Capacity▪ Risk Mitigation

#C1

5LV

12

Possible Solutions

#C1

5LV

Possible Solutions

13

1 2 3 4

Fire Them All!

In-Depth Analytics

Separate Branch Plants

Flex Accounting

#C1

5LV

Door #1: Fire Them All!

■ You’ve chosen to fire your financial staff and plant managers.

■ Outcomes:▪ Low Employee Morale ▪ Untrained Staff▪ New Plant Launch fails

14

#C1

5LV

Possible Solutions

15

2 3 4

Fire Them All!

In-Depth Analytics


Flex Accounting

1

#C1

5LV

Door #2: In-Depth Analytics

■ You’ve chosen to continue managing your manufacturing variances through in-depth analytics and number crunching.

■ Outcomes:▪ Waste Key Resources▪ Increase Margin of Error▪ Inefficient Operations

16

#C1

5LV

Possible Solutions

17

3 4

Fire Them All!

In-Depth Analytics


Flex Accounting

1 2

#C1

5LV

Door #3: Separate Branch Plants

■ You’ve chosen to continue managing your manufacturing variances by creating separate branch plants for each work area.

■ Outcomes:▪ Variances by work area▪ Transactional Nightmare▪ System Limitations▪ Tail wagging the dog

18

#C1

5LV

Possible Solutions

19

4

Fire Them All!

In-Depth Analytics


Flex Accounting

1 2 3

#C1

5LV

Door #4: Flex Accounting

■ You’ve chosen to manage your manufacturing variances by implementing flex accounting.

■ Outcomes: ▪ Variance can be tracked by

work area▪ Low Maintenance▪ Future Re-Application

20

#C1

5LV

21

What is Flex Accounting?

#C1

5LV

Manufacturing Flex Accounting

■ Flex Accounting allows you to flex the Business Unit and Subsidiary sections of the general ledger account structure when performing various accounting transactions.

■ Available in the following applications of EnterpriseOne:▪ Manufacturing▪ Cost Accounting▪ Distribution ▪ Financial

■ Located in System 16 Advanced Cost Accounting

22

#C1

5LV

23

Tables/Files That Support Flex Accounting■ F4101 – Item Master■ F4102 – Item Branch■ F4801 – Work Order Master■ F0006 – Business Unit Master■ F3102 – Production Cost Variance■ F3111 – Work Order Part List■ F3112 – Work Order Routing■ FF31112 – Lean Trans Routing■ FF31111 – Lean Trans Part List■ FF31011 – Lean Trans Master■ FF31200 – Lean Trans Production Costs

#C1

5LV

24

Walk Through

#C1

5LV

25

High Level Process

Flex Accounting Process

Man

ufac

turin

g In

dust

rial

Engi

neer

ing

Fina

nce

Buena Park & Spaulding

Add RoutingSKU Setup Populate Flex Field (URAB)

Process Work Order Enter Actual Completions

MRP

Cre

ates

Man

ufac

turin

g De

man

d

Enter Actual Labor Expense

Run Manufacturing Accounting Journal

Entries Program

Run Manufacturing Accounting Variance

ProgramVariance Rollup

#C1

5LV

Industrial Engineering

■ Functional Requirements:▪ Item Setup Workflow▪ Item to Work Area

Relationship

26

■ Technical Requirements: ▪ User Reserved Number –

Address Book (URAB)▪ Item Master Workflow

Validation


#C1

5LV

27

Populate Flex Field (URAB)

#C1

5LV

28

High Level Process


Man

ufac

turin

g In

dust

rial

Engi

neer

ing

Fina

nce




MRP

Cre

ates

Man

ufac

turin

g De

man

d



Entries Program



#C1

5LV

Manufacturing

■ Functional Requirements:▪ Work Order Reconcile▪ Enter Actual Labor Expense▪ Enter Actual Material

Completions

29

■ Technical Requirements: ▪ None



#C1

5LV

30


#C1

5LV

31

Enter Actual Quantity Completed

#C1

5LV

32

High Level Process


Man

ufac

turin

g In

dust

rial

Engi

neer

ing

Fina

nce




MRP

Cre

ates

Man

ufac

turin

g De

man

d



Entries Program



#C1

5LV

Finance

■ Functional Requirements:▪ Create Subsidiary G/L

Accounts▪ Report Monthly Variances▪ Calculate Annual Standards

33

■ Technical Requirements: ▪ Versions▪ Processing Options▪ Data Selection


Entries Program



#C1

5LV

34

R31802A – Manufacturing Accounting Journal Entries

#C1

5LV

35

R31802A – Manufacturing Accounting Journal Entries

Doc Type GL Acct. Acct Desc. Debit CreditIH Spaulding WIP Labor Charged to WO 1,932.00IH Soft Gels Absorption Labor Charged to WO -1,932.00

#C1

5LV

36

R31804 – Variance Journal Entries

#C1

5LV

37

R31804 – Variance Journal Entries

Doc Type GL Acct. Acct Desc. Debit CreditIV Soft Gels Actual Variance Calculated for WO 8,219.28IV Soft Gels Eng. Variance Calculated for WO 278.35IV Spaulding WIP Variance Calculated for WO 8,497.63

#C1

5LV

38

Configuration Requirements

#C1

5LV

39

System Requirements – “Switches”

■ Enable Functionality by Application (P16902) ■ Cost Object Rules Setup Method (P1691)■ Flex Definition Rules (P40296)

#C1

5LV

40

Challenges / Successes

#C1

5LV

41

Challenges

■ Flex Accounting Documentation■ Finding a Flex Field■ Customized Security Access■ Customized Menu Structure■ Data Quality

Successes■ Future Re-Application■ No Disruption to Manufacturing■ No Dedicated Support Needed■ Retrofitting

#C1

5LV

42

Questions

#C1

5LV

Please complete the session evaluationWe appreciate your feedback and insight

You may complete the session evaluation either on paper or online via the mobile app

#C1

5LV

44

Visit Seth & Dana at the Quest International Users Group Booth #337

■ Let us show you how to leverage the Quest community to maximize your ERP investment

■ Receive your personalized Quest Activation Plan & learn how to make the most of your membership

■ Plus, find out how you can join us in celebrating our 20th year of success – you might just win a special Quest-themed bottle of Kentucky bourbon!

Quest is the home for PeopleSoft and JD Edwards Users

collaborate 2015 - flex accounting presentation

Documents