Please find below comprehensive breakdown of different 1099 reporting scenarios based on ERP go-live timing and approach: 1. Go-Live on the 1st Day of the New Year 2. Go-Live in the Middle of the Year […]
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 […]
Enterprise Resource Planning and Integrations BlogSpot 