Oracle_ERP_R12_月结文档

<Insert Picture Here>

SWAT Team Training R12 Period Close and ReconciliationJoe Gum & Linda Wong, Financials Product Strategy

Agenda

Process Changes & Dependencies Close Process General Payables Receivables Assets Cash Management General Ledger

Intercompany Reconciliation Q&A

<Insert Picture Here>

Process Change Release 12

Process Change - Close11iTransactions

R12Transactions DistributionsProduct Period Close

Distributions

Balancing Lines SLA JournalsProduct Period Close

Balancing Lines GL Journals

GL Journals

GL Balances

GL Balances

Close Dependencies

InvPO AP FA

PAAR CE GL

Process Change - Reconciliation11iTransactionsTransactional Reports

R12Transactions Distributions Balancing Lines Balancing Lines SLA Journals

Distributions

GL Journals

Accounting Reports

GL Journals

GL Balances

GL Balances

<Insert Picture Here>

General Steps Release 12

Close Process – General Steps1. 2. 3. 4. 5. 6. Complete Transactions Create Accounting Reconcile Transactions Post to GL Reconcile Accounting Close Period

<Insert Picture Here>

Payables Release 12

Close Checklist - Payables1. Complete Transactionsa. Invoices On Hold Report

2. 3. 4. 5.

Approve Invoices Complete Payments Reconcile Payments/Bank Statements Resolve Potential Accounting Issues*a. Create Accounting b. Journal Entries Report c. Unaccounted Transactions Report

6. Post (GL) Payables Transactions*

Close Checklist - Payables7. Review Accounting*a. Payables Accounting Process Report b. Posted Invoices Register c. Posted Payments Register

8. Unaccounted Transactions Sweep* 9. Close Payables Perioda. Subledger Period Close Exceptions Report*

10. Accrue Un-invoiced Receipts 11. Reconcile Payables Activity to GL*a. AP Trial Balance Report* (Account definition, Data Mgr Program) b. Third Party Balances Report* c. Account Analysis Report*

12. Mass Addition Transfer to Assets

New and Improved AP Trial Balance Multiple Formats, Group By Account & Supplier. Summary & Detail. Outputs in *.pdf, *.xml Ability to rebuild the Trial Balance definition anytime New columns on the report to highlight anomalies Capture Accounting Class Code=LIABILITY only Display invoices if payments are accounted prior to invoices in AP Payment Status as of Date & CancellationDate can help catch anomalies, as shown below. At a glance, you can catch any Fully Paid/Cancelled invoice appearing in the report

AP Reconciliation Issues1. Transactions do not appear in Open Account Balances Listing report 2. Accounting does not appear in Account Analysis report 3. Cancelled invoices/payments result in errors in accounting and reports 4. Create accounting program errors 5. Transfer to GL program errors

Best Practices1. Reconcile R11i and R12 AP Trial Balance for upgraded period. 2. Include all LIABILITY accounts in Open Account Balances Report Definition. 3. Explore the Control Account feature with Third Party B

alances report. 4. Avoid reversing batches (or modifying Journals) in GL, if transferred by SLA. 5. Use Period Close Exception report prior to closing Periods in GL and reconciling to Account Analysis & Trial Balance reports. 6. Use only SLA or GL (not both) to create manual journal entries for subledger transaction corrections.

<Insert Picture Here>

Receivables Release 12