How-toJD Edwards EnterpriseOneFixed Assets (system 12)

JD Edwards Fixed Assets: Setup, Depreciation and the Account Ledger Flow

Question
jd edwards fixed assets

Also searched as

  • jde fixed assets depreciation
  • jd edwards asset master F1201
  • jde fixed asset account ledger

Short answer

In JD Edwards EnterpriseOne, the Fixed Assets system (system code 12) keeps an asset master record per asset, asset account balances per ledger type, and generates depreciation that is posted to the general ledger through journal entries. The flow is: set up constants and ledger types, create assets, run depreciation, review, create journal entries, then post.

Applies to: JD Edwards EnterpriseOne 9.x. Program numbers, menus and processing options vary by release and localization; verify on your instance.

Fixed assets from setup to GL posting

  1. 1Set up Fixed Assets constants and the account number structure, including the account to book cost, accumulated depreciation and depreciation expense.
  2. 2Define asset ledger types and the depreciation method for each, for example one for book and others for tax or management reporting.
  3. 3Set up automatic accounting instructions (AAIs) for fixed assets so cost, accumulated depreciation and expense map to the right GL accounts.
  4. 4Create asset master records, either manually, from a voucher, or from a purchase, with category codes, life, method and in-service date.
  5. 5Run the depreciation process in proof mode, review the report for outliers, then run it in final mode.
  6. 6Create the depreciation journal entries, review the batch, approve and post it so the amounts reach the general ledger.
  7. 7Reconcile the fixed asset subledger to the GL for cost, accumulated depreciation and net book value each period.

Data model in brief

The asset master (table F1201) holds the identity of an asset: number, description, category codes, acquisition data. Balances per asset and ledger live in the asset account balances table (F1202). Depreciation calculations read the balances plus the method and life, and write the period's depreciation back to the balances.

Because balances are stored per ledger type, a single asset can carry different cost and depreciation values for book and tax without double entry.

The account ledger flow

Fixed assets balances are not the general ledger. The GL receives amounts only when journal entries are created from the depreciation and posted. That is why a balance difference between the asset subledger and the GL points to unposted batches, a mismatched AAI or manual GL entries to asset accounts.

Run reconciliation by account and by ledger, comparing sums from F1202 to the GL account balances for the same accounts and period. Use the batch status to find anything stuck before posting. See the related page on GL batches in error.

-- Illustrative reconciliation shape (verify column names on your release)
-- Compare asset cost by account with GL balance for the same period:
-- SELECT account, SUM(amount) FROM F1202 GROUP BY account;
-- versus the GL account balances (F0902) for those accounts.

Common setup mistakes

Most depreciation problems trace to setup: wrong in-service date, a life that does not match the method, missing AAIs, or a ledger type that was never activated for the asset. Changing methods mid-life can produce catch-up amounts, so test on a copy of an asset before applying to a population.

Disposals and transfers need their own transactions, not manual edits, so that gain or loss and the ledger stay consistent.

Try it here, free

Oracle EBS Fixed Asset Straight-Line Depreciation Calculator

Open full tool

Straight-line depreciation by life in months with salvage value, plus a net book value curve over the asset's life.

Common pitfalls

  • !Missing or wrong AAIs, so depreciation journals fail or hit the wrong accounts.
  • !Running depreciation in final mode before reviewing proof output.
  • !Editing balances directly instead of using disposal or transfer transactions.
  • !Leaving depreciation batches unposted at period close.
  • !Different in-service dates across ledgers causing unexplained differences.

How an ERP-grounded AI assistant handles this

Fixed asset reconciliations are tedious cross-table checks. A grounded assistant such as ERPray can answer which assets have cost but no depreciation this period or where the subledger differs from the GL, by running read-only queries over F1201, F1202 and GL tables and showing the SQL. Posting and corrections stay with the finance team. For on-prem JDE, the model can run inside your network.

Frequently asked questions

What tables hold fixed assets data in JD Edwards?

