Pre-requisite – Mass Additions Create Rules for Import from Payables to Fixed Assets Mass Additions Create will only create mass addition lines under certain circumstances. Please check that you have invoice lines that satisfy the […]
2-Way, 3-Way and 4-Way PO-Matching One of the fundamental controls in Payables is the PO match. This simply means that the invoice you enter in the application is matched to the Purchase Order. If the […]
AP Intercompany Accounting and XLA_DISTRIBUTION_LINKS table Question: When I enter intercompany invoice or make an Intercompany payment in R12 EBS, i could see the corresponding sub ledger accounting entries in the “View Journal entries” screen. […]
What are the different methods to transfer Sub ledger journals to GL? a) ONLINE MODE GL Transfer can be spawned during Online Accounting using the “Final Post” option for a specific document (Example: AP Invoice and […]
Function to get reporting currency conversion rate for AP invoice 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 […]
How does the XLA_DISTRIBUTION_LINKS table map to the Payables Subledger? This table contains the link between transactions and subledger journal entry lines. Module: Payables Column – EVENT_ID: Invoice/Payment In case of invoice it will be […]
Rebuild AP Trial Balance in R12 To rebuild xla_trial_balances table or create a new report definition. For better performance of Data Manager run, increase the number of workers to 16,32 or 64 Navigate : Subledger […]
How to reconcile AP Trial Balance with Payable Transactions for a given period Get the output of the following for account and period where the difference was observed (In Detail); Now run following reports within […]
Before getting into the transactions, let’s see what are Debit Memos and Credit Memos. In Oracle Payables both of them are used to reduce the invoice amount. This reduction can be of any reason and […]
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 […]
Enterprise Resource Planning and Integrations BlogSpot 