Search icon
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Oracle PeopleSoft Enterprise Financial Management 9.1 Implementation

You're reading from  Oracle PeopleSoft Enterprise Financial Management 9.1 Implementation

Product type Book
Published in Jun 2011
Publisher Packt
ISBN-13 9781849681469
Pages 412 pages
Edition 1st Edition
Languages
Author (1):
Ranjeet Yadav Ranjeet Yadav
Profile icon Ranjeet Yadav

Table of Contents (16) Chapters

Oracle PeopleSoft Enterprise Financial Management 9.1 Implementation
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
PeopleSoft Financials Fundamentals PeopleSoft Security PeopleSoft Billing Module PeopleSoft Accounts Receivable Module PeopleSoft Asset Management Module PeopleSoft Accounts Payable Module PeopleSoft General Ledger Module PeopleSoft Expenses Module PeopleSoft Commitment Control Index

Chapter 3. PeopleSoft Billing Module

The PeopleSoft Billing Module performs the important function of generating customer invoices for the goods or services sold by an organization. It is an important part of the 'Order to Cash' business process. This module allows an organization to seamlessly receive data from various PeopleSoft modules to create customer invoices. It allows us to create multiple formats to generate invoices based on business needs. Various batch processes in the Billing module enable the complete automation of the entire invoicing process. Users can manually create invoices as well if required.

PeopleSoft Billing can perform necessary calculations for Sales and Use Tax (SUT) and Value Added Tax (VAT). It also allows adjustments to generated invoices, creates accounting entries, and interfaces the invoice data to other PeopleSoft modules.

In this chapter, we will discuss the invoice lifecycle and various Billing batch processes. We'll gain an understanding of concepts such...

Understanding the invoice lifecycle


In the PeopleSoft Billing module, you will frequently hear the terms "bill" and "invoice". To put it simply, while an invoice is the final document to be sent to a customer, a bill can be considered a 'raw' version of the invoice.

The following illustration shows a high-level process for invoice processing:

The billing process begins with the entry of bills, either manually or through delivered interfaces from other PeopleSoft modules. We'll discuss these concepts in greater detail a little later. Once these bills are in the PeopleSoft system, they can be reviewed and approved (if necessary). Reviewing the bills can be implemented through printing draft invoices, called pro-forma invoices. You can print pro-forma invoices using a batch process as many times as needed to review how the invoices would look. If any changes are needed, they are made to the bill.

Once the bill is deemed appropriate, a batch process is executed to 'finalize' the bill. This transforms...

Entering bill data


As we briefly saw in the invoice lifecycle, bills can be entered into the PeopleSoft system manually or through an interface from other PeopleSoft modules or non-PeopleSoft systems. We'll now discuss these approaches in detail. Note that manual bill entry is appropriate when the bill volume is relatively small. Usually for large organizations, the bill data volume is quite high and originates from other sources. For such situations, manual entry is certainly not an option and an automated interface needs to be employed.

Receiving bill data from other modules or external sources

PeopleSoft offers a set of interface tables to store bill data from external sources (PeopleSoft/non-PeopleSoft) and a batch process named Billing Interface (BIIF0001) to load the data from these staging tables into billing tables.

Of course, you may be wondering how the bill data will be loaded into the interface tables in the first place. As far as bill data from other PeopleSoft modules (such...

Understanding billing batch processes


Based on our discussion of the invoice lifecycle, you have now gained some idea of how the billing batch processes play an important part in invoice processing. It would not be wrong to say that these batch processes handle almost every aspect of invoice processing. In this section, we'll explain these processes.

The following table lists the billing batch processes in the order they need to be executed. Note that not all of these processes are mandatory for invoice processing.

Performing invoice adjustments


In a typical invoicing process, it is fairly common that an invoice sent out to a customer will need to be modified. Consider the following scenarios:

  • An invoice for customer A is accidentally created for customer B. Now customer B contacts us and wants us to cancel the bill.

  • A customer complains that he received an invoice for something that he never purchased.

  • A customer purchases products A, B and C but finds that we have sent him an invoice for products A, B and D. Now we need to correct the bill line with product D and change it to product C.

  • A discount of 10% was promised to a customer on purchase of a certain product. However, when he receives the invoice, he finds that he did not receive the discount. He now wants us to apply the promised discount on the invoice amount and resend the corrected invoice.

These are only a few possible situations where we need to make adjustments to customer invoices.

PeopleSoft Billing offers two ways of adjusting invoices...

Deferred revenue processing and unbilled revenue accrual


The most straight-forward scenario in customer invoicing includes the following steps:

  • An organization sells some goods/services to a customer

  • An invoice is created and sent out

  • The customer pays the invoice amount and the invoice is closed in Accounts Receivable

In this case, a typical accounting entry for the invoice is as follows:

  • DR Accounts Receivable

  • CR Revenue

In other words, we recognize the revenue and record the receivable (from the customer) at the same time. However, there are many situations where this is not possible due to various reasons.

Sometimes, even if we invoice a customer, we cannot recognize the revenue and need to defer (postpone) the revenue recognition. This is known as deferred revenue processing. On the other hand, sometimes, we need to recognize the revenue, even if we have not invoiced the customer. This is known as unbilled revenue accrual.

Deferred revenue processing

Consider a customer invoice for the amount...

Understanding important billing configurations


So far we have familiarized ourselves with the basic business process and the system features used by the PeopleSoft Billing module. Now we will understand some of the important configurations that enable these business processes. We'll discuss the following configuration options, which are not necessarily set up in the same order:

  • Invoice number IDs

  • Bill types

  • Bill sources

  • Invoice formatting and printing options

  • Distribution codes

  • Billing charge codes

  • Discounts and surcharges

  • Billing business unit

Configuring invoice number IDs

PeopleSoft Billing offers a flexible invoice numbering structure that enables the creation of various conventions for invoice numbers.

Let's assume that Global Vehicles Inc. needs to number its invoices in the format GV-US-XXXXXXXXXX. The first part of the invoice ID is static where GV denotes Global Vehicles. The second segment indicates the geography (such as the US) and the last segment will denote the 10-digit invoice ID...

Summary


Bills can be entered into the system manually or brought in through the Billing interface. PeopleSoft offers a set of interface tables which act as a staging area for bills coming from other PeopleSoft modules such as Order Management, Contracts, and so on or external non-PeopleSoft systems. A batch process known as Billing Interface reads the data from interface tables, performs the validations and creates bills in the Billing system. This option is suitable for high volumes of billing data.

A set of batch processes perform various operations such as finalizing the bill, printing invoices, creating accounting entries, and interfacing the bill data to other PeopleSoft modules such as General Ledger, Accounts Receivable, and Accounts Payable.

If created invoices need to be modified, PeopleSoft offers two methods to do so: crediting entire bill or crediting specific bill lines. In Billing module, we can handle various scenarios such as Deferred Revenues (where revenue recording can...

lock icon The rest of the chapter is locked
You have been reading a chapter from
Oracle PeopleSoft Enterprise Financial Management 9.1 Implementation
Published in: Jun 2011 Publisher: Packt ISBN-13: 9781849681469
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $15.99/month. Cancel anytime}

Process

Description

Purpose

BIIF0001

Billing interface

As discussed earlier, this process loads the bill data from interface tables into the billing tables and creates new bills. It is not required if bills are manually created.

BIPVAT00

Process VAT defaults

This process applies the Value Added Tax (VAT) default values for the bill header and bill lines based on the VAT setups. It is required only if VAT is applicable to the organization's invoices. VAT is usually...