Oracle Account Payables Setups

Account Payables

Creating Liabilities (Invoice Work Bench)

Making Payments (Payments Work Bench)

Types Of Invoices: -

Standard Invoice

Debit Memo Invoice

Credit Memo Invoice

Mixed Invoice

PO Default Invoice

Quick Match Invoice

Prepayment Invoice

Interest Invoice

Expense Report Invoice

AWT (Allow withhold Tax) Invoice

Creating Supplier: -

Nav: - Suppliers – Entry

Table Name: AP_VENDORS_V

Table Name: AP_VENDOR_SITES_V

Creating Paygroup

Nav: - Setup – Lookups – Purchasing

Table Name: FND_LOOKUP_VALUES_VL

Payment Terms

Nav - Setup – Invoice – Payment Terms

Table Name: AP_TERMS

Period Open: -

NAV: - Accounting – Control Payables Periods

Table Name: GL_PERIOD_STATUSES

Creating Standard Invoice: -

NAV - Invoices – Entry -- Invoices

Table Name: AP_INVOICES_V

Table Name: AP_INVOICE_DISTRIBUTIONS_V

View Accounting: -

NAV: - Tools – View Accounting

Table Name: XLA_AEL_SL_V

View Accounting: -

NAV: - Tools – View Accounting

Table Name: XLA_AEL_SL_V

Holds: -

1.User Defined holds

2.System Defined holds

User Defined Holds: -

Holds All Payments

Holds Unvalidated Invoices

Holds Unmatched Invoices

User Defined holds can rectified using Action 1 Button

System Defined Holds: -

It occurs in two ways

1. If invoice exceeds invoice limit.

2. When Distribution amount does not match to invoice amount.

These can rectify only when the condition is resolve.

Creating Freight Invoice: -

Setup: -

1.Enable fright in payable options in invoice tab and Map Fright Account

Path: - Setup – Options – Payables

2. Enter invoice for fright

Nav: - Invoices – Entry -- Invoices

Table Name: AP_INVOICES_V

Table Name: AP_INVOICE_DISTRIBUTIONS_V

View Accounting: -

Nav: - Tools – View Accounting

Cancel Invoice: -

Foreign Currency Invoice: -

Setup: -

1.Enable Foreign Currency

Nav: - Setup – Currency – Define

Table Name: FND_CURRENCIES_VL

2.Conversion Rate

Nav: - Setup – Currency – Rate – Daily

Table Name: GL_DAILY_RATES_V

3.Enable allow multiple currencies in payable options in currency tab

Nav: - Setup – Options – Payable

Table Name: AP_SYSTEM_PARAMETERS

4.Enable Invoice for foreign currencies

Nav: - Invoices – Entry – Invoices

View Accounting: -

Nav: - Tools – View Accounting

Distribution Set: -

1. Define Distribution set

Nav: - Setup – Invoice – Distribution Set

Table Name: AP_DISTRIBUTION_SET_LINES

2. Enter Invoice for Distribution Set

Nav: - Invoices – Entry – Invoices

View Accounting: -

Nav: - Tools – View Accounting

Debit Memo: -

Nav: - Invoices – Entry – Invoices

Table Name: AP_INVOICES_V

Credit Memo: -

Nav: - Invoices – Entry – Invoices

Mixed Invoice: -

Nav: - Invoices – Entry – Invoices

Expense Report Invoice: -

Setup: -

1. Define Employee Suppliers

Nav: - Suppliers – Entry

Table Name: AP_VENDORS_V

Table Name: AP_VENDOR_SITES_V

2. Enter Expense Report Invoice

Nav: - Invoices – Entry – Invoices

Table Name: AP_INVOICE_DISTRIBUTIONS_V

Taxes: -

Nav: - Setup – Tax -- Codes

Table Name: AP_TAX_CODES

Allow Withholding Tax Invoice: -

Setup: -

1. Define Tax Authority Suppliers

Nav: - Suppliers – Entry

1. Define Special Calendar

Nav: - Setup – Calendar – Special Calendar

Table Name: AP_OTHER_PERIODS

1. Define Special Tax Code and Rate

Nav: - Setup – Tax – Codes

BANK: -

Nav: - Setup – Payment – Banks

Table Name: AP_BANK_BRANCHES

Table Name: AP_BANK_ACCOUNTS

Payments: -

Independent

Batch (Automatic Payments)

Prepayment Invoice:

Setup: -

1. Create Prepayment Invoice.

Nav: - Invoices – Entry – Invoices

.Enter Standard Invoice.

Nav: - Invoices – Entry – Invoices

Interest Invoice:

Setup: -

1. Enable allow interest invoice at supplier header level in payment Tab.

Nav: - Suppliers – Entry

1. Define Interest Rates.

NAV: - Setup – Payment – Interest Rates

Table Name: AP_INTEREST_PERIODS

1. Enable allow interest invoice at payable options in Interest Tab..

NAV: - Setup – Options -- Payables

Table Name: AP_SYSTEM_PARAMETERS

1. Enter Invoice for interest invoice.

NAV: - Invoices – Entry – Invoices

PO Default Invoice and Quick Match Invoice : -

Setup: -

1.Create Employee or Buyer in System Administrator

NAV: - Security – User – Define

Table Name: FND_USER

1. Create Purchase Order in Purchasing

Nav: - Purchase Orders -- Purchase Orders

3.Create Invoice in AP and Match with PO

Nav: - Invoices – Entry – Invoices

Table Name: XLA_AEL_SL_V

Batch Payments: -

Nav: - Payments – Entry – Payment batches

Table Name: AP_INV_SELECTION_CRITERIA_V