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 […]
–Query to get GL Batches, Journal and Lines for Liability Account for a single GL period for source Payables and Category Purchase Invoices if you want include payment category then comment out category equals Purchase […]
Use following query to find the accounting package is being used 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 […]
Issue: Payment is not getting accounted or payment is not posting to GL. Analysis: Query the Payment, then navigate to Tools à View Accounting Events à Check the status of Event_Status on accounting event page, […]
Requirement: Requirement is to identify Fixed Asset and Payables transaction related Asset Clearing Account coming into GL. This is to make the reconciliation of asset clearing account easy. Solution: Build BI Publisher report using following script […]
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 SELECT code.concatenated_segments, period1.begin_balance_dr […]
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 […]
