My Oracle Support Banner

WS: 30/31: Manufacturing Costing & Accounting DMAAIs, Journal Entries & Next Numbers (Doc ID 1542725.1)

Last updated on JULY 21, 2020

Applies to:

JD Edwards World Shop Floor Management - Version A7.3 cume 4 and later
JD Edwards World Product Data Management - Version A7.3 cume 4 and later
Information in this document applies to any platform.

Purpose

Manufacturing DMAAIs Overview

Manufacturing Accounting Instructions, (DMAAIs) must be defined for every manufacturing transaction that generates a journal entry. DMAAIs are tables that link the manufacturing accounting to the Chart of Accounts.  The fast path command is DMAAI which stands for Distribution and Manufacturing Automatic Accounting Instructions. DMAAIs are also available by navigating to the Shop Floor Control Setup menu (G3141) under the OTHER SYSTEM SETUP section, select Automatic Acctg Instructions. The Automatic Accounting Instruction (AAI) Values File (F4095) contains account numbers that are entered in the DMAAI tables and are used to create journal entries and charge amounts to those accounts. JD Edwards World defines manufacturing DMAAIs at the 3000 level, for example :

3110    Raw Material and Sub-Assemblies, used by Work Order WIP & Completion Accounting programs like P31802 and  Orderless Manufacturing Accounting P31862.

3120    Work In Process, used in WO WIP & Completion Accounting, Orderless Manufacturing Accounting, Actual Costing and Standard Cost WO Variances Accounting P31804.

There are DMAAIs defined in the distribution system, level 41, that are also used by the Manufacturing Costing programs (P30835-Frozen Cost Update & P30837 -WIP Revaluation) such as: 4134 - Inventory and 4136-Expense or Cost of Goods Sold.

In this document, you will find a detailed description of the relationship between manufacturing programs and DMAAIs.

Scope

Manufacturing and/or Cost Accountants and users responsible for the Manufacturing Cost maintenance as well as Shop Floor work order accounting can benefit from this document. Requires knowledge on the Inventory Management, Product Data Management and Shop Floor modules.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
 Manufacturing DMAAIs Overview
Scope
Details
 
 Manufacturing DMAAI Keys
 Key 1: Order Type
 Key 2: Company Number
 Key 3: Document Type
 Key 4: General Ledger Class Code (GLPT)
 Key 5: Cost Type
 G/L Account Numbers
 Hierarchy
 1: Business Unit
 2: Object Account 
 3: Subsidiary Account 
 Product Costing DMAAIs & Journal Entries
 Manufacturing Accounting DMAAIs
 1) Standard Costing 
 WO Manufacturing Journal Entries (P31802)
 WO Variance Accounting (P31804)
 Orderless Manufacturing Accounting (P31862)
 2) Actual Costing
 Close Actual Cost Work Orders (P31806)
 Journal Entries
 Miscellaneous Notes 1:
 Next Numbers
 Miscellaneous Notes 2:
 Illustration for a Discrete WO and Next Numbers for A73.12 and above cross referencing Item Ledger (F4111), W.O. Cross Reference File (F3106) and Account Ledger (F0911) files:
 Chart for A73.11 and below before Next Numbers were implemented: 
 Flexible Accounting in Manufacturing

References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.