ERP Systems Overview Quiz
52 Questions
9 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

Which type of controls are implemented at the time of installing the ERP?

  • Configurable controls (correct)
  • Inherent controls
  • Embedded controls
  • Processing controls

Which options are commonly known as processing controls?

  • Inherent and configurable controls
  • Configurable and embedded controls
  • Management and security controls
  • Both B & C (correct)

What is a fundamental aspect of inherent controls?

  • Ensuring Debit equals Credit (correct)
  • Mandatory third-party validation
  • Integration with external systems
  • Documentation of all procedures

What must an auditor do if they find ineffective General IT Controls (GITC)?

<p>Test the automated controls (D)</p> Signup and view all the answers

Should an auditor report deficiencies that were present in prior audit periods?

<p>Yes, they should always mention it (A)</p> Signup and view all the answers

What is the nature of the audit procedures required for companies?

<p>Both listed and unlisted companies (A)</p> Signup and view all the answers

Which term best describes a system where all modules are seamlessly connected?

<p>Integrated system (A)</p> Signup and view all the answers

In an ERP system, how many primary sets of Books typically exist?

<p>One, all (B)</p> Signup and view all the answers

Which of the following is not a possible reason why substantive procedures may not be feasible in ERP?

<p>Low level of integration (D)</p> Signup and view all the answers

Which of these best characterizes the flow of transactions in an integrated ERP system?

<p>Transactions flow between relevant modules (A)</p> Signup and view all the answers

What does an integrated Enterprise Resource Planning system imply about its modules?

<p>They are interconnected and collaborative (A)</p> Signup and view all the answers

In the context of ERP systems, what is a characteristic trait of transactions?

<p>Distributed processing is common (A)</p> Signup and view all the answers

What is implied by a 'high volume of transactions' in ERP systems?

<p>Increased complexity in audits (D)</p> Signup and view all the answers

What can be utilized to extract payroll information such as leaves available per employee?

<p>Database Queries (C)</p> Signup and view all the answers

Which of the following is not considered an element for determining the testing strategy for reports?

<p>Validation Techniques (D)</p> Signup and view all the answers

What is included in the validation of reports?

<p>All of the above (D)</p> Signup and view all the answers

Before planning to understand the types of reports, the auditor checks the ____________ of the data.

<p>Integrity (B)</p> Signup and view all the answers

When may the auditor limit test procedures to validate or test the reports?

<p>When GITC are effective (B)</p> Signup and view all the answers

Which indicative commands are used by companies in SAP to generate reports?

<p>All the above (A)</p> Signup and view all the answers

What aspect of report validation ensures that all necessary data is included?

<p>Completeness check (A)</p> Signup and view all the answers

Which of the following would NOT typically be checked for during data validation?

<p>Data Source Authentication (B)</p> Signup and view all the answers

What does NSJE stand for?

<p>Non Standard Journal Entries (D)</p> Signup and view all the answers

Where can unusual, non-recurring transactions typically be directly entered?

<p>General Ledger (A)</p> Signup and view all the answers

Estimates and impairments are generally categorized as what type of journal?

<p>Non Standard journals (D)</p> Signup and view all the answers

What should be noted while understanding IT/ERP systems that record entries?

<p>Timing of entries (A)</p> Signup and view all the answers

Which of the following are considered fraud risk factors leading to unusual transactions?

<p>All of the above (D)</p> Signup and view all the answers

In which type of entries are unusual transactions for non-recurring events typically recorded?

<p>General ledger entries (C)</p> Signup and view all the answers

What does PCI-DSS stand for?

<p>Payment Card Industry Data Security Standard (D)</p> Signup and view all the answers

Which of the following best describes non-standard journal entries?

<p>Entries for unusual or irregular transactions (A)</p> Signup and view all the answers

What could lead to non-standard journal entries besides impairments?

<p>One-time extraordinary events (C)</p> Signup and view all the answers

Which of the following is NOT a key aspect of SA 300?

<p>Evaluating the audit evidence (D)</p> Signup and view all the answers

Which of the following standards is related to assurance engagements?

<p>ISAE (D)</p> Signup and view all the answers

What area does PCI-DSS primarily address?

<p>Security of payment card information (D)</p> Signup and view all the answers

Which of the following terms is associated with ISAE?

<p>Assurance Engagements (C)</p> Signup and view all the answers

Payment Card Industry Data Security Standard is developed to ensure what?

<p>Protection of cardholder data (D)</p> Signup and view all the answers

How does ISAE benefit auditors?

<p>By establishing overall audit objectives (C)</p> Signup and view all the answers

Which of the following is part of the goals of PCI-DSS?

<p>To secure payment processing systems (C)</p> Signup and view all the answers

