Accounts payable setup in oracle apps EBS

Setting up Accounts Payable (AP) in Oracle E-Business Suite (EBS) involves configuring various components to manage supplier invoices, payments, and financial transactions efficiently. Below is a step-by-step guide on setting up Accounts Payable (AP) in Oracle EBS:

1. Define System Options

  • Navigate to: Payables Manager → Setup → Options → Payables Options
  • Configure:
    • Invoice and Payment processing options
    • Default currency, calendar, and accounting periods
    • Tolerance levels for matching invoices to purchase orders (POs)

2. Define Financials Options

  • Navigate to: Payables Manager → Setup → Options → Financials Options
  • Configure:
    • Set up legal entity and operating unit
    • Define liability accounts, prepayment accounts, and other financial controls

3. Define Payment Terms

  • Navigate to: Payables Manager → Setup → Invoice → Payment Terms
  • Examples of payment terms:
    • Net 30 (Payment due in 30 days)
    • 2/10 Net 30 (2% discount if paid within 10 days, otherwise due in 30 days)

4. Define Supplier and Supplier Sites

  • Navigate to: Payables Manager → Suppliers → Entry
  • Define:
    • Supplier Master Details (name, tax information, bank accounts)
    • Supplier Sites (Bill-to, Ship-to, RFQ, and Payment sites)
    • Set payment methods such as Check, Wire Transfer, or ACH

5. Define Banks and Bank Accounts

  • Navigate to: Payables Manager → Setup → Payments → Banks
  • Set up:
    • Bank details (Name, Branch, Address)
    • Bank accounts (Account Number, Currency, Payment Documents)

6. Define Invoice Types

  • Invoice types in Oracle AP:
    • Standard Invoice – For supplier payments
    • Credit Memo – To reduce invoice amount
    • Debit Memo – To increase liability
    • Prepayment – Advance payments to suppliers
    • Expense Report – Employee reimbursements

7. Define Distribution Sets (Optional)

  • Navigate to: Payables Manager → Setup → Invoice → Distribution Sets
  • Helps in automatic distribution of expenses across multiple accounts

8. Set Up Invoice Approval Workflow (Optional)

  • Configure AME (Approval Management Engine) for invoice approval routing

9. Define Payment Methods

  • Navigate to: Payables Manager → Setup → Payments → Payment Methods
  • Define methods like:
    • Check
    • Electronic Funds Transfer (EFT)
    • Wire Transfer
    • Clearing

10. Configure Payment Processing

  • Navigate to: Payables Manager → Setup → Payments → Payment Terms and Formats
  • Assign:
    • Payment format (Check, ACH, etc.)
    • Bank account to supplier site for electronic payments

11. Configure Tax Setup (Optional)

  • Navigate to: Payables Manager → Setup → Tax → Tax Codes
  • Set up:
    • Tax rates and codes for compliance with tax regulations

12. Configure Withholding Tax (If Required)

  • Navigate to: Payables Manager → Setup → Tax → Withholding
  • Define withholding tax rates applicable to specific suppliers

13. Perform Accounting Setup

  • Navigate to: General Ledger → Setup → Accounting Setup Manager
  • Define:
    • Chart of Accounts
    • Accounting Calendar
    • Subledger Accounting (SLA) Rules for Payables

14. Test the Setup

  • Create a Test Supplier and enter a Test Invoice
  • Validate invoice processing, approvals, and payment cycle
  • Check if the correct accounting entries are generated

Key Modules Integrated with Accounts Payable

  • Oracle General Ledger (GL) – Posts accounting entries
  • Oracle Purchasing (PO) – Matches invoices with purchase orders
  • Oracle Cash Management – Reconciles bank statements with payments
  • Oracle Fixed Assets (FA) – Manages capital expenditure invoices

Would you like a specific configuration in more detail? 😊

Comments

Post a Comment

Popular posts from this blog

Accrual reconciliation when using Accrue Expense Items at Receipt in Oracle EBS R12 or Oracle Fusion.

 1. SLA Accounting Rules (Subledger Accounting Setup) When you’re using Accrue at Receipt , Oracle needs to know which accounts to use during different steps of the P2P process. SLA handles this through Journal Line Definitions (JLD) and Account Derivation Rules (ADR) .  A. Typical Accounting Setup in SLA for Expense Items at Receipt Event Debit Credit Description Receiving (Expense Destination) Charge Account (from PO) Accrual Account Accrual created immediately at receipt Invoice Matching Accrual Account AP Liability Reverses accrual and creates liability Payment AP Liability Cash/Bank Standard AP payment Optional Enhancements via SLA : Add cost center segments from PO distribution. Use item category to change accounts. Override based on supplier site or BU .B. Example Account Derivation Rule Let’s say you want the credit accrual account to vary by item category. Your rule tree can look like: java IF Item Category = 'IT_HARDWARE' THEN use Accrual A...
Read more

AP Accrual at Receipt in Oracle R12

 what really happens in Oracle E-Business Suite/Oracle Fusion Procurement & Payables when you set Accrue Expense Items = “At Receipt” (sometimes called Perpetual Accrual ). I’ve broken it into the three moments you actually care about— Receipt, Invoice, and Period Close/Reconciliation —plus the key setup switches that drive it. 1. Key setup you need to double-check Module Form / Task Field / Profile What it must be Why it matters Purchasing Purchasing Options Accrue Expense Items At Receipt (not Period End ) Tells the Receiving Transaction Processor (RTP) to book an accrual the instant you do the receipt. Receiving Receiving Options (supplier & org) Expense AP Accrual Account A suspense / clearing account Credited at receipt and debited when the invoice posts. Payables Financial Options Liability Account Your trade AP control Credited when the invoice is accounted. Sub-ledger acct. rules (SLA) (optional) Override rules Only if you need different accounts by item categ...
Read more

Types of AP invoices in oracle ERP

  In Oracle ERP (Enterprise Resource Planning), specifically in the context of Accounts Payable (AP) invoicing, you can create and manage various types of invoices to handle different financial transactions and business needs. Here are some common types of AP invoices in Oracle ERP: 1.Standard Invoice: This is the most common type of AP invoice, used to request payment from your organization's customers for goods or services provided. It typically includes details such as the supplier's name, invoice number, invoice date, and itemized charges. 2.Credit Memo: A credit memo is issued by a supplier to reduce the amount owed by your organization. It may be used to account for returns, discounts, or other adjustments to previously issued invoices. 3.Debit Memo: Conversely, a debit memo is issued by a supplier to increase the amount owed by your organization. It might be issued for additional charges, fees, or other adjustments. 4.Prepayment Invoice: Prepayment invoices are used when...
Read more