PeopleSoft Purchasing Report Details

Rel (release)

If the purchase order is tied to a contract, the contract release number appears.

PO Status (purchase order status)

Displays the status of the purchase order: Approved, Canceled, Completed, Dispatched, Initial, Open, or Pending Approval.

EmplID (employee ID)

Displays the procurement card user's name along with the user's ID.

Credit Card

Select the supplier responsible for issuing the card. Typically, this supplier is a bank.

CC Account (credit card account)

Enter the credit card account number.

Currency Code

Select the currency code. The report contains transactions with the selected currency code.

Date From

Select the start point of the transaction date range.

To

Select the end point of the transaction date range.

Event ID

Displays the sourcing event ID along with the round and version numbers.

Line Grouping ID

A line group is a bundle of items that buyers use in PeopleSoft Strategic Sourcing to obtain better pricing for items. Other values in the report such as the amount released, awarded and remaining apply to the corresponding line group ID and document.

Purchasing Business Unit

Displays the PeopleSoft Purchasing business unit in which the line grouping is defined. A business unit is an operational subset of the organization that tracks and maintains its own set of requisitions and purchase orders.

Document Type

Displays the type of document. Values include: Requisition, Purchase Order, RTV, RFQ, Receipt, Work Order, MSR, and Contract.

Document ID

Displays the system identifier and short description for the document.

Supplier ID

Displays the supplier to which the event was awarded.

Buyer ID

Displays the buyer for sourcing event ID along with the round and version numbers.

Payment Terms

If you are using a procurement card or a supplier card as the payment method for the purchase order, ProCard appears in this field.

Procurement Card Information

Depending on the procurement card dispatch option you select different procurement card information will appear on this report. The procurement card information appears under the Bill To information in the header portion of the report. For example: Procurement Card: *********7777 Card Type: Visa Expires: 2100-01-01

Replenishment Option

Displays whether the items on the purchase order are standard or stockless. Each purchase order contains either all standard or all stockless items.

Extended Amt (extended amount)

The schedule price multiplied by the schedule quantity. This is the merchandise amount of the schedule. It does not include other amounts associated with the schedule, such as freight and tax. This is in the transaction currency on the purchase order that you send to the supplier.

Total Amount

The total amount that can be ordered against the contract line.

Total Quantity

The total (maximum) quantity that can be ordered against the contract line.

PO Status

Status of the purchase order after you run the process.

Budget Status

Status of the budget check that you performed on the purchase order.

Budget Ln Status (budget line status)

Status of the budget check performed on the purchase order line.

Include Cancelled POs?

Check to include canceled purchase orders on the report.

Include Open/Pending Appr POs?

Check to include purchase orders that are still open or pending approval.

The line amounts will be zero for canceled, open, and pending approval purchase orders.

Option

Select beginning and ending dates. Values are:

C (current date): Report purchase order activity beginning and ending with the current date.

M (current date minus days): Report purchase order activity beginning and ending with the date that is a specified number of days before the current date. Specify that number in the Nbr Days field.

N (no selection by date): Date criteria not used to report purchase order activity.

P (current date plus days): Report purchase order activity beginning and ending with the date that is a specified number of days after the current date. Specify the number in the Nbr Days field.

S (specified date): Report purchase order activity beginning and ending with the date that you select in the Date field.

Only Those Needing Review

Select to report only on acknowledgments not yet identified as Reviewed.

Exceptions Only

Select to report only on acknowledgments for which the status indicates that the supplier has changed the purchase order.

Option

Select the beginning and ending dates for which you want to report acknowledgments. Values are:

C (current date): Report received acknowledgments beginning and ending with the current date.

M (current date minus days): Report received acknowledgments beginning and ending with the date that is a specified number of days before the current date. Specify that number in the Nbr Days field.

N (no selection by date): Date criteria not used to report acknowledgments.

S (specified date): Report received acknowledgments beginning and ending with the date that you select in the Date field.

POA Status

Acknowledgment status for the purchase order.

Line Status

Acknowledgment status for the line.

Supplier ID

Enter the supplier SetID in the first field and the supplier ID in the second.

Print Schedules

Select to have the report generate detail to the schedule level.

Production ID

If the item is associated with a PeopleSoft Manufacturing production kit, this field displays the item's associated production identification number.

Op Seq (operation sequence)

The order number in which this material is used in the production sequence.

Supplier ID

Enter the supplier SetID in the first field and the supplier ID in the second.

Print Schedules

Select to generate detail that includes the schedule level on the report.

Open Quantity

Quantity of the purchase order line (or schedule) that has not been received. This is the purchase order quantity minus the receipt quantities.

Production ID

If the item is associated with a PeopleSoft Manufacturing production kit, this is the item's associated production ID.

Op Seq (operation sequence)

The order number in which this material is used in the production sequence.

Pegged

Indicates if the line or schedule is pegged.

GL Business Unit

Select this option and enter a business unit to report on receipts for a specific business unit. If you do not enter a specific business unit, you will report on all GL business units.

