Populating Billing

The topic provides an overview of the Populate Billing process, lists prerequisites, and discusses how to run the Populate Billing process (OM_BILL).

Page Name

Definition Name

Usage

Populate Billing Page

RUN_OM_BILLING1

Establish process parameters to run the Populate Billing process (OM_BILL) to populate the Billing Interface or the OM Invoicing multi-process job (OM_IVC). The OM Invoicing process runs the Populate Billing, the Billing Interface, and the Process VAT Defaults or as part of Direct Invoicing (DIRCTIVC) or Direct Invoicing – No Load (DIRCTIV2).

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:

  • Populate Billing (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 Populate Billing job (OM_IVC), which combines both processes and runs these processes:

  • Populate Billing (OM_BILL)

  • Billing Interface (BIIF0001)

  • Process VAT Defaults (BIPVAT00)

Note: If you run the Populate Billing process individually, run the Billing Interface to move the data from the interface tables to the Billing tables to create invoices. Use the Populate Billing interface ID from the OM Billing Message Log page to run the Billing Interface.

Note: The Billing Interface table (INTFC_BI) does not 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.

  1. Establish business unit options.

    1. If you are 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.

    2. If you are 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.

  2. Establish distribution codes and required billing options to send information to PeopleSoft General Ledger through PeopleSoft Billing.

    1. If you are billing by billing business unit, use the Accounting and Billing page.

    2. If you are billing by inventory business unit, use the Inventory Definition - Business Unit Options: Revenue and Billing Defaults page.

  3. Establish automatic numbering for invoices on the Installation Options - Billing - General Options page.

  4. 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.

Use the Populate Billing page (RUN_OM_BILLING1) to establish process parameters to run the Populate Billing process (OM_BILL) to populate the Billing Interface or the OM Invoicing multi-process job (OM_IVC).

The OM Invoicing process runs the Populate Billing, the Billing Interface, and the Process VAT Defaults or as part of Direct Invoicing (DIRCTIVC) or Direct Invoicing – No Load (DIRCTIV2).

Navigation:

Order Management > Quotes and Orders > Create OM Billing Entries > Process OM Billing

Field or Control

Description

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 Populate Billing 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 counter sales orders only.

See Populating Billing for Counter Sales Orders

Run

The Process Scheduler Request page appears, choose to run:

  • The Direct Invoicing (DIRCTIVC) multi-process job.

    The Direct Invoicing – No Load (DIRCTIV2) multi-process job.

  • The Populate Billing process individually.

  • The OM Invoicing multiprocess job which runs Populate Billing, Billing Interface, and Process VAT Defaults.

Note: If you run Populate Billing (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 Populate Billing ID from the Populate Billing instance to run the Billing Interface. The Interface ID is found in the message log of the Populate Billing process instance.

Set up the EMP_SERVLET for the notifications used with URL Locations prior to running the process.

See Setting Up the URL Location for Notifications.