- OracleApps Epicenter - http://www.oracleappshub.com -
Tired of the Invoice Pile? Think “Consolidated Billing Invoice”
Posted By Sanjit Anand On September 10, 2008 @ 9:36 am In Oracle Receivable | 3 Comments
The Consolidated Billing Invoice works in similar way that Statement Generation program works. The Consolidated Billing Invoice program lets you print a single, monthly invoice that includes all of your customer's transactions for the period . This will you send one consolidated billing invoice instead of a separate invoice for each transaction. For each bill to site one Consolidated bill will be generated.
Other Oracle Vanilla Features of Consolidated Billing Invoice are:
These are bit different from Statement .
Oracle Vanilla Features of Statements
Typical Business scenarios
If you made several invoices in fortnight and want to send only one consolidate invoice to the client , is it possible to do a consolidate invoice even if I capture individual invoices?
Yes, You can do it with this assumption that you are using either the invoice interface or manual , but not using a combination of manual and imported invoices. Also, consolidated billing requires the use of a single bill-to site
In order to create consolidated invoices, you will need to enable them. You will probably want to setup a customer profile class, with the CONSOLIDATED BILLING INVOICE enabled. If the customer has multiple bill-to-sites, you can set up consolidated billing at the customer level (i.e., for each bill-to site).
In following section , you can find detailed discussion for enabling this feature in R11i.
Types of industry using these features
Health care, Telecom, Utilities, Retails are heavy usage of consolidated Billing Feature.
Quick Points on major vanilla Features
Pre-requsite Setup for enabling Oracle Vanilla "Consolidated Billing" Feature
By using Consolidated Billing related Invoice of customer can be grouped in a given billing cycle. Once you will do system, system generate and store a unique reference number on these invoices. To enable this functionality you need to perform these setups.
1. Define Proxima Payment Term
You need to define payment term for the Consolidated Billing Invoice
Setup ->Transaction -> Pyament Terms
Normally Consolidated Billing Invoice requires the use of Proxima Payment terms.
Lets we have example name our payment term "HUB24",when running Consolidated Billing Invoice, the program will use the cutoff Date selected in the submission parameter and the payments terms defined as:
Here we defined cutoff days =24
This is day of the month that determines when an invoice with proxima payment terms is due.
That’s means when you run the CBI on Aug 24, invoice dated/created before Aug 24 are due in the next billing period, invoice dated after 24th are due in the following period.
If you are using OracleEBS 11i , Take a note::
- Payment Terms without cutoff date cannot be used for consolidated billing.
- You can create multiple payment terms can be defined with different cutoff dates
- You cann't use multiple due dates by spliting payment term.
2. Show Billing Number
Once you enable this system option, Billing Number field is displayed on the following places in AR.
(i)Transactions (ii)Transaction Overview (iii)Receipt Application and Mass Application window (iv)Customer Calls (v)Account Details
3. Qualifying Customer for Consolidated Billing Invoice
Here is how payment term is associated by a particular customer.
You can also setting up Customer Profile Class and tag customer, that will eliminate some sets to tagging payment term.
4. Invoice selection criteria & Bill creation
- Invoice due date derived form the payment terms cutoff date
- Due date on consolidation report determines
You need to run Consolidated Billing process. These seeded processes Oracle provides you :
- Accept Consolidated Billing Invoices :If you are satisfied with the draft invoices, choose this option to accept them. When you do this,AR changes the status from Draft to Accepted. This option does not reprint the consolidated billing invoices
- Print Draft Consolidated Billing Invoices:This lets you review your consolidated billing invoices for accuracy and completeness, then either accept or reject them. The printed copy of the draft appears exactly as it will appear when you choose to print new consolidated billing invoices; the only difference is that the draft invoice has a status of Draft rather than Accepted.
- Print New Consolidated Billing Invoices :This generates and prints the consolidated billing invoices and changes the status to Accepted.
- Reject Consolidated Billing Invoices : If you are not satisfied with the draft invoices, choose this option to reject them. AR changes the invoice print status from 'Printed' to 'Pending.' You can print these invoices again using either the Draft or New function.
- Reprint Consolidated Billing Invoices : Choose this option to reprint draft or final (accepted) consolidated billing invoices.
You can Consolidation request can be printed by running (2) and (3) of above, the Only difference is
- Draft Invoice -You can use review,can be modified
- New Invoice –This cann't be modified
If you have situation , you already run draft consolidated billing and got to know account department wants to add more bills in current cycle? Then how to do?
If this the case , what you have to do, in order to accommodate additional invoices in consolidated bill, perform these steps:
- Reject a consolidated invoice by running Reject Consolidated Billing Invoices concurrent program and choose the proper consolidated invoice in the parameters.
- Once this Concurrent Process is completed, run the Print Draft Consolidated Billing Invoices program again.This way all new invoices will now be in the consolidated invoice
" what if ' if you are getting "NO DATA FOUND" after running these processes:
You need to do quick check of your setup , parameter , checklist are:
Let me know, in case if you stuck or some information.
Article printed from OracleApps Epicenter: http://www.oracleappshub.com
URL to article: http://www.oracleappshub.com/accounts-receivable/tired-of-the-invoice-pile-think-consolidated-billing-invoice/
Disclaimer The opinions expressed here represent solely my own represent personal conjecture based upon experience, practice and observation and does not represent the thoughts, intentions, plans or strategies of my current & previous employers and their clients. Copyright © 2007-2010 OracleApps Epicenter. All rights reserved.