Showing posts with label payment terms. Show all posts
Showing posts with label payment terms. Show all posts

Configuring Revenue for Receivables in Oracle Fusion Applications

What is Revenue Management? 

Oracle Revenue Management complies with accounting standards that tell the organization to recognize the revenue later after the invoice has been sent. A sample of this would be a multi-period Mobile contract for Voice and Data Subscription, or Streaming Subscription, or a Software Support Contract. 

The concept of Revenue Management is that your organization sells a service or product to your customer, but have not fully delivered that service, we cannot fully recognize the whole revenue for that invoice at once because we have to follow an accounting standard. What Revenue Management does is we prorate our revenue from the start and end of the contract. For Example, the contract was for a 12-month period, that's the bill will be pro-rated for 12 months.

An example we can use for this whole article would be a support service provided by Oracle Corporation for a period of 12 months for $100,000.00. The Support fees would be pro-rated in a 12-month accounting period, instead of having it only at one accounting period. 

Depending on your Requirements, you may need to configure or update the following setups related to revenue:
  1. Setup Revenue Recognition
  2. Revenue Scheduling Rules
  3. Define Revenue Policies
  4. Define Revenue Contingencies
Each of these setups will be discussed in detail below.

Setup Revenue Recognition It's a collection of defaults, options, functionality features that is broken down into two areas, billing-related and cash-processing system options and customer payment system options. Below are the setups for Revenue Recognition:
  1. Salesperson System Options - Allows an organization to require a Salesperson when you enter an invoice. The idea here is to assign sales credit to that person that sold the product or service so that they can receive commissions based on their sales.
It also has an implication in terms of revenue recognition, because if you make an adjustment to their revenue, the sales credit of that salesperson will be impacted. If the salesperson gets paid based on revenue, an adjustment will also be made to his or her commission. 
In some cases, you compensate salespeople on revenue and non-revenue, so it doesn't have to equal 100%. You can strictly compensate a salesperson based on revenue. To do this, you can enter a value in the Sales Credit Percent Limit field.
  1. Revenue Adjustment Reason Lookup Type – If you create an invoice with revenue recognition rule that has the deferral option turned on, then you need to make sure that you track the reasons for revenue recognition. This Lookup just means you can add reasons to the seeded reasons list so that users can pick the value they need when they are about to recognize revenue manually.
  1. AutoAccounting based on a Standard Line - If AutoAccounting is based on standard line, the transaction line must either be an inventory item or a memo line, and not a user-entered line.
When you are entering lines for an invoice in receivables, those lines can be adhoc. If you enter an adhoc line, it's going to be difficult for receivables to generate the required revenue accounting information. It doesn't know how to generate the accounting distributions for that line.
However, if it's an inventory item that you are using in an invoice line, AutoAccounting can generate the accounting distribution. It can also can be a standard line, which means that you are defining products and services outside of the inventory module.

Revenue Scheduling RulesYou can create an invoice with revenue recognition rules. A scheduling rule is a rule that tells receivables how to allocate our revenue into the future. It can be that a revenue scheduling rule that tells receivables not to recognize revenue now, we are going to recognize the revenue manually in the future by processing a revenue adjustment. For more information about Managing Revenue Scheduling Rules, check out a separate article: Manage Revenue Scheduling Rules in Oracle Fusion Applications.

Revenue Policies - Revenue Policies allow your organization to make automatic revenue recognition decisions for manually entered and imported transactions. This works in connection with revenue contingencies.

To create Revenue Policies, go to the Functional Setup Manager, pick the Financials offering, select the Revenue Recognition functional area and choose the Task “Manage Revenue Policies”.

Revenue policies can be based on different criteria such as:
  1. Credit classification- When you create a customer, you can assign that customer a credit classification in the customer profile class setup. It can be excellent, average or poor credit. For example, the customer has excellent credit classification, then you might decide to recognize their revenue right away because they are good payers. Or on the other hand, you may want to recognize the revenue later on if the customers have poor credit, as you don’t want to recognize the revenue now and reverse it later on if the customer fails to pay.
  1. Refund Policy Threshold- You can use the refund policy threshold column to enter the standard refund period represented in days that you offer to your customers. When you enter or import the transaction, if a line is associated with a contract, receivables analyzes the contract and look at the refund period. And if the contract offers a refund period that exceeds their refund policy, then our contingency is going to be assigned to the line. This is commonly used when your organization might have a certain refund policy where you may allow an unhappy customer a refund within 30 or 45 days. If that's the case, you might want to wait after the refund period has passed to recognize your revenue.
  1. Payment Terms Threshold– Based on the Business Unit, payment terms and the transactions, receivables will identify that these are non-standard payment terms and therefore we are going to defer their revenue. This will dictate that we are only going to recognize the revenue after the removal event has happened, such as a customer payment, or after 60 days has passed, etc. For example, if there's an invoice created with these a non-standard NET 45 payment terms, it will be subject to a contingency and revenue will not be recognized unless the customer has already paid.
