Print Processing Steps

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 and BI Publisher reports. Each printing process selects bills from the extract tables that meet the requirements for the type of invoice it generates.

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.

BI Publisher invoices have two parts:

  • An Application Engine program which selects the invoices to process.

  • Report definitions, or templates, which define the format and the layout of the invoice

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

See Understanding Invoice Programming.

This table lists the print process options:

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.

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.

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 (BI Publisher)

Portrait

BI_IVCEXT

Sample BI Publisher invoice.

BIPRNXPC01

Application Engine (BI Publisher)

Portrait

BI_IVCEXT

Sample BI Publisher consolidated invoice.

BI_XPSF103X

Application Engine (BI Publisher)

Portrait

BI_IVCEXT

Standard form 1034/1035 BI Publisher invoice.

BIXCA

BI Publisher

Portrait

BI_IVCEXT

BI Publisher contracts invoice.

BIXCLSUM

BI Publisher

Landscape

BI_IVCEXT

BI Publisher summarization invoice.

BIXCLSUMC

BI Publisher

Landscape

BI_IVCEXT

BI Publisher consolidated summarization invoice.

BIXPRNT00

BI Publisher

Portrait

BI_IVCEXT

BI Publisher generic invoice.

BIXPRNC00

BI Publisher

Landscape

BI_IVCEXT

BI Publisher generic consolidated invoice.

BIXPRNT01

BI Publisher

Landscape

BI_IVCEXT

PS/PC - BI Publisher projects invoice.

BIXPRNT02

BI Publisher

Landscape

BI_IVCEXT

BI Publisher Order Management invoice.

BIXPRNC02

BI Publisher

Landscape

BI_IVCEXT

BI Publisher Order Management consolidated invoice.

BIXPSA01

BI Publisher

Portrait

BI_IVCEXT

BI Publisher project by employee invoice.

BIXPSA02

BI Publisher

Portrait

BI_IVCEXT

PS/PSA02 - BI Publisher projects by activity invoice.

BIXPSA03

BI Publisher

Portrait

BI_IVCEXT

PS/PSA03 - BI Publisher project detail invoice.

BI_PRNLOC

BI Publisher

Portrait

BI_LOCEXT

BI Publisher Letter of Credit.

BI_PRNXPGN1

Application Engine (BI Publisher)

Portrait

BI_IVCEXT

Sample BI Publisher invoice.