Recv BU

Select this option and enter a business unit to report on receipts for a specific receiving unit. If you do not enter a specific business unit, you will report on all receiving business units.

ChartField

Enter the ChartField by which to sort the report. The default is by account.

ChartField Value 1 and ChartField Value 2

Then enter ChartField values in order to limit the report to a specific range for that ChartField. To report on all values, leave the range fields blank.

You can sort by more than one ChartField.

All Unprocessed Receipts

Select to produce a flat file including items on all unprocessed receipts. The system retrieves all lines in the RECV_LN_DISTRIB table that have not been processed (LOC_RECV_LBL_FLG = N) for usage label generation.

Reprint

Select to reprint a report including items on a specific flat file. In addition, you may reprint labels according to values that you entered in the Receipt ID and Receipt Line fields, or according to entries in the RECV_LN_DISTRIB table with a LOC_RECV_LBL_FLG = Y.

Receipt ID

If you selected the Reprint option, enter the receipt number for which to reprint labels.

Receipt Line

If you selected the Reprint option and have entered a receipt ID, enter the receipt line number associated with the item for which to reprint labels.

Item Usage Label Format

Select a label format ID from the available options. You define this value on the Data Collection Label Setup page.

Number of Copies

Enter the number of sets of labels to print.

Override File

Select to designate that this report file is to override an existing flat file.

File Directory

Enter the file directory that contains the file to override with the current flat file.

File Name

Enter the name of the file to override with the current flat file.

Include Inactive Items

Select to include items that are restricted to warehouse movement transactions, adjustments, RMA and RTV transactions, and receiving transactions.

Refresh

Click to display multiple rows for each column in the ChartField Selection area and default Sequence field values. When you click Refresh, the button name changes to Restore, and you can click it to restore the default view of ChartField Selection area.

Sequence

The sequence in which ChartFields appear on the report.

Include CF (include ChartField)

Select to generate a report on the ChartField and values that you selected in this row.

Pending

Select to report on purchase orders that are pending.

Mid Roll

Select to report on purchase orders for which you have run the PO Roll1 process.

Roll Completed

Select to report on purchase orders for which you have run the PO Roll1 process and the PO Roll2 process. As a result, new distributions are ready to be budget checked.

Disqualified

Select to report on purchase orders that are in roll error.

Business Unit

Displays the business unit to which this report applies.

Search ID

Displays the search ID that you selected for the report.

Report Sort Order

The report can be sorted by exception type or purchase order number.

Exception Type

Displays the rollover error and information associated with the error sorted by exception type. For each rollover error type, the report displays the error title and information using these rules:

• Invalid budget status on PO.

• Invalid budget status on voucher.

• Invalid budget status on PO and voucher.

• Invalid budget status on PO and receipt partially vouchered.

• Invalid budget status on PO and voucher and receipt partially vouchered.

• One receipt is partially vouchered.

• Invalid budget status on voucher and receipt partially vouchered.

PO ID

Displays the purchase order business unit.

PO Amount

Displays the amount of the purchase order.

Business Unit

Displays the purchase order business unit.

Document ID

Displays the document ID which can be a voucher or receipt.

Document Amount

Displays the amount for the purchase order.

Requester Signature

The person who submitted the requisition can sign here for purposes of accountability.

Procurement Card, Card Type, and Expires

If applicable, the procurement card number, type, and expiration date will appear in the header portion of the report under the Requestor Signature field.

*

An asterisk will appear next to the requisition line and schedule if that line is to be paid by a procurement card.

Extended Amt (extended amount)

The merchandise amount of the schedule is the schedule price multiplied by the schedule quantity. It does not include other amounts associated with the schedule, such as freight and tax. This is in the transaction currency on the purchase order that you send to the supplier.

Freight Terms

If freight terms apply to this return to vendor, this field shows the applicable terms according to the schedules of the purchase order for the received material. The freight terms reflect who holds legal responsibility for the material until ownership has passed.

UM (unit of measure)

Unit of measure of the quantity being returned.

Action

Return action for the item.

Dispose

Disposition assigned to the item being returned.

Reason

Return reason for the item.

Ship Via

Route or mode of transportation of the shipment assigned to the returned material.

Business Unit

Purchasing business unit for which the report was run.

Budget Date From/To

Budget dates for which the report was run. The budget dates do not necessarily correspond to a budget period.

Remaining Amount (at the report header level)

Distribution remaining amount criteria against which the report was run.

PO ID (purchase order ID)

Purchase order for which information is reported.

Line/Sched/Dist (line/schedule/distribution)

Report processing checks the Purchase Order Line Distribution tables and selects lines, schedules, and distributions for which the following criteria are met:

The business unit and budget date on the line meet report request parameters.

The report provides information for distribution lines with budget line statuses of V (valid) or W (warning).

The line meets defined ChartField criteria, if any.

Original PO Amount (original purchase order amount)

Original purchase order distribution amount.

Liquidated Amount

The liquidated amount is calculated from the original purchase order amount less the remaining amount.

