Oracle AP setup step by step

 Setting up Oracle Accounts Payable (AP) involves several steps, from defining your accounts payable options to setting up suppliers, invoices, payments, and related configurations. Below is a step-by-step guide to setting up Oracle AP:

1. Define Payables System Setup Options

This setup involves defining options that apply to your entire accounts payable system.

  • Navigation: Payables Manager > Setup > Options > Payables System Setup
  • Steps:
    • Set your Ledger and Operating Unit.
    • Define your Payment Terms and Payables Calendar.
    • Specify Invoice Tolerances (e.g., variance limits for invoice matching).
    • Set Supplier Controls (e.g., supplier number auto-generation).

2. Define Payment Terms

Payment terms determine how due dates and discounts are calculated for invoices.

  • Navigation: Payables Manager > Setup > Invoice > Payment Terms
  • Steps:
    • Define different payment terms (e.g., Net 30, Net 45).
    • Configure discount terms (e.g., 2% discount if paid within 10 days).

3. Define Financial Options

Financial options include your default currency, tax codes, and other financial settings.

  • Navigation: Payables Manager > Setup > Options > Financial Options
  • Steps:
    • Set your Functional Currency.
    • Define default Supplier Sites for payments.
    • Specify Interest Rates for overdue invoices if applicable.

4. Create Suppliers

Suppliers provide goods or services, and you need to set them up to manage invoices and payments.

  • Navigation: Payables Manager > Suppliers > Entry > Suppliers
  • Steps:
    • Enter the Supplier Name and Supplier Type (e.g., standard, employee).
    • Specify Taxpayer ID and other compliance details.
    • Define Supplier Sites (e.g., locations where invoices are sent).

5. Setup Payment Methods

Payment methods dictate how payments are made (e.g., checks, electronic payments).

  • Navigation: Payables Manager > Setup > Payments > Payment Administrator > Payment Methods
  • Steps:
    • Define payment methods like Check, Wire Transfer, ACH.
    • Associate the payment methods with the appropriate Bank Accounts.

6. Setup Banks, Branches, and Accounts

Define the banks, branches, and accounts your company uses for payments.

  • Navigation: Payables Manager > Setup > Payments > Banks
  • Steps:
    • Create the Bank and Branch.
    • Define the Bank Account and associate it with the appropriate Ledger.
    • Set up Internal Bank Accounts for payments.

7. Define Invoice Approval Workflow (Optional)

If you want to use workflow for invoice approvals, this needs to be set up.

  • Navigation: Payables Manager > Setup > Invoices > Approval Workflow
  • Steps:
    • Enable the workflow and define the rules for invoice approvals.

8. Create Invoice Batches (Optional)

Invoice batches help in grouping multiple invoices for easier processing.

  • Navigation: Payables Manager > Invoices > Entry > Invoices Batches
  • Steps:
    • Create a new Invoice Batch.
    • Enter the Batch Name and Control Count (number of invoices expected).
    • Enter invoices within the batch.

9. Enter and Validate Invoices

Invoices need to be entered, matched to purchase orders (if applicable), and validated.

  • Navigation: Payables Manager > Invoices > Entry > Invoices
  • Steps:
    • Enter the Invoice Details (Supplier, Date, Amount, etc.).
    • Match the invoice to a Purchase Order if required.
    • Validate the invoice by running the Invoice Validation Process.

10. Create Payments

Once invoices are validated, you can proceed to pay them.

  • Navigation: Payables Manager > Payments > Entry > Payments
  • Steps:
    • Create a Payment Batch or a Single Payment.
    • Select the Invoices to be paid.
    • Run the Build Payments Process to generate payments.
    • Review and confirm the payment batch before finalizing.

11. Reconcile Payments (Optional)

Reconciliation ensures that the payments recorded in Oracle match your bank statement.

  • Navigation: Cash Management > Bank Statements > Bank Statement Reconciliation
  • Steps:
    • Upload or enter your Bank Statement.
    • Match the bank statement transactions with Oracle payment records.
    • Reconcile and post the reconciliation.

12. Generate Reports and Analyze

Run various reports to analyze your accounts payable activities.

  • Navigation: Payables Manager > View > Requests
  • Steps:
    • Run reports like Invoice Aging Report, Payment Register, Supplier Balance Report.

13. Close Payables Period

Closing the payables period ensures that all transactions are accounted for in the correct accounting period.

  • Navigation: Payables Manager > Accounting > Control Payables Periods
  • Steps:
    • Review all transactions for the period.
    • Resolve any issues with unprocessed transactions.
    • Close the period by selecting Close Period.

This setup should prepare your Oracle Accounts Payable module for efficient operation. Each step might vary slightly depending on your organization’s specific requirements and configurations.

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