Where are we going?. Business process model data base report All accounting systems have these… BPdocumentchart of accountsjournalledgerreports BPdata modeltriggerdata entryreport. Traditional approach: separate systems for each cycle. Financing. Reporting & G/L.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Data about ALL of the various business processes
Just part of the picture
Adapted from: Numetrix Users Group meeting, 1999
An ERP can create a hierarchical, uniform organization…
An ERP can strengthen an organization’s ability to execute effective business processes…
An ERP can threaten an organization’s ability to execute an effective business strategy…Enterprise-Wide Systems
Consider the transaction captured by this source document:
What entities are involved?
What tables are needed?
Is all information accounted for?
What database rule(s) are violated?
We have created an efficient relational database thatuses foreign keys to link the tables:
Business activity to business information
“The material is hard to envision due to the fact that most of it is hopeful thinking as to future developments. Why do accountants need this really?”
“Building accurate databases requires a great deal of careful planning and design before you even sit down at a computer.”
A set of
Call on Customer
Take Cust. Order
Plus: Many-to-Many Relationships
Customer No., Employee No.
Date of Sale, Time of Sale,
Cash Rect. No.
Employee No., Customer No.,
Receipt Date, Receipt Time,
Total Amount of Receipt
Description, List Price
Bank, Type of Account
Customer Name, Customer
Address, Customer Phone
Employee Name, Employee
Address, Employee Phone,
Sale No, Item No.