Enterprise Resource Planning and Integrations BlogSpot

Skip to content

Payments

What are the different methods to transfer Sub ledger journals to GL

  • by Yogesh Pachpute
  • Posted on November 2, 2017November 2, 2017
  • Payables

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 […]

Read More

How does the XLA_DISTRIBUTION_LINKS table map to the Payables Subledger?

  • by Yogesh Pachpute
  • Posted on October 17, 2017February 6, 2018
  • Payables

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 […]

Read More

Rebuild AP Trial Balance in R12

  • by Yogesh Pachpute
  • Posted on October 11, 2017October 26, 2018
  • Payables

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 […]

Read More

How to reconciled AP Trial Balance with Payable Transactions for a period

  • by Yogesh Pachpute
  • Posted on October 11, 2017October 26, 2018
  • Payables

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 […]

Read More

Debit Memo and Credit Memos in Accounts Payable

  • by Yogesh Pachpute
  • Posted on October 10, 2017December 2, 2018
  • Payables

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 […]

Read More

How to Reconcile Account Payable with GL trial balance

  • by Yogesh Pachpute
  • Posted on October 4, 2017October 4, 2017
  • General Ledger

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 […]

Read More

Script to get AP Invoice Aging for Prepayment

  • by Yogesh Pachpute
  • Posted on October 4, 2017October 26, 2018
  • Payables

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 […]

Read More

AP Trail Balances SQL Query for R12

  • by Yogesh Pachpute
  • Posted on October 4, 2017October 26, 2018
  • Payables

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 […]

Read More

What is MICR? and what are common MICR Check Requirements

  • by Yogesh Pachpute
  • Posted on September 20, 2017September 20, 2017
  • Payables

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 […]

Read More

Where Is The Invoice Validation Status Stored? How Is The Invoice Validation Status Determined?

  • by Yogesh Pachpute
  • Posted on August 1, 2017August 1, 2017
  • Payables

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 […]

Read More

Posts navigation

Older posts

Categories

  • AR Reconciliation (8)
  • BI Publisher (3)
  • Cash Management (4)
  • Cloud Enterprise Structure (2)
  • Concurrent Processing in R12 (4)
  • Conversion (2)
  • Cost Management (1)
  • Fixed Asset (23)
  • General Ledger (25)
  • GRC (6)
  • iExpense (21)
  • Linux Server Security and Maintenance (1)
  • Microsoft Windows Configurations (6)
  • Oracle Cloud Cutover Tasks (1)
  • Oracle Cloud Fusion Financial (12)
  • Oracle Cloud Security (2)
  • Oracle Database (2)
  • Oracle Fusion HCM (10)
  • Oracle Fusion HCM Technical (5)
  • Oracle Fusion Technical (10)
  • Oracle Installations (3)
  • Oracle Inventory (2)
  • Oracle SQL (4)
  • Order Management (2)
  • Payables (47)
  • Payables Period Close (10)
  • Payables Reconciliation (10)
  • Payments (29)
  • Payroll (1)
  • Perl and Unix Scripting (1)
  • Purchasing (4)
  • Receivables (17)
  • Receivables Period Close (15)
  • Receiving Subledger (3)
  • RMCS (1)
  • SubLedger Accounting (26)
  • Supply Chain Managment (1)
  • TCA – DQM (1)
  • Uncategorized (2)
  • Useful SQL Scripts (4)
  • Workday (7)

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 35 other subscribers

Calendar

Calendar

February 2023
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728  
« Jan    
Blog at WordPress.com.
  • Follow Following
    • Enterprise Resource Planning and Integrations BlogSpot
    • Join 35 other followers
    • Already have a WordPress.com account? Log in now.
    • Enterprise Resource Planning and Integrations BlogSpot
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...