PeopleSoft Enterprise Billing 9.1 PeopleBook

Appendix: PeopleSoft Billing Reports

This appendix provides an overview of PeopleSoft Billing reports and provides information about PeopleSoft Billing:

Structured Query Report (SQR) reports.
Crystal reports.
Standard financial reports.
PeopleSoft Enterprise Services Automation invoice samples.

See Also

Enterprise PeopleTools PeopleBook: Crystal Reports for PeopleSoft

PeopleSoft Billing Reports: A to Z

This section lists:

PeopleSoft Billing reports, sorted alphanumerically by report ID.
Information that is important to specific PeopleSoft Billing reports.

Note. The billing invoice reports are required to be run after the billing invoice data extraction (BI_IVCEXT) process and hence they are embedded into billing invoice printing jobs.

Report ID and Report Name	Description	Navigation	Run Control Page
BIARRT01 AR Pending Items (accounts receivable pending items)	A reprint that displays all of the pending items that are processed in a specified accounts receivable (AR) entry date range. For example, you may want to regenerate lost reports that previous Load AR processes created.	Billing, Generate Invoices, Reproduce Reports, AR Pending Item Report Billing, Generate Invoices, Reproduce Reports, Consol AR Pending Item Report, Consolidated AR Pending Item	RUN_BI_AR
BIACCR01 Bill Line Accrued	Displays accrued bills and bill lines along with the accounts and amounts for everything in the date range that you specify.	Billing, Generate Invoices, Accrue Unbilled Activity, Bill Lines Accrued Report, Bill Lines Accrued	RUN_BI_ACCR_RPT1
BIACCR02 Bill Lines Not Ready to Accrue	Lists bills and bill lines that you may have expected to accrue but did not. You can also use this report to find out ahead of time which bills will not accrue.	Billing, Generate Invoices, Accrue Unbilled Activity, Lines Not Ready to Accrue Rpt, Bill Line Not Ready	RUN_BI_ACCR_RPT2
BIACCUM Accumulation Report	Displays the data that the Balance Accumulation process selects and processes.	Billing, Generate Invoices, Accumulated Balances, Calculate Balances, Balance Accumulation	RUN_BI_ACCUM
BIAPRT01 AP Voucher Entries (accounts payable voucher entries)	A reprint that displays all voucher entries that were processed within a specified range selection. For example, you may want to regenerate lost reports that previous Generate AP Voucher processes created.	Billing, Generate Invoices, Reproduce Reports, AP Voucher Entries, AP Voucher Entries Report	RUN_BI_AP
BICA PSA Crystal Contracts	Grouped by contract detail. This format prints contract details. It applies to PeopleSoft Contracts without PeopleSoft Project Costing.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices Billing, Generate Invoices, Non-Consolidated, Reprint Invoices	RUN_BI_PRNCRX9
BIXCA XML Publisher Contracts Invoice	Grouped by contract detail. This format prints contract details. It applies to PeopleSoft Contracts without PeopleSoft Project Costing.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices Billing, Generate Invoices, Non-Consolidated, Reprint Invoices	RUN_BI_PRNXP3
BICAA Acceptgiro PSA Crystal Contracts	Acceptgiro version of BICA.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices Billing, Generate Invoices, Non-Consolidated, Reprint Invoices	RUN_BI_PRNCRX9A
BICLSUM Crystal Summarized Invoice	This report groups and summarizes invoice lines according to the summarization templates attached to the lines.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNCRX1S
BIXCLSUM XML Publisher Summarized Invoice	This report groups and summarizes invoice lines according to the summarization templates attached to the lines.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNXP4
BICLSUMC Crystal Consolidated Summarized Invoice	This report consolidates summarized invoices.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNCRX4S
BIXCLSUMC XML Publisher Consolidated Summarized Invoice	This report consolidates summarized invoices.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNXP5
BIGIVCPN Grants Print Portrait Invoices	GM_103X produces the SF1034 and SF1035 standard forms, which are used to bill federal contracts, the SF-270 for billing federal grants, and a general invoice format for grants activity (GM_GEN).	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNSQR5
BIGLRT01 GL Accounting Entries (general ledger accounting entries)	A reprint that displays all of the accounting entries that were processed in a specified accounting date range. For example, you may want to regenerate lost reports that previous Load GL processes created.	Billing, Generate Invoices, Reproduce Reports, Consol GL Accounting Entries Billing, Generate Invoices, Reproduce Reports, GL Accounting Entries, GL Accounting Entries Report	RUN_BI_GL
BIGMLOC Pro Forma Letter of Credit or Finalized Letter of Credit Report	Summarizes the letter of credit draw for individual letters of credit by document number. Note. You can generate a Pro Forma Letter of Credit or Finalized Letter of Credit report by clicking the Generate Pro Forma or Generate Draw button on the Letter of Credit Summary page. There is no run control from which you generate these reports. When you click the Generate Pro Forma or Generate Draw button, the system executes the single action job BIJOB50 in the background and generates the report. The system does not, however, generate an invoice; the Letter of Credit (LOC) invoices use invoice format GM_LOC without the Print Form option selected, and produces only the LOC report.	Billing, Billing Worksheet, Letter of Credit Summary	No run control page.
BIGNAP01 Generate AP Vouchers (generate accounts payable vouchers)	Initiates the creation of accounts payable (AP) vouchers for InterUnit bills only.	Billing, Generate Invoices, Non-Consolidated, Load Invoices to AP, Generate AP Vouchers Billing, Generate Invoices, Consolidated, Load Invoices to AP, Consolidated Generate AP Vchr	RUN_BI_GENAP RUN_BI_GENAP_CON
BIGSALDL Salary Detail Report	Reports the current dollar amounts that are charged for each employee ID, along with cumulative amounts for each employee. The header includes the institution name and address, the award ID, and the invoice number.	Billing, Generate Invoices, Reports, Salary Detail, Salary Detail Report	RUN_GM_SAL_DETL
BIIFD001 Interface Detail Summary by Interface ID	Summarizes the total number of lines and total dollars by invoice, customer, and load status for both processed and unprocessed transactions.	Billing, Interface Transactions, Create Billing Intrfc Report, Billing Interface	RUN_BI_INTFC3
BIIFD002 Interface Detail Summary by Business Unit	Summarizes the total number of lines and total dollars by invoice, customer, and load status for both processed and unprocessed transactions.	Billing, Interface Transactions, Create Billing Intrfc Report, Billing Interface	RUN_BI_INTFC3
BIIFD003 Interface Summary by Interface ID	A summary of the Detail report. This report summarizes the total number of lines and total dollars by load status for both processed and unprocessed transactions.	Billing, Interface Transactions, Create Billing Intrfc Report, Billing Interface	RUN_BI_INTFC3
BIIFD004 Interface Summary by Business Unit	A summary of the Detail report. This report summarizes the total number of lines and total dollars by load status for both processed and unprocessed transactions.	Billing, Interface Transactions, Create Billing Intrfc Report, Billing Interface	RUN_BI_INTFC3
BIIFE001 Interface Error Summary by Interface ID	Lists any unprocessed interface lines that are currently in an error status. Lines are broken down by error status number.	Billing, Interface Transactions, Create Billing Intrfc Report, Billing Interface	RUN_BI_INTFC3
BIIFE002 Interface Error Summary by Business Unit	Lists any unprocessed interface lines that are currently in an error state. Lines are broken down by error status number.	Billing, Interface Transactions, Create Billing Intrfc Report, Billing Interface	RUN_BI_INTFC3
BIIVC002 Invoice Register by Invoice Number	Lists all invoices according to selected parameters, sorted by invoice number.	Billing, Generate Invoices, Reports, Invoice Register	RUN_BI_IVCRGSTR
BIIVC003 Invoice Register by Customer Name	Lists all invoices according to selected parameters, sorted by customer name.	Billing, Generate Invoices, Reports, Invoice Register	RUN_BI_IVCRGSTR
BIIVC004 Invoice Register for Consolidated Invoices	Lists all consolidated invoices according to selected parameters. Displays all consolidated headers and their attached bills.	Billing, Generate Invoices, Reports, Consolidated Register, Consolidation Invoice Register	RUN_BI_IVCRGSTR
BIIVCLC Pro forma or Invoice	Consolidated Invoice - Landscape Orientation. All bills that are attached to a consolidated header must have the same orientation layout as the consolidated header, although they may have different forms. This program prints either a pro forma or an invoice, depending on which menu option you select. This program prints pro formas only for bills with a status other than INV and prints invoices only for bills with a status of INV.	Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNSQR4
BIIVCLN Pro forma or Invoice	Regular Invoice - Landscape Orientation. There are two delivered standard landscape layouts: LANDSCAPE and ORDERMGMT. This program prints either a pro forma or an invoice, depending on which menu option you select. This program prints pro formas only for bills with a status other than INV and prints invoices only for bills with a status of INV.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNSQR2
BIIVCPC STD Print Portrait Consol Inv	Consolidated Invoice - Portrait Orientation. All bills that are attached to a consolidated header must have the same orientation layout as the consolidated header, although they may have different forms. This program prints either a pro forma or an invoice, depending on which menu option you select. This program prints pro formas only for bills with a status other than INV and prints invoices only for bills with a status of INV. This program prints these invoice layouts: MISC RIGHTSTUB Default Portrait PSA51 PSA52 PSA53 CA51	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNSQR3
BIIVCPN Pro forma or Invoice	Regular Invoice - Portrait Orientation. This program prints either a pro forma or an invoice, depending on which menu option you select. This program prints pro formas only for bills with a status other than INV and prints invoices only for bills with a status of INV.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNSQR1
BIIVCSTS Invoice Status Change Report	Displays the Invoice Status Change process results.	Billing, Maintain Bills, Change Status of Bills, Status Change	RUN_BI_STSCHG
BILDAR01 Load AR Pending Items (load accounts receivable pending items)	Lists all pending items that were generated for invoices according to selected parameters. These pending items are now ready to post in accounts receivable.	Billing, Generate Invoices, Non-Consolidated, Load Invoices to AR, Load AR Pending Items Billing, Generate Invoices, Consolidated, Load Invoices to AR, Load AR for Consolidated Bills	RUN_BI_LOADAR RUN_BI_LOADAR_CON
BILDGL01 Load GL Accounting Entries (load general ledger accounting entries)	Displays all of the accounting entries that were created for invoices according to selected parameters. Journal Generator can process these accounting entries now ready.	Billing, Generate Invoices, Non-Consolidated, Create Accounting Entries, Load GL Accounting Entries Billing, Generate Invoices, Consolidated, Create Accounting Entries, Load GL for Consolidated Bills	RUN_BI_LOADGL RUN_BI_LOADGL_CON
BIPRNC00 Crystal Invoice Consolidated	A simple, miscellaneous type of consolidated invoice, which consolidates many simple invoices into one. PeopleSoft Billing information on this invoice is nonindustry-specific. It also supports the printing of global fields, such as the billing currency, value-added tax (VAT) amounts, and the invoice format in euros.	Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices Billing, Generate Invoices, Consolidated, Reprint Invoices	RUN_BI_PRNCRX4
BIXPRNC00 XML Publisher Invoice Consolidated	A simple, miscellaneous type of consolidated invoice, which consolidates many simple invoices into one. PeopleSoft Billing information on this invoice is nonindustry-specific. It also supports the printing of global fields, such as the billing currency, value-added tax (VAT) amounts, and the invoice format in euros.	Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices Billing, Generate Invoices, Consolidated, Reprint Invoices	RUN_BI_PRNXP7
BIPRNC02 Crystal Order Management Invoice, Consolidated	An invoice for a consolidated bill that contains information that is related to a sales order. This invoice is typical of a bill that originates from PeopleSoft Order Management and features printing a logo and subtotals by line type. The invoice also supports the printing of configuration detail, if the bill is for a configured product, and the printing of global features, such as the billing currency, VAT amounts, and the invoice amounts in euros.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNCRX5
BIXPRNC02 XML Publisher Order Management Invoice, Consolidated	An invoice for a consolidated bill that contains information that is related to a sales order. This invoice is typical of a bill that originates from PeopleSoft Order Management and features printing a logo and subtotals by line type.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNXP10
BIPRNCA0 Crystal Acceptgiro Invoice Consolidated	Acceptgiro version of BIPRNC00.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNCRX4A
BIPRNCA2 Crystal Order Management Invoice, Consolidated	Acceptgiro version of BIPRNC02.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNCRX5A
BIXPRNT00 XML Publisher Invoice	A simple, miscellaneous type of bill with nonindustry-specific billing information. This invoice supports the printing of global fields, such as the billing currency, VAT amounts, and the invoice format in euros.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNXP6
BIPRNT00 Crystal Invoice	A simple, miscellaneous type of bill with nonindustry-specific billing information. This invoice supports the printing of global fields, such as the billing currency, VAT amounts, and the invoice format in euros.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNCRX1
BIXPRNT01 XML Publisher Projects Invoice	An invoice for a regular bill with project- and contract-related information. This invoice is typical of a bill that originates from PeopleSoft Project Costing.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNXP8
BIPRNT01 Crystal Projects Invoice	An invoice for a regular bill with project- and contract-related information. This invoice is typical of a bill that originates from PeopleSoft Project Costing. The invoice uses Crystal subqueries, such as Bill To Date, Previously Billed, and Billed This Period, to print balances on the invoice.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNCRX2
BIXPRNT02 XML Publisher Order Management Invoice	This reports provides the same information for a regular bill as XML Publisher Order Management Invoice, Consolidated does for a consolidated bill.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNXP9
BIPRNT02 Crystal Order Management Invoice	This reports provides the same information for a regular bill as Crystal Order Management Invoice, Consolidated does for a consolidated bill.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNCRX3
BIPRNTA0 Crystal Acceptgiro Invoice	Acceptgiro version of BIPRNT00 invoice.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNCRX1A
BIPRNTA2 Crystal Order Management Acceptgiro Invoice	Acceptgiro version of BIPRNT02 invoice.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNCRX3A
BIPRNXPN01 XML Publisher Invoice	A regular invoice with portrait orientation. This program uses XML Publisher to produce a simple miscellaneous type of invoice. The PeopleSoft Billing information on this invoice is non industry-specific. The program prints either a pro forma or an invoice, depending on which menu option you select. This program prints pro formas only for bills with a status other than INV and prints invoices only for bills with a status of INV.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices Billing, Generate Invoices, Non-Consolidated, Reprint Invoices	RUN_BI_PRNTIVC
BIPRNXPC01 XML Publisher Consolidated Invoice	A consolidated invoice with portrait orientation. This program uses XML Publisher to produce a simple miscellaneous type of consolidated invoice, which consolidates many simple invoices into one. The PeopleSoft Billing information on this invoice is non industry-specific. The program prints either a pro forma or an invoice, depending on which menu option you select. This program prints pro formas only for bills with a status other than INV and prints invoices only for bills with a status of INV.	Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices Billing, Generate Invoices, Consolidated, Reprint Invoices	RUN_BI_PRNTIVC_CON
BIXPSA01 XML Publisher project by employee invoice.	This format groups lines by project description, employee name, and resource type (if they exist) and prints subtotals on change of project or employee. It prints contract prepaid information for utilization lines based on the existence of contract number and contract prepaid sequence number.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNXP10
BIPSA01 PSA Crystal by Project, Employee	This format groups lines by project description, employee name, and resource type (if they exist) and prints subtotals on change of project or employee. It prints contract prepaid information for utilization lines based on the existence of contract number and contract prepaid sequence number.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNCRX6
BIXPSA02 XML Publisher by Project, Activity	This format groups lines by project description, activity description, employee name, resource type, and resource category (if they exist) and prints subtotals on change of project, activity, or employee. It prints contract prepaid information for utilization lines based on the existence of a contract number and a contract prepaid sequence number.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNXP12
BIPSA02 PSA Crystal by Project, Activity	This format groups lines by project description, activity description, employee name, resource type, and resource category (if they exist) and prints subtotals on change of project, activity, or employee. It prints contract prepaid information for utilization lines based on the existence of a contract number and a contract prepaid sequence number.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNCRX7
BIXPSA03 XML Publisher Project Details	Grouped by project detail. This format displays project details.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNXP13
BIPSA03 PSA Crystal Project Details	Grouped by project detail. This format displays project details.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNCRX8
BIPSAA1 PSA Acceptgiro Crystal by Project, Employee	Acceptgiro version of BIPSA01.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNCRX6A
BIPSAA2 PSA Acceptgiro Crystal by Project, Activity	Acceptgiro version of BIPSA02.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNCRX7A
BIPSAA3 PSA Acceptgiro Crystal Project Details	Acceptgiro version of BIPSA03.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNCRX8A
BISF108X SF1080 - Standard Form 1080	Voucher for Transfers between Appropriations or Funds. Used as a charge document and basic voucher for agencies that require payment by check for charges to other government agencies. Also used for settlement of fund accounts between agencies that are paid by check where at least one agency resides outside the treasury disbursement area. SF1081 - Standard Form 1081 Voucher and Schedule of Withdrawals and Credits. Used by agencies within the treasury disbursing area for a combined billing and payment document for interagency appropriation, fund, and receipt accounts. Note. The Billing Interface process (BIIV0001) does not verify that the billing currency is USD for bills using SF108x layouts. Source systems must pass USD as the currency or ensure that the default currency associated with the customer is USD.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNSQR6
BISLSUM Landscape Summarized Invoice	This report groups and summarizes invoice lines according to the summarization templates attached to the lines.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNSQR2S
BISLSUMC Consolidated Landscape Summarized Invoice	This report consolidates summarized invoices.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma, Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices, Finalize and Print Billing, Generate Invoices, Non-Consolidated, Reprint Invoices Billing, Generate Invoices, Consolidated, Single Action Consolidation Billing, Generate Invoices, Consolidated, Print Consolidated Pro Forma, Consolidated Pro Forma Billing, Generate Invoices, Consolidated, Finalize and Print Invoices, Consolidated Final and Print Billing, Generate Invoices, Consolidated, Reprint Invoices, Consolidated Reprint Invoices	RUN_BI_PRNSQR4S
BIXPSF103X XML Publisher Billing SF1034/1035 Invoice	SF1034/1035 invoice with portrait orientation. This program uses XML Publisher to produce a SF1034/1035 invoice. The PeopleSoft Billing information on this invoice is U.S. Government specific. The invoices are grouped by Public Voucher Number. This program prints either a pro forma or an invoice, depending on which menu option you select. This program prints pro formas only for bills with a status other than INV and prints invoices only for bills with a status of INV.	Billing, Generate Invoices, Non-Consolidated, Single Action Invoice Billing, Generate Invoices, Non-Consolidated, Print Pro Forma Billing, Generate Invoices, Non-Consolidated, Finalize and Print Invoices Billing, Generate Invoices, Non-Consolidated, Reprint Invoices	RUN_BI_PRNTIVC

