Document 218503

Copyright © DARC Corporation, 2010
1
How to Defer Invoicing / Revenue
Recognition Based on Customer
Acceptance (OM & AR)
Michelle Taylor
DARC Corporation
Copyright © DARC Corporation, 2010
2
DARC Lines of Business
• Production Support
• 24x7 Functional & Database
• Consulting Services
• Program Management, Functional, Technical,
Architecture
•
•
Organizational Change Management
Communications, Documentation, Training
•
Accelerators for Interfaces and Conversions
• Mergers & Acquisitions
• Global Consolidation
Copyright © DARC Corporation, 2010
3
Speaker’s Qualifications
•
•
•
•
•
•
•
•
Implementing Oracle Applications for over 14 years
Certified Expert Consultant, Oracle E-Business Suite R12 Supply Chain:
Order Management
Certified Implementation Specialist, Oracle E-Business Suite R12 Supply
Chain: Order Management
Certified Implementation Specialist, Oracle E-Business Suite R12 Supply
Chain: Inventory
Oracle Supply Chain Management R12.1 PreSales Specialist
Oracle Supply Chain Management R12.1 Sales Specialist
Oracle Financial Management R12.1 Sales Specialist
Certified Professional Consultant, Oracle E-Business Suite R11i Supply
Chain: Order Management
Copyright © DARC Corporation, 2010
4
Agenda
• Introduction
– Description, Benefits & Definitions
• Setup Steps
• Process Flow & Processes Review
– Acceptance Helpful Hints
• Revenue Recognition Overview
• Considerations
• Summary
Copyright © DARC Corporation, 2010
5
Description & Benefits - Customer Acceptance Based
Deferrals for Invoicing & Revenue Recognition
• Businesses have the requirement to DEFER Revenue
Recognition until receipt of a sales order shipment has been
formally acknowledged / accepted by a customer
• Benefits
– Reduce …
• Administrative Costs – Revenue Accounting Maintenance / Mgt
• Revenue Recognition inconsistencies (audit)
– Improve …
• Compliance to corporate governance regulations /
requirements
Copyright © DARC Corporation, 2010
6
Description & Benefits - Customer Acceptance Based
Deferrals for Invoicing & Revenue Recognition
• Customers have the requirement to DEFER Invoicing until they have
formally acknowledged / accepted the receipt of goods and / or
services from a sales order shipment
– Eliminates the need to manage / monitor the time lags between ship
date, transit time values & invoice date
• Benefits
– Reduce …
• Administrative Costs – AP Maintenance / Mgt (customer side)
• Administrative Costs – AR Maintenance / Mgt (vendor side)
– Improve …
• Overall customer service
Copyright © DARC Corporation, 2010
7
Definition - Acceptance Types
• Explicit Acceptance
– Can be record Manually or Programmatically
– Using the Order Information Portal (OIP) the sales order lines can be
marked as Accepted by an External or Internal (CSR) Customer
(separate setups required) to record acceptance explicitly
– Order Import / Process Orders API
– Notification if Acceptance done in AR Revenue Mgt> Revenue
Accounting form
• Implicit Acceptance
– Can ONLY be recorded Programmatically
– Revenue Contingency / Deferral Reason has to be defined with an Event
Attribute Date that has a value for Expire Days
– Implicit Acceptance Request Set – concurrent programs used to record
implicit acceptance
Copyright © DARC Corporation, 2010
8
Definition - Acceptance Deferral Types
• Pre-billing Acceptance
– Always tied to Invoicing Removal Event
• Defers Invoicing AND Revenue Recognition
– Can be Implicit or Explicit
– Sales Order Line Workflow process is held at Invoice Interface
Eligible – Pending Customer Acceptance
• Sales order line workflow status is reflected as Pending prebilling acceptance post ship confirm
Copyright © DARC Corporation, 2010
9
Definition - Acceptance Deferral Types
• Post-billing Acceptance
– Always tied to Customer Acceptance Removal Event
• Defers ONLY Revenue Recognition
– Can be Implicit or Explicit
– Sales Order Line Workflow process is held at Close Line Eligible
– Pending Customer Acceptance
• Sales order line workflow status is reflected as Pending postbilling acceptance post ship confirm
• Invoice generated but Revenue Deferred and held in the
Unearned Revenue Account until Acceptance is completed
Copyright © DARC Corporation, 2010
10
R12 Setup Steps
Copyright © DARC Corporation, 2010
11
R12 Setup Steps – Order Management
• Enable Customer Acceptance
– Customer acceptance can be enabled at OU level through OM
system parameter: Enable Fulfillment Acceptance – Y / N
– Once enabled the AR API is called to invoke the rules engine to
validate customer acceptance on every sales order line
• Enable function security within responsibilities’ menus
– Sales Orders: Fulfillment Acceptance
– Sales Orders: Update Acceptance Attributes
• Enable Folder Fields for Customer Acceptance – SO / QSO
– Order Organizers’ SOL Results tab
– Sales Order Forms Lines’ Regions - Others tab
Copyright © DARC Corporation, 2010
12
R12 Setup Steps – Order Management
• User Access to Order Information Portal (required to perform
Manual Explicit Acceptance)
– External User – Actual Customer User
– Internal User – CSR
• Otherwise Insufficient Privileges Error Message will be
displayed after clicking the Fulfillment Acceptance (B)
Copyright © DARC Corporation, 2010
13
R12 Setup Steps – Order Management – Customer
Acceptance Data Fields via Folder Tools
Copyright © DARC Corporation, 2010
14
R12 Setup Steps – Order Management – Customer
Acceptance Data Fields via Folder Tools
Copyright © DARC Corporation, 2010
15
R12 Setup Steps – Accounts Receivable /
Revenue Mgt – Create Revenue Contingencies
• Define Revenue Contingency / Deferral Reason
– Create Revenue Contingency / Deferral Reason (Acceptance
Name) via Receivables Revenue Management set ups
– Create Assignment Rule(s) to link the Revenue Contingency /
Deferral Reason (Acceptance Name) to – based on customer, site,
item, etc
Copyright © DARC Corporation, 2010
16
R12 Setup Steps – Accounts Receivable /
Revenue Mgt – Create Revenue Contingencies
Copyright © DARC Corporation, 2010
17
R12 Setup Steps – Accounts Receivable / Revenue
Mgt – Revenue Contingency Assignment Rules
Copyright © DARC Corporation, 2010
18
R12 Setup Steps – Accounts Receivable / Revenue
Mgt – Revenue Contingency Assignment Rules
• Revenue Contingency / Deferral Reason (Acceptance Name) and their related
Event Attributes can be defaulted during order creation when the AR API that
is called from OM (NOT Traditional Order Management Defaulting Rules)
─ If Enable Fulfillment has not been activated – the AR API will NOT be
called to invoke the related AR Revenue Contingency defaults EVEN IF
Assignment Rules (can be assigned to customer, site, item, etc) have been
setup
Copyright © DARC Corporation, 2010
19
Process Flow & Processes
Review
Copyright © DARC Corporation, 2010
20
Customer Acceptance Process Flow
SETUP
PROCESS
Set deferral reason(s)
in AR Revenue Mgt
Enable Fulfillment
Acceptance in OM
Acceptance attributes
can be defaulted or be
specified for SO line
Enter & Book
Sales Order
Process Acceptance
Yes
Acceptance
Required?
Automated process
Type of
Acceptance
Pre-billing
Pre or Post
Billing?
Implicit
No
Legend
Explicit
Pick Release & Ship
Confirm Material
Post-billing
AutoInvoice
creates
invoice
No
Expiration
Period past?
Yes
Process
Acceptance
(Conc Progs)
Normal Flow
(without Acceptance)
Pre-billing Flow
Post-billing Flow
Revenue Recognition
Copyright © DARC Corporation, 2010
21
Record Acceptance
(OIP/ Order Import)
R12 Process - Order to Cash
w/ Customer Acceptance
• Enter & Book orders that are subject to Customer Acceptance viewing / updating (if appl.) order line Acceptance Attributes
• Pick Release and Ship Confirm goods – view workflow line status
transition
– Pending pre-billing acceptance
– Pending post-billing acceptance
• Perform Acceptance / Rejection
– Implicit (Programmatic only) or Explicit (Manual via OIP or Order
Import / Process Order API)
• View Acceptance Details in SO line and / or in OIP> Order Status (T)
• View Invoice and Revenue Recognition acceptance related details
from AR / Revenue Mgt
Copyright © DARC Corporation, 2010
22
Pre-Billing Acceptance
with Explicit Process Description
• Pre-Billing Acceptance (Invoicing Removal Event)
– Sales Order Line in Pending pre-billing acceptance workflow status
post ship confirm
– Invoicing AND Revenue Recognition deferred
– Record Acceptance via Order Information Portal (OIP)> Order
Status (T) or Order Import/ Process Orders API [EXPLICIT]
– Line status transitions to Closed and line gets interfaced to AR
• The Acceptance Date is the Invoice Date in AR
• Could have different values for Ship Date and Invoice Date as
a result
– Invoice generation and Revenue Recognition happen consecutively
Copyright © DARC Corporation, 2010
23
Pre-Billing Acceptance
with Implicit Process Description
• Pre-Billing Acceptance (Invoicing Removal Event)
– Sales Order Line in Pending pre-billing acceptance workflow status
post ship confirm
– Invoicing AND Revenue Recognition deferred
– Record Acceptance via Implicit Acceptance Request Set - Based
on Event Attribute Expire Days data [IMPLICIT]
– Line status transitions to Closed and line gets interfaced to AR
• The Acceptance Date is the Invoice Date in AR
• Could have different values for Ship Date and Invoice Date as
a result
– Invoice generation and Revenue Recognition happen consecutively
Copyright © DARC Corporation, 2010
24
Sales Order Line BEFORE Ship Confirm
and Pre-billing Implicit Acceptance
Copyright © DARC Corporation, 2010
25
Sales Order Line AFTER Ship Confirm
but BEFORE Pre-billing Implicit Acceptance
Copyright © DARC Corporation, 2010
26
Sales Order Line AFTER Ship Confirm
but BEFORE Pre-billing Implicit Acceptance
Copyright © DARC Corporation, 2010
27
Pre-Billing Acceptance Sales Order Line
Workflow Status Diagram
Copyright © DARC Corporation, 2010
28
Post-Billing Acceptance
with Implicit Process Description
• Post-Billing Accept. (Customer Acceptance Removal Event)
– Sales Order Line in Pending post-billing acceptance workflow status post
ship confirm
– Invoice is generated in AR Revenue is held in Unearned Revenue
account – ONLY Revenue Recognition deferred
– Record Acceptance via Implicit Acceptance Request Set - Based on
Event Attribute Expire Days data [IMPLICIT]
– Line status transitions to Closed
– Upon Acceptance completion the Revenue Recognition reverses the
originally Unearned Revenue account assignment and debits the appropriate
Revenue account
• The Acceptance Date is the GL Date used for when the Revenue is
Recognized
Copyright © DARC Corporation, 2010
29
Post-Billing Acceptance
with Explicit Process Description
• Post-Billing Accept. (Customer Acceptance Removal Event)
– Sales Order Line in Pending post-billing acceptance workflow status post ship
confirm
– Invoice is generated in AR and Revenue is held in Unearned Revenue
account – ONLY Revenue Recognition deferred
– Record Acceptance via Order Information Portal (OIP)> Order Status (T)
or Order Import/ Process Orders API [EXPLICIT]
– Line status transitions to Closed
– Upon Acceptance completion the Revenue Recognition reverses the originally
Unearned Revenue account assignment and debits the appropriate Revenue
account
• The Acceptance Date is the GL Date used for when the Revenue is
Recognized
Copyright © DARC Corporation, 2010
30
Sales Order Line
Before Post-billing Explicit Acceptance
Copyright © DARC Corporation, 2010
31
Sales Order Line
Before Post-billing Explicit Acceptance
Copyright © DARC Corporation, 2010
32
Post-Billing Acceptance Sales Order Line
Workflow Status Diagram
Copyright © DARC Corporation, 2010
33
How to Manually Complete
Explicit Acceptance
Copyright © DARC Corporation, 2010
34
Actions (B) LOV (Header / Lines)
Actions LOV> Fulfillment
Acceptance (Select for Manual
Explicit Acceptance)
Copyright © DARC Corporation, 2010
35
OR Fulfillment Acceptance (B)
Copyright © DARC Corporation, 2010
36
Manual Explicit Acceptance via Order
Information Portal (OIP)> Order Status (T)
Copyright © DARC Corporation, 2010
37
OIP> Order Status (T)> Process
Manual Explicit Acceptance
Copyright © DARC Corporation, 2010
38
Confirmation of Manual Explicit
Acceptance in OIP > Order Status (T)
Copyright © DARC Corporation, 2010
39
OIP> Order Status (T) Reflecting Manual
Explicit Acceptance Detail Updates
Copyright © DARC Corporation, 2010
40
Sales Order Line Others (T) After Completing
OIP Post-Billing Manual Explicit Acceptance
Copyright © DARC Corporation, 2010
41
How to Complete Implicit
Acceptance
Copyright © DARC Corporation, 2010
42
Implicit Acceptance Request Set /
Concurrent Programs
Copyright © DARC Corporation, 2010
43
Sales Order Line Implicit Acceptance
Completed Indicator
Copyright © DARC Corporation, 2010
44
Helpful Hints - Implicit Acceptance
• Request Set contains two concurrent programs
– Generate Pre-billing Acceptance Program for Pre-billing, Implicit
Acceptance
– Revenue Contingency Analyzer for Post-billing, Implicit
Acceptance
• Implicit Acceptance Programs validate the Date inclusive of the Time
Stamp value for the related Event Attribute
– Event Attribute is Ship Confirm Date and Expire Day is 1
• Ship Confirm Date value is 17-FEB-2010 16:00:00
• The Implicit Acceptance Request Set will NOT process the
related sales order line record(s) for Acceptance until 18-FEB2010 16:00:00 or later
Copyright © DARC Corporation, 2010
45
Helpful Hints – Acceptance Management
Customer Acceptance Report
Copyright © DARC Corporation, 2010
46
Helpful Hints – Acceptance Management
Customer Acceptance Report – Sample Output
Copyright © DARC Corporation, 2010
47
Revenue Recognition
Overview
Copyright © DARC Corporation, 2010
48
Post-Billing Revenue Recognition BEFORE
Acceptance – AR Revenue Accounting
Copyright © DARC Corporation, 2010
49
Post-Billing Revenue Recognition BEFORE
Acceptance – AR Revenue Accounting
Copyright © DARC Corporation, 2010
50
Explicit Acceptance Completed via
the Order Information Portal
Copyright © DARC Corporation, 2010
51
Post-Billing Revenue Recognition
AFTER Acceptance – AR Revenue Accounting
Copyright © DARC Corporation, 2010
52
Post-Billing Revenue Recognition
AFTER Acceptance – AR Revenue Accounting
Copyright © DARC Corporation, 2010
53
Post-Billing Revenue Recognition
AFTER Acceptance – AR Invoice Distributions
Copyright © DARC Corporation, 2010
54
Pre-Billing AFTER
Acceptance – AR BPA Invoice View
Copyright © DARC Corporation, 2010
55
Considerations
Copyright © DARC Corporation, 2010
56
Considerations - Customer Acceptance Based
Deferrals for Invoicing & Revenue Recognition
• Requirement to complete Invoicing and / or Revenue Recognition
AFTER the sales order shipment is physically received/ formally
acknowledged / accepted
• Receivables / Revenue Management
– Revenue Contingencies / Deferral Reasons (Acceptance Names) cannot
be assigned to transaction lines that have deferred account rules
– Revenue Contingencies / Deferral Reasons (Acceptance Names) and their
related Event Attributes are setup in AR Revenue Mgt but enforced in
Order Management
– Continued on next slide…
Copyright © DARC Corporation, 2010
57
Considerations - Customer Acceptance Based
Deferrals for Invoicing & Revenue Recognition
• Continued
– Revenue Contingency / Deferral Reason (Acceptance Name) and
their related Event Attributes can be defaulted during order creation
when the AR API that is called from OM (NOT Traditional Order
Management Defaulting Rules)
• Based on Customer Acceptance being activated via the OM System
Parameter: Enable Fulfillment Y / N and the setup of Revenue
Contingency Assignment Rules
─ If Enable Fulfillment has not been activated – the AR API will NOT
be called to invoke the related AR Revenue Contingency defaults
EVEN IF Assignment Rules (can be assigned to customer, site,
item, etc) have been setup
Copyright © DARC Corporation, 2010
58
Considerations - Customer Acceptance Based
Deferrals for Invoicing & Revenue Recognition
• Order Management
– Once the system applies the Revenue Contingency, it will remain applied to the
Order Line till the user manually removes it from the Sales Order form
– Support for multiple Inventory item types – Standard, Service, ATO / PTO Model and
PTO Kits
• For Service, ATO / PTO Model and PTO Kits – Acceptance contingency is
defined at the parent level, child lines inherit acceptance information from the
parent
– Fulfillment Acceptance functions need to be added to menus
– Only supports Full Acceptance / Rejection for outbound order lines
– Ship Confirm Date is the only event attribute supported for the current release
– Fields of Earliest and Latest Acceptable dates are still only applicable to sales order
line scheduling calculations
– Does not apply to returns, internal orders or retro bill orders
Copyright © DARC Corporation, 2010
59
Summary
Copyright © DARC Corporation, 2010
60
Customer Acceptance Based Deferrals for
Invoicing & Revenue Recognition - Summary
• Contingency Definition / Deferral Reason (Acceptance Name) and
their related Event Attributes are setup in AR / Revenue Mgt and can
be defaulted during order creation as a result of the AR API that is
called from OM (dependent on additional setups)
• Folder functionality enables user access to Acceptance data details
on sales order lines
• Pre-billing deferral is tied to Invoicing and defers BOTH Invoicing and
Revenue Recognition
• Post-billing deferral is tied to Customer Acceptance and defers ONLY
Revenue Recognition
• Explicit and Implicit Acceptances are supported with standard
functionality (additional setups required)
Copyright © DARC Corporation, 2010
61
Questions?
Copyright © DARC Corporation, 2010
62
Copyright © DARC Corporation, 2010
63