Configuring Invoicing Jobs

This chapter provides overviews of the invoicing processes and the delivered invoicing jobs which contain these processes, discusses the details of the direct invoicing jobs, and discusses how to configure and optimize the invoicing jobs.

Click to jump to parent topicUnderstanding Invoicing Processes

This section provides an overview of invoice processing and discusses:

Click to jump to top of pageClick to jump to parent topicInvoice Processing

PeopleSoft Billing generates invoices from the data stored in the Billing tables when an invoicing job is run. The components of an invoicing job can include AE, SQR, and Crystal processes, as well as subjobs. You can configure the invoicing jobs so that all the processes needed to generate an invoice are part of a single job, or you can use separate jobs to divide the invoicing process into logical steps. Likewise, you can configure a single job to generate all types of invoice forms, or you can use different jobs for different types of invoice forms.

The typical steps required to generate an invoice include:

When configuring invoice jobs, you must maintain the proper processing order. The processes and subjobs within a job can be configured to run in series or in parallel. In general, pre- and post-process steps must be run in series, while the processes that print the different types of invoice can be run in parallel.

Click to jump to top of pageClick to jump to parent topicPreprocesses

Before invoices can be printed, the billing data must be imported (for Interface bills), validated, and finalized.

This table lists the processes used to prepare billing data for invoicing (in alphabetical order):

Process Name

Type

Prerequisites

Notes

BIIF0001

AE

External sources of billing data must load the Billing interface tables.

Transfer data from the interface tables to the standard Billing tables. BIIF0001 can be run on its own, or as part of a larger job such as in direct or streamlined invoicing.

See Understanding the Billing Interface Process Main Processing Logic.

BIIVC000

AE

BIPVAT00 must be run before BIIVC000, if VAT defaulting is required.

Prepare bills for invoicing. No further changes can be made to billing data after the BIIVC000 process is run.

BIPVAT00

AE

Must be run before BIIVC000 for those transactions that are subject to VAT taxation.

Set VAT defaults.

See Understanding the Process VAT Defaults Process (BIPVAT00).

BIRMAADJ

AE

 

Load RMA adjustments into the billing interface tables.

See Managing Returned Material.

IN_FUL_CONF

AE

 

Confirm inventory picking.

See Picking Inventory.

IN_PUB_MSG

AE

 

Publish inventory outbound message.

See Understanding Order Fulfillment Processing.

INS6300

SQR

 

Load interunit transfer bills into the billing interface tables.

See Transferring Stock Between Business Units.

INS6500

SQR

 

Generate inventory packing slips.

See Understanding Order Fulfillment Processing.

OM_BILL

AE

 

Load PeopleSoft Order Management bills into the billing interface tables.

See Populating Billing.

Understanding Finalization (BIIVC000)

The Finalization process selects bills that are ready for invoicing and validates and transforms the bill data. The process works in two modes. In pro forma mode, the process performs data validations and transformations that are necessary to preview the invoice. In finalization mode, the process carries out the same tasks as in pro forma mode and also performs final processing, such as setting the invoice date and status, and processing credit cards. Any number of pro formas can be created for a single bill; however, a bill can only be finalized once.

The Finalization process performs the following tasks (the tasks performed only in finalization mode are noted):

Note. Use the Message Log page to review the results of this process online.

Platform-Specific Statements in BIIVC000

Because the ROUND and DATETIME functions differ from platform to platform, the system creates the following platform-specific sections:

DBSPEC

DAY-related statement.

DBSPEC05, 06, 07, 08

Due date calculation.

DBSPEC10, 11

ROUND function for tax calculation without VAT.

DBSPEC25, 26

ROUND function for tax calculation with VAT.

BIBIIVC000_UPD
_BI_HDR

Bill Header multi-column update.

BIBIIVC000_UPD
_BI_HDR_VAT

Bill Header VAT multi-column update.

BIBIIVC000_UPD
_BI_LINE

Bill Line multi-column update.

BIBIIVC000_UPD
_BI_LINE_TAX

Bill Line Tax multi-column update.

BIBIIVC000_UPD
_BI_LINE_EXS_DTL

Bill Line Excise and Sales Tax multi-column update.

Finalization Errors

BIIVC000 validates bill data during pro forma and finalization processing. The following error codes are issued to BI_HDR and BI_LINE for validation and processing errors:

0120

Invalid Tax Code.

0233

Missing or invalid bill currency.

0900

Missing Remit To / Bank Code.

0901

Invalid Invoice Form for Accepgiro.

0902

Invalid Bank CD for Accepgiro.

0903

Invalid Bank Account for Accepgiro.

1000

AVP Error.

1050

Ship To Geocode Not Numeric.

1055

Ship From Geocode Not Numeric.

1060

Order Acc Geocode Not Numeric.

1110

Missing Ship To Cust ID. (missing ship-to customer ID)

1111

Invalid Ship To Cust Addr. (invalid ship-to customer address)

1112

Invalid HDR Ship To Cust Addr. (invalid header ship-to customer address)

1120

Invalid Ship From Bus Unit. (invalid ship-from business unit)

1121

Invalid Ship From Bus Unit Loc. (invalid ship-from business unit location)

1122

Invalid Ship From Location.

1123

Missing Inventory BU Location. (missing Inventory business unit location)

1130

Missing Order Mgmt Bus Unit. (missing Order Management business unit)

1131

Invalid Ord Mgmt Bus Unit Loc. (invalid Order Management business unit location)

1132

Invalid Business Unit Loc. (invalid business unit location)

1140

Order Accept Address not found.

1141

Order Origin Address not found.

1142

Location Address is incomplete.

1143

Original BU/INV does not exist.

1200

Line(s) contain error.

1210

Attached Bill(s) contain error.

1220

Consolidation group has error.

1300

Missing active Remit To Address.

1310

Missing active Bill To Address.

1350

Missing active Payment Terms.

1360

Missing active Distribution CD. (missing active distribution code)

1370

Missing Invoice Date. Rerun the program.

1380

Error calculating Due Dates.

1400

Missing Email ID for Contact.

1410

Contact Not Set up for eBill Payment.

1420

