transaction processing & enterprise resource planning systems

Principles of Information Systems, Sixth Edition

Transaction Processing & Enterprise Resource Planning Systems

Chapter 9

Principles of Information Systems, Sixth Edition

An Overview of Transaction Processing Systems

Principles of Information Systems, Sixth Edition

TPS, MIS/DSS, and Special Information Systems

Principles of Information Systems, Sixth Edition

Traditional Transaction Processing Methods & Objectives

• Batch processing systems• On-line transaction processing (OLTP)• On-line entry with delayed processing• Process data generated by and about transactions• Process data generated for and about transactions• Maintain a high degree of accuracy and integrity• Produce timely documents & reports

Principles of Information Systems, Sixth Edition

Traditional Transaction Processing Methods & Objectives

• Increase labor efficiency• Help provide improved service• Help build and maintain customer loyalty• Achieve competitive advantage

Principles of Information Systems, Sixth Edition

Batch versus On-Line Transaction Processing

Principles of Information Systems, Sixth Edition

Integration of a Firm’s TPSs

Principles of Information Systems, Sixth Edition

Examples of Transaction Processing

Principles of Information Systems, Sixth Edition

Transaction Processing Systems

Principles of Information Systems, Sixth Edition

Transaction Processing Activities

• Data collection– Should be collected at source– Should be recorded accurately, in a timely

fashion

• Data editing

• Data correction

Principles of Information Systems, Sixth Edition

Document Production and Reports

Principles of Information Systems, Sixth Edition

Control & Management Issues

• Business resumption planning• Disaster recovery

– Backups

Principles of Information Systems, Sixth Edition

Transaction Processing Audit

• Does the system meet its business requirements?

• Are there procedures and controls? • Are the procedures & controls properly used?

Principles of Information Systems, Sixth Edition

Order Processing Systems

• Order entry• Sales configuration• Shipment planning• Shipment execution• Invoicing• Customer relationship management (CRM)• Routing and scheduling• Scheduling systems

Principles of Information Systems, Sixth Edition

Document Production Reports

Principles of Information Systems, Sixth Edition

Traditional Transaction Processing Applications

Principles of Information Systems, Sixth Edition

Order Processing Systems

Principles of Information Systems, Sixth Edition

Order Processing Systems

Principles of Information Systems, Sixth Edition

Order Entry System

Principles of Information Systems, Sixth Edition

Shipment Planning

Principles of Information Systems, Sixth Edition

Inventory Status Report

Principles of Information Systems, Sixth Edition

Invoicing

Principles of Information Systems, Sixth Edition

Customer Relationship Management

Principles of Information Systems, Sixth Edition

The 15 Top-Rated CRM Software Packages

Principles of Information Systems, Sixth Edition

Purchasing Systems

• Inventory control• Purchase order processing• Receiving• Accounts payable

Principles of Information Systems, Sixth Edition

Purchasing Systems

Principles of Information Systems, Sixth Edition

Accounts Payable

Principles of Information Systems, Sixth Edition

Accounts Payable

Principles of Information Systems, Sixth Edition

Accounting Systems

Principles of Information Systems, Sixth Edition

Accounts Receivable

Principles of Information Systems, Sixth Edition

Accounts Receivable Aging Report

Principles of Information Systems, Sixth Edition

Typical Paycheck Stub

Principles of Information Systems, Sixth Edition

Payroll Journal

Principles of Information Systems, Sixth Edition

General Ledger

Principles of Information Systems, Sixth Edition

General Ledger

Principles of Information Systems, Sixth Edition

ERP Software Vendors

Principles of Information Systems, Sixth Edition

International Issues

• Different languages and cultures• Disparities in information systems infrastructure• Varying laws and custom rules• Multiple currencies

Principles of Information Systems, Sixth Edition

Enterprise Resource Planning

Principles of Information Systems, Sixth Edition

Enterprise Resource Planning

• Real-time monitoring of business functions• Supports human resources, sales, and

distribution• Accommodates the different ways each

company runs business

Principles of Information Systems, Sixth Edition

Advantages of ERP

• Eliminates costly, inflexible legacy systems• Improved technology infrastructure• Improved work processes• Increased data access for decision making

Principles of Information Systems, Sixth Edition

Disadvantages of ERP

• Expense & time• Radical change• Integrating with other systems• One vendor risks

Principles of Information Systems, Sixth Edition

ERP System

Principles of Information Systems, Sixth Edition

Business Application Programming Interface (BAPI)

Principles of Information Systems, Sixth Edition

Summary

• Transaction Processing Systems - consist of all components of a CBIS, including databases, telecommunications, and people

• Transaction Processing Systems Methods - batch, on-line, and on-line with delayed processing

• Enterprise resource planning (ERP) software - a set of integrated programs that manage a company’s vital business operations for an entire multisite, global organization