# JD Edwards AAI and DMAAI Setup Reference: F0012 and F4095 > Source: https://netray.co/tools/jde-aai-dmaai-f0012-f4095-reference > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer The financial AAIs (F0012) and distribution/manufacturing AAIs (F4095) that cause most posting questions in JDE 9.2, with the program that uses each and a typical setup mistake. ## Category oracle ## Erp JD Edwards EnterpriseOne ## Audience - JDE financial consultant - Distribution consultant - Controller - JDE developer ## Tool **Kind:** worksheet **Mode:** reference **Columns:** #### Table **Key:** table **Type:** text #### AAI item / number **Key:** item **Type:** text #### Description **Key:** description **Type:** text #### Used by **Key:** program **Type:** text #### Typical debit/credit **Key:** drcr **Type:** text #### Common setup mistake **Key:** mistake **Type:** text **Rows:** **Table:** F0012 **Item:** PB / PByyyy **Description:** Payables bank (default bank account for payments) **Program:** Voucher entry (P0411), payment processing **Drcr:** Credit bank on payment **Mistake:** Using PByyyy offsets without defining matching PCyyyy items, which the guide requires. **Table:** F0012 **Item:** PC / PCyyyy **Description:** Payables trade (A/P trade, by G/L offset yyyy) **Program:** Voucher post (R09801), payment post **Drcr:** Credit at voucher post, debit at payment **Mistake:** G/L offset on the supplier (F0401) with no PCyyyy for company 00000 or the company: post fails with a missing AAI. **Table:** F0012 **Item:** PKD **Description:** Payables discount available **Program:** Payment post **Drcr:** Credit discount available **Mistake:** Not set up while discounts are taken; required if you take discounts. **Table:** F0012 **Item:** PKL **Description:** Payables discount lost **Program:** Payment post **Drcr:** Debit when discount not taken **Mistake:** Pointing PKD and PKL to different accounts without meaning to; both may point to the same account. **Table:** F0012 **Item:** PP **Description:** Preliminary expense for voucher logging (with PQ suspense trade) **Program:** Voucher logging **Drcr:** Debit preliminary expense, reversed at redistribution **Mistake:** Leaving logged vouchers unredistributed at period end. **Table:** F0012 **Item:** RB **Description:** Receivables bank (default when the receipt has no bank account) **Program:** Receipts entry (P03B102) **Drcr:** Debit bank on receipt **Mistake:** Relying on company 00000 when companies bank separately. **Table:** F0012 **Item:** RC / RCxxxx **Description:** Receivables trade by G/L offset xxxx **Program:** Invoice post, receipt post **Drcr:** Debit at invoice post, credit at receipt **Mistake:** Customer G/L offset in F03012 with no RCxxxx item. **Table:** F0012 **Item:** RAxx **Description:** Write-off expense by reason code xx (UDC 03B/RC) **Program:** Receipts with write-off **Drcr:** Debit write-off expense **Mistake:** Adding a write-off reason in 03B/RC without the RAxx item. **Table:** F0012 **Item:** GLG2 **Description:** Beginning account range for assets **Program:** Financial reports, annual close **Drcr:** Range definition, no entries **Mistake:** Setting up GLGx per company; only GLG4 is set per company, the others for 00000. **Table:** F0012 **Item:** GLG3 **Description:** Beginning account range for liabilities and equity **Program:** Financial reports (sign reversal) **Drcr:** Range definition **Mistake:** Object account ranges not matching the chart of accounts. **Table:** F0012 **Item:** GLG4 **Description:** Retained earnings account **Program:** Annual Close (posts retained earnings) **Drcr:** Credit profit / debit loss at close **Mistake:** Account is not a posting account or the business unit is missing for companies with different balance sheet BUs. **Table:** F0012 **Item:** GLG6 **Description:** Beginning account range for revenue **Program:** Annual close, sign reversal, percent of revenue **Drcr:** Range definition **Mistake:** Revenue accounts below GLG6 are treated as balance sheet. **Table:** F0012 **Item:** GLG12 **Description:** Ending profit and loss (last income statement account) **Program:** Annual close **Drcr:** Range definition **Mistake:** Accounts above GLG12 are not closed to retained earnings; blank uses 999999. **Table:** F0012 **Item:** ICH **Description:** Intercompany settlement account, hub method **Program:** G/L post with intercompany settlements = 1 in G/A constants **Drcr:** Due to / due from **Mistake:** Wrong ICH items produce unbalanced companies on the Companies in Balance report. **Table:** F0012 **Item:** ICCC **Description:** Intercompany settlement accounts, detail method **Program:** G/L post with intercompany settlements = 2 **Drcr:** Due to / due from **Mistake:** Mixing hub and detail setups when switching methods. **Table:** F4095 **Item:** 4122 **Description:** Inventory: balance sheet inventory valuation account **Program:** Issues (P4112), transfers (P4113), adjustments (P4114) **Drcr:** Debit or credit inventory **Mistake:** Missing GL class rows for new G/L classes (41/9). **Table:** F4095 **Item:** 4124 **Description:** Inventory: expense or cost of goods sold offset **Program:** Issues and adjustments **Drcr:** Offset of 4122 **Mistake:** Using 4124 COGS for adjustments that finance wants in a variance account; use document type rows. **Table:** F4095 **Item:** 4134 **Description:** Item balance cost change: inventory offset **Program:** Cost changes (P4105) with G/L **Drcr:** Debit or credit inventory **Mistake:** Changing costs without 4134 and 4136 for the document type used. **Table:** F4095 **Item:** 4136 **Description:** Item balance cost change: expense or COGS offset **Program:** Cost changes **Drcr:** Offset of 4134 **Mistake:** Offset to COGS instead of a revaluation account. **Table:** F4095 **Item:** 4152 **Description:** Physical inventory update: inventory offset **Program:** Cycle count and physical count update **Drcr:** Debit or credit inventory **Mistake:** No row for the count document type. **Table:** F4095 **Item:** 4220 **Description:** Sales: cost of goods sold **Program:** Sales Update (R42800) **Drcr:** Debit COGS **Mistake:** Missing **** GL class fallback; sales update errors out. **Table:** F4095 **Item:** 4230 **Description:** Sales: revenue **Program:** Sales Update (R42800) **Drcr:** Credit sales revenue **Mistake:** Flexible sales accounting (F4096) set up for some companies only. **Table:** F4095 **Item:** 4240 **Description:** Sales: inventory **Program:** Sales Update (R42800) **Drcr:** Credit inventory **Mistake:** Different account from 4122 for the same GL class, so inventory does not reconcile. **Table:** F4095 **Item:** 4245 **Description:** Sales: A/R trade **Program:** Sales Update (R42800) **Drcr:** Debit A/R **Mistake:** Not used when Sales Update is set to bypass the A/R update; check the R42800 version before blaming the AAI. **Table:** F4095 **Item:** 4250 **Description:** Sales: tax liability **Program:** Sales Update (R42800) **Drcr:** Credit tax payable **Mistake:** Tax areas added without a 4250 row for the order type. **Table:** F4095 **Item:** 4270 **Description:** Advanced pricing: price adjustments **Program:** Sales Update (R42800) **Drcr:** Per adjustment **Mistake:** New adjustment names not covered by F4096 flex setup. **Table:** F4095 **Item:** 4310 **Description:** Purchasing: inventory or expense at receipt **Program:** PO Receipts (P4312) **Drcr:** Debit inventory **Mistake:** GL class on the item branch not matching any 4310 row. **Table:** F4095 **Item:** 4320 **Description:** Purchasing: received not vouchered **Program:** PO Receipts (P4312), Voucher Match (P4314) **Drcr:** Credit at receipt, debit at voucher match **Mistake:** Different 4320 accounts by document type, so RNV never clears. **Table:** F4095 **Item:** 4385 **Description:** Landed costs / expense adjustments (debit), with 4390 for the credit **Program:** PO Receipts, Purchase Receipts Inquiry (P43214), Voucher Match **Drcr:** Debit landed cost **Mistake:** Setting 4385 but not 4390. **Notes:** F0012 items are keyed by item and company (KGITEM, KGCO) and searched for the company, then company 00000. F4095 rows are keyed by AAI number, company, order type, document type, G/L class and cost type (MLANUM, MLCO, MLDCTO, MLDCT, MLGLPT, MLCOST). For sales AAIs the search is company + order type + G/L class, then G/L class ****, then company 00000, then 00000 with ****, then an error. Financial AAIs are maintained in P0012, distribution AAIs in P40950. ## Content **Intro:** This reference covers the JD Edwards EnterpriseOne 9.2 automatic accounting instructions that cause most posting questions: financial AAIs in F0012 such as PC, PB, RC and the GLG ranges, and distribution and manufacturing AAIs (DMAAIs) in F4095 such as 4122, 4220, 4240, 4310 and 4320. Each row names the program that uses it, the usual debit or credit and a common setup mistake. **Sections:** #### Where AAIs live **Body:** Financial AAIs are stored in the Automatic Accounting Instructions Master (F0012), keyed by item name and company, and maintained in P0012. Item names are hard coded: A/P items start with P, A/R items with R, general purpose ranges with GLG. Distribution and manufacturing AAIs are stored in F4095, keyed by AAI number, company, order type, document type, G/L class and cost component, and maintained in Distribution AAIs (P40950), form W40950B. Each entry resolves to a business unit, object and optional subsidiary. Sales AAIs 4220, 4230, 4240 and 4250 can also use flexible accounting in F4096. #### Search order **Body:** For the sales AAIs the system looks for order company + order type + G/L class, then the same with G/L class ****, then company 00000 with the G/L class, then 00000 with ****, and errors if none is found. When product detailed costing is used, cost type is added for 4220 and 4240. A/P trade follows a simpler order: for a voucher in company 00100 with G/L offset 30 it looks for PC30 in 00100, then PC30 in 00000. Knowing the order lets you fix a missing AAI with one row instead of many. **Bullets:** - Company 00000 rows act as the default - **** is the wildcard G/L class in F4095 - GLGx items are set for 00000, except GLG4 per company when needed #### Worked example: a PO receipt **Body:** A stock item with G/L class IN30 is received on an OP order in company 00200: 100 units at a PO price of 10.40. P4312 looks up 4310 for company 00200, order type OP and G/L class IN30 (falling back to **** and 00000) and debits inventory 1,040.00, then credits received not vouchered 1,040.00 through 4320. At voucher match, P4314 debits the same 4320 account for 1,040.00 and credits A/P trade through PCxxxx for the supplier G/L offset. Standard cost items and invoice price differences post to variance accounts from their own purchasing AAIs, so list the 43xx items in P40950 for your release before testing. #### Common mistakes **Body:** Most AAI errors come from new master data: a new G/L class, order type or company with no row and no fallback. Add **** and 00000 rows deliberately so new codes fall back somewhere sensible, then add specific rows where finance needs a different account. Keep 4122 and 4240 pointing at the same inventory account for a G/L class, or inventory will not reconcile to the cardex. After any change, run a test transaction and check the journal in F0911 before telling users it is fixed. **Cta:** If your finance team wants to ask 'which account did this receipt hit and why' in plain English, with the AAI lookup shown, on your own JD Edwards servers, we can build that. **Faq:** #### What is the JD Edwards AAI table? **Answer:** Financial AAIs are in F0012, the Automatic Accounting Instructions Master, keyed by item (KGITEM) and company (KGCO), with business unit, object and subsidiary columns. You maintain them in P0012. Distribution and manufacturing AAIs are a separate table, F4095. #### What is the DMAAI table in JDE? **Answer:** DMAAIs are stored in F4095, Distribution/Manufacturing - AAI Values. Rows are keyed by AAI number (MLANUM), company, order type, document type, G/L class (MLGLPT) and cost component, and give a business unit, object and subsidiary. You maintain them in P40950. #### How do I set up AAIs in JDE? **Answer:** Review the existing items in P0012 or P40950, then add rows for the default company 00000 first and company specific rows only where accounts differ. For DMAAIs, add **** G/L class rows as a fallback. Test with a real transaction and check the resulting F0911 lines before closing the change. #### What do DMAAI 4310 and 4320 do? **Answer:** 4310 gives the inventory (or expense) account debited by PO Receipts (P4312). 4320 gives the received not vouchered account, credited at receipt and debited when Voucher Match (P4314) creates the voucher. If they use different accounts by document type, RNV will not clear. ## Search terms jd edwards aai table, jd edwards dmaai table, aai setup in jde, dmaai setup in jde, jde dmaai 4310 4320, jde aai pc pb rc, jde f4095 table, jde glg4 retained earnings --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json