Setup Configuration
1. System Options
2. Territory KeyFlexfield (Optional)
Customer
1. Profile Classes
2. Customer
3. Customer Accounts
4. Customer Sites /Addresses
5. Party merge
Transaction
1. Auto Accounting
2. Payment Terms
3. Transaction Types
4. Transaction Sources
5. Standard memo lines
6. Approval Limits
7. Territories
8. Accounting Rules
9. Auto Invoices
a. Grouping Rules
b. Line Order Rules
Types of Transactions
1. Standard Invoice
2. Debit Memo — Increase Customer Amount
3. Credit Memo
4. Deposits – Advances
5. Guarantee — Sales Forecasting
6. Charge Backs — Reschedule payments
Bills in Advance
unearned revenue
Jan:
Receivable Account DR 1000
Revenue 500
Unearned Revenue 500
Feb:
Unearned Revenue DB 300
Revenue 300
Mar:
Unearned Revenue DR 200
Revenue 200
Bills in Arrears
Unbilled Receivables
Mar:
Receivables DR 1000
Revenue 500
Unbilled Receivable 500
Jan
Unbilled Receivables Dr 300
Revenue 300
Feb
Unbilled Receivables Dr 200
Revenue 200
Setup
1. Define Period Types
2. Define Accounting Rules
3. Create Transactions
What Occurs During AutoInvoice
1. SQL Loader Program populates the 3 interface tables with
lines, sales credit and accounting information
2. BFB payment terms are validated
3. Lines are ordered and grouped
4. Legal entities are assigned to transactions
5. Tax is calculated
6. GL date is determined
7. GL accounts are assigned using Auto Accounting, where necessary
8. Tax, freight, commitments and credit memos are lined to transaction lines
9. All transactions are batched
10. Validated lines create the transactions
Auto Invoice
RA_Interface_errors_all –> All errors are stored in this table while running Auto Invoice
AutoInvoice Interface Tables
RA_INTERFACE_LINES_ALL
RA_INTERFACE_DISTRIBUTIONS_ALL
RA_INTERFACE_SALESCREDITS_ALL
Grouping Rules Hierarchy
.. Assign Grouping Rules to :
1. Transaction Batch Sources
2. Customer Profile Classes
3. System Options
Hierarchy to Determine Grouping Rule to use:
1. Transaction Batch Source
2. Customer Profile Classes
3. System Options
AutoInvoice Validation
Checks lines for : Accounting Rules and Accounting Periods
Checks Interface Table with those in Receivables for:
1. Existence
2. Batch Sources
3. Uniqueness
4. Precision
5. Cross Validation
AutoInvoice Reports
1. AutoInvoice Execution Report: Review AutoInvoice Results
2. AutoInvoice Validation Report: Review lines that failed validation
Receipts Setups
—————
1. Receivable activities
2. Receipt Class
3. Receipt Methods
4. Bank Account
5. Receipt Sources
6. Distribution Sets
7. Bank and Branches
8. Auto Lock Box
a. Application Rule Set
b. Auto Cash Rule Set
9. Collection
System Profile Options for Receivables
1. AR: Receipt Batch Source
2. AR: Transaction Batch Source
Bank Charges
————-
Profile Option: AR: Create Bank Charges
AP / AR Netting
===============
AT Transaction
Receivable A/C
Revenue A/C
Cash A/C
Receivables A/C
AP Invoice
Exp Account
To Liab/Pyabables
Payment–>
Payables
Netting A/c
AR
Netting A/C
Receivables
Setup Required for AR/AP Netting
1. Create a GL Account Netting Control A/C
2. Create a dummy/bank account AP/AR Netting Account
3. Configure AP/AR Receipt Class
4. Create Netting Agreement
5. Create a Netting Batch
