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

Accounting entries of P2P cycle in Oracle R12

 The Procure-to-Pay (P2P) cycle in Oracle R12 involves various transactions that generate accounting entries as goods and services are purchased, received, and paid for. Below is a detailed breakdown of the typical accounting entries generated during each step of the P2P cycle: 1. Purchase Order Creation When a Purchase Order (PO) is created, there are no accounting entries recorded immediately. The creation of a PO is a commitment to purchase and does not impact the financials until the goods or services are received. 2. Receipt of Goods or Services (Receiving Transaction) When goods or services are received, accounting entries are generated to reflect the receipt in inventory or as an expense. The entries depend on whether the receipt is for inventory or direct charge (expense) items. a. Inventory Receipt (Accrual-Based) Dr. Inventory Material (Asset) Reflects the increase in inventory. Cr. Accrual (Receiving Inventory or Purchase Price Variance Account) Represents the liability...
Read more

Multi Org in Oracle ERP R12

Image
Multi-Org means the implementation of multiple business units (or Organization) under a single installation of Oracle Applications. There are Hierarchy Flow of Multi-Org -  1. Business Group - This is highest level in the Organization Structure. The Business group secures HR     Information. Multiple set of books can share same business group.  2. Legal Entity - It is a legal Business purpose, At this Level we prepared income tax reports.  3. Ledger - It is use to secure Journal and Ledger Balances of a company. A Ledger is a collection of   Currency, chart of account, calendar and accounting Methods.  4. Operating Unit - It is a strategic business unit, At this level we partition and secure sales and purchase   transaction data.  5. Inventory Organization - An Organization for which you track Inventory transactions and balances   and/or an Organization that manufactures or distributes products. ...
Read more

Accounting entries of O2C cycle in Oracle R12

 The Order-to-Cash (O2C) cycle in Oracle R12 involves various transactions that generate accounting entries as goods or services are sold, shipped, invoiced, and payment is collected. Below is a detailed breakdown of the typical accounting entries generated during each step of the O2C cycle: 1. Sales Order Creation When a Sales Order (SO) is created, no accounting entries are generated. The order creation is a commitment from the customer and does not affect the financials until the goods or services are delivered or invoiced. 2. Shipping of Goods (Shipping Transaction) When goods are shipped to the customer, accounting entries are generated to reflect the reduction in inventory and the recognition of the Cost of Goods Sold (COGS). Dr. Cost of Goods Sold (COGS) Reflects the cost of the goods that are shipped to the customer. Cr. Inventory (Asset) Reduces the inventory account to reflect the goods leaving the inventory. 3. Invoicing the Customer (Invoice Creation) When an invoice is...
Read more