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 […]
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 […]
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 […]
AP Trail Balances SQL Query for R12 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 […]
What is MICR? Magnetic Ink Character Recognition (MICR) is the line of numbers (ten numeric and four special symbols) on a document that relates a transaction to a specific customer’s account. Encoded checks are processed […]
Goal How does the Invoices Workbench (APXINWKB) determine the validation status of an invoice? The validation status of an invoice is displayed at invoice header level, but this information is not stored in the corresponding table AP_INVOICES_ALL […]
Enterprise Resource Planning and Integrations BlogSpot 