This chapter discusses the way in which sales orders are billed in PeopleSoft Billing. The chapter provides an overview of the billing process, prerequisites, and discusses how to:
Use direct invoicing.
Populate billing.
Prepare nonstock products for billing.
PeopleSoft Billing invoices customers for sales orders. Information is passed to PeopleSoft Billing by using either:
Direct Invoicing.
Populate Billing.
Invoices can be generated by either:
Ship from warehouse from shipment history in PeopleSoft Inventory.
PeopleSoft Order Management business unit.
Note. Divide sales order transactions among different Billing business units if you're billing by Inventory business unit. Each Inventory business unit can be linked to a separate Billing business unit. A PeopleSoft Order Management business unit can only be linked to a single PeopleSoft Billing business unit.
After the invoice is created, the invoice number, date, and line number appear on shipment history inquiries in PeopleSoft Order Management.
Note. Sales orders that are created from PeopleSoft Contracts are billed from Contracts. Shipment history data for contracts sales orders are not updated with invoice information.
PeopleSoft Billing uses the bill-by concept to group sales activity on invoices. For example, it can generate a separate invoice for each shipping ID or for each sales order number. Define a different bill by for each customer so that one customer is billed by order number and another by shipping ID. Establish bill-by criteria on the Bill By Identifier page in PeopleSoft Billing.
Payment Method, Payment Terms Code, and Address Sequence Number are implicit bill bys for PeopleSoft Order Management.
Note. Associate the Bill By Identifier with a Bill To customer on the General Information - Bill To Options page. If sales transactions are liable for value added tax (VAT), these fields are implicitly included in the bill-by fields list for the bill-by identifier: Ship To Country, Ship From Country, Buyer's VAT Registration Country (customer's VAT registration country), Seller's VAT Registration Country (reporting country) and VAT Treatment Group.
Note. When billing sales order activity that is subject to VAT, the Populate Billing process passes VAT parameters to PeopleSoft Billing. When this occurs, the Billing Interface process creates new bills rather than adding activity to existing similar bills within PeopleSoft Billing. Therefore, if you choose to bill customers according to bill cycles, it is recommended that you run the Populate Billing process on a schedule that enables you to produce fewer invoices per bill cycle.
See Order Processing in a VAT Environment.
Pricing Considerations for Billing Sales Orders
Sales orders can have pricing UOM's that are different from the ordering UOM. The OM Billing Interface (OM_BILL) will always invoice order activity in the pricing UOM. The UOM and prices reflected on the invoice will be in the pricing UOM.
If you are using tiered pricing and an order schedule is broken out into more than one pricing schedule, quantities from each pricing schedule will be on individual lines of an invoice. In this example, there are two pricing schedules for an order schedule—the first schedule for 10 units at 10 USD and the second schedule for 10 units at 8 USD. If the pricing schedules shipped before the OM Billing Interface process was run, there would be two invoice lines, even though there was only one order schedule. If all of the schedules have not shipped before the OM Billing Interface process is run, the lines would be invoiced in this example. Using the same scenario with two pricing schedules, however only 7 units shipped before the OM Billing Interface process was run. There would be one on an invoice for 7 units at 10 USD. When the remaining 13 units shipped and the OM Billing Interface process was run again, there would be two additional invoice lines— one line for 3 units at 10 USD and another line for 10 units at 8 USD.
Direct invoicing streamlines the billing process combining several steps in the order-to-invoice cycle. PeopleSoft designed direct invoicing for order management environments that require immediate invoicing for shipped goods, instead of a traditional cycle billing. Direct invoicing is active by default. Leave the option selected for customers who require time-sensitive invoices based on shipment ID. Deactivate the option for customers who prefer summarized billing (perhaps monthly) on the customer General Information - Bill To Options page. The direct invoicing option moves by defaults to the Bill To section of the Order Entry Form page on the sales order. Because you can change the direct invoicing option by order as well as by customer, you can configure customers' billing requirements.
If you don’t use the direct invoicing option, you must run individually each of the processes that are included in direct invoicing.
Note. When using the Direct Invoicing, you must specify the Range Selection ID and Direct Invoicing on the Bill-By Identifier page.
Direct invoicing is run from PeopleSoft Inventory or PeopleSoft Order Management. This table discusses each option to run direct invoicing:
Process |
Run Control Page |
Description |
Processes |
Direct Invoicing (DIRCTIVC). |
|
Launches the multiprocess job to move invoices into PeopleSoft Billing. Invoices are finalized and printed and also loaded into PeopleSoft Receivables and General Ledger. |
|
Direct Invoicing - No Load (DIRCTIV2). |
|
Launches the multiprocess job to move invoices into PeopleSoft Billing. Invoices are finalized and printed, but not loaded into PeopleSoft Receivables and General Ledger. |
|
Direct Invoicing with Auto-ship (DIRAUTO). |
Ship and Invoice page in PeopleSoft Inventory. |
Launches Direct Invoicing with the Auto-Ship multiprocess job (DIRAUTO), which confirms, ships, depletes, and creates invoices for the shipped stock in addition to launching all of the processes in the Direct Invoicing (DIRCTIVC) multiprocess job. |
|
Direct Invoicing with Auto-ship (DIRAUTO continued). |
|
Warning! Important! To remove processes from the Direct Invoicing job, you must modify the PeopleCode that controls this job. Because there is more than one Application Engine application being run by this job, only the first application is defined as a process in the job definition. PeopleCode sets up the additional Application Engine request for additional applications, such as PeopleSoft Currency Conversion. You must modify the PeopleCode to disable the creation of this request.
Important! Important! Direct invoicing always runs on a server, never on a client. You must select a server that is appropriate for direct invoicing processes. For example, if you're running Taxware or Vertex, you need to select a server that is appropriate for tax module processing in that operating environment.
See Also
Processing Billing Interface Activity
The section provides an overview of the Populate Billing Process, lists prerequisites, and discusses how to run the OM Billing Interface process (OM_BILL).
You can populate PeopleSoft Billing with sales orders data for invoicing using the Direct Invoicing from the Populate Billing run control page. You can select either Direct Invoicing (DIRCTIVC) or Direct Invoicing — No Load (DIRCTIV2).
To populate PeopleSoft Billing without using the Direct Invoicing job, these two processes must be completed:
OM Billing Interface (OM_BILL): Populates the interface tables in PeopleSoft Billing with the shipment history that is from PeopleSoft Inventory:
INTFC_BI
INTFC_BI2
INTFC_BI_AEDS
INTFC_BI_NOTE
INTFC_BI_HDR
INTFC_BI_EXSD
INTFC_BI_TAX (This table is only used for fully paid counter sales where Order Management passes the tax detail to Billing and Billing does not recalculate taxes.
Billing Interface (BIIF0001): Moves the data from the interface tables to the PeopleSoft Billing tables in order to finalize and print the invoices.
These processes can be run individually or together with the OM Billing Interface job (OM_IVC), which combines both processes and runs these processes:
OM Billing Interface (OM_BILL)
Billing Interface (BIIF0001)
Process VAT Defaults (BIPVAT00)
Note. If you run the OM Billing Interface individually, run the Billing Interface to move the data from the interface tables to the Billing tables to create invoices. Use the OM Billing Interface ID from the OM Billing Message Log page to run the Billing Interface.
Note. The Billing Interface table (INTFC_BI) doesn’t store the invoice number. After the Billing Interface is run, it updates the IN_DEMAND_BI table with the Invoice Number and the Invoice line number.
Note. Sales orders that are generated from PeopleSoft Contracts are billed from Contracts, not Order Management.
Associate a PeopleSoft Billing business unit, distribution codes, a bill type, a bill source, and product IDs for restocking, freight, and miscellaneous charges with the PeopleSoft Order Management business units or PeopleSoft Inventory business units. The Inventory business unit billing options take precedence over the billing options on the Order Management business unit. The bill type field on the sales order defaults from the customer or order group, in that order. If there is not a bill type on the sales order, the Populate Billing process will determine if the bill type field from the Inventory Business Unit or Order Management Business Unit will be used.
Important! The billing interface is structured to work with PeopleSoft Billing. If you use a own or a third-party billing system, you cannot use the Populate Billing process.
Note. Business unit setup also affects returned material authorization (RMA) processing. The RMA Adjustments process (BIRMAADJ) in PeopleSoft Billing requires that you always associate an Order Management business unit with a Billing business unit, even if you are invoicing by Inventory business unit.
As a prerequisite for the Populate Billing process, set up these parameters.
Establish business unit options.
If you're billing by billing business unit, select a Billing business unit with an Order Management business unit on the Order Management Definition - Order Management Setup page and Accounting and Billing page.
If you're billing by inventory business unit, select the Billing business on the Inventory Definition - Business Unit Definition page and the Inventory Definition - Business Unit Options: Revenue and Billing Defaults page.
Establish distribution codes and required billing options to send information to PeopleSoft General Ledger through PeopleSoft Billing.
If you're billing by billing business unit, use the Accounting and Billing page.
If you're billing by inventory business unit, use the Inventory Definition - Business Unit Options: Revenue and Billing Defaults page.
Establish automatic numbering for invoices on the Installation Options - Billing - General Options page.
On the Accounting and Billing page:
Determine how weight and volume and total order price adjustments are sent to PeopleSoft Billing
Determine whether discounts and surcharges pass to PeopleSoft Billing and appear on invoices.
See Also
Defining Your Operational Structure in PeopleSoft Inventory
Defining Billing Installation Options
Setting Up PeopleSoft Order Management Business Units
Page Name |
Object Name |
Navigation |
Usage |
RUN_OM_BILLING1 |
Order Management, Quotes and Orders, Create OM Billing Entries, Process OM Billing |
Establish process parameters to run the OM Billing Interface (OM_BILL) to populate the Billing Interface or the OM Invoicing multi-process job (OM_IVC). The OM Invoicing process runs the OM Billing Interface, the Billing Interface, and the Process VAT Defaults or as part of Direct Invoicing (DIRCTIVC) or Direct Invoicing — No Load (DIRCTIV2). |
Access the Populate Billing page.
Billing Unit, Order Management Unit, Inventory Business Unit |
Select a combination. If you want to select data for all PeopleSoft Order Management or Inventory business units, enter the Billing Unit but leave the Order Management Unit or Inventory Business Unit blank. The OM Billing Interface process then selects data for all Order Management or Inventory business units that are tied to the Billing Unit on the page. |
Sold To Customer, Bill To Customer, Order No, Shipping ID, Instance, Interface ID |
Use these fields to narrow the scope of the shipment history that is sent to PeopleSoft Billing for invoicing. |
Only Process Paid Orders |
You can optionally select paid orders. |
Run |
The Process Scheduler Request page appears, choose to run:
Note. If you run OM Billing Interface (OM_BILL) individually, you must run the Billing Interface (BIIF001) to move the data from the interface tables to the Billing tables so that the invoice can be created. You need the OM Billing Interface ID from the OM Billing Interface instance to run the Billing Interface. The Interface ID is found in the message log of the OM Billing Interface process instance. |
This section provides an overview, common elements, and discusses how to :
Process billing activity automatically.
Process billing activity manually.
Because nonstock products aren't shipped, the system builds shipment history for nonstock products when they are marked for billing.
When an order is saved or Populate Demand (OM_DEMAND) is run, non-stock products and products that are shipped directly from the vendor to the customer, will be inserted as IN_FULFILL_STATE = ‘10’ (Pending) in IN_DEMAND. When Mark Lines for Billing is run , the status in IN_DEMAND will be updated to ‘70’ (Depleted).
A row will be inserted into IN_DEMAND_ADDR with the correct ship to address for the order schedule. If an override exists, that address will be used and the IN_DEMAND.ADDR_OVRD_LEVEL will be set to ‘D’. If the quantity is less then the quantity scheduled, a new pending row will be inserted into IN_DEMAND representing the difference between the quantity shipped and the quantity scheduled.
Note. You can not Mark Lines for Billing if an active hold exists for the schedule and the pass to billing flag for that hold type on the order management business unit definition is turned off.
Note. Sales orders that PeopleSoft Contracts generates that have nonstocked or direct-shipped order schedules must also run any of the options to mark lines for billing to create the shipping history and costing data for Order Management and Inventory. Only nonstock products that are type General Use Including Contracts or General Use Excluding Contracts are processed through Mark Lines for Billing.
The OM Billing Interface process handles billing for products and product kits differently:
Products for shipment history are selected, even if the scheduled quantity is only partially shipped.
For example, if 10 workstations are scheduled and four are shipped today, then four are billable today. If six more ship next week, then they are billable when shipped. In other words, products can be billed even if the order line quantity is partially shipped. A bill line is eventually generated for each shipment after the billing interface is run.
Product kits, on the other hand, are billable when the required components ship in ratios that form a complete kit. If you have components that are not marked as required, those components are not considered when determining if a full kit has shipped.
A product kit that has required stock and nonstock items is invoiced when the stock items are shipped.
For example:
An order is placed for five of product kit 670001−Standard Desktop System. This table lists the components for each kit and the components that are available to pick and ship:
Components |
Required |
Component Per Kit |
Component Quantity Available |
10001-Monitor |
Yes |
1 |
5 |
10002-Keyboard |
Yes |
1 |
5 |
10003-Hard-drive |
Yes |
1 |
4 |
10004–Software |
No |
1 |
5 |
Because only four hard-drives are available, four kits are shipped and PeopleSoft Billing invoices for the four complete kits that are shipped. The non-required component is not included in the calculation.
Billing Product Kits/Configured Kits with Nonstock Components
If a kit contains required nonstock products, the number of these components that are marked for billing must equal the available stocked components to maintain the correct kit completion ratio.
Note. A product/configured kit that has required stock and nonstock items is invoiced when the stock items are shipped. If you select the Mark for Billing at Order Save option on the Order Entry Features page, the nonstock items are marked for billing when the order schedule is saved. If the OM Billing Interface is run before the stocked components are shipped, the kit isn’t invoiced, even though the nonstock items are billable. The kit is invoiced when the stock items are shipped.
Changes to Product Kit Schedules
When an order schedule for a product kit is saved with a status of open, the demand for the stocked components is staged in the PeopleSoft Inventory demand table (IN_DEMAND) as separate demand lines that are tied to the parent product ID. The date for the demand lines is the scheduled shipment date of the order schedule. The system compares the effective date for each of the stocked components to the shipment date to determine the valid components for the kit at the time of shipment.
If you mark a product kit component obsolete after demand for the kit is sent to PeopleSoft Inventory, the demand for the kit is not changed. The fulfillment and invoicing process for the schedule continues. To correct Inventory demand, you must cancel the existing schedule for the kit and add a new schedule.
See Changing Orders.
Distrib. Type (distribution type) |
Distribution types determine which cost of goods sold account is debited and which offset account is credited. PeopleSoft Inventory handles the distribution type for stocked items at the time of shipment. For nonstock products, optionally select a value on the Order Schedule Distribution page. If a value doesn't exist for nonstock order schedules, use this field to select a value for the system to use as the default for those schedules. Note. If a direct-shipped order schedule is for a product that is normally stocked in PeopleSoft Inventory, the system uses the distribution type that is defined for that product in Inventory and not the default that you choose on this page. |
Page Name |
Object Name |
Navigation |
Usage |
RUN_OM_MARKLN |
Order Management, Quotes and Orders, Create OM Billing Entries, Process Mark Lines for Billing |
Establish the process parameters to automatically insert order schedule lines into the PeopleSoft Inventory shipping history staging table (IN_DEMAND) for nonstock and direct-shipped order schedules, insert costing data to CM_CST_NSSHIP, and set the status for nonstock products to Ready for Invoicing. For direct-shipped schedules, you can include matched lines only, when there is a matching payables invoice for the purchasing receipt. Note. This process is for all non-stock products and direct ships. |
|
SHIP_NONSTK |
Order Management, Quotes and Orders, Create OM Billing Entries, Mark Lines For Billing |
Manually record shipment history for all nonstock products, product kit components and configured kit components. |
Access the Mark Lines for Billing process page.
Mark Direct Ship If Matched Only |
If you select the check box, the process inserts demand lines for direct-shipped order schedules only if there is a PeopleSoft Payables invoice for the Purchasing receipt. If you do not select this check box, all direct-shipped schedules are inserted as shipped lines (IN_DEMAND) in PeopleSoft Inventory. |
Schedule Thru Date/Time |
To restrict the order schedules that are picked up by the process to a range of dates, enter a value in the field. All order schedules that are scheduled to ship at any time up to and including the value that you enter are included. |
Ship Date/Time |
The system uses the date that you enter as the default for nonstock order schedules. Because these schedules don't actually ship, this date indicates when the service is provided. |
Access the Mark Lines for Billing page.
Quantity Shipped |
The value appears by default from the line and can’t be changed if it’s shipped or billed. |