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.
This section provides an overview of invoice processing and discusses:
Preprocessing steps.
Print processing steps.
Email notification (paperless invoices).
Post-invoicing processing steps.
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, once the bill is entered and approved, include:
Preprocessing steps:
Import billing data through the Billing interface.
Set VAT and tax defaults.
Finalize invoice data and set status.
Extract invoice data and print processing steps:
Extract data to temporary tables.
Run print processes for each invoice form.
Physical printing, email notification, electronic data interchange (EDI) transmittal.
Post-processing steps:
Process credit card payments.
Convert currency (if needed).
Create accounting entries.
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.
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 first, 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. |
|
IN_FUL_CONF |
AE |
Confirm Inventory picking. See Picking Inventory. |
|
IN_PUB_MSG |
AE |
Publish Inventory outbound message. |
|
INS6300 |
SQR |
Load InterUnit transfer bills into the Billing interface. |
|
INS6500 |
SQR |
Generate Inventory packing slips. |
|
OM_BILL |
AE |
Load Order Management bills into the Billing interface. 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 those data validations and transformations 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 invoiced 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):
Sequences bill lines by the user-defined sort by option, or according to the invoice line numbers that you define manually during bill entry.
Calculates taxes by line according to current line values and tax rates.
Updates the bill header invoice amount to include currently calculated taxes.
Note. The system does not calculate taxes or VAT for a bill line when the bill line's tax timing option (populated by PeopleSoft Contracts) is defined as S (taxes on services rendered).
Calculates due date and updates the bill header with this value.
Changes bill status from RDY (ready) to INV. (Finalization mode only.)
Updates the invoice date with the appropriate value for the bill, the run control, or the current date. (Finalization mode only.)
If you define the invoice date on the Process Scheduler Request page, the system checks that the date is in an open accounting period and issues a warning on the Process Scheduler Request page if the date falls outside the period currently open in PeopleSoft General Ledger.
Updates the invoice print setting with the status Printed for bills where the invoice form ID specifies a nonprinting form. (Finalization mode only.)
(If no printing is expected on this bill, the print status is Complete upon finalization.)
For credit card bills, generates credit card authorization requests and changes the status of the bill to FNL (final), instead of INV (invoiced). (Finalization mode only.)
Updates last maintenance user ID and last update date and time. (Finalization mode only.)
For invoices in euro-participating currencies, converts invoice amount to the euro currency so that the amount appears on printed invoices in both currencies.
Creates EDI request entries for bills by EDI using XML technology. (Finalization mode only.)
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 |
Bill Header multi-column update. |
BIBIIVC000_UPD |
Bill Header VAT multi-column update. |
BIBIIVC000_UPD |
Bill Line multi-column update. |
BIBIIVC000_UPD |
Bill Line Tax multi-column update. |
BIBIIVC000_UPD |
Bill Line Excise and Sales Tax multi-column update. |
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:
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. |
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 or Sales Tax Rate Code. |
2820 |
No Excise Tax Rate Details. |
2830 |
No Sales Tax 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 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. |
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 two types of print processes, SQR and Crystal reports. Each printing process selects those bills from the extract tables that meet the requirements for the types of invoice it can generate.
Crystal invoices have two parts, queries that select the invoices to process from the extract tables, and a Crystal report defining formatting and layout for 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 detail invoices. Thus one SQR program prints consolidated, portrait, detail invoices, while another prints consolidated, landscape, detail invoices. Not every combination is available in the delivered SQR programs. For example, summarized invoices are only provided in landscape format.
The print processes and queries can be modified to produce tailored invoice forms.
See Understanding Invoice Forms.
This table lists the 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. |
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 BIIVCEMAIL process must follow the BIIVC000 finalization process.
Note. The BI_WF_0001 Invoice Notification process can also be used to send email notification to customers.
See Also
Running the Email Notification Process
Running the Invoice Notification Process
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 |
Credit card processing. |
|
BICURCNV |
AE |
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. |
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. The following jobs are provided:
Note. Subjobs in the Components column are indicated with the emphasis style.
Job Name |
Classification |
Description |
Components |
BICPJ00 |
Print subjob |
Print nonconsolidated Crystal invoices |
|
BICPJ00C |
Print subjob |
Print consolidated Crystal invoices |
|
BICPJ10C |
|
Print consolidated SQR invoices |
|
BICPJ11C |
|
Print portrait SQR invoices |
|
BICPJ40C |
|
Print consolidated Crystal invoices |
|
BICPJA00 |
Print subjob |
Print Crystal acceptgiro invoices |
|
BICPJA0C |
Print subjob |
Print consolidated Crystal acceptgiro invoices |
|
BIDIRIV2 |
Interface, preprocess, finalize, and print |
Direct invoicing (no postprocesses) See The BIDIRIVC Jobs. |
|
BIDIRIVC |
Interface, preprocess, finalize, print, and postprocess |
Direct invoicing See The BIDIRIVC Jobs. |
|
BIINIU |
Interface, preprocess, finalize, print, and postprocess |
InterUnit inventory transfer See The BIINIU Job. |
|
BIINIU2 |
Interface, preprocess, finalize, and print |
InterUnit inventory transfer (no Crystal or postprocesses) See The BIINIU Job. |
|
BIINIU3 |
Interface, preprocess, finalize, print SQR, and postprocess |
InterUnit inventory transfer (No Crystal processes) See The BIINIU Job. |
|
BIJOB01 |
Finalize and print |
Finalize and print Crystal and SQR invoices |
|
BIJOB02 |
Finalize and print |
Finalize and print consolidated Crystal and SQR invoices |
|
BIJOB03 |
Finalize, print, and postprocess |
Single action. Print SQR, Crystal, and acceptgiro invoices |
|
BIJOB03K |
Finalize, print, and postprocess |
Single action. Print SQR, Crystal, and acceptgiro invoices with commitment control |
|
BIJOB04 |
Finalize, print, and postprocess |
Single Action. Print consolidated SQR, Crystal, and acceptgiro invoices |
|
BIJOB04K |
Finalize, print, and postprocess |
Single Action. Print consolidated SQR, Crystal, and acceptgiro invoices with commitment control |
|
BIJOB05 |
Postprocess |
Currency conversion, preload accounting entries, and load AR |
|
BIJOB06 |
Postprocess |
Currency conversion, preload accounting entries, and load GL |
|
BIJOB06K |
Postprocess |
Currency conversion, preload accounting entries, and load GL with commitment control |
|
BIJOB07 |
Interface and preprocess |
Process RMA adjustments through the Billing interface and VAT defaults |
|
BIJOB08 |
Finalize and print |
Single Action. Print SQR, Crystal, and acceptgiro invoices without postprocesses |
|
BIJOB09 |
|
Extract and print generic Crystal invoices |
|
BIJOB10 |
|
Extract and print Crystal PS/PC invoices |
|
BIJOB11 |
|
Extract and print Crystal PS/OM invoices |
|
BIJOB12 |
|
Extract and print consolidated Crystal invoices |
|
BIJOB13 |
|
Extract and print consolidated PS/OM invoices |
|
BIJOB14 |
|
Extract and print Crystal PS/CA invoices |
|
BIJOB15 |
|
Extract and print Crystal PS/PSA01 invoices |
|
BIJOB16 |
|
Extract and print Crystal PS/PSA02 invoices |
|
BIJOB17 |
|
Extract and print Crystal PS/PSA03 invoices |
|
BIJOB18 |
Postprocess |
Currency conversion and preload accounting entries |
|
BIJOB19 |
Reprint |
Reprint invoices |
|
BIJOB20 |
|
Print portrait SQR invoices |
|
BIJOB21 |
|
Print portrait consolidated SQR invoices |
|
BIJOB22 |
|
Print landscape SQR invoices |
|
BIJOB23 |
|
Print landscape consolidated SQR invoices |
|
BIJOB50 |
Finalize, print, and postprocess |
Single Action. Print Project Costing and Contracts invoices |
|
BIJOB51 |
Finalize and print |
Finalize and print Crystal invoices |
|
BIJOB52 |
Finalize and print |
Finalize and print consolidated Crystal invoices |
|
BIJOBI01 |
Interface and preprocess |
Process Billing interface and VAT Defaults |
|
BIJOBP01 |
Pro forma |
Print pro formas |
|
BIJOBP02 |
Pro forma |
Print consolidated pro formas |
|
BIJOBP03 |
Pro forma |
Print pro forma Note. BIPJOB03 is run from the Proforma button on the online bill entry pages. |
|
BIJOBP51 |
Pro forma |
Print Crystal pro formas |
|
BIJOBP52 |
Pro forma |
Print consolidated Crystal pro formas |
|
BIPJ10 |
|
Print/SQR invoices |
|
BIPJ11 |
|
Print portrait SQR invoices |
|
BIPJ20 |
|
Print Grants SQR invoices |
|
BIPJ30 |
|
Print SQR SF1080/81 forms |
|
BIPJ40 |
|
Print Crystal invoices |
|
BISPJ00 |
Print subjob |
Print SQR invoices |
|
BISPJ00C |
Print subjob |
Print SQR invoices |
|
DIRAUTO |
Interface, preprocess, finalize, print, and postprocess |
Print Order Management Direct Invoicing invoices having automatic approval See The DIRAUTO Job. |
|
DIRCTIV2 |
Interface, preprocess, finalize, and print |
Print Order Management Direct Invoicing invoices (no postprocesses) See The DIRCTIVC Job. |
|
DIRCTIV3 |
Interface, preprocess, finalize, print SQR, and postprocess |
Print Order Management Direct Invoicing invoices (No Crystal processes) See The DIRCTIVC Job. |
|
DIRCTIVC |
Interface, preprocess, finalize, print, and postprocess |
Print Order Management Direct Invoicing invoices See The DIRCTIVC Job. |
|
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:
The DIRCTIVC job.
The BIDIRIVC jobs.
The BIINIU job.
The DIRAUTO 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 postinvoicing processes. Likewise, the DIRCTIV3 job contains no Crystal processes, but does contain the postinvoicing 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 (OMBILL) |
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:
|
All bills for range selection ID with direct invoice option Off. The status of activity not selected remains RDY. |
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 and Crystal invoice print process. |
|
Invoice Printing (BISPJ00, BICPJ00, BICPJA00, 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
The BIDIRIVC and BIDIRIV2 jobs carry out the Billing portion of the Projects/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/Contracts to Billing and back. The BIDIRV2 job is identical to the BIDIRIVC job, except that it contains no post-printing 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:
|
All bills for range selection ID with direct invoice option Off. The status of activity not selected remains RDY. |
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 and Crystal invoice print processes. |
|
Invoice Printing (BISPJ00, BICPJ00, BICPJA00, BISLSUM, BICLSUM, BIGIVCPN) |
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
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 no Crystal or postinvoicing processes. Likewise, the BIINIU3 job contains no Crystal processes, but does contain the postinvoicing 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:
|
All bills for range selection ID with direct invoice option Off. The status of activity is RDY. |
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 and Crystal invoice print processes. |
|
Invoice Printing (BISPJ00, BICPJ00, BICPJA00, BISLSUM, BICLSUM) |
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
Transferring Stock Between Business Units
Creating Orders for Fulfillment
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:
|
All bills for range selection ID with direct invoice option Off. The status of activity is RDY. |
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 and Crystal invoice print processes. |
|
Invoice Printing (BISPJ00, BICPJ00, BISLSUM, BICLSUM) |
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
Creating Shipping Documentation
Configuration of Order Fulfillment
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:
The delivered invoicing jobs typically include processes to print a range of invoice types. If you never print some of the invoice types, remove those print processes from the job.
As invoices are extracted, printed and reprinted, the invoice extract tables and print process run control tables will grow in size. Over time, these tables can become large enough to degrade the performance of the extract and print processes. To maintain performance, the Billing Delete Data process (BIDELDATA) should be run regularly. It is also helpful to recompute the database statistics on these tables on a regular basis.
While most of the steps in generating an invoice must be carried out in sequence, the invoice printing processes themselves can be run in parallel.
See PeopleTools 8.46 PeopleBook: Process Scheduler, Defining Jobs and JobSets
In some cases, you can decrease the processing time of jobs containing many processes by reducing the Process Scheduler sleep time.
See PeopleTools 8.46 PeopleBook: Process Scheduler, Setting Server Definitions
Review the document, Performance Recommendations for PeopleSoft Billing, and implement the recommendations appropriate for your PeopleSoft implementation. Refer to PeopleSoft ICE incident number 1318405001 to obtain the latest version (or contact your PeopleSoft representative).
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:
BIIVC000 (Finalization)
BI_IVCEXT (Extract)
BISPJ00 (SQR invoices)
BICPJ00 (Crystal invoices)
BISLSUM (Summarized SQR invoices)
BICLSUM (Summarized Crystal invoices)
BIGIVCPN (Grants invoices)
Summarized and Grants invoices aren't needed, so these can be removed from the job definition. When properly configured, the BIJOB01 definition should look like this:
BIIVC000
BI_IVCEXT
BISPJ00
BICPJ00
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) |
|
|
The BIPRNT00, BIPRNT02, and BIIVCPNA processes create invoices that aren't used, so they should be removed:
BICPJ00 |
BICSPJ00 |
|
|