Revenue Contingencies - provides certain restrictions that you apply on revenue recognition that are going to be removed by an event. For example, the event can be payment, or the event can be that 30 days have passed, and now I feel comfortable that I can recognize the revenue.

How Does Revenue Contingencies Work?


You enter and complete the receivable transactions, either manually or automatically. Receivables will analyze the invoice and look at the contingencies and assignment rules that you have defined. If the customer specified in that invoice and the Business Unit matches the contingencies and assignment rules, it will proceed to determine if are there any restrictions for this invoice. 

If there are no restrictions, then it can go on and recognize the revenue. If it does find contingencies, it will defer the revenue and wait until a removal event takes place. The removal event in this example is a payment. The system will not recognize revenue until the customer pays. Once the customer pays, it will automatically recognize the revenue for that particular invoice. 

Removal Event – Removes the restriction based on an event such as a Payment, number of days passed, etc. For example, if a customer was billed with a non-standard payment term (NET 45), they will be assigned a revenue contingency, in which a payment will be the removal event. Once the customer pays, the restriction will be removed on the revenue, and we will recognize the revenue and report it because there's no risk anymore.

Revenue Contingency Assignment Rules - Defines a rule on how to apply that contingency. You can apply the rule to a given customer or a set of customers.

For more full-detailed Tutorials and Tips, check out #TheOracleProdigy at https://lifeofanoracleprodigy.blogspot.com/
Follow The Oracle Prodigy on Facebook (https://www.facebook.com/theOracleProdigy/) and Twitter (https://twitter.com/D_OracleProdigy)

Overview of Reference Data Sets in Oracle Fusion Applications

Reference Data Sets (RDS) in Oracle Fusion Applications allows either the sharing of Master Data Objects (i.e. Payment Terms, Set of Books, etc.) across Business Units or makes it exclusive to a specific Business Unit. It basically partitions the Master Data Objects on which BUs get access to it.

There are two seeded RDS, "Common" and "Enterprise".
  1. Common: This RDS allows the access of Master Data Objects Across all Business Units (Global in Scope)
  2. Enterprise: This RDS only allows access of Master Data Objects to the specific Business Unit (Local in Scope).
Most Organizations create new Enterprise Reference Data Sets depending on their need. A common naming convention is to name the Reference Data Sets as the same as the Business Unit.

To Create a new Reference Data Set, navigate to "Setup and Maintenance" > Search for the Task named "Manage Reference Data Sets" and create the name of the Data Set there.



To Assign a Reference Data Set to a Business Unit, navigate to "Setup and Maintenance" > Search for the Task named "Manage Business Units" and edit the existing Business Unit you want to assign the Reference Data Set to.


In this case, our Business Unit in our sample named "Eagle" is assigned to the seeded "COMMON" data set, which grants the Eagle Business Unit all Reference Data that is assigned to the "COMMON" RDS.


For a Master Data Object to be assigned to a RDS, navigate to "Setup and Maintenance" > Search for the Task named "Manage Business Unit Set Assignment" and setup your needed Reference Data Object to the appropriate RDS:


In some complex cases, we can make a specific value in a Reference Data Object "shared" across Business Units. Take Payable Payment Terms as a sample below.

SET ASSIGNMENT

Business Unit
Reference Data Object
Reference Data Set Name
US1
AR Payment Term
US1SET
US2
AR Payment Term
US2SET
US3
AR Payment Term
COMMON

SETUP DATA


Reference Data Set Name
AR Payment Term
US1SET
NET30
US1SET
NET45
COMMON
NET30
COMMON
IMMEDIATE
US2SET
NET45
ORGSET
NET30

QUESTIONS

A User under a specific Business Unit is trying to create an AR Invoice. Using the SET ASSIGNMENT and SETUP DATA provided, What are the Payment Terms visible to the User?
  1. The User is under Business Unit "US1"
  2. The User is under Business Unit "US2"
  3. The User is under Business Unit "US3"
ANSWERS

The Payment Terms visible to the User would be:
  1. NET30, NET45 and IMMEDIATE
  2. NET30, NET45 and IMMEDIATE
  3. NET30 and IMMEDIATE
The reason both US1 and US2 show the same Payment terms is because NET30 and IMMEDIATE are under the "COMMON" configuration, and therefore are available to all Business Units.
If you want to make it exclusive the US1 or US2, the Setup for those Payment Terms should be removed for "COMMON".

In another Example, The diagram below shows that the specific Payment Term "NET 30" is shared between 3 Reference Data Sets (US1, US2 and Special Shared Set). This can be achieved by using the correct setup and making sure there are no common values. More information on this can be found from Understanding Enterprise Structures: Reference Data.


For more full-detailed Tutorials and Tips, check out The Oracle Prodigy at https://lifeofanoracleprodigy.blogspot.com/
Follow The Oracle Prodigy on Facebook (https://www.facebook.com/theOracleProdigy/) and Twitter (https://twitter.com/D_OracleProdigy)

Recent Posts

SQL Fundamentals

Introduction to SQL and Syntax What is SQL? SQL stands for Structured Query Language. is a standard programming language for accessing datab...

Top Posts