Function to get reporting currency conversion rate for AP invoice
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 […]
Payables
How does the XLA_DISTRIBUTION_LINKS table map to the Payables Subledger?
How does the XLA_DISTRIBUTION_LINKS table map to the Payables Subledger? Module: Payables Column – EVENT_ID: Invoice/Payment In case of invoice it will be Invoice transaction event id. In case of payment it will be Payment […]
Rebuild AP Trial Balance in R12
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 reconciled AP Trial Balance with Payable Transactions for a period
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 […]
Debit Memo and Credit Memos in Accounts Payable
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
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 […]
Script to get AP Invoice Aging for Prepayment
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
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? and what are common MICR Check Requirements
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 […]
Where Is The Invoice Validation Status Stored? How Is The Invoice Validation Status Determined?
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 […]