The main focus of SA 300 is primarily on which aspect?

<p>Planning the audit strategy (D)</p> Signup and view all the answers

What must be tested annually for completeness and accuracy?

<p>Custom reports (A)</p> Signup and view all the answers

Who needs to be verified by the auditor when testing custom reports?

<p>Authorized users (D)</p> Signup and view all the answers

What should be verified if changes occurred to a custom report before an audit?

<p>Approval of changes (D)</p> Signup and view all the answers

What type of access do users with critical business activity capabilities have in an ERP?

<p>Sensitive Access (D)</p> Signup and view all the answers

What is the purpose of segregation of duties?

<p>To prevent conflicts of interest (D)</p> Signup and view all the answers

What generally defines the relationship between ERP roles and users?

<p>Many to many (D)</p> Signup and view all the answers

What group typically consists of regular employees who perform daily tasks in an ERP?

<p>Normal Users (C)</p> Signup and view all the answers

What represents a designation within a company and not an individual?

<p>Roles (C)</p> Signup and view all the answers

What type of errors may occur when deficiencies are present in a tested report?

<p>Significant reporting errors (D)</p> Signup and view all the answers

What distinguishes privileged users in an ERP system?

<p>Extensive access (D)</p> Signup and view all the answers

Internal users of the ERP system that perform automated operations are known as?

<p>System Users (D)</p> Signup and view all the answers

What kind of users do not belong to the company?

<p>External Users (D)</p> Signup and view all the answers

What is an effective access control feature in an ERP?

<p>All of the above (D)</p> Signup and view all the answers

What are controls established to manage data manipulation in the context of databases?

<p>Effective controls (B)</p> Signup and view all the answers

Flashcards

What type of companies require audit procedures?

Audit procedures are mandatory for both listed companies and unlisted companies that have an integrated enterprise resource planning (ERP) system.

What is an integrated ERP system?

An integrated enterprise resource planning (ERP) system is a software system that seamlessly connects all business modules (e.g., finance, inventory, sales) and ensures a smooth flow of transactions across the organization.

How do transactions flow in an ERP system?

In an ERP system, all transactions are recorded in one primary set of books, which serves as the single source of truth for financial information. These transactions are then distributed and processed across various modules based on their nature and destination.

Why may substantive procedures be difficult in an ERP system?

Substantive procedures, a crucial part of auditing, might not be feasible in an ERP system due to factors like the distributed nature of transactions, outsourced functions, or the sheer volume of transactions processed by the system.

Signup and view all the flashcards

What are substantive procedures in an audit?

Substantive procedures are audit procedures designed to obtain sufficient appropriate audit evidence to detect material misstatements at the assertion level. These procedures involve examining the substance of transactions and balances to verify their accuracy.

Signup and view all the flashcards

How does the distributed nature of transactions impact audits?

The distributed nature of transactions in an ERP system means that data is spread across multiple modules and systems, making it difficult to track and verify the flow of transactions during an audit.

Signup and view all the flashcards

How do outsourced functions impact audits in an ERP?

Outsourced functions, common in modern organizations, can complicate audits in an ERP system because external service providers may handle key processes, making it challenging to obtain sufficient evidence about their operations.

Signup and view all the flashcards

How does transaction volume impact audits?

The sheer volume of transactions processed by an ERP system can overwhelm auditors, making it a logistical challenge to obtain sufficient evidence about the accuracy and completeness of all transactions.

Signup and view all the flashcards

Inherent controls

Controls that are built into a system during the design and development phase.

Signup and view all the flashcards

Configurable controls

Controls that can be modified or configured by the user after the system is implemented.

Signup and view all the flashcards

Processing controls

Controls that are part of the day-to-day operations of an organization.

Signup and view all the flashcards

Testing Inherent controls

The auditor must test automated controls closer to the balance sheet date if they are found to be ineffective.

Signup and view all the flashcards

Mentioning Deficiencies

The auditor must mention any control deficiencies found in prior audit periods.

Signup and view all the flashcards

What does ISAE stand for?

International Standard on Assurance Engagements (ISAE) is a set of globally recognized standards providing guidance for assurance engagements, helping to build trust in financial reporting and other information.

Signup and view all the flashcards

What does PCI DSS stand for?

The Payment Card Industry Data Security Standard (PCI DSS) is a set of security standards designed to protect cardholder data during payment transactions. It's mandatory for all organizations that process, store, or transmit credit card information.

Signup and view all the flashcards

SA 300 - What is it about?

SA 300 is a standard issued by the International Auditing and Assurance Standards Board (IAASB) that provides guidance for auditors when planning and performing an audit of financial statements. It focuses on setting the overall audit strategy and the auditor's responsibilities.

Signup and view all the flashcards

