Procure to Pay | Order to Cash | ERP | Application Controls | |
---|---|---|---|---|
blanket and individual
Blanket: allow vendors to make multiple deliveries over time Individual: one-time order
The two types of purchase orders and the difference between the two
|
document the carrier gives to the seller to acknowledge receipt of goods for shipment. Purpose is to transfer title of goods from seller to buyer.
Define bill of lading
|
Oracle
SAP Microsoft IBM
Name the main vendors
|
Manual: performed without assistance from application or automated systems
Automated: programmed and embedded into applications Configurable: automated controls that have a specific configuration Hybrid: combination of automatic and manual
4 types of application controls
|
1. develop algorithm
2. implement algorithm through code 3. usage
3 steps of traditional programming
|
the purchase order, receiving reports, and vendor's invoice
These documents are used in a 3-way match
|
Packing slip
A P_ cking slip is sent to the customer.
|
Cloud
On-Premise Hybrid
What are the different Implementation models?
|
Schema on read: you write to the data store and then figure out how you want to organize it later
Schema on write: to write to the data store, you need to adhere to the predetermined schema
Schema on write vs. schema on read
|
Process
Decision Repetition
3 algorithm constructs
|
open purchase order
This authorizes the receipt of goods
|
open sales order
What authorizes fulfillment?
|
2 tier
1. Client 2. Server 3 tier 1. Client 2. Server 3. Database
Difference between 2 and 3 (multi) tier ERP architecture.
|
Completeness
Accuracy Validity Authorization Timely
Objectives?
|
housing both data (values) and algorithm instructions (code) within a single object. AKA object holds both properties and methods.
Define object oriented programming
|
Cash management module
Bank Inventory management or SCM system Vendor GL
Name 2 external data sources in P2P process
|
P2P Module
Production module Carrier SCM module Customer GL Credit card or other fund transfer company Bank
Name 2 external data sources in OTC process
|
the initially come without controls enabled that management and auditors would want to see
Why do all ERP systems contain vulnerabilites?
|
Hash
Financial Record count
Batch totals
|
Do while loop: condition is at the top (0:M)
Do loop while: condition is at the bottom (1:M)
Do while loop vs. do loop while
|
1. Identify need and create purchase request
2. Order goods/services 3. Process receipts 4. Recognize liability 5. Pay for purchases
5 Information Processes
|
1. Process quote requests
2. Process sales orders 3. Processing picking and shipping 4. Bill customer 5. Record cash collection
5 information processes
|
Master Files: contain master data. More static than transaction files.
Transaction Files: contain data that describe actions of a business – bulk of day to day transactions. Constantly changing. Reference Files: might need to reference when performing the business process. Suspense Files: await some action. Also known as “Tickler” files. Here you would see exception and exception reporting. Archive Files: For storage. Contain files and metadata.
5 files types - define
|
Business: Activities @ wrong time, wrong resource (amount), wrong location, without authorization.
Information: recording, maintaining, and reporting risks associated with DATA
Business risks vs information risks
|
VB/VBA: functions, subs, event handlers
Python: Only functions
How do we write code in VBA/VB vs in python?
|