Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Understanding Global Accounting Engine – Dual posting, Tables, Reports

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

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

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.

1

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.

2Table Details

These are the additional tables which keeps the events data.

  • gloabal accounting processAX_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

 

3AX 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.

4 Limitations of AX

  • It has been designed based on primary transactions in Local GAAP.
  • Its needs same calendar in primary and secondary set of books
  • The other limitation is that no user access to account transformation rules that mean very limited functionality.
  • Intensive setup and maintenance, that makes a technical difficulty.
  • Separate release and patch sets. This support issue is yet another limitation.
  • Non-Standard as it is replaced by GL posting process,separate additional tables.
  • Not Complete as only limited to few like AP, AR and in some case France can use INVENTORY as sub-ledger modules

Related Posts

Posted in Functional, Oracle General Ledger, Oracle Product | 4 Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
4 Responses
  1. Srinivas Seripella Says:

    Excellent article. I need help to work on purging of data of GAE countries. Donot know how to proceed. There is a standard Program Subledger archive and Purge.

    Looking forward for help.

  2. Sanjit Anand Says:

    Srinivas,

    I am really afraid,I will not help in this area as i dnot have any idea ..for archival ..
    .Some of the functionlity we have already mapped with SLA.
    http://www.oracleappshub.com/release12/r12-sla-vis-a-vis-ax-of-11i/
    there is no seeded way to achieve this:

    Would advice . to take a look in metalink and documentation.Else, you have to develop own custom purge and archival based out of business need.

  3. Skanceunern Says:

    What’s up, is there anybody else here?
    If it’s not just all bots here, let me know. I’m looking to network
    Oh, and yes I’m a real person LOL.

    See ya,

  4. Anil Wadhwa Says:

    I’m presently working on a European Implementation for 3 entities in France, Spain & Italy where we have a requirement to implement GAE. The client is on 11. 5.10.2

    As per the reference notes available on metalink
    Any accounting distribution referring to an Inventory valuation account must be balanced (debit/credit) by a distribution on a transfer account known as bridging account.

    Accordingly for the Deliver to Subinventory transaction along with the standard inventory accounting entrues, the additional accounting entry in AX Inventory is
    Dr Material (Standard Cost)
    Cr Receiving Inspection
    Dr Purchase Expense (PO Price)
    Cr Inventory Bridging (PO Price)

    However for sales order shipment there are only standard accounting entries are created, when we did some transaction testing in an AX configured enviornment
    Dr COGS (Std Cost)
    Cr Material (Std Cost)

    Need to validate whether for ship confirm transaction, no AX accounting entry is generated, and if yes, then at period end do we just adjust the balances in the Purchase Expense and Inventory Bridging account..

    Kindly advise

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.