About Course
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