Sunday, October 22, 2017

How to Transfer Accounting to General Ledger in Release 12

Concurrent Program General Ledger Transfer used in 11i is obsolete in R12.
In Release 12 this program has been replaced by the following:

  • Create Accounting or Submit Accounting
  • Transfer Journal Entries to General Ledger.
1) Create Accounting - This process handles the generation of accounting entries in Sub-ledger Accounting (XLA)

Responsibility: Receivable Manager
Navigation: Control > Request > Run

Submit a Single Request
From List of Values, pick Create Accounting
Enter the appropriate Parameters

NOTES:
  • The Parameter Transfer to General Ledger denotes whether or not the records created by Create Accounting in the XLA tables will be posted to the the General Ledger Tables.                          
    1.  If you enter YES - the process will automatically call "Transfer Journal Entries to General Ledger" for you and your records are transferred from XLA Tables to GL and your entries are posted.
    2. If you enter NO - then you need to explicitly run program "Transfer Journal Entries to General Ledger" to pickup the final accounted transactions from the sub ledger (XLA Tables) and move them on to GL. See step 3 on how to do this.
  • If you have transactions with Accounting Rules, you need to run Revenue Recognition prior to running "Create Accounting" otherwise the invoice will not be picked up for accounting, OR you can use "Submit Accounting" instead, which is described below.
2) Submit Accounting - This process is an Oracle Receivables-specific counterpart of the create accounting process
This Oracle Receivables-Specific concurrent request called Submit Accounting, does the following:
  • Spawns Revenue Recognition to properly create distributions for Transactions with Accounting Rules
  • Calls "Create Accounting" Concurrent Program.

Responsibility: Receivable Manager
Navigation: Control > Request > Run

Submit a Single Request
From List of Values, pick  Submit Accounting
Enter the appropriate Parameters.

NOTES:
  • The Parameter Create Accounting determines whether you want to spawn the "Create Accounting" process as well - this is equivalent to running it standalone as in step 1 above
  • The Parameter Transfer to General Ledger denotes whether or not the records created by Create Accounting in the XLA tables will be posted to the the General Ledger Tables.                
    •  If you enter YES - the process will automatically call "Transfer Journal Entries to General Ledger" for you and your records are transferred from XLA Tables to GL and your entries are posted.
    • If you enter NO - then you need to explicitly run program "Transfer Journal Entries to General Ledger" to pickup the final accounted transactions from the sub ledger (XLA Tables) and move them on to GL. See step 3 on how to do this.
3) Transfer Journal Entries to General Ledger
If in either of the previous steps: Create Accounting OR Submit Accounting, you entered NO for the parameter Transfer to General Ledger, then you need to run this step explicitly.

Responsibility: Receivable Manager
Navigation: Control > Request > Run

Submit a Single Request
From List of Values, pick Transfer Journal Entries to GL
Enter the appropriate Parameters

No comments:

Post a Comment

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)