|Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today|
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:
- You can print a single, monthly bill that includes all of a customer's transactions for the period. Consolidated Billing Invoice is normally generated at the Bill-To location level. A Consolidated Billing Invoice itemizes only Invoices, Credit memo and adjustment.
- Consolidated Billing Invoice also have details for receipts in summarized form.
- Customer qualified consolidated billing invoice are selected by the Cutoff date and payment terms.
- Consolidated Billing Invoice does not includes aging.
These are bit different from Statement .
Oracle Vanilla Features of Statements
These are normally generated at the customer level.
- Customer uses this document for informational purpose.
- Statement display itemize adjustment, credit memos, debit memo, invoices, chargeback’s, deposits, receipts and on-account credits.
- Statement are subjected for aging
- Customer are selected by statement Cycle
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
- All Transaction created before the cut-off date specified and that have not included on previously on a Consolidated Billing Invoice
- A beginning balance
- An Itemized list of new charges including invoice, CM and adjustment, in either summary or details format depending on the parameter chosen.
- Separated reporting on consumption tax.
- The total amount of any payment received since the previously CBI
- The total balance due for this customer or Bill-to site.
- Groups the invoices created in a billing cycle.
- You can manage high volume invoicing with this feature.
- You can also make this feature for imported invoice through auto invoice.
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.
- Define Proxima Payment Term
- Set the "show Billing Number" system options
- Assign Proxima Payment term to customer
- Enable the Consolidated Billing Options on customer
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:
Proxima Payment Term , have you specify a cut off day and a single due date.
Is the customer for which you are making qualified for consolidate Invoicing is compliant or not. Check it out at what level you have attached.
Have you opened the Business Purpose form for the usage of Bill To and assign the CBI Payment Term.
What parameter you are passing , is the day specified within the Cut Off date must match the cut off day given to the Payment Terms. This is required so that Consolidated Billing Invoice can determine which terms codes will be selected (even if the terms code is provided as on of the run time parameters).
If the Consolidated Billing Invoice Profile: Print Document - Format (Customer form) is defined to be 'Summary', the report Type must also be 'Summary Consolidated Billing'; likewise, if Profile: Print Document - Format is defined to be 'Detail', the Type must also be 'Detailed Consolidated Billing'.
Let me know, in case if you stuck or some information.