JD Edwards Fixed Assets: Setup, Depreciation and the Account Ledger Flow
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
- 1Set up Fixed Assets constants and the account number structure, including the account to book cost, accumulated depreciation and depreciation expense.
- 2Define asset ledger types and the depreciation method for each, for example one for book and others for tax or management reporting.
- 3Set up automatic accounting instructions (AAIs) for fixed assets so cost, accumulated depreciation and expense map to the right GL accounts.
- 4Create asset master records, either manually, from a voucher, or from a purchase, with category codes, life, method and in-service date.
- 5Run the depreciation process in proof mode, review the report for outliers, then run it in final mode.
- 6Create the depreciation journal entries, review the batch, approve and post it so the amounts reach the general ledger.
- 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
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
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-toHow 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-toHow 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-toJD 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 fixJDE 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 fixJD 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 ERPAI 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 ERPAI 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
- Oracle EBS Fixed Asset Straight-Line Depreciation CalculatorStraight-line depreciation by life in months with salvage value, plus a net book value curve over the asset's life.
- JD Edwards F0911 General Ledger SQL GeneratorFill in schema, company, ledger type and a Julian date range to get ready-to-run SQL for F0911 detail and an account summary.
- JD Edwards EnterpriseOne AI Assistant Sizing and Value CalculatorEstimate peak load, GPUs, index size, hours saved and payback for an on-prem AI assistant on JD Edwards EnterpriseOne.
ERP fixes and how-tos
- How to Add a Private AI Layer to JD Edwards EnterpriseOne On-PremAdd a private AI layer to JD Edwards EnterpriseOne: AIS data service, Orchestrator, Security Workbench mapping, a local model and human approval.
- JD Edwards table conversion: how it works and how to run oneWhat a JD Edwards table conversion does to a JDE table's structure and data, when it runs in a package build, and how to run or design one manually.
- JD Edwards Advanced Pricing: Adjustment Types, Schedules and Definitions ExplainedHow JD Edwards Advanced Pricing works: price adjustment types, definitions, schedules, price groups and the pricing tables, with a setup order and pitfalls.
Runs with your ERP
- Oracle CPQ and JD Edwards EnterpriseOne: quote to sales orderHow Oracle CPQ integrates with JD Edwards EnterpriseOne: customer data into quotes, sales orders created from quotes, and status back, with setup and pitfalls.
- Prometheus Planning & Scheduling with JD Edwards EnterpriseOne maintenanceHow Prometheus Group's planning and scheduling tool works with JD Edwards EnterpriseOne maintenance: Gantt scheduling, time confirmation, setup and pitfalls.
- RF-SMART and JD Edwards EnterpriseOne: Barcode Scanning and Mobile WMSHow RF-SMART connects barcode scanning to JD Edwards EnterpriseOne and World: integration method, data flows, setup steps, pitfalls and where private AI helps.
Guides
- Oracle JD Edwards to Infor: Migration Planning GuidePlan your Oracle JD Edwards EnterpriseOne migration to Infor CloudSuite or LN. Data mapping, functional comparison, and migration timeline.
- SyteLine Fixed Assets Management Configuration GuideConfigure fixed asset management in Infor SyteLine including asset creation, depreciation methods, disposal workflows, and book-tax depreciation tracking.
AI on your ERP
- AI for JD Edwards Inventory Management and Shop Floor ManufacturingAI on JD Edwards EnterpriseOne inventory and manufacturing: item ledger, work orders, MRP messages and cost variances, answered in plain English on your own servers.
- AI for JD Edwards EnterpriseOne, Built on Orchestrator and AISAdd 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.
Integrations
- How to add AI agents to JD Edwards EnterpriseOneHow to add AI agents to JD Edwards EnterpriseOne: Orchestrator and AIS as the tool layer, read-only first, human approval on writes, on-prem models.
- How to use ChatGPT with JD Edwards EnterpriseOneHow to use ChatGPT with JD Edwards EnterpriseOne: custom GPT actions over AIS, exports versus live access, enterprise data controls, and private alternatives.