Selected PeopleSoft Billing Report Information

This section provides detailed information, including important fields, about individual PeopleSoft Billing reports.

Note. PeopleSoft Billing delivers Crystal invoice examples, which you can use as a starting point for designing and creating your own Crystal invoice formats. You may need to configure your Crystal reports to expand the amount sizes to meet your business needs.

Common Elements Used in This Section

Adj (adjustment)	An asterisk in this column denotes an adjustment line on the invoice.
Amount Remitted	Displays a blank line for the amount that the customer wants to pay.
Bill Inquiry Phone	Number printed on the invoices for customers to call if they have any questions about their bills.
Bill To	Bill-to customer and bill-to address.
Bill To Customer Name	Customer to whom you ship the invoice.
Buyer's VAT Registration ID (buyer's value-added tax registration ID)	The buyer's VAT country registration number. Each country has its own set of valid VAT registration numbers.
Calculation Method	If you select to calculate VAT at Gross, the system calculates VAT before it applies any early payment discounts. If you select to calculate VAT at Net, the system calculates VAT after it deducts early payment discounts.
Contract	Default value, if it exists, comes from the CONTRACT_NUM field.
Currency	Billing currency.
Declaration Point	When VAT transaction information is recognized for reporting purposes.
Document Number	Header document sequence number.
Due Date	Date on which payment is due.
Est. Due Date (estimated due date)	Estimated date on which payment is due.
Final Start Date and Final End Date	Finalize run dates of the finalized invoices that you specify on the Invoice Register Process page for review on the report.
From and To	From and to dates for the corresponding resource type and category. The From field value is the minimum of CHARGE_FROM_DT. The To field value is the maximum of CHARGE_TO_DT.
In Euro	Total amount due for the invoice in euros.
Invoice No (invoice number)	Unique number that is assigned to the invoice. Define invoice number IDs on the Invoice Number page.
Net Amount	If you did not select Apply Disc/Surchg to Line Amt on the Invoice Formatting Options - Discounts, Surcharges, Taxes page, then net amount is the invoice amount before discounts, surcharges, and taxes are applied. If you select Apply Disc/Surchg to Line Amt, the net amount contains discounts and surcharges. Taxes are not included.
Number of Bills	Number of bills that are processed in the run.
Number of Invoices	Number of invoices that are included.
Page number or Page No.	Page number of the invoice or summary invoice.
Prepaid Utilization	Contracts prepaid utilization description, derived from CA_PPD_UTL_DESCR and based on CONTRACT_PPD_SEQ and CONTRACT_NUM, if those values exist. Sum of NET_EXTENDED_AMT. This field applies to utilization rows only (line type is UTL).
PO (purchase order)	Default value comes from the PO_REF field.
Printed On	Date and time when the invoice was generated.
Project	For each project, the report displays a description of PROJECT_ID, an employee name that corresponds to the value of EMPLID, and a description of the values from RESOURCE_TYPE and RESOURCE_CATEGORY.
Process Instance	System-generated instance ID from the Process Scheduler.
Rate	Amount billed for each unit of measure. The system derives this value from UNIT_AMT.
Report Action	Indicates whether the run was a pro forma (Pro forma) or a Finalize and Print (Invoice).
(Sales/Use)	The sales and use taxes that are applied to the bill.
Site	The system derives this value from the SHIP_TO_CUST_ID and SHIP_TO_ADDR_NUM fields. The system uses the ship-to information to get site details on the invoice header. It obtains the ship-to name from the CUSTOMER table. The ship-to customer ID and ship-to address number fields that are provided on the bill header must exist in the CUSTOMER table, and the CUST_STATUS field must have a value of A (active). Additionally, the SHIP_TO_FLG field must have a value of Y (yes). The system retrieves the ship-to address from BI_SHP_ADDR_VW based on the SHIP_TO_CUST_ID and SHIP_TO_ADDR_NUM fields.
Sellers VAT Registration ID (seller's value-added tax registration ID)	The seller's VAT country registration number. Each country has its own set of valid VAT registration numbers.
Status/Type	Invoice status and invoice type.
Subtotal	Combined net amount of each bill line.
Subtotal For Employee	Subtotal of NET_EXTENDED_AMT for each employee in the project.
Subtotal For Project	Subtotal of NET_EXTENDED_AMT for each project.
Summary page	On the Invoice Formatting Options - General page, you can define the summary page options and elect to have a summary page print with the invoice.
Total Amount Due	Total amount, including discounts, surcharges, and taxes, that is due for the invoice.
Total Invoice Amount	Total invoice amount, including taxes, discounts, surcharges, and other adjustments.
Total number of bills printed	Number of bills that are included with the invoice.
Total Number of Consolidated Invoices	Total number of registered consolidated invoices.
Total # of Invoices (total number of invoices)	Total number of registered invoices.
Unit Amt (unit amount)	Price per unit.
VAT Treatment (value-added tax treatment)	Main driver for processing VAT on sales and procurement transactions is the VAT treatment. This determines which default values to apply and controls the availability of some VAT-related fields.

See Also

Structuring Bills

The Pro Forma or Invoice BIIVCPN Report

This program prints these invoice layouts:

MISC	A simple, miscellaneous type of bill with nonindustry-specific billing information.
RIGHTSTUB	A simple, miscellaneous type of bill that is constructed with a remittance tear sheet on the right side of the form.
Default Portrait	A simple, miscellaneous type of bill with nonindustry-specific billing information.
PS/PSA51 - PSA by Project, Employee Name	Similar to Crystal layout PS/PSA01. This format groups lines by project description, employee name, and resource type (if they exist) and prints subtotals on change of project or employee. It prints contract prepaid information for utilization lines based on the existence of a contract number and a contract prepaid sequence number.
PS/PSA52 - PSA by Project, Activity	Similar to Crystal layout PS/PSA02. This format groups lines by project description, activity description, employee name, resource type, and resource category (if they exist) and prints subtotals on change of project, activity, or employee. It prints contract prepaid information for utilization lines based on the existence of contract number and a contract prepaid sequence number.
PS/PSA53 - PSA Project Details	Similar to Crystal layout PS/PSA03. This format displays project details.
PS/CA51 - PSA Contracts Only	Similar to layout PS/CA. This format prints contract details. It applies to PeopleSoft Contracts without PeopleSoft Project Costing.

Consolidated Pro Forma or Invoice - Landscape Orientation Report

This consolidated invoice includes a summary page of the attached bills. The header information that appears on this invoice page represents all of the attached bills.

Note. All bills that are attached to a consolidated header must have the same orientation layout as the consolidated header, although they may have different forms. When attaching bills with different portrait SQR forms and layouts, you cannot attach bills unless all of the bills are printed by the same SQR process, either BIIVCPC1 or BIIVCPC2. This restriction is necessary to prevent exceeding the maximum parameter sizes that the SQR module defines for these processes. You can configure these processes to include your preferred collection of forms for consolidation if the delivered processes do not meet your specific needs.

Consolidation Summary

Each attached bill appears with its corresponding amount due. The total amount due for all attached bills appears at the bottom.

Load AR Pending Items Report

The Load AR Pending Items report displays these fields:

Range Option	Parameters that the system uses to select the bill or group of bills for processing for the specified business unit. Specify range options on the Load AR Pending Items page.
Post Action	Indicates to the Receivables Update process how to process the pending receivables items that the Load AR process created.
Group ID	A system-generated identifier for any group of pending items that the Receivable Update program will process.
Item (Invoice)	The individual receivables that comprise a customer's balance. Companies may refer to items in a variety of ways, including invoices, obligations, open items, receivables, or documents.
Entry Type	The pending items that create or update posted items within the system. The Receivable Update program uses the pending items that you supply to create or update items and to maintain customer balances. Examples of entry types are invoices, debit memos, credit memos, payments, prepayments, on account payments, deductions, adjustments, and write-offs. Use the Entry Type Correction page to correct invalid entry type and reason entries.
Entry Reason	An entry type can be qualified by an entry reason, which is a means of further categorizing the pending items. Use the Entry Type Correction page to correct invalid entry type and reason entries.
Entry Use ID	System function or type of processing that is associated with an entry type.
Entry Amount	Amount of the AR entry.
Terms	Payment term code. Specifies how the payment due date and discount due date are calculated.
# of Invoices in Group (number of invoices in the group)	Total number of invoices that are posted to the receivables system for the corresponding group ID.
# of AR Entries in Group (number of accounts receivable entries in the group)	Total number of AR entries that are posted to the receivables system for the corresponding group ID.
Accounts Receivable Amount	Total amount of AR entries that are posted to the receivables system for the corresponding group ID.
Total # of Invoices Processed (total number of invoices processed)	The total number of items (invoices) that are processed for all group IDs in the range selection.
Total # of AR Entries Generated (total number of accounts receivable entries generated)	The total number of AR entries that are processed for all group IDs in the range selection.

AR Pending Items Report

The AR Pending Items report displays all pending items that are processed within the start and end AR entry dates. These dates refer to the date on which the system created AR entries in the AR Pending Items table.

Load GL Accounting Entries Report

The Load GL Accounting Entries report displays these fields:

Range Option	The parameters that the system uses to select the bill or group of bills for processing for the specified business unit. Specify range options on the Load GL Accounting Entries page.
Starting ID and Ending ID	A user-specified invoice ID range parameter. These dates refer to the beginning and ending invoice IDs that are selected for the Load GL process.
Stat (statistic)	Statistics code that is used to identify non-monetary amounts
AR Entry Amount (accounts receivable entry amount)	Amount of the entry that is passed to the receivables system.
Offset Entry Amounts	When you invoice a bill, the Load GL process finds the same lines that you accrued in the current accounting period and creates reversal entries for the current accounting period. These offsetting entries are reversed in the next accounting period.
Total for Currency	Totals for all AR entry amounts and offset entry amounts that are generated.

GL Accounting Entries Report

The GL Accounting Entries report displays all accounting entries that are processed within the start and end accounting dates. Specify the accounting date for an invoice in the Acctg Date (accounting date) field on the Standard Billing - Header - Info 1 page.

See Also

Entering Bill Header Information

Generate AP Vouchers Report

The Generate AP Vouchers report displays these fields:

Range Option	Parameters that the system uses to select the bill or group of bills for processing for the specified business unit. Specify range options on the Generate AP Vouchers page.
AP Unit (accounts payable unit)	An independent transaction processing entity.
Vendor Set ID	Unique identifier that represents a default set of rules, or attributes, that define how you conduct business with a particular vendor.
Vendor ID	Unique identifier that represents a default set of rules, or attributes, that define how you conduct business with a particular vendor.
# of Lines (number of lines)	Number of bill lines per bill header.
Total # of Voucher Headers Generated (total number of voucher headers generated)	Total number of voucher headers generated for the corresponding range option.

Invoice Status Change Report

The Invoice Status Change report displays these fields:

GL (general ledger)	Depending on how you define the GL Level field on the Installation Options - Billing - GL/AR Options page, values are: A: Accounts receivable creates GL accounting entries. PeopleSoft Receivables is responsible for creating accounting entries and passing them to the general ledger system. B: PeopleSoft Billing creates GL accounting entries. PeopleSoft Billing is responsible for creating accounting entries and passing them to the general ledger system. N: No GL accounting entries. PeopleSoft Billing does not pass any accounting entries to the general ledger system.
AR	Depending on how you defined the AR Level field on the Installation Options - Billing - GL/AR Options page, values are: H: Header is AR Open Item. PeopleSoft Billing passes each bill as an open item in the receivables system. B: Bill line is AR open item. PeopleSoft Billing passes each bill line as an open item in the receivables system. N: No AR open items. PeopleSoft Billing does not pass any open items to the receivables system.
Template	If you select the Replace Template check box on the Define Copy Group Detail 2 page, the resulting invoice from this copy process becomes the new template for subsequent batch copy processes. This field has a value of Y (yes) if you elect to replace the template and of N (no) if you did not elect to replace the template.
Type	The invoice layout ID. See the Layout Identifiers page.
Level	The discount level that you define on the Standard Billing - Discount/Surcharge page.
Error Message	Error messages for any fields that failed the required criteria for status change.
Range Option	Parameters that the system uses to select the bill or group of bills for processing for the specified business unit.
Starting ID and Ending ID	Displays the invoice ID with which the process begins and ends. Define these invoice IDs in the Range Selection field.
Total Number of Bills Updated	Total number of bills that are processed within the corresponding starting and ending IDs.

Entering Bill Line Discount and Surcharge Information

Copying Groups of Bills

Defining Additional Billing Installation Options

Balance Accumulation Report

The Balance Accumulation report displays these fields:

Bal Accum ID (balance accumulation ID)	You can calculate cumulative balances for a nearly unlimited set of key combinations in PeopleSoft Billing. Each balance accumulation ID represents a set of accumulation rules, which you establish on the Accumulation Description page.
Start Date	Date on which you defined this accumulation to begin.
Key	Display all of the fields to which you have defined this accumulation to pertain. Every key that you add after the first functions to increase the level of detail that you retrieve. For example, if you accumulate by customer, you get a total for each customer. If you accumulate by customer and order number, you receive subtotals for each combination of customer and order number, which significantly increases the number of rows in the database. In the example, this accumulation updates bill-to customer balances. On the Accumulation Description page, you can define the keys from a list that includes most of the informational fields that are found in the bill header and bill line tables.
Amount	Display the amounts that you want to maintain and for which you want to balance. Balances are maintained for invoiced bills, uninvoiced bills, and total (invoiced plus uninvoiced). In the example, this accumulation updates cumulative balances for quantity (because you selected Accumulate Quantity), gross extended amount, and net extended amount.
Accum Qty (accumulation quantity)	Quantities that you define for accumulation.

See Also

Defining Accumulations

Crystal Order Management Invoice Report

The Crystal Order Management Invoice report displays these fields:

Order	The unique identifier that is assigned to the order. The system derives this value from ORDER_NO from the bill line.
Date	Order date.
Shipment	The system derives this value from SHIP_ID from the bill line.
Subtotal	Combined net amount of each bill line.
(Sales/Use)	Sales and use taxes that are applied to the bill.
Configuration Code	CONFIG_CODE. View IN_DEMAND where the business unit, invoice, order, and line sequence number match the corresponding values of the bill line.

The system derives these configuration detail values from BI_CONFIG_D_VW:

Line	INVOICE_LINE
Product	IDENTIFIER
Config Seq	CP_COMP_SEQ
Description	OPTION_DESC
Option Value	OPTION_VALUE.
Configuration Value	CONFIG_VALUE

Crystal Projects Invoice Report

The Crystal Projects Invoice report displays these fields:

Project	The system derives this value from PROJECT_ID.
Activity	The system derives this value from ACTIVITY_ID.
Contract	The system derives this value from CONTRACT_NUM.

Interface Detail Summary by Interface ID Report

The Interface Detail Summary by Interface ID report displays these fields:

From Intfc ID (from interface ID) and To Intfc ID (to interface ID)	Represents the beginning and end of a range of interface identifiers that you specify on the Billing Interface Report page prior to running the interface process.
Load Status	The billing activity in the interface staging area has one of these load statuses: NEW: The Billing Interface was not run for the data. ERR: The Billing Interface was run and encountered validation errors. DON: The Billing Interface successfully loaded the billing activity into a structured bill format and is considered complete. Items in this state are automatically moved to an archive table. UPD: The Billing Interface is actively processing data.
Trans Type (transaction type)	The type of information that is contained in the bill line. Values are: LINE: Charge line. AHDR: Adjustment Header. DDS: Deferred Discount/Surcharge. EXSD: India Excise/Sales Tax Details. TAX: Sales/Use Tax Details. AE: Accounting Entry. NOTE: Note/Comment. DS: Discount or Surcharge.
# Lines (number of lines)	Number of lines of each transaction type that the system calculates for each customer for the corresponding interface ID.
Tot Gross Ext Amount (total gross extended amount)	Total gross extended amount for each transaction type. This field is applicable only for the transaction type LINE.
Total Amount	Total amount–including taxes, discounts, surcharges, or other adjustments–for each transaction type. This field is applicable only for the transaction types AE and DS.
Totals for Status	Total number of lines, gross extended amount, and total amount for the corresponding load status.
Totals for Intfc ID (totals for interface ID)	Total number of lines, gross extended amount and total amount for the corresponding interface ID.
Grand Totals for Currency	Total number of lines, gross extended amount, and total amount for the corresponding currency code.
Total Number of Lines	Total number of lines that are processed for the corresponding range selection.

Interface Detail Summary by Business Unit Report

The fields on this report are the same as those on the Interface Detail Summary by Interface ID report.

Interface Summary by Interface ID Report

The fields on this report are the same as those on the Interface Detail Summary by Interface ID report.

Interface Summary by Business Unit Report

The fields on this report are the same as those on the Interface Detail Summary by Interface ID report.

Interface Error Summary by Interface ID Report

The Interface Error Summary by Interface ID report displays these fields:

From Intfc ID and To Intfc ID	Represents the beginning and end of a range of interface identifiers that you specify on the Billing Interface Report page prior to running the interface process.
Error Status	The Billing Interface process performs edit checks on the data that is presented to the interface staging area to verify data integrity. If the Billing Interface process finds an error, it marks all rows that are related to the bill line charge found to be in error with a load status of ERR (error) and marks the error status column with a more specific error condition. Review the Billing Interface errors and take the appropriate action necessary to correct the error. See the Billing Interface Errors table for specific information about Billing Interface error conditions.
Intfc Line # (interface line number)	The rows of data that are related to the bill line charge that are in error.
Trans Type (transaction type)	The type of information that is contained in the bill line. Values are: LINE: Charge line. AHDR: Adjustment Header. DDS: Deferred Discount/Surcharge. EXSD: India Excise/Sales Tax Details. TAX: Sales/Use Tax Details. AE: Accounting Entry. NOTE: Note/Comment. DS: Discount or Surcharge.
Trans Type Seq # (transaction type sequence number)	The transaction type sequence is part of the key and is used to provide uniqueness in the event that there are multiple accounting entries, notes, comments, or discounts or surcharges for a bill line.
Total Errors	The total number of errors for the corresponding interface ID.

Interface Error Summary by Business Unit Report

The fields on this report are the same as those on the Interface Error Summary by Interface ID report.

Bill Lines Accrued Report

The Bill Lines Accrued report displays these fields:

Transaction Amount	Total amount in transaction currency. Transaction currency is the currency that is used to complete the transaction.
Base Amount	Total amount in base currency (the primary currency that is in use for a business unit). Each business unit must have one base currency. This is usually the local currency for the organization, but accounting rules or other circumstances may dictate that it be different.

Bill Lines Not Ready for Accrual Report

The Bill Lines Not Ready for Accrual report displays these fields:

Not Marked to Accrue	Bills that you did not mark to accrue on the Standard Billing - Header - Info 2 page (ACCRUE_UNBILLED='N').
100% Revenue Distribution	Bills that do not have adequate revenue accounting information to create accounting entries.
No Dis/Sur ChartFields (no discount or surcharge ChartFields)	Bills that do not have adequate discount or surcharge accounting information to create accounting entries.

Note. If a bill did not accrue because all three reasons, the report lists that bill three times.

Bill Status Not Eligible	Bills with a bill status that is neither included on the list of statuses on the business unit nor INV, TMP, TMR, or CAN. Bills that did not accrue for this reason could have been disqualified for other reasons, as well. You must fix the status and run this report again to see if it was disqualified for any other reason.
Reason	System-generated message indicating why a report did not accrue.
Transaction Amount	Total amount in transaction currency (the currency that is used to complete the transaction).
Base Amount	Total amount in base currency (the primary currency that is in use for a business unit). Each business unit must have one base currency. This is usually the local currency for the organization, but accounting rules or other circumstances may dictate that it be different.

Summarization Invoice Reports

The summarization invoice reports, BISLSUM, BISLSUMC, BICLSUM, and BICLSUMC, display the following summarization fields:

Group Heading	Group headings are dynamically constructed from the summarization template using the custom text defined in the template and the values in the field or fields upon which the grouping is based.
Summarization note	The text for the optional summarization note is defined in the summarization template.
Summarized line	The text displayed for summarized lines is dynamically constructed from the custom text in the template and the selected fields from the summarized bill lines.

See Also

Setting Up Bill Summarization

(NLD) Acceptgiro Invoice Reports

The acceptgiro invoice reports include:

BIPRNTA0
BIPRNTA2
BIPSAA1
BIPSAA2
BIPSAA3
BICAA
BIPRNCA0
BIPRNCA2
BIIVCPNA
BIIVCPCA

The following field is unique to acceptgiro invoices:

Payment Reference

The payment reference helps match the acceptgiro payment to the invoice. The reference is printed in both the invoice and attached payment slip portions of the report. The payment reference number consists of a one-digit control code followed by a 15-digit, automatically generated number. The control code is calculated based on the digits in the generated number and serves to validate that the reference number was not garbled in transmission.

See Also

(NLD) Printing Acceptgiro Invoices