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 […]
Following are 3 key programs that can be used to upload GL Daily Conversion Rates. A) XXCB FX Rates Data Load Program B) XXCB FX Rates Validation Procedure Program C) Program – Daily Rates Import […]
Query to write Custom Invoice And Payment Report that matches with GL Liability Account Balance, GL Prepayment Account Balance, Expense Accounts etc. 1 2 3 4 5 6 7 8 9 10 11 12 13 […]
Enterprise Resource Planning and Integrations BlogSpot 