What are the main aspects of SA 300?

The key areas of SA 300 include: understanding the entity and its environment, assessing the risks of material misstatement, and designing and performing audit procedures to obtain sufficient appropriate audit evidence.

Signup and view all the flashcards

What can be used to extract payroll information?

Database queries can be used to extract specific information from a database, such as payroll data like available leaves per employee.

Signup and view all the flashcards

What does validating a report involve?

Validation of reports involves assessing the accuracy of data, the logic used, and the completeness of information to ensure the reliability of the report.

Signup and view all the flashcards

What needs to be checked before validating reports?

The auditor needs to check the integrity of data before planning to understand the types of reports and the validation process. Integrity ensures data is accurate, consistent, and reliable.

Signup and view all the flashcards

When can the auditor limit report validation?

The auditor might limit the validation procedures when the controls in business processes or the General IT Controls (GITC) are effective. This means the internal controls are working well.

Signup and view all the flashcards

When can the auditor limit report validation?

The auditor might limit the validation procedures when the controls in business processes or the General IT Controls (GITC) are effective. This means the internal controls are working well.

Signup and view all the flashcards

What commands can be used to generate reports in SAP?

SE16, SE16N, and SA38 are some common commands in SAP that can be used to generate reports. These commands provide access to data and tools for reporting.

Signup and view all the flashcards

Substantive Audit Procedures

Tests designed to evaluate the accuracy and completeness of reports generated by an ERP system.

Signup and view all the flashcards

Customised Reports

Reports created by company personnel for internal use and reporting purposes.

Signup and view all the flashcards

Authorized Users

Users who are authorized to create or modify custom reports in an ERP system.

Signup and view all the flashcards

Appropriate Approvals

Verification that changes made to custom reports are approved through proper channels.

Signup and view all the flashcards

Database Queries

Reports pulled on an as-needed basis in response to specific requirements.

Signup and view all the flashcards

Data Manipulation

The potential for data manipulation after a report is created.

Signup and view all the flashcards

Effective GITC's

The effectiveness of controls across all domains of an ERP system.

Signup and view all the flashcards

Non-Standard Journal Entries

Unusual, non-recurring transactions that are not part of regular business operations. These transactions might be infrequent and often require special attention.

Signup and view all the flashcards

Standard Journal Entries

Entries that are directly related to the company's core business operations and happen regularly. These are typically well-defined and follow standard procedures.

Signup and view all the flashcards

Timing of Report Testing

The criteria for determining the timing of report testing.

Signup and view all the flashcards

One Sample in Each Scenario

A sampling procedure where one sample is selected from each scenario or domain.

Signup and view all the flashcards

Intercompany Transactions

Transactions that happen between different companies or departments within the same organization. It's important to carefully track these transactions to ensure accuracy.

Signup and view all the flashcards

Audit Procedures

The process of verifying that accounting entries are accurate and complete. This may involve reviewing source documents, reconciling balances, and analyzing transactions.

Signup and view all the flashcards

Types of Errors

The types of errors that may occur when deficiencies are found in reports.

Signup and view all the flashcards

Sensitive Access

The ability of a user to perform critical business actions in the ERP System.

Signup and view all the flashcards

Fraud Risk Factors

Factors that increase the risk of fraudulent activity. These factors can relate to internal or external pressures, a lack of internal controls, or opportunities for manipulation.

Signup and view all the flashcards

Users with Sensitive Access

Users with high-risk business activities that can have a wide impact on operations.

Signup and view all the flashcards

Internal Controls

Procedures that are designed to prevent or detect errors in financial reporting. These controls can include internal checks, audits, and segregation of duties.

Signup and view all the flashcards

Segregation of Duties

The separation of job duties to prevent conflicts of interest.

Signup and view all the flashcards

ERP Systems

Software systems that integrate all aspects of a business, such as finance, inventory, and sales. This can help improve efficiency and control.

Signup and view all the flashcards

Non-Standard Transactions

Transactions that are not related to the company's core business operations. These transactions may be unusual or infrequent and require special attention.

Signup and view all the flashcards

Normal Users

Users who perform daily business operations and transactions in an ERP system.

Signup and view all the flashcards

Previleged Users

Users with a high level of access and privileges within the ERP system.

Signup and view all the flashcards

Signup and view all the flashcards

Study Notes

ERP Systems

  • ERP systems (Enterprise Resource Planning) are integrated management systems encompassing various business functions.
  • Examples include SAP and Oracle.

Internal Control Risk Assessment (SA 315)

  • Auditors aim to identify and assess material misstatement risks, including fraud.
  • Understanding the entity and internal control environment, including relevant information systems.
  • Auditor's responsibility is to design and implement responses in audit procedures in response to SA315.
  • Assessing the effectiveness of internal controls for reporting.

