 |
|
|
This
page contains the working files for the "It's month
end, now comes the reconciliation crunch" case
study. You can download a zip file containing all the
working files or you can download individual files
according to your requirements. The workings mainly
consist of reports (for July 2002), extracts and screen shots
from the 11.5.9 Oracle E-Business Suite Vision instance.
Also available for download is a reconciliation summary
prepared in Excel and various Visio architecture
diagrams. To download, right hand click over
the text "PDF", "PPT",
"OTHER" or the "DOWNLOAD" button and
choose "Save Target As...." All the links and videos on this page should be working
so if you have any problems please don't hesitate to contact
me. General
| This
zip file contains the complete set of files
available for individual download on this page |
(uploading
soon) |
Reconciliation
Workings
This
Excel sheet contains a mapping template and the
reconciliation workings for Accounts Payable,
Accounts Receivable, Fixed Assets, Cash Management
and General Ledger Reconciliation.
|
XLS
(732KB) |
System
Architecture Diagrams
This
file contains various Microsoft Visio diagrams which show
how the various Oracle Financials modules interact.
|
VSD
(48KB) |
Find
Requests - Screen Shot
This
screen shot shows the Find Requests form in Oracle
Applications. This form is common to all modules
and can be used to find completed concurrent
requests, in progress requests, all requests or
requests that meet specific criteria.
|
JPG
(45KB) |
|
Submit
a new Request - Screen Shot
When
submitting a new request the user is given the
option to submit a single request or a group of
requests.
|
JPG
(21KB) |
General
Ledger
Journal
Sources Extract
Every
entry that goes into the Oracle General Ledger is
achieved through a journal. Every single journal
that is captured in the GL must have a
"source". Oracle Applications comes with
a standard list of Journal Sources and you can
also add your own journal sources to cater for
instances where you have entries coming in from
third party systems. This extract shows the
Journal Sources for the Vision 11i instance.
|
TXT
(3KB) |
Journal
Categories Extract
To
further classify journals they are given
categories. Categories give an indication of the
type of transaction that has led to the creation
of the journal. This extract shows the Journal
Categories for the Vision 11i instance.
|
TXT
(5KB) |
Chart
of Accounts Listing Report
This
report gives a detailed listing of the Chart of
Accounts in the Vision Operations 11i instance. It
lists the associated settings for each line in the
Chart of Accounts.
|
TXT
(337KB) |
Trial
Balance Report - Summary 1
Review
General Ledger actual account balances and activity
summarised by account segment value for the month
of July 2002
|
TXT
(20KB) |
|
Account
Analysis Report by Source (for July 2002)
This
report prints the journal entry lines and beginning and ending balances of
selected accounts. The above mentioned reports and extracts, together with this report were used to prepare the “Mapping Template” sheet in the Excel Workbook which contains all the reconciliation workings. The Mapping Template indicates what journal sources and categories are utilised for transaction that originate in the sub-ledgers. It also indicates what General Ledger A/C numbers are used for transactions initiated from Accounts Payable, Accounts Receivable, Fixed Assets and Cash Management.
|
TXT
(1.43MB) |
|
Set
of Books - Screen Shot
This
screen shot displays how the 3C's (Chart of
Accounts, Calendar and Currency) combine to form a
Set of Books.
|
JPG
(74KB) |
Accounts
Payable
Accounts
Receivable
Fixed
Assets
Cash
Management
|
|
|
|