Contact has no row-level security on the Bill-To Customer of the bill.

1430

Email Notification Failed.

2033

Financial sanctions list match.

2040

Invalid Tax Vendor Supplied.

2041

Invalid action supplied.

2042

Ship To address required.

2043

No Geocode found -ShipTo ZIP. (no geocode found - ship-to zip code)

2044

Invalid ShipTo Geocode.

2045

No Geocode found - ShipFr ZIP. (no geocode found - ship-from zip code)

2046

Invalid Ship From Geocode.

2047

No Geocode found - Ord Acc ZIP. (no geocode found - order acceptance address zip code)

2048

Invalid Ord Accept Geocode. (invalid order acceptance geocode)

2050

Error calculating tax.

2051

No Tax Provider Install data.

2052

Tax Vendor Error.

2053

No Tax Vendor Application.

2054

Tax Upgrade Not Run.

2100

Invalid Tax Code.

2110

Interlink Tax Error.

2111

Integration Gateway Error.

2150

Invalid Tax Authority Code.

2160

Incomplete Header VAT Defaults.

2170

Incomplete Line VAT Defaults.

2500

Missing Intrastat NatureOfTxn1. (missing intrastat nature-of-taxation one)

2510

Missing Intrastat NatureOfTxn2. (missing intrastat nature-of-taxation two)

2520

Missing Intrastat Fiscal Regm. (missing intrastat fiscal regime)

2600

Missing VAT Reporting Country.

2650

Missing Supply State.

2800

Excise and Sales Tax Defaulting Not Applied.

2810

No Excise, Sales Tax, or VAT Rate Code.

2820

No Excise Tax Rate Details.

2830

No Sales Tax or VAT Rate Details.

2840

Excise and/or Sales Tax Calculation Error.

2850

No Tax Transaction Type.

2860

Missing Excise Tax Parameter(s).

2870

Missing Sales Tax or VAT Parameter(s).

2880

No Excise Conversion Rate.

3000

Missing EDI Profile. (missing electronic data interchange profile)

3100

Document Sequence Error.

3110

Missing DOC TYPE on Billing BU. (missing document type on billing business unit)

3500

Missing Currency Rate Type.

3530

Missing Euro exchange rates.

Click to jump to top of pageClick to jump to parent topicPrint Processes

The print processes consist of the data extract process, which copies bill data to temporary extract tables and print processes for generating each type of invoice. There are three types of print processes, which are SQR, Crystal and XML Publisher reports. Each printing process selects bills from the extract tables that meet the requirements for the type of invoice it generates.

Crystal invoices have two parts; queries that select the invoices to process from the extract tables, and a Crystal report form that defines the format and the layout of the invoice. The delivered Crystal invoices each generate a single form of invoice.

The delivered SQR programs combine invoice selection, layout, and formatting in a single, modular program. Most of the SQR programs can generate several forms of invoice within a given layout; however, separate SQR programs are used for consolidated versus nonconsolidated invoices, portrait versus landscape invoices, and summarized versus detailed invoices. Thus one SQR program prints consolidated, portrait, and detailed invoices, while another prints consolidated, landscape, and detailed invoices. Not every combination is available in the delivered SQR programs. For example, summarized invoices are only provided in landscape format.

Similar to Crystal, XML Publisher invoices have two parts:

The print processes and queries can be modified to produce tailored invoice forms.

See Understanding Invoice Forms.

This table lists the print process options:

Print Processes

Process Name

Type

Layout

Prerequisites

Notes

BI_IVCEXT

AE

 

BIIVC000

Extracts billing data to the temporary extract tables. BI_IVCEXT must be run before any of the other print processes.

BICA

Crystal

Portrait

BI_IVCEXT

PS/CA Contracts invoice.

BICAA

Crystal

Portrait

BI_IVCEXT

PS/CA Contracts invoice with acceptgiro.

BICLSUM

Crystal

Landscape

BI_IVCEXT

Summarization invoice.

BICLSUMC

Crystal

Landscape

BI_IVCEXT

Consolidated summarization invoice.

BIGIVCPN

SQR

Portrait

BI_IVCEXT

Grants invoices.

BIIVCLC

SQR

Landscape

BI_IVCEXT

Consolidated invoices.

BIIVCLN

SQR

Landscape

BI_IVCEXT

Nonconsolidated invoices.

BIIVCPC

SQR

Portrait

BI_IVCEXT

Consolidated invoices.

BIIVCPCA

SQR

Portrait

BI_IVCEXT

Consolidated acceptgiro invoices.

BIIVCPN

SQR

Portrait

BI_IVCEXT

Nonconsolidated invoices.

BIIVCPNA

SQR

Portrait

BI_IVCEXT

Nonconsolidated acceptgiro invoices.

BIPRNC00

Crystal

Landscape

BI_IVCEXT

Generic consolidated invoice.

BIPRNC02

Crystal

Landscape

BI_IVCEXT

PS/OM Order Management invoice.

BIPRNCA0

Crystal

Portrait

BI_IVCEXT

Generic consolidated acceptgiro invoice.

BIPRNCA2

Crystal

Portrait

BI_IVCEXT

Consolidated PS/OM Order Management acceptgiro invoice.

BIPRNT00

Crystal

Portrait

BI_IVCEXT

Generic invoice. Prints header notes at the bottom of the invoice. Prints line notes after the line.

BIPRNT01

Crystal

Landscape

BI_IVCEXT

PS/PC - Project Costing invoice.

BIPRNT02

Crystal

Landscape

BI_IVCEXT

PS/OM - Order Management invoice. This query subtotals (on LINE_TYPE), prints configuration detail, and prints product kit description.

BIPRNTA0

Crystal

Portrait

BI_IVCEXT

Generic acceptgiro invoice.

BIPRNTA2

Crystal

Portrait

BI_IVCEXT

Order Management acceptgiro invoice.

BIPSA01

Crystal

Portrait

BI_IVCEXT

PS/PSA01 - Projects By Employee invoice.

BIPSA02

Crystal

Portrait

BI_IVCEXT

PS/PSA02 - Projects By Activity invoice.

BIPSA03

Crystal

