Contents

List of Figures

Title and Copyright Information

Preface

• Audience
• JD Edwards EnterpriseOne Products
• JD Edwards EnterpriseOne Application Fundamentals
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction to JD Edwards EnterpriseOne Advanced Stock Valuation

• 1.1 JD Edwards EnterpriseOne Advanced Stock Valuation Overview
• 1.2 JD Edwards EnterpriseOne Advanced Stock Valuation Integrations
• 1.3 JD Edwards EnterpriseOne Advanced Stock Valuation Implementation
  • 1.3.1 Global Implementation Steps
  • 1.3.2 Advanced Stock Valuation Implementation Steps

2 Understanding the Advanced Stock Valuation System

• 2.1 The Advanced Stock Valuation System
• 2.2 System Integration
• 2.3 System Flow
• 2.4 Business Considerations
  • 2.4.1 General Considerations
  • 2.4.2 Inventory Identification
  • 2.4.3 Cost Identification
  • 2.4.4 Stock Valuation Methods
  • 2.4.5 Dual Currency
• 2.5 Tables Used in Advanced Stock Valuation

3 Understanding Valuation Calculations

• 3.1 FIFO and LIFO Calculations
  • 3.1.1 FIFO Calculations
  • 3.1.2 LIFO Calculations
  • 3.1.3 Example: Annual LIFO Method of Stock Valuation
• 3.2 Weighted Average Cost Calculations
  • 3.2.1 Average Cost in Inventory Management
  • 3.2.2 Average Cost in Advanced Stock Valuation

4 Setting Up the Advanced Stock Valuation System

• 4.1 Understanding Setup Requirements for the Advanced Stock Valuation System
• 4.2 Understanding AAI Setup for Advanced Stock Valuation
• 4.3 Activating Advanced Stock Valuation
  • 4.3.1 Prerequisite
  • 4.3.2 Forms Used to Activate Advanced Stock Valuation
  • 4.3.3 Activating the Advanced Stock Valuation System
• 4.4 Activating Dual Currency
  • 4.4.1 Understanding Currency Requirements
  • 4.4.2 Prerequisite
  • 4.4.3 Forms Used to Activate Dual Currency
  • 4.4.4 Activating the Dual Currency Feature
• 4.5 Setting Up User-Defined Codes
  • 4.5.1 Understanding UDCs
    • 4.5.1.1 Document Types
  • 4.5.2 Form Used to Set Up UDCs
  • 4.5.3 Setting Up UDCs
• 4.6 Specifying the Stock Valuation Processing Mode
  • 4.6.1 Understanding the Stock Valuation Processing Mode
  • 4.6.2 Form Used to Specify the Stock Valuation Processing Mode
  • 4.6.3 Setting the Processing Mode
• 4.7 Defining Valuation Methods
  • 4.7.1 Understanding Valuation Methods
  • 4.7.2 Form Used to Define Valuation Methods
  • 4.7.3 Creating Valuation Method Definitions
• 4.8 Using Pools and Items
  • 4.8.1 Understanding Stock Valuation at the Item or Pool Level
    • 4.8.1.1 Setup Considerations
  • 4.8.2 Understanding Valuation Methods
  • 4.8.3 Prerequisites
  • 4.8.4 Forms Used to Use Pools and Items
  • 4.8.5 Assigning Pools
    • 4.8.5.1 Assigning Default Pools for New Items
    • 4.8.5.2 Assigning Branch/Plant Pools for Existing Items
  • 4.8.6 Assigning Valuation Methods
  • 4.8.7 Assigning Unit Cost
• 4.9 Extracting Advanced Stock Valuation Records
  • 4.9.1 Extracting Advanced Stock Valuation Records
• 4.10 Purging Advanced Stock Valuation Records
  • 4.10.1 Purging Advanced Stock Valuation Records

5 Running Advanced Stock Valuation Processing

• 5.1 Understanding Advanced Stock Valuation Processing
• 5.2 Understanding Dual Currency
  • 5.2.1 Use of Dual Currency
  • 5.2.2 Dual Currency Accounts
• 5.3 Prerequisite
• 5.4 Running the Period Build Program
  • 5.4.1 Understanding the Period Build Program
  • 5.4.2 Prerequisites
  • 5.4.3 Running the Stock Valuation Period Build Program
    • 5.4.3.1 Period Processing Mode
    • 5.4.3.2 Annual Processing Mode
  • 5.4.4 Setting Processing Options for Stock Valuation Period Build (R39120)
    • 5.4.4.1 Select
  • 5.4.5 Running the Clear and Restart Period Build Program
  • 5.4.6 Setting Processing Options for Clear and Restart Period Build (R39120)
    • 5.4.6.1 Select
• 5.5 Reviewing Valuation Results
  • 5.5.1 Understanding Valuation Information Review
  • 5.5.2 Understanding Layers
  • 5.5.3 Forms Used to Review Valuation Results
  • 5.5.4 Working with Stock Valuation
  • 5.5.5 Reviewing Item or Pool Quantities
  • 5.5.6 Reviewing Historical Layers
  • 5.5.7 Reviewing Methods
  • 5.5.8 Reviewing by Document Type
  • 5.5.9 Reviewing General Ledger Adjustments
  • 5.5.10 Setting Processing Options for Unit Cost Inquiry (P39210)
    • 5.5.10.1 Unit Cost
  • 5.5.11 Reviewing Unit Cost Inquiry
• 5.6 Updating the General Ledger
  • 5.6.1 Understanding the Stock Valuation GL Update Program
  • 5.6.2 Running the Stock Valuation GL Update Program
  • 5.6.3 Setting Processing Options for the Stock Valuation GL Update Program (R39130)
    • 5.6.3.1 Defaults
    • 5.6.3.2 Process
    • 5.6.3.3 Setup

6 JD Edwards EnterpriseOne Advanced Stock Valuation Reports

• 6.1 JD Edwards EnterpriseOne Advanced Stock Valuation Reports: A to Z
• 6.2 JD Edwards EnterpriseOne Advanced Stock Valuation: Selected Reports
  • 6.2.1 R39220 - Annual Layered Fiscal Report
  • 6.2.2 Processing Options for the Annual Layered Fiscal Report (R39220)
    • 6.2.2.1 Process
  • 6.2.3 Processing Options for the Stock Valuation Detail Report (R39400)
    • 6.2.3.1 Print Report
  • 6.2.4 Processing Options for the Stock Valuation Summary Report (R39500)
    • 6.2.4.1 Dual Currency
  • 6.2.5 Processing Options for the General Ledger Update Summary Report (R39510)
    • 6.2.5.1 G/L Update Sum
  • 6.2.6 R39540 - Unit Cost Period Report
  • 6.2.7 Processing Options for Unit Cost Period Report (R39540)
    • 6.2.7.1 Process

Glossary

Index