Understanding Global Accounting Engine - Dual posting, Tables, Reports

Posted on November 10th, 2007 by Sanjit Anand | Print This Post | Email This Post

Continuing my last post for AX , here is some more information for Global accounting Engine's Dual posting and Reporting need. Lets start with Dual posting.

Global Accounting Engine (AX) Dual Posting

The Global Accounting Engine's dual posting functionality allow simultaneous posting into two sets of books (a main and a secondary sets of books).The AX Dual posting (or multiple posting) functionality lets you meet reporting and accounting requirements when you have multiple sets of books with different charts of accounts, calendars, and rules sets.

• Control Accounts
  The Global Accounting Engine automatically creates detailed balances for control accounts. The balances are calculated for each account with the control account status by period and third party when you run a subledger report. Control accounts are printed on summary and detail balance reports provided by the Global Accounting Engine.
• Documents Sequencing
  A document sequence uniquely numbers documents generated by an Oracle Applications product. Using Oracle Applications, you initiate a transaction by entering data through a form and generating a document, for example, an invoice. Document sequences can provide proof of completeness. For example, document sequences can be used to account for every transaction, even transactions that fail.

Document sequences can also provide an audit trail. For example, a document sequence can provide an audit trail from the general ledger into the subsidiary ledger, and to the document that originally affected the account balance.

Table Details

These are the additional tables which keeps the events data.

• AX_SETUP_GLOBAL
• AX_SETUP_POSTING_BOOKS
• AX_TRANS_PROGRAMS
• AX_EVENTS
• AX_DOCUMENT_STATUSES
• AX_SLE_HEADERS
• AX_SLE_LINES
• AX_BALANCES
• GL_INTERFACE
• GL_JE_LINES

 

AX Reporting

Below is a list of the most important AX Reports:

• The Daily Journal Book - Line Descriptions report displays fiscal year totals for specified sequences. For both manual and imported journals in General Ledger, the report shows the General Ledger accounting sequence number assigned at the time of posting, instead of the General Ledger document sequence number.
• The Daily Journal Book - Header Descriptions report is sorted by sequence name, General Ledger date, and accounting sequence number within the range of requested balancing segments. The report provides totals for the range of balancing segments requested, but not subtotals for each balancing segment.
• The Final Daily Journal Book - Header Descriptions report allow the review of all accounting entries for your set of books by sequence name and period.
• The Supplier/Customer Balance by Account/Accounting Flexfield report allows reviewing information about balances and period activities by account and supplier/customer for one or more accounting periods. This report lets you justify your balances in General Ledger, Payables, and Receivables.

Limitations of AX