Oracle Payables Setups 11i
I
n this chapter you will learn the key setups that are required to
configure the Oracle Payables application
Author: Zain Aziz Creation Date: Mar 20th, 2009 Last Updated: Mar 20th, 2009
Define Chart of Accounts (N) General Ledger > Setup > Financials > Flexfields > Key > Segments
Query (F11)
Enter Information: Application: General Ledger Flexfield Title: Accounting Flexfield
Execute Query (CTRL+F11)
Enter Information:
Code: ARAF Title: Arshiya Accounting Flexfield
(B) Segments
Enter Information: Number: 1 Name: Company Window Prompt: Company Column: SEGMENT1 Number: 2 Name: Department Window Prompt: Department Column: SEGMENT2 Number: 3 Name: Account Window Prompt: Account Column: SEGMENT3
Save Record (B) Flexfield Qualifiers
repeat for each segment. For Ex: Department = Cost Center Segment, and Account = Natural Account Segment
(B) Value Set
Enter Information: Value Set Name: ARAF Company Description: Arshiya Company List Type: List of Values Security Type: No Security Format Type: Char Maximum Size: 2 Validation Type: Independent
Save Record (B) New
Enter Information:
Value Set Name: ARAF Department Description: Arshiya Department List Type: List of Values Security Type: No Security Format Type: Char Maximum Size: 3 Validation Type: Independent
Save Record (B) New
Enter Information: Value Set Name: ARAF Account Description: Arshiya Account List Type: List of Values Security Type: No Security Format Type: Char Maximum Size: 4 Validation Type: Independent
Save Record
Assign Value Set
Enter Information: Company = ARAF Company Department = ARAF Department Account = ARAF Account
Save Record Populate the Chart of Accounts (N) General Ledger > Setup > Financials > Key > Values
Enter Information Application: General Ledger Title: Accounting Flexfield Structure: Arshiya Accounting Flexfield
(B) Find
Enter Company Values Value: 01 Translated Value: 01 Description: United States (HQ) Value: 02 Translated Value: 02 Description: Canada Value: 03 Translated Value: 03 Description: India Value: 04 Translated Value: 04 Description: England
Click Accounting Flexfield and Press down Arrow to go to Next Record
Enter Department Values Value: 100 Translated Value: 100 Description: Finance Value: 200 Translated Value: 200 Description: Information Technology Value: 300 Translated Value: 300 Description: Research and Development Value: 400 Translated Value: 400 Description: Human Resources
Save Record Go to next record “Account”
Enter Account Values Parent Values: Value: 1000 Translated Value: 1000 Description: Asset Value: 2000 Translated Value: 2000 Description: Liability Value: 3000 Translated Value: 3000 Description: Expense Value: 4000 Translated Value: 4000 Description: Income Child Values: Value: 1100 Description: Cash Value: 2100 Description: Accounts Payable Value: 3100 Description: Travel Value: 4100 Description: Revenue
Select ‘Asset’ (B) Define Child Ranges
Enter Range From: 1100 To: 1100
Save Record Close window and Compile Hierarchy
(B) Ok
Define Accounting Calendar (N) General Ledger > Setup > Financials > Calendar > Accounting
Define Accounting Calendar Periods
Define Set of Books (N) General Ledger > Setup > Financials > Books > Define
Enter Information: Sets of Books: Arshiya (USA) Short Name: AUSA Chart of Accounts: Operations Accounting Flex Functional Currency: USD Calendar Name: Accounting Calendar Future Periods: 1 Period Types: Month (T) Closing Enter Information: Retained Earnings: 01-000-3310-0000-000 Translation Adjustment: 01-000-3500-0000-000
(T) Journaling
Enable / Disable Information: Balance Intercompany Journal: Journal Approval: Enabled Journal Entry Tax: Enabled Suspense: 01-000-2990-0000-000 Rounding Differences: 01-000-7862-0000-000 (T) Multiple Reporting Currencies Enable Information: Set of Books Type: Primary Set of Books
Save Record
Assign Set of Books to Responsibilities (N) System Administrator > Profile > System
Enter Information Responsibility: Payables, Arshiya (USA) Profile: GL Set of Book Name
(B) Find
Enter Information GL Set of Books Name: Arshiya (USA)
Save Record
Define Payment Terms (N) Payables > Setup > Invoice > Payment Terms
Enter Information:
Name: NET 30 Description: Due in 30 Days Cut-off Day: 10 % Due: 100
Save Record
Define Invoice Tolerances (N) Payables > Setup > Invoice > Tolerances
Enter Information:
Name: Arshiya Tolerance Description: Purchase Order Matching Tolerances Type: Goods Ordered: 5% Received: 5% Price: 10% Max Ship Amount: 500,000 Max Total Amount: 1,000,000.
Save Record
Define Invoice Hold and Release Names
(N) Payables > Setup > Invoice > Hold and Release Names
Enter Hold Information: Name: Amount Description: Invoice amount exceeded limit Type: Invoice Hold Reason Accounting Allowed: Yes Manual Release Allow: Yes
Enter Hold Release Information Name: Reduced Amount Description: Invoice amount lowered Type: Invoice Release Reason Accounting Allowed: No Manual Release Allowed: Yes
Save Record
Distribution Sets (N) Payables > Setups > Invoices > Distribution Sets
Enter Information: Name: Arshiya (Full) Description: Arshiya Full Distribution Set Num: 1 %: 90 Account: 01-000-3015-0000-000 Description: Item Num: 2 %: 10 Account: 01-000-2560-0000-000 Description: Tax
Save Record
Define Financial Options (N) Payables > Setups > Options > Financials
(T) Supplier – Entry
(T) Supplier – Payables
(T) Supplier – Purchasing
(T) Encumbrance
(T) Tax
(T) Human Resources
Define Payables Options (N) Payables > Setups > Options > Payables
(T) Transfer to GL
(T) Payment Accounting
(T) Currency
(T) Supplier
(T) Invoice
(T) Matching
(T) Interest
(T) Expense Reports
(T) Payment
(T) Invoice Tax
(T) Withholding Tax
Define Payment Programs (N) Payables > Setup > Payment > Payment Programs
Enter Information Name: Arshiya Build Payment Program Type: Build Payments Registered Name: APXPBBLD
Name: Arshiya Format Payment Program Type: Format Payments Registered Name: APXPBFOR
Save Record
Define Payment Formats (N) Payables > Setups > Payment > Formats
Enter Information Payment Format: Arshiya Payment (USD) Payment Method: Check Number of Invoices: 50 Build Payments: Arshiya Build Payment Program Format Payments: Arshiya Format Payment Program
Save Record
Define Bank Accounts (N) Payables > Setup > Payment > Banks
Enter Information: Name: Wells Fargo Alternate Name: Wells Fargo Number: 12345678 Name: Wells Fargo – 94538 Alternate Name: Wells Fargo – 94538 Institution: Bank Country: United States Address: 1401 Red Hawk Blvd City: Fremont State: CA
(B) Bank Accounts
Enter Information Name: Arshiya (USA) Account Use: Internal Number: 123456789 Currency: USD Alternate Name: Arshiya (USA)
(T) Account Contact
(T) Receivables Options
(T) More Receivables Options
(T) Payables Options
(B) Payables Documents
Enter Information Document Name: Check Disbursement Type: Combined Payment Format: Arshiya Format (USD)
(T) Additional Information
Enter Information Last Used: 0 Last Available: 100
Save Record
Define Suppliers (N) Payables > Suppliers > Entry
Enter Information
Supplier Name: Ccomcast Alternate Name: Ccomcast
(B) Sites
Enter Information: Site Name: Fremont Address: 456 Red Street City: Santa Clara State: CA Postal Code: 95050 Site Uses: Pay, and Purchasing
(T) Contacts
(T) Accounting
(T) Control
(T) Payment
(T) Bank Accounts
(T) EDI
(T) Invoice Tax
(T) Tax Reporting
(T) Purchasing
Open / Close Accounting Period
(N) Payables > Accounting > Control Payables Periods
Open / Close Periods