Portrait

BI_IVCEXT

PS/PSA03 - Project Detail invoice.

BIPSAA1

Crystal

Portrait

BI_IVCEXT

PS/PSA01 - Projects By Employee acceptgiro invoice.

BIPSAA2

Crystal

Portrait

BI_IVCEXT

PS/PSA02 - Projects By Activity acceptgiro invoice.

BIPSAA3

Crystal

Portrait

BI_IVCEXT

PS/PSA03 - Project Detail acceptgiro invoice.

BISF108X

SQR

Portrait

BI_IVCEXT

Standard Forms 1080 and 1081.

BISLSUM

SQR

Landscape

BI_IVCEXT

Summarization invoices.

BISLSUMC

SQR

Landscape

BI_IVCEXT

Consolidated summarization invoices.

BI_PRNXPN01

Application Engine (XML Publisher)

Portrait

BI_IVCEXT

Sample XML Publisher invoice

BIPRNXPC01

Application Engine (XML Publisher)

Portrait

BI_IVCEXT

Sample XML Publisher consolidated invoice

Click to jump to top of pageClick to jump to parent topicEmail Notification (Paperless Invoices)

The BIIVCEMAIL Email Notification process sends an email to billed customers for invoices that were finalized with an Invoice Media setting of Email. The process can be run independently from its own run control page, or it can be incorporated into one or more of the invoicing jobs. If incorporated, the Email Notification process must follow the BIIVC000 finalization process.

Note. The BI_WF_0001 Invoice Notification process can also be used to send email notifications to customers.

See Also

Running the Email Notification Process

Running the Invoice Notification Process

Click to jump to top of pageClick to jump to parent topicPost-Invoicing Processes

After you generate a set of invoices, several processes can be run to create accounting entries.

This table lists the Billing post-invoice processes (in alphabetical order):

Note. Additional processes not listed here may also be required when finalized invoice data needs to be sent back to integrated applications such as Project Costing and Contracts.

Process Name

Type

Prerequisites

Notes

BICRC000

AE

BIIVC000

Credit card processing.

BICURCNV

AE

BIIVC000 and BICRC000 (when credit card payments are accepted).

Billing currency conversion.

Warning! Do not run the Currency Conversion process concurrently. If you run two Currency Conversion processes at the same time, one or both processes may fail.

See Understanding the Currency Conversion Process (BICURCNV).

BIGNAP01

SQR

BIPRELD

Generate AP vouchers.

BILDAR01

SQR

BIPRELD

Load AR pending items.

BILDGL01

SQR

BIPRELD

Load GL interface.

BIPCC000

AE

 

Billing to PC/CA Interface.

BIPRELD

AE

BICURCNV

Billing preload process.

FS_BP

AE

BILDGL01

Commitment Control Budget Check.

Click to jump to parent topicUnderstanding the Delivered Invoicing Jobs

The delivered invoicing jobs combine invoicing processes and subjobs to provide a range of options for generating invoices. You should reconfigure the delivered jobs to suit your company's business needs.

Note. If the Billing Interface process is run as a part of a job, such as Indirect Invoicing, that gets initiated by an upstream product, such as OM, the RANGE_SELECTION_ID field should be added to the Bill By identifier. This allows the billing processes to identify what transaction needs to be processed.

Note. Subjobs in the Components column are indicated with the emphasis style.

The following jobs are provided:

Job Name

Classification

Description

Components

BICPJ00

Print subjob

Print nonconsolidated Crystal invoices

  • BIPRNT00

  • BIPRNT01

  • BIPRNT02

  • BIPSA01

  • BIPSA02

  • BIPSA03

  • BICA

BICPJ00C

Print subjob

Print consolidated Crystal invoices

  • BIPRNC00

  • BIPRNC02

BICPJ10C

Print

Print consolidated SQR invoices

  • BI_IVCEXT

  • BISPJ00C

  • BISLSUMC

BICPJ11C

Print

Print portrait SQR invoices

  • BI_IVCEXT

  • BIIVCPC

BICPJ40C

Print

Print consolidated Crystal invoices

  • BI_IVCEXT

  • BICPJ00C

  • BICLSUMC

BICPJA00

Print subjob

Print Crystal acceptgiro invoices

  • BIPRNTA0

  • BIPRNTA2

  • BIPSAA1

  • BIPSAA2

  • BIPSAA3

  • BICAA

BICPJA0C

Print subjob

Print consolidated Crystal acceptgiro invoices

  • BIPRNCA0

  • BIPRNCA2

BIDIRIV2

Interface, preprocess, finalize, and print

Direct invoicing (no postprocesses)

See The BIDIRIVC Jobs.

  • BIIF0001

  • BIPVAT00

  • BIIVC000

  • BI_IVCEXT

  • BISPJ00

  • BICPJ00

  • BICPJA00

  • BISLSUM

  • BI_PRNXPN01

  • BICLSUM

BIDIRIVC

Interface, preprocess, finalize, print, and postprocess

Direct invoicing

See The BIDIRIVC Jobs.

  • BIIF0001

  • BIPVAT00

  • BIIVC000

  • BI_IVCEXT

  • BISPJ00

  • BICPJ00

  • BICPJA00

  • BISLSUM

  • BI_PRNXPN01

  • BICLSUM

  • BIGIVCPN

  • BIDIRIVC

  • BICURCNV

  • BIPRELD

  • BILDGL01

  • BILDAR01

  • BISF108X

  • BIGNAP01

BIINIU

Interface, preprocess, finalize, print, and postprocess

InterUnit inventory transfer

See The BIINIU Job.

  • INS6300

  • BIIF0001

  • BIPVAT00

  • BIIVC000

  • BI_IVCEXT

  • BISPJ00

  • BICPJ00

  • BICPJA00

  • BISLSUM

  • BI_PRNXPN01

  • BICLSUM

  • BICURCNV

  • BIPRELD

  • BILDAR01

  • BILDGL01

  • BIGNAP01

BIINIU2

Interface, preprocess, finalize, and print

InterUnit inventory transfer (no Crystal or postprocesses)