Governance Framework

  • The business team is the owner of data residing within application.
  • Ownership is transferred to the IT team in charge of application
  • Communication channels are crucial between Chief Information Officer and Chief Financial Officer for effective data management

Automated Environment Risks

  • Automated environments present numerous risks due to the complexity and interconnectedness of applications.
  • Risks are influenced by the number and location of applications within the system.

Reporting from ERP Systems

  • Standard generated reports are provided by ERP systems to businesses
  • Customised reports are developed for business use within the ERP system.
  • Database queries are used to retrieve information in a structured format from the database.

Controls in ERP

  • Inherent controls ensure the accuracy, completeness, and validity of transactions, present in ERP.
  • Configurable controls are those implemented during ERP installation in an organization.
  • Input controls are the first point of control within ERP.

Sensitive Access and Segregation of Duties (SOD)

  • Sensitive access in an ERP system grants extensive or unrestricted access to carry out various activities.
  • Role-based access control (RBAC) involves grouping related access rights into roles for streamlined user management.
  • Segregation of Duties is the distribution of job roles among employees to avoid conflicts and ensure accountability.

User Roles and Access

  • Normal users perform daily operations within the ERP system.
  • System users execute automated operations and transactions.
  • Privileged users possess extensive or unlimited access for key activities.
  • Default users come embedded with the ERP software
  • Generic users are positions or designations, not specific people
  • Temporary users are granted access for a limited time.
  • External users represent individuals/entities outside the company
  • Multiple roles and users can interact in a "many-to-many" relationship.

User and Access Control Deficiencies

  • Auditors must document and report control deficiencies to management, following standards.
  • The deficiencies relating to user access controls should be evaluated in order to understand the impact of the deficiencies on audit.
  • Understanding the business environment and IT environment is a crucial starting point for audits on segregation of duties.
  • The business rules for the implementation and review of SOD and sensitive access should focus on the company rules, policies and procedure.

ERP Migration and Data Procedures

  • ERP migration involves planning, system design, data conversion/configuration, testing, and go-live stages.
  • Rollback procedures are for managing potential errors during the process.
  • During migration, sensitive access, SOD, and related controls must be considered.
  • Internal auditors can provide valuable experience regarding ERP changes.
  • Documentation is essential to effectively manage any ERP implementation.

Financial Data Records (Journal Entries)

  • Standard journal entries record regular transactions.
  • Non-standard journal entries capture unusual and non-recurring transactions, adjustments, and corrections.
  • Non-standard entries are often not subject to normal internal controls.
  • The extraction and analysis of JE data can be enhanced using software scripts.

Query Creation and Usage in ERP

  • Subqueries can be used within queries to filter specific output values.
  • Access uses a variety of queries ranging from simple to complex, capable of extracting aggregated results.
  • Joins in Access can connect data from different tables.
  • Aggregate functions summarise numerical values.
  • A wide arrange of filters are available for further refinement.

Working with and Summarizing Data

  • Using Pivot Tables helps users quickly summarize and analyze data in a spreadsheet.
  • Calculations can be run on existing data using expressions and functions.
  • Conditional formatting highlights cells containing specific values, a powerful method to track and refine data during analyses.

Statistical and Probability Concepts

  • Benford's Law is useful for identifying potential data irregularities when a specific numerical pattern appears significantly off from the expected value.
  • Hypothesis testing involves comparing observed data to a predicted outcome, using calculated probabilities to determine whether to accept or reject those probabilities.
  • Statistical analysis is crucial for drawing meaningful conclusions from data sets.

Data Mining and Warehousing

  • Data Mining is used to uncover patterns from a database.
  • Data Warehousing is a repository for storing and organizing historical data, for analysis.
  • OLAP is the technique and tool to query complex multi-dimensional databases.
  • Operational Data Stores are used for detailed data for processes.

Accounting and Financial Concepts

  • Financial Planning involves establishing financial targets.
  • Depreciation is the accounting process for spreading the cost of using an asset over its useful life.
  • Cash budgets and capital budgeting are used to manage and model monetary flow in a business.
  • Various financial ratios help in comparison analysis.

Excel Functions

  • Specific Excel functions are used to generate and manage financial/accounting data
  • Excel functions help in performing various calculations on financial data.
  • There are tools in Excel suited for various data management activities.

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

Quiz Team

Related Documents

ADV Sample Question-split PDF

Description

Test your knowledge on Enterprise Resource Planning (ERP) systems with this quiz. Explore key concepts such as controls, audit procedures, and transaction characteristics within ERP environments. Ideal for students and professionals looking to enhance their understanding of ERP.

Use Quizgecko on...
Browser
Browser