Simplify, Optimize & Automate

Easily reconcile your logistics and accounting inventory.

Account & Inventory Reconciliation (AIR) developed by our Dutch Partner Cadran Consultancy enables you to automatically match journal entries and inventory transactions. This means that the balances of your suspense and inventory accounts are always up-to-date. AIR allows you to easily correct variances with just one click. You can even combine multiple accounts into a single reconciliation process and monitor more complex processes like validating intercompany transactions.

The included inventory reporting gives you an accurate view of your inventory by financial period. The built-in inventory integrity software supports an automated periodic integrity check, so you will know if your inventory is reliable, for both the quantities and the total value. You an also do ad-hoc inventory reporting. The AIR module contains four main functionalities:

  • Account reconciliation - Suspense account
  • Inventory Reconciliation.
  • Inventory Reporting.
  • Inventory Integrity.




Account & Inventory Reconciliation introduction icon 3

Account Reconciliation
Account Reconciliation

The tool enables you to reduce the number of errors in your financial books. Just add your accounts to the list of accounts to reconcile, set the correct summary/sequencing fields to group transactions together and start reconciling. Or even better: reconcile automatically, for instance each night, weekend, month end or on demand.

Inventory Overview
Inventory Overview

The Account & Inventory Reconciliation module contains all you need to get a grip on your inventory reporting. Inventory Reconciliation matches the item ledger transaction with the GL transactions to identify discrepancies. Inventory Reporting accurately reports your inventory as of month-end (retroactively). Inventory Integrity validates your item balances and current value (quantity times cost).

Inventory Reconciliation
Inventory Reconciliation

Using the full power of the Account Reconciliation functionality, Inventory Reconciliation extends the general ledger transaction with the inventory transaction from your Item Ledger, allowing you to match the general ledger with inventory on the transaction level.

Inventory Reporting
Inventory Reporting

AIR contains an ‘Advanced Item As-Of’ reporting solution. Generate your inventory As-Of based on your inventory transactions (retroactively, as far back as needed) and review the results with the application. Review this by inventory account (the variance with your General Ledger is calculated automatically), by branch or drill down to item/lot/location level or even down to the individual transactions.

Key Benefits

  • Save time: Efficient user-friendly reconciliation.
  • Reduce errors in accounting.
  • All tasks completed within JD Edwards Software.
  • Your Reporting tool can be used to create additional reports.

Key Features

  • Produce accurate info for your accountant and save on audit costs.
  • Identify incorrect transactions and correct your processes.
  • Reliable inventory reporting and explanation of your balances.

Managing our suspense accounts and Inventory reconciliation used to take days at month end, often with external help. This tool is a real timesaver for our accounting department. Our inventory reporting matches our General Ledger to the cent. The inventory movement reporting is very helpful for our accountant when we close our books. We finally have our processes in control.

Wilfred Legebeke, Business Controller at Paul Mueller Company


Developed with the JDE toolset, there is no need for additional servers or databases and your users benefit from the familiar look and feel of JD Edwards.

Data is stored in the same database as your other JD Edwards data and is automatically part of your data set. Your normal reporting tools can be used to create additional reports and software updates move from development all the way to production just like your other JD Edwards upgrades and modifications.

Use queries, personalized grids, watchlists, notifications and orchestrations as you see fit to enhance user experience and improve your processes even further.

Request a Demo or More Information

Speed up your month-end processes with Account & Inventory Reconciliation.

EMEA: +31 33 247 1598
US: +1 (513) 842-8506

Circle K

When Circle K (formerly known as Statoil Fuel and Retail) chose to change their legacy ERP in 2011 from SAP to Oracle’s JD Edwards, the commercial world sat up and took notice.

Arvos Group

Ljungström needed to migrate a high volume of ERP data from SAP to Oracle JD Edwards EnterpriseOne.

Pizza Hut

Pizza Hut Restaurants UK wanted to benefit from the efficiencies and reduced costs associated with Cloud-based infrastructure.

MPL uses Oracle Technology to create an award-winning Chatbot

MPL, our Brazilian partner delivered an exciting and award-winning project using Oracle technology to create an interactive chatbot for their client’s website. The chatbot helps to drives sales, creates differentiation and delivers an outstanding customer experience.

JD Edwards Events in Spain

Join our Spanish partner Qualita at some great JD Edwards community events coming up in the next few weeks. Lots of great learning and networking is planned.

Award | Business Impact Partner of the Year – Europe West Tech/Cloud award for 2023.

Redfaire International is proud to accept the award for Award | Business Impact Partner of the Year – Europe West Tech/Cloud award for 2023.

JD Edwards & SCM Cloud | From A Reactive to A Proactive Supply Chain

Join us to learn how JD Edwards & Oracle Supply Chain Planning Cloud can work together to help you move from a reactive to a proactive supply chain.

Redfaire International at French Oracle User Group

The French Oracle User Group takes place on October 10th - See you there!