See The BIINIU Job.

  • INS6300

  • BIIF0001

  • BIPVAT00

  • BIIVC000

  • BI_IVCEXT

  • BISPJ00

  • BISLSUM

BIINIU3

Interface, preprocess, finalize, print SQR, and postprocess

InterUnit inventory transfer (No Crystal processes)

See The BIINIU Job.

  • INS6300

  • BIIF0001

  • BIPVAT00

  • BIIVC000

  • BI_IVCEXT

  • BISPJ00

  • BISLSUM

  • BICURCNV

  • BIPRELD

  • BILDAR01

  • BILDGL01

  • BIGNAP01

BIJOB01

Finalize and print

Finalize and print SQR, XML Publisher, and Crystal invoices

  • BIIVC000

  • BI_IVCEXT

  • BISPJ00

  • BICPJ00

  • BISLSUM

  • BI_PRNXPN01

  • BICLSUM

  • BIGIVCPN

BIJOB02

Finalize and print

Finalize and print consolidated SQR, XML Publisher, and Crystal invoices

  • BIIVC000

  • BI_IVCEXT

  • BISPJ00C

  • BICPJ00C

  • BISLSUMC

  • BI_PRNXPN01

  • BICLSUMC

BIJOB03

Finalize, print, and postprocess

Single action. Print SQR, XML Publisher, Crystal, and acceptgiro invoices

  • BIIVC000

  • BI_IVCEXT

  • BISPJ00

  • BICPJ00

  • BICPJA00

  • BISLSUM

  • BI_PRNXPN01

  • BICLSUM

  • BIGIVCPN

  • BICURCNV

  • BIPRELD

  • BILDGL01

  • BILDAR01

  • BISF108X

  • BIGNAP01

BIJOB03K

Finalize, print, and postprocess

Single action. Print SQR, XML Publisher, Crystal, and acceptgiro invoices with commitment control

  • BIIVC000

  • BI_IVCEXT

  • BISPJ00

  • BICPJ00

  • BICPJA00

  • BISLSUM

  • BI_PRNXPN01

  • BICLSUM

  • BIGIVCPN

  • BICURCNV

  • BIPRELD

  • BILDGL01

  • FS_BP

  • BILDAR01

  • BISF108X

  • BIGNAP01

BIJOB04

Finalize, print, and postprocess

Single Action. Print consolidated SQR, XML Publisher, Crystal, and acceptgiro invoices

  • BIIVC000

  • BI_IVCEXT

  • BISPJ00C

  • BICPJ00C

  • BISLSUMC

  • BI_PRNXPC01

  • BICLSUMC

  • BICURCNV

  • BIPRELD

  • BILDGL01

  • BILDAR01

  • BIGNAP01

BIJOB04K

Finalize, print, and postprocess

Single Action. Print consolidated SQR, XML Publisher, Crystal, and acceptgiro invoices with commitment control

  • BIIVC000

  • BI_IVCEXT

  • BISPJ00C

  • BICPJ00C

  • BICPJA0C

  • BISLSUMC

  • BI_PRNXPC01

  • BICLSUMC

  • BICURCNV

  • BIPRELD

  • BILDGL01

  • FS_BP

  • BILDAR01

  • BIGNAP01

BIJOB05

Postprocess

Currency conversion, preload accounting entries, and load AR

  • BICURCNV

  • BIPRELD

  • BILDAR01

BIJOB06

Postprocess

Currency conversion, preload accounting entries, and load GL

  • BICURCNV

  • BIPRELD

  • BILDGL01

BIJOB06K

Postprocess

Currency conversion, preload accounting entries, and load GL with commitment control

  • BICURCNV

  • BIPRELD

  • BILDGL01

  • FS_BP

BIJOB07

Interface and preprocess

Process RMA adjustments through the Billing interface and VAT defaults

  • BIRMAADJ

  • BIIF0001

  • BIPVAT00

BIJOB08

Finalize and print

Single Action. Print SQR, Crystal, and acceptgiro invoices without postprocesses

  • BIIVC000

  • BI_IVCEXT

  • BISPJ00

  • BICPJ00

  • BICPJA00

  • BISLSUM

  • BICLSUM

  • BIGIVCPN

  • BIGNAP01

BIJOB09

Print

Extract and print generic Crystal invoices

  • BI_IVCEXT

  • BIPRNT00

  • BICLSUM

BIJOB10

Print

Extract and print Crystal PS/PC invoices

  • BI_IVCEXT

  • BIPRNT01

  • BICLSUM

BIJOB11

Print

Extract and print Crystal PS/OM invoices

  • BI_IVCEXT

  • BIPRNT02

  • BICLSUM

BIJOB12

Print

Extract and print consolidated Crystal invoices

  • BI_IVCEXT

  • BIPRNC00

  • BICLSUMC

BIJOB13

Print

Extract and print consolidated PS/OM invoices

  • BI_IVCEXT

  • BIPRNC02

  • BICLSUMC

BIJOB14

Print

Extract and print Crystal PS/CA invoices

  • BI_IVCEXT

  • BICA

  • BICLSUM

BIJOB15

Print

Extract and print Crystal PS/PSA01 invoices

  • BI_IVCEXT

  • BIPSA01

  • BICLSUM

BIJOB16

Print

Extract and print Crystal PS/PSA02 invoices

  • BI_IVCEXT

  • BIPSA02

  • BICLSUM

BIJOB17

Print

Extract and print Crystal PS/PSA03 invoices

  • BI_IVCEXT

  • BIPSA03

  • BICLSUM

BIJOB18

Postprocess

Currency conversion and preload accounting entries

  • BICURCNV

  • BIPRELD

BIJOB19

Reprint

Reprint invoices

  • BI_IVCEXT

  • BISPJ00

  • BICPJ00

  • BICPJA00

  • BISLSUM

  • BI_PRNXPN01

  • BICLSUM

  • BIGIVCPN

  • BISF108X

BIJOB20

Print

Print portrait SQR invoices

  • BI_IVCEXT

  • BIIVCPN

  • BISLSUM

BIJOB21

Print

Print portrait consolidated SQR invoices

  • BI_IVCEXT

  • BIIVCPC

  • BISLSUMC

