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
PeopleTools 8.46 PeopleBook: Crystal Reports for PeopleSoft
This section lists:
PeopleSoft Billing reports, sorted alphanumerically by report ID.
Information that is important to specific PeopleSoft Billing reports.
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.
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
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. |
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. |
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. |
See Also
Running the Load AR Pending Items Process (BILDAR01)
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.
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 nonmonetary 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. |
See Also
Running the Load GL Accounting Entries Process (BILDGL01)
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
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. |
See Also
Running the Generate AP Vouchers Process (BIGNAP01)
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 doesn't 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 doesn't 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. |
See Also
Establishing Invoice Formatting, Sorting, and Printing Options
Entering Bill Line Discount and Surcharge Information
Defining Additional Billing Installation Options
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
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 |
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. |
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. AE: Accounting entry. NOTE. 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. |
See Also
Generating Summary Reports of Interface Activity
The fields on this report are the same as those on the Interface Detail Summary by Interface ID report.
See Also
Generating Summary Reports of Interface Activity
The fields on this report are the same as those on the Interface Detail Summary by Interface ID report.
See Also
Generating Summary Reports of Interface Activity
The fields on this report are the same as those on the Interface Detail Summary by Interface ID report.
See Also
Generating Summary Reports of Interface Activity
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 |
The type of information that is contained in the bill line. Values are: LINE: Charge line. AE: Accounting entry. NOTE 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. |
See Also
Generating Summary Reports of Interface Activity
The fields on this report are the same as those on the Interface Error Summary by Interface ID report.
See Also
Generating Summary Reports of Interface Activity
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. |
The Bill Lines Not Ready for Accrual report displays these fields:
Not Marked to Accrue |
Bills that you didn’t mark to accrue on the Standard Billing - Header - Info 2 page (ACCRUE_UNBILLED=’N’). |
100% Revenue Distribution |
Bills that don’t have adequate revenue accounting information to create accounting entries. |
No Dis/Sur ChartFields (no discount or surcharge ChartFields) |
Bills that don’t have adequate discount or surcharge accounting information to create accounting entries. |
Note. If a bill didn’t 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,, or CAN). Bills that didn’t 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. |
See Also
Generating Summary Reports of Interface Activity
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
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