The asset master is in F1201 and asset account balances are in F1202. Depreciation results are written to the balances and reach the general ledger through journal entries.

How do I run depreciation in JD Edwards?

Run the depreciation process in proof mode first, review the report, then run it in final mode, create the journal entries and post the batch. Names of the programs depend on your release.

Why does the asset subledger not match the GL?

Typical causes are unposted depreciation batches, AAI mapping errors, manual journal entries on asset accounts and assets in different ledgers. Reconcile by account and ledger to isolate the difference.

Can I keep book and tax depreciation separate?

Yes. Use separate asset ledger types with their own methods and lives so one asset carries parallel cost and depreciation values.

Related

Error fix

JD Edwards GL Post: Batch in Error or Out of Balance

A JD Edwards journal batch fails to post when the General Ledger Post program (R09801) finds a problem in the batch header (F0011) or its detail (F0911), such as an out-of-balance document, an invalid account, a closed period or an inactive business unit. Read the post report errors, fix the offending journal lines in Journal Entry, then repost the batch from Batch Review.

How-to

How to set data selection and processing options in JD Edwards

Data selection controls which rows a UBE's underlying business view reads (a filter, stored per version in F9210/F9211), while processing options control how the program behaves once it has that data (a settings template stored per version in F983051/F983052). They are configured from the same Version Detail screen but are separate, unrelated mechanisms that new users routinely confuse.

How-to

How to set up BI Publisher output for a JD Edwards report

In JD Edwards, 'JDE BI' usually means BI Publisher, the template-based report layout tool, rather than a separate business intelligence product. BI Publisher for JD Edwards EnterpriseOne lets a UBE render through an RTF or PDF template designed in BI Publisher instead of EnterpriseOne's own print engine, giving far more control over layout for things like invoices, checks, and financial statements. Setting it up means confirming the connection to a BI Publisher server, building or importing a template against the report's XML data structure, and associating that template with the specific report version through Report Design Aid.

How-to

JD Edwards Three-Way Match: PO Receipt to Voucher

In JD Edwards a three-way match ties the purchase order line (F4311), the receipt (F43121) and the supplier voucher together. Receive the goods in Purchase Order Receipts (P4312), then create the voucher with Voucher Match so the system matches quantity and price to the receipt and books any variance to the accounts set in the AAIs.

Error fix

JDE UBE failed (status E): how to read jde.log and jdedebug.log

A UBE (batch report/program) that ends with status E in Work With Submitted Jobs tells you almost nothing on its own. The real error is in jde.log on the enterprise server, in the job's own PDF/log subdirectory (jdedebug.log if you turned on debug), and in the work directory for that job number under PrintQueue or the OS temp path.

Error fix

JD Edwards: record is being used by another user (record reservation)

EnterpriseOne places a soft record reservation lock when a user opens a record for edit, tracked in the F00165 table, and releases it when the user saves, cancels, or the session ends cleanly. A stuck lock almost always means a session died abnormally (browser crash, network drop, kiosk timeout) without triggering the release, and it must be cleared by an admin, not by the original user retrying.

AI for ERP

AI for JD Edwards EnterpriseOne, Built on Orchestrator and AIS

Add AI to JD Edwards E1 9.2 using Orchestrator, AIS, and BSSV rather than screen-scraping. Ground a private LLM on F4211, F4111, and F0411 data.

AI for ERP

AI for JD Edwards EnterpriseOne Manufacturing, Without Leaving the F-Tables Exposed

Grounded AI over JD Edwards EnterpriseOne Manufacturing: work orders, routings, and Orchestrator data, answered on-prem without sending F-table data to a public model.

Stuck on JD Edwards EnterpriseOne?

Talk to engineers who work inside JD Edwards EnterpriseOne every week, and who build private AI that answers these questions from your own ERP data.

Keep exploring

Free tools

ERP fixes and how-tos

Runs with your ERP

Guides

AI on your ERP

Integrations

Software