How Subledger Accounting (XLA) Tables are link to General Ledger (GL) Tables Assumption is GL Entry Summarization: Summarize (By GL Date or Period) JLT – Transfer to GL: Detail Expected behavior is: Summarize Entries at […]
Summary GL_BALANCES contains actual, budget, and encumbrance balances for detail and summary accounts. This table stores ledger currency, foreign currency, and statistical balances for each accounting period that has ever been opened. ACTUAL_FLAG is either […]
The Link between GL to SLA and reference columns in GL_IMPORT_REFERENCES Since there is always a one-to-one correspondence between XLA_AE_LINES and GL_IMPORT_REFERENCES, they are used to link GL and the subledgers. GL_IMPORT_REFERENCES.gl_sl_link_id => XLA_AE_LINES.gl_sl_link_id GL_JE_BATCHES.group_id => […]
How to Reconcile Account Payable with GL trial balance Run the Accounts Payable Trial Balance for a particular period which you have already closed (or) intend to close in both AP and GL. Now Run […]
Payroll journal entries are used to record the compensation paid to employees. These entries are then incorporated into an entity’s financial statements through the general ledger. The key types of payroll journal entries are: Initial […]
Asset Trace or Single Asset Diagnostics Run the program “Generate Asset Trace” FA responsibility: Other > Requests > Run Generate Asset Trace It will span following two […]
Goal: How can I setup the new Consolidated Review and Manage Accounting Exception Program in Receivables? Also referred to as the Sweep program. Solution: Please perform the following: For Release 12.1, in order to enable […]
Execute Following action plan to disable GL Account and all associated GL code combinations. Query GL Account Value Set through Flexfield à Validation à Values Then uncheck “Enabled” check box and save the changes Then […]
It may not always be the case that Account codes will be created by user from the front end. There may be scenarios sometimes where we need to have programs that will be creating the code combinations. […]
1) Key Assumption is “Allow Dynamic Inserts” should have been enabled for GL Accounting Flexfield Structure One May have to use apps initialize, but mostly not required if called from concurrent program. 1 2 3 […]
