Preprocessing Steps

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

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

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	NA	Load RMA (return material authorization) adjustments into the billing interface tables.
IN_FUL_CONF	AE	NA	Confirm inventory picking. See PeopleSoft Inventory: Understanding the Picking Process.
IN_PUB_MSG	AE	NA	Publish inventory outbound message. See PeopleSoft Inventory: The Order Fulfillment Process.
INS6300	SQR	NA	Load interunit transfer bills into the billing interface tables. See PeopleSoft Inventory: Understanding Stock Transfers Between Business Units.
INS6500	SQR	NA	Generate inventory packing slips. See PeopleSoft Inventory: The Order Fulfillment Process.
OM_BILL	AE	NA	Load PeopleSoft Order Management bills into the billing interface tables. See PeopleSoft Order Management: Populating Billing.

Finalization Process (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 be finalized only once.

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

• Selects invoices that are equal to or greater than the Threshold Amount specified on the Billing Definition - Business Unit 4 Page.

• 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 tax timing option for the bill line (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 run control request page, the system checks if the date is in an open accounting period and issues a warning on the run control request page if the date falls outside of the period that is currently open in PeopleSoft General Ledger.

• Updates the invoice print setting with a status of 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 the last maintenance user ID and last updated date and time fields (Finalization mode only).

• For invoices in euro-participating currencies, converts the 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).

• Performs the Screen for Denied Parties process (SCM_FSS) as a secondary process if the Financial Sanctions Screening (FSS) is configured to be performed for the Order to Cash.

  See Billing Definition - Business Unit 4 Page.

  See Managing Financial Sanctions Screening for Invoices.

• When the Error in Finalization check boxes are selected, the system validates the accounting date for Billing, Receivables, and then General Ledger during the bill finalization process.

  For more information about how this feature, see Application Fundamentals: Billing - Integration Options Page, Accounting Date Edit Option section.

Note:

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

Platform-Specific Statements in BIIVC000

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

Statements	Description
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 proforma and finalization processing. Use the Review Invoice Errors component (Billing, and then Review Processing Results, and then Review Invoice Errors), or the message log to view errors that the system finds during the Finalization (BIIVC000) process. Use the Standard Billing - Header - Info 1 Page or the Express Billing - Billing General Page to correct these errors.

The following error codes are issued to BI_HDR and BI_LINE for validation and processing errors:

Term	Definition
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 Provider 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 Provider Error.
2053	No Tax Provider 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	GST Defaulting Not Applied.
2810	No Tax Rate Code.
2820	No Excise Tax Rate Details.
2830	No GST Rate Details.
2840	GST Calculation Error.
2850	No Tax Transaction Type.
2860	Missing Excise Tax Parameter(s).
2870	Missing Tax Parameter(s).
2880	No Excise Conversion Rate.
3000	Missing EDI 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.