Remaining Amount (at the report line level)

The remaining amount is calculated using the default commitment control ledger group associated with the general ledger business unit on the purchase order distribution line, the ledger group in the BU_LED_GRP_TBL table, and the setting of the Commitment Detail Ledger option on the Ledgers for a Unit - Commitment Control Options page.

If you select the Commitment Detail Ledger option, the remaining amount is derived from KK_LIQUIDATION.MONETARY_AMT.

If the Commitment Detail Ledger option is not selected, the remaining amount is derived from PO_LN_DISTRIB.MONETARY_AMT_BSE.

Vouchered Amount

Sum of the vouchered amount associated with the purchase order distribution line.

Totals

The report provides totals for original purchase order amount, liquidated amount, remaining amount, and vouchered amount values.

Business Unit

Purchasing business unit for which the report was run.

Budget Date From/To

Budget dates for which the report was run. The budget dates do not necessarily correspond to a budget period.

Remaining Amount (at the report header level)

Distribution remaining amount criteria against which the report was run.

REQ ID (requisition ID)

Requisition for which information is reported.

Line/Sched/Dist (line/schedule/distribution)

Report processing checks the Requisition Line Distribution tables and selects lines, schedules, and distributions for which the following criteria are met:

The business unit and budget date on the line meet report request parameters.

The report provides information for distribution lines with budget line statuses of V (valid) or W (warning).

The line meets defined ChartField criteria, if any.

Original REQ Amount (original requisition amount)

Original requisition distribution amount.

Liquidated Amount

The liquidated amount is calculated from the original requisition amount less the remaining amount.

Remaining Amount (at the report line level)

The remaining amount is calculated using the default commitment control ledger group associated with the general ledger business unit on the requisition distribution line, the ledger group in the BU_LED_GRP_TBL table, and the setting of the Commitment Detail Ledger option on the Ledgers for a Unit - Commitment Control Options page.

If you select the Commitment Detail Ledger option, the remaining amount is derived from KK_LIQUIDATION.MONETARY_AMT.

If the Commitment Detail Ledger option is not selected, the remaining amount is derived from REQ_LN_DISTRIB.MONETARY_AMT_BSE.

PO Amount

Sum of the MONETARY_AMT_BSE field values from the purchase order distribution lines associated with the requisition distribution line.

Totals

The report provides totals for original requisition amount, liquidated amount, remaining amount, and PO amount values.

Max Amount (maximum amount)

The maximum amount of the contract.

Rcv Date (receiving date)

The date on which you physically received the shipment.

Rcv Status (receiving status)

The status of the shipment.

Match Status

The matching status of the receipt line item. Values are:

Matched: Fully matched.

No Match: No match found.

Partial: Partially matched.

To Match: To be matched.

Bill Of Lading

The shipper's proof of identification of the material in transit.

Hold Asset

Indicates whether the system is currently processing asset information for this receipt or holding until you clear Hold Asset on the Receipt Defaults page.

Y (yes) indicates that Hold Asset is selected for this receipt. N (no) indicates that Hold Asset is not selected for this receipt.

Hold Inventory

Indicates whether the system is currently processing inventory and putaway information for this receipt or holding until you clear Hold Inventory on the Receipt Defaults page.

Y (yes) indicates that Hold Inventory is selected for this receipt. N (no) indicates that Hold Inventory is not selected for this receipt.

Rcv Status (receiving status)

The status of the shipment.

GL BU (general ledger business unit)

The PeopleSoft General Ledger business unit associated with the selected distribution.

Product

The identification number of the product group to which the selected distribution line item belongs.

Bill of Lading

Displays the shipper's proof of identification of the material in transit.

Recv Ln (receiving line)

Displays the receipt line number.

PO HDR Comment/PO LINE Comment

Displays the header and line comments entered on the purchase order with the Shown at Receipt option selected.

Production ID

If the item is associated with a PeopleSoft Manufacturing production kit, the system displays the item's associated production ID in this field.

Operation Sequence

The order number in which this material is used in the production sequence.

WC Description (work center description)

Description of the selected work center.

Bill of Lading

The shipper's proof of identification of the material in transit.

Recv Ln (receiving line)

The identification number of the line on the receipt.

RTV ID (return to vendor)

Select a Return To Vendor ID in combination with a business unit to run a report for an individual return.

Return Status

Select a return status to run a report for all vendor returns having a specific return status and business unit.

Freight Terms

If freight terms apply to this return to vendor, this field shows the applicable terms according to the schedules of the purchase order for the received material. The freight terms reflect who holds legal responsibility for the material until ownership has passed.

Disp Type (disposition type)

Disposition assigned to the item being returned.

Prod ID (production ID)

If the item is associated with a production kit, this field displays the item's associated production ID.

OP Seq (operation sequence)

Number designating the sequence in which production uses this material.

Ship Via

Route or mode of transportation for the shipment line assigned to the returned material. The ship via can differ line to line if for some reason an item requires a different method of shipping. For example, a shipment line may require a ship via for a hazard-controlled item.