ERP on Oracle Financials

The author's institution has a degree program in accounting information systems and the authors believed that it was critical that enterprise resource planning (ERP) skills and applications be included in order to maintain the currency of the program. Although difficulties were expected, the authors nonetheless pursued various classroom ERP alternatives and ultimately chose Oracle. This paper reports on those efforts, which culminated in the design and implementation of an ERP Oracle financial applications class in a short time period. Specific course content is presented.


Course Outline


Sales Module

Creation of Salesman /Customer Group /Terms of payment
Price list /Sales Promotion /Credit Control Rule
Sales Quotation /Sales Order Setup
Delivery Note Setup/Invoice Setup


Purchase Module

Creation of Supplier Codes/ Supplier Master
Purchase Order Setup/ Shipment Advice Setup


Accounts & Finance

Company Master /Division /Department Update
Chart of Account grouping /Main Account Master
Currently Master Update/ MIS Report
Bank Reconciliation


Stock

Creation of Item Master/ Item Group
Item Code/ Store location, Expense Codes
Stock Adjustment /Reason Codes


Inventory

Bill of Material / Job Expense Code


Reporting

Statement of payables / Creditors Aged analysis
Suppliers invoice Received but not settled
Direct Payment List /Statement of Receivables
Debtors Aged Analysis/PDC on hand
PDC to be Banked