BIJOB22

Print

Print landscape SQR invoices

  • BI_IVCEXT

  • BIIVCLN

  • BISLSUM

BIJOB23

Print

Print landscape consolidated SQR invoices

  • BI_IVCEXT

  • BIIVCLC

  • BISLSUMC

BIJOB24

Print

Print XML Publisher invoices for eBill Payment

  • BI_IVCEXT

  • BI_PRNXPN01

BIJOB25

Print

Print XML Publisher consolidated invoices for eBill Payment

  • BI_IVCEXT

  • BI_PRNXPC01

BIJOB50

Finalize, print, and postprocess

Single Action. Print Project Costing and Contracts invoices

  • BIGMLOC

  • BIIVC000

  • BI_IVCEXT

  • BISPJ00

  • BICPJ00

  • BICPJA00

  • BISLSUM

  • BICLSUM

  • BICURCNV

  • BIPRELD

  • BILDGL01

  • BILDAR01

  • BIGNAP01

BIJOB51

Finalize and print

Finalize and print Crystal invoices

  • BIIVC000

  • BI_IVCEXT

  • BICPJ00

  • BICPJA00

  • BICLSUM

BIJOB52

Finalize and print

Finalize and print consolidated Crystal invoices

  • BIIVC000

  • BI_IVCEXT

  • BICPJ00C

  • BICPJA0C

  • BICLSUMC

BIJOBI01

Interface and preprocess

Process Billing interface and VAT Defaults

  • BIIF0001

  • BIPVAT00

BIJOBP01

Pro forma

Print pro formas

  • BIIVC000

  • BI_IVCEXT

  • BISPJ00

  • BICPJ00

  • BICPJA00

  • BISLSUM

  • BI_PRNXPN01

  • BICLSUM

  • BIGIVCPN

  • BISF108X

BIJOBP02

Pro forma

Print consolidated pro formas

  • BIIVC000

  • BI_IVCEXT

  • BISPJ00C

  • BICPJ00C

  • BISLSUMC

  • BI_PRNXPC01

  • BICLSUMC

BIJOBP03

Pro forma

Print pro forma

Note. BIPJOB03 is run from the Proforma button on the online bill entry pages.

  • BIIVC100

  • BI_IVCEXT

  • BISPJ00

  • BICPJ00

  • BISLSUM

  • BICLSUM

  • BI_PRNXPN01

  • BIGIVCPN

  • BISF108X

BIJOBP51

Pro forma

Print Crystal pro formas

  • BIIVC000

  • BI_IVCEXT

  • BICPJ00

  • BICPJA00

  • BICLSUM

BIJOBP52

Pro forma

Print consolidated Crystal pro formas

  • BIIVC000

  • BI_IVCEXT

  • BICPJ00C

  • BICPJA0C

  • BICLSUMC

BIPJ10

Print

Print/SQR invoices

  • BI_IVCEXT

  • BISPJ00

  • BISLSUM

BIPJ11

Print

Print portrait SQR invoices

  • BI_IVCEXT

  • BIIVCPN

BIPJ20

Print

Print Grants SQR invoices

  • BI_IVCEXT

  • BIGIVCPN

  • BISLSUM

BIPJ30

Print

Print SQR SF1080/81 forms

  • BI_IVCEXT

  • BISF108X

  • BISLSUM

BIPJ40

Print

Print Crystal invoices

  • BI_IVCEXT

  • BICPJ00

  • BICPJA00

  • BICLSUM

BIPJ50

Print

Print XML Publisher invoices

  • BI_IVCEXT

  • BI_PRNXPN01

BISPJ00

Print subjob

Print SQR invoices

  • BIIVCPN

  • BIIVCLN

  • BIIVCPNA

BISPJ00C

Print subjob

Print SQR invoices

  • BIIVCPC

  • BIIVCLC

  • BIIVCPCA

BIXPJ00C

Print

Print XML Publisher consolidated invoices

  • BI_IVCEXT

  • BI_PRNXPC01

DIRAUTO

Interface, preprocess, finalize, print, and postprocess

Print Order Management Direct Invoicing invoices having automatic approval

See The DIRAUTO Job.

  • IN_FUL_CONF

  • INS6500

  • IN_PUB_MSG

  • OM_BILL

  • INS6300

  • BIIF0001

  • BIPVAT00

  • BIIVC000

  • BI_IVCEXT

  • BISPJ00

  • BICPJ00

  • BISLSUM

  • BI_PRNXPN01

  • BICLSUM

  • BICURCNV

  • BIPRELD

  • BILDAR01

  • BILDGL01

  • BIGNAP01

DIRCTIV2

Interface, preprocess, finalize, and print

Print Order Management Direct Invoicing invoices (no postprocesses)

See The DIRCTIVC Job.

  • OM_BILL

  • BIIF0001

  • BIPVAT00

  • BIIVC000

  • BI_IVCEXT

  • BISPJ00

  • BICPJ00

  • BISLSUM

DIRCTIV3

Interface, preprocess, finalize, print SQR, and postprocess

Print Order Management Direct Invoicing invoices (No Crystal processes)

See The DIRCTIVC Job.

  • OM_BILL

  • BIIF0001

  • BIPVAT00

  • BIIVC000

  • BI_IVCEXT

  • BISPJ00

  • BISLSUM

  • BICURCNV

  • BIPRELD

  • BILDAR01

  • BILDGL01

  • BIGNAP01

DIRCTIVC

Interface, preprocess, finalize, print, and postprocess

Print Order Management Direct Invoicing invoices

See The DIRCTIVC Job.

  • OM_BILL

  • BIIF0001

  • BIPVAT00

  • BIIVC000

  • BI_IVCEXT

  • BISPJ00

  • BICPJ00

  • BICPJA00

  • BI_PRNXPN01

  • BISLSUM

  • BI_PRNXPN01

  • BICLSUM

  • BICURCNV

  • BIPRELD

  • BILDAR01

  • BILDGL01

  • BIGNAP01

Click to jump to parent topicUnderstanding the Direct Invoicing Jobs

Direct invoicing jobs streamline the billing process by combining several steps in the collection and processing of billing activity from other source systems. The PeopleSoft Billing user preferences that you set up on the User Preferences - Billing page as well as where you initiate direct invoicing determine which jobs are initiated.

This section discusses the details of:

Click to jump to top of pageClick to jump to parent topicThe DIRCTIVC Job

Use the DIRCTIVC job (initiated by clicking the Run Process button on the Shipping/Issues - Order Summary page), to create invoices for sales orders originating from PeopleSoft Order Management. The DIRCTIV2 job is similar to DIRCTIVC, but contains no Crystal or post invoicing processes. Likewise, the DIRCTIV3 job contains no Crystal processes, but does contain the post invoicing processes.

This table lists all of the processes that are part of the DIRCTIVC job used in PeopleSoft Inventory:

Process

What Gets Selected Now?

What Needs to Be Processed Later?

OM Billing Interface (OM_BILL)

All activity for Ship ID.

Nothing.

Billing Interface (BIIF0001)

All activity for INTFC ID. To process direct invoicing through the Billing Interface process, the Range Selection ID and Direct Invoicing fields must be part of the explicit bill-by criteria and must be populated on the interface transaction lines. Direct invoicing bills are created with a status of RDY (ready).

All activity for INTFC ID with errors.

VAT Defaulting (value-added tax) (BIPVAT00)

Applies defaults at the bill header and line levels for VAT fields. Selects all VAT bills with range selection ID specified by the direct invoicing job and with Defaults Applied=No. Status changes from RDY to HLD if defaulting fails. Defaults applied change to Yes if defaulting succeeds. If your business never processes VAT invoices, you can remove this step from the BIDIRIVC job.

All VAT bills with VAT defaulting errors.

Invoice Finalization (BIIVC000)

All bills for range selection ID with direct invoice option On. Status changes to:

  • FNL: If paid by credit card.

  • INV: If not paid by credit card.

All bills for range selection ID with direct invoice option Off. The status of activity not selected remains RDY.

Any bills for the range selection ID that were found to have errors.

Any pending credit card transactions that were created.

Invoice Extract Process (BI_IVCEXT)

Selects all printable bills with range selection ID specified by the direct invoicing job.

All printable bills will be extracted into the billing extract tables. This process also prepares the run control records for the SQR, Crystal and XML Publisher invoice print process.

 

Invoice Printing (BISPJ00, BICPJ00, BICPJA00, BI_PRNXPN01, BISLSUM, BICLSUM )

All printable bills extracted by the Invoice Extract process. The system prints these bills using one of several processes, depending on the invoice form.

All bills get marked as printed and get assigned a print date.

 

Billing Currency Conversion (BICURCNV)

All bills for range selection ID with a status of FNL or INV. Your business practices may dictate different timing for running currency conversion. However, currency conversion must be completed before billing activity can be interfaced to PeopleSoft Receivables or General Ledger.

All bills for range selection ID with direct invoice option Off.

Pre-Load (BIPRELD)

All bills for range selection ID with a status INV and which have completed currency conversion.

All bills for range selection ID with status RDY or FNL. All bills for ship ID with invoice and currency conversion errors.

Load Receivables (BILDAR01)

All bills for range selection ID with a status INV and which have completed currency conversion. Your business practices may dictate different timing for loading to PeopleSoft Receivables. You can remove this processes from the DIRCTIVC job.

All bills for range selection ID with status RDY or FNL. All bills for ship ID with invoice and currency conversion errors.

Load General Ledger (BILDGL01)

All bills for range selection ID with status INV and which have completed currency conversion. Your business practices may dictate different timing for loading to PeopleSoft General Ledger. You can remove this process from the DIRCTIVC job.

All bills for range selection ID with status RDY or FNL. All bills for ship ID with invoice and currency conversion errors.

Generate AP Voucher (BIGNAP01)

All bills for range selection ID with status INV and which have completed currency conversion.

All bills for range selection ID with status RDY or FNL. All bills for ship ID with invoice and currency conversion errors.

Warning! If you do not click the Run button on the Shipping/Issues - Order Summary page, you must run all of the processes individually.

See Also

Shipping Inventory

Click to jump to top of pageClick to jump to parent topicThe BIDIRIVC Jobs

The BIDIRIVC and BIDIRIV2 jobs carry out the Billing portion of the Projects and Contracts to Billing interface process. These jobs are normally called from the CA_BI_INTFC job as part of the larger process of moving bill data from Projects and Contracts to Billing and back. The BIDIRV2 job is identical to the BIDIRIVC job, except that it contains no post-invoicing processes.

This table lists all of the processes that are part of the BIDIRIVC and BIDIRIV2 jobs used in Contracts and Project Costing:

Process

What Gets Selected Now?

What Needs to Be Processed Later?

Billing Interface (BIIF0001)

All activity for INTFC ID. To process direct invoicing through the Billing Interface process, the Range Selection ID and Direct Invoicing fields must be part of the explicit bill-by criteria and must be populated on the interface transaction lines. Direct invoicing bills are created with a status of RDY (ready).

All activity for INTFC ID with errors.

VAT Defaulting (BIPVAT00)

Applies defaults at the bill header and line levels for VAT fields. Selects all of the VAT bills with Defaults Applied = No. Status changes from RDY to HLD if defaulting fails. Defaults applied changes to Yes if defaulting succeeds. If your business never processes VAT invoices, you can remove this step from the BIDIRIVC job.

All VAT bills with VAT defaulting errors.

Invoice Finalization (BIIVC000)

All bills for range selection ID with direct invoice option On. Status is changes to:

  • FNL: If paid by credit card.

  • INV: If not paid by credit card.

All bills for range selection ID with direct invoice option Off. The status of activity not selected remains RDY.

Any bills for the range selection ID that were found to have errors.

Need to process any pending credit card transactions that were created.

Invoice Extract Process (BI_IVCEXT)

Selects all printable bills with range selection ID specified by the direct invoicing job.

All printable bills will be extracted into the Billing extract tables. This process also prepares the run control records for the SQR, Crystal, and XML Publisher invoice print processes.

 

Invoice Printing (BISPJ00, BICPJ00, BICPJA00, BISLSUM, BICLSUM, BIGIVCPN,BI_PRNXPN01)

All printed bills extracted by the Invoice Extract process. The system prints these bills using one of several processes, depending on the invoice form.

All bills get marked as printed and get assigned a print date.

 

Billing Currency Conversion (BICURCNV)

All bills for range selection ID with a status of FNL or INV. Your business practices may dictate different timing for running currency conversion. However, currency conversion must be completed before billing activity can be interfaced to PeopleSoft Receivables or General Ledger.

All bills for range selection ID with direct invoice option Off.

Pre-Load (BIPRELD)

All bills for range selection ID with a status INV and which have completed currency conversion.

All bills for range selection ID with status RDY or FNL. All bills for ship ID with invoice and currency conversion errors.

Load Receivables (BILDAR01)

All bills for range selection ID with a status INV and which have completed currency conversion. Your business practices may dictate different timing for loading to PeopleSoft Receivables. You can remove this process from the BIDIRIVC job.

All bills for range selection ID with status RDY or FNL. All bills for range selection ID with invoice and currency conversion errors.

Load General Ledger (BILDGL01)

All bills for range selection ID with status INV and which have completed currency conversion. Your business practices may dictate different timing for loading to PeopleSoft General Ledger. You can remove this process from the BIDIRIVC job.

All bills for range selection ID with status RDY or FNL. All bills for range selection ID with invoice and currency conversion errors.

BISF108X

Print Standard forms 1080 and 1080X.

 

Generate AP Voucher (BIGNAP01)

All bills for range selection ID with status INV and which have completed currency conversion.

All bills for range selection ID with status RDY or FNL. All bills for range selection ID with invoice and currency conversion errors.

See Also

Integrating with PeopleSoft Contracts, Project Costing, Grants, and Pay/Bill Management

Processing Contracts Billing

Click to jump to top of pageClick to jump to parent topicThe BIINIU Job

You can initiate the BIINIU job from the Express Issue and Shipping/Issues - Order Summary page to create invoices for intercompany transfers.

The first process the system runs for this job is the Transfer Order Billing Load process (INS6300), which extracts all intercompany transfer order information with the same shipping identifier from the inventory shipping table (IN_DEMAND) and loads that information into the PeopleSoft Billing Interface table (INTFC_BI). Once this information is within PeopleSoft Billing, it's ready for subsequent processing. The BIINIU2 job is similar to BIINIU, but contains only SQR print processing and no post invoicing processes. Likewise, the BIINIU3 job contains only SQR print processes, but does contain the post invoicing processes.

You initiate the Transfer Order Billing Load process from the PeopleSoft Inventory Express Issue and Shipping/Issues components, as well as from the InterUnit Bill Load Process page.

Note. All shipment activity for a shipping identifier is loaded to PeopleSoft Billing even if the direct invoice option is not selected.

This table lists all of the processes that are part of the BIINIU job used in PeopleSoft Inventory:

Process

What Gets Selected Now?

What Needs to Be Processed Later?

Transfer Order Billing Load (INS6300)

All activity for ship ID.

Nothing.

Billing Interface (BIIF0001)

All activity for INTFC ID. For intercompany transfers with direct invoicing selected at the customer level, the Billing Interface process creates bills in RDY status, unless there are errors. For intercompany transfers without direct invoicing selected, the Billing Interface process creates bills according to the status that you defined on the Billing Bill By Identifier page: New, Pending, or Hold.

All activity for INTFC ID with errors.

VAT Defaulting (BIPVAT00)

Applies defaults at the bill header and line levels for VAT fields. Selects all VAT bills with Defaults Applied=No. Status changes from RDY to HLD if defaulting fails. Defaults applied change to Yes if defaulting succeeds. If your business never processes VAT invoices, you can remove this step from the BIINIU job.

All VAT bills with VAT defaulting errors.

Invoice Finalization (BIIVC000)

All bills for range selection ID with direct invoice option On. Status is changes to:

  • FNL: If paid by credit card.

  • INV: If not paid by credit card.

All bills for range selection ID with direct invoice option Off. The status of activity is RDY.

Any bills for the range selection ID that were found to have errors.

Any pending credit card transactions that were created.

Invoice Extract Process (BI_IVCEXT)

Selects all printable bills with range selection ID specified by the direct invoicing job.

All printable bills will be extracted into the Billing extract tables. This process also prepares the run control records for the SQR, Crystal, and XML Publisher invoice print processes.

 

Invoice Printing (BISPJ00, BICPJ00, BICPJA00, BISLSUM, BICLSUM, BI_PRNXPN01)

All printed bills extracted by the Invoice Extract process. The system prints these bills using one of several processes, depending on the invoice form.

All bills get marked as printed and get assigned a print date.

 

Billing Currency Conversion (BICURCNV)

All bills for range selection ID with a status of FNL or INV. Your business practices may dictate different timing for running currency conversion. However, currency conversion must be completed before billing activity can be interfaced to PeopleSoft Receivables or General Ledger.

All bills for range selection ID with direct invoice option Off.

Pre-Load (BIPRELD)

All bills for range selection ID with a status INV and which have completed currency conversion.

All bills for range selection ID with status RDY or FNL. All bills for ship ID with invoice and currency conversion errors.

Load Receivables (BILDAR01)

All bills for range selection ID with a status INV and which have completed currency conversion. Your business practices may dictate different timing for loading to PeopleSoft Receivables. You can remove this process from the BIINIU job.

All bills for range selection ID with status RDY or FNL. All bills for ship ID with invoice and currency conversion errors.

Load General Ledger (BILDGL01)

All bills for range selection ID with status INV and which have completed currency conversion. Your business practices may dictate different timing for loading to PeopleSoft General Ledger. You can remove this process from the BIINIU job.

All bills for range selection ID with status RDY or FNL. All bills for ship ID with invoice and currency conversion errors.

Generate AP Voucher (BIGNAP01)

All bills for range selection ID with status INV and which have completed currency conversion.

All bills for range selection ID with status RDY or FNL. All bills for ship ID with invoice and currency conversion errors.

See Also

Shipping Inventory

Transferring Stock Between Business Units

Creating Orders for Fulfillment

Click to jump to top of pageClick to jump to parent topicThe DIRAUTO Job

You can initiate the DIRAUTO job from the Ship and Invoice Process page to create invoices for sales orders (originating from PeopleSoft Order Management) and intercompany transfers. DIRAUTO takes stock requests that are confirmed on the Material Picking Feedback page and runs all of the remaining processes to invoicing. You must select the autoship option for any stock requests that you want to process.

This table lists all of the processes that are part of the DIRAUTO job used in PeopleSoft Inventory:

Process

What Gets Selected Now?

What Needs to Be Processed Later?

Picking Confirmation (IN_FUL_CONF)

All lines that match the selection criteria on the Ship and Invoice Process page.

All lines not marked as autoship, as well as any lines that could not be autoshipped.

Packing Slip (INS6500)

All lines that were shipped in the picking confirmation step.

Nothing.

Depletion (INPDDEPL)

All lines that were shipped in the picking confirmation step.

Nothing.

Advanced Shipping Notices (IN_PUB_MSG)

All lines that were shipped in the picking confirmation step.

Nothing.

OM Billing Interface (OM_BILL)

All lines originating from the PeopleSoft Order Management system that were depleted in the depletion step.

Nothing.

Transfer Order Billing Load (INS6300)

All activity for ship ID.

Nothing.

Billing Interface (BIIF0001)

All activity for INTFC ID. To process direct invoicing through the Billing Interface process, the Range Selection ID and Direct Invoicing fields must be part of the explicit bill-by criteria and must be populated on the interface transaction lines. Direct invoicing bills are created with a status of RDY (ready).

All activity for INTFC_ID with errors.

VAT Defaulting (BIPVAT00)

Applies defaults at the bill header and line levels for VAT fields. Selects all VAT bills with Defaults Applied=No. Status changes from RDY to HLD if defaulting fails. Defaults applied change to Yes if defaulting succeeds. If your business never processes VAT invoices, you can remove this step from the DIRAUTO job.

All VAT bills with VAT defaulting errors.

Invoice Finalization (BIIVC000)

All bills for range selection ID with direct invoice option On. Status changes to:

  • FNL: If paid by credit card.

  • INV: If not paid by credit card.

All bills for range selection ID with direct invoice option Off. The status of activity is RDY.

Any bills for the range selection ID that were found to have errors.

Any pending credit card transactions that were created.

Invoice Extract Process (BI_IVCEXT)

Selects all printable bills with range selection ID specified by the direct invoicing job.

All printable bills will be extracted into the Billing extract tables. This process also prepares the run control records for the SQR, Crystal, and XML Publisher invoice print processes.

 

Invoice Printing (BISPJ00, BICPJ00, BISLSUM, BICLSUM,BI_PRNXPN01 )

All printed bills extracted by the Invoice Extract process. The system prints these bills using one of several processes, depending on the invoice form.

All bills get marked as printed and get assigned a print date.

 

Billing Currency Conversion (BICURCNV)

All bills for range selection ID with a status of FNL or INV. Your business practices may dictate different timing for running currency conversion. However, currency conversion must be completed before billing activity can be interfaced to PeopleSoft Receivables or General Ledger.

All bills for range selection ID with direct invoice option Off.

Pre-Load (BIPRELD)

All bills for range selection ID with a status INV and which have completed currency conversion.

All bills for range selection ID with status RDY or FNL. All bills for ship ID with invoice and currency conversion errors.

Load Receivables (BILDAR01)

All bills for range selection ID with a status INV and which have completed currency conversion. Your business practices may dictate different timing for loading to PeopleSoft Receivables. You can remove this process from the DIRAUTO job.

All bills for range selection ID with status RDY or FNL. All bills for ship ID with invoice and currency conversion errors.

Load General Ledger (BILDGL01)

All bills for range selection ID with status INV and which have completed currency conversion. Your business practices may dictate different timing for loading to PeopleSoft General Ledger. You can remove this process from the DIRAUTO job.

All bills for range selection ID with status RDY or FNL. All bills for ship ID with invoice and currency conversion errors.

Generate AP Voucher (BIGNAP01)

All bills for range selection ID with status INV and which have completed currency conversion.

All bills for range selection ID with status RDY or FNL. All bills for Ship ID with invoice and currency conversion errors.

See Also

Shipping Inventory

Creating Shipping Documentation

Configuration of Order Fulfillment

Click to jump to parent topicConfiguring and Optimizing Invoicing Jobs

Consider both the human and the machine factors when configuring and optimizing invoicing jobs. Optimizing for the human factor requires matching the job definitions to natural work practices. Removing unneeded jobs can make the system simpler to operate and reduce user errors. Optimizing for the machine factor requires configuring the jobs to make efficient use of system resources. To improve the performance of the Billing jobs, consider the following:

Invoice Job Configuration Example

In this example, we will configure the BIJOB01 job to print only Project Costing and Contracts invoices. As delivered, the BIJOB01 job has the following components:

Summarized, Grants, and XML Publisher invoices aren't needed, so these can be removed from the job definition. When properly configured, the BIJOB01 definition should look like this:

BICPJ00 and BISPJ00 are subjobs that contain a number of print processes, so they must also be modified. These jobs contain the following components:

BICPJ00 (Crystal invoices)

BICSPJ00 (SQR invoices)

  • BIPRNT00 (Generic)

  • BIPRNT01 (Project Costing)

  • BIPRNT02 (Order Management)

  • BIPSA01 (Projects By Employee)

  • BIPSA02 (Projects By Activity)

  • BIPSA03 (Project Detail)

  • BICA (Contracts)

  • BIIVCPN (Portrait)

  • BIIVCLN (Landscape)

  • BIIVCPNA (Acceptgiro)

The BIPRNT00, BIPRNT02, and BIIVCPNA processes create invoices that aren't used, so they should be removed:

BICPJ00

BICSPJ00

  • BIPRNT01

  • BIPSA01

  • BIPSA02

  • BIPSA03

  • BICA

  • BIIVCPN

  • BIIVCLN