How to Setup Use and Balance Your Ap Accrual Accounts
Introduction
For Releases 11i to 12, this presentation describes the Oracle accrual processes for periodic (expense) and perpetual (inventory) Accounts Payables Accruals, also known as uninvoiced receipts or purchase clearing accruals. Accrual integration between A/P, Purchasing, WIP, Inventory and G/L is discussed. Setup and balancing steps, implementation and conversion issues, and frequent business issues are discussed. In addition, custom reporting is also explored, with SQL examples included.
Scope of this Paper
This paper covers Release 11i, and differences with Release 12 are noted. To the extent possible, known bug fixes are identified, as of February 26, 2008, along with an explanation of how to correct improper setups.
Much of this information can be derived from the Release 11i Oracle Purchasing Reference Manual, the Receipt Accruals Topical Essay, and sections for the Accrual Reconciliation Report, Accrual Write-Off Form, and the Accrual Write-Off Report. Please note that many changes have occurred since the Oracle Reference Manuals were published. This paper is current up to Release 11.5.10.2 plus patches as noted in the paper.
Other information comes from the author’s design, development and debug experience with these accrual processes, and valuable contributions from Oracle Development teams, independent consultants and Oracle customers.
Any included SQL*PLUS scripts are deemed correct but no warranties, guarantees or other liability is assumed by the author or Douglas Volz Consulting, Inc. Please note that the SQL scripts are based on Release 11.5.10.2 and some will not run properly in a Release 12 environment. In Release 12 the A/P Accrual functionality has been substantially rewritten.
Features beyond the scope of this paper include:
▪ Use of Release 12 Subledger Accounting Rules for the purchase order distribution and A/P accrual accounts
▪ Accruals and the relationship to encumbrance accounting
For Releases 11i to 12, this presentation describes the Oracle accrual processes for periodic (expense) and perpetual (inventory) Accounts Payables Accruals, also known as uninvoiced receipts or purchase clearing accruals. Accrual integration between A/P, Purchasing, WIP, Inventory and G/L is discussed. Setup and balancing steps, implementation and conversion issues, and frequent business issues are discussed. In addition, custom reporting is also explored, with SQL examples included.
Scope of this Paper
This paper covers Release 11i, and differences with Release 12 are noted. To the extent possible, known bug fixes are identified, as of February 26, 2008, along with an explanation of how to correct improper setups.
Much of this information can be derived from the Release 11i Oracle Purchasing Reference Manual, the Receipt Accruals Topical Essay, and sections for the Accrual Reconciliation Report, Accrual Write-Off Form, and the Accrual Write-Off Report. Please note that many changes have occurred since the Oracle Reference Manuals were published. This paper is current up to Release 11.5.10.2 plus patches as noted in the paper.
Other information comes from the author’s design, development and debug experience with these accrual processes, and valuable contributions from Oracle Development teams, independent consultants and Oracle customers.
Any included SQL*PLUS scripts are deemed correct but no warranties, guarantees or other liability is assumed by the author or Douglas Volz Consulting, Inc. Please note that the SQL scripts are based on Release 11.5.10.2 and some will not run properly in a Release 12 environment. In Release 12 the A/P Accrual functionality has been substantially rewritten.
Features beyond the scope of this paper include:
▪ Use of Release 12 Subledger Accounting Rules for the purchase order distribution and A/P accrual accounts
▪ Accruals and the relationship to encumbrance accounting