Purchase Order Register
Prints purchase order information as entered — vendor, line items, quantities, amounts, and status. Use this to review what's been committed and confirm PO details before or after sending to vendors. You can include or exclude columns for quantities ordered, received, cancelled, and remaining, as well as encumbrance and coding detail.
Note: If you're not familiar with the MIP Report Builder, see Report Builder for an introduction.
The following columns are available to include in the report:
Purchase Order Number - The number assigned to the purchase order when printed.
Reference Number - The temporary number assigned to the purchase order before it is printed.
Document Date - The date assigned to the purchase order.
Purchase Order Status - The purchase order's status: In Process, Ready to Print, Open, Closed, or Void.
Description - The title or description of the purchase order.
Vendor ID - The vendor ID assigned to the purchase order.
Vendor Name - The name associated with the vendor ID.
Vendor PO Address - The vendor's address, city, state or province, and postal code.
Vendor PO Contact - The contact name for the vendor.
Vendor PO Contact Email - The contact's email address.
Vendor PO Contact Phone - The contact's telephone number.
Vendor PO Contact Fax - The contact's fax number.
Receiving Skipped - Y (Yes) or N (No), indicating whether the Skip Receiving option was selected on the purchase order.
Create Encumbrance - Y (Yes) or N (No), indicating whether the Create Encumbrance option was selected on the purchase order.
Encumbrance Session ID - The session ID of the encumbrance created when the purchase order was printed, if applicable.
Shipping Address Code - The shipping address code assigned to the purchase order.
Shipping Address - The address associated with the shipping code.
Billing Address Code - The billing address code assigned to the purchase order.
Billing Address - The address associated with the billing code.
Attention - The name of the person or department that should receive payment.
Buyer - The name of the buyer who handled the order.
FOB - The freight on board information for the purchase order.
Shipping Method - The shipping method for the purchase order, such as Ground or Priority Mail.
Comments - Any comments entered on the purchase order.
Line Number - The line number for each line item on the purchase order.
Category Code - The category code for each line item.
Item Code - The item code for each line item.
Item Code Status - The status of the item code: Active, Inactive, or Discontinued.
Item Description - The description for each line item.
Special Instructions - Any additional information related to the line item.
GL Code - Item Detail - The general ledger code for each line item.
Distribution Code - The distribution code for each line item.
Purchase Unit - The unit of measure for one purchase unit, such as each or case.
Quantity Ordered - The quantity ordered for each line item.
Quantity Received - The quantity received for each line item. Displays zero when Skip Receiving was selected.
Quantity Cancelled - The quantity cancelled for each line item. Displays zero when Skip Receiving was selected.
Quantity Adjusted (Net) - The net difference between the original and adjusted quantity. Displays zero when Skip Receiving was selected.
Quantity Remaining - The remaining quantity to be fulfilled for each line item.
Adjusted Quantity - The adjusted quantity for each line item. Displays zero when Skip Receiving was selected.
Unit Price - The monetary amount per unit for each line item.
Ordered Amount - The amount ordered for each line item on Skip Receiving purchase orders.
Cancelled Amount - The amount cancelled for each line item on Skip Receiving purchase orders.
Invoiced Amount - The amount invoiced for each line item.
Remaining Amount - The difference between the ordered amount and the invoiced and cancelled amounts, for Skip Receiving purchase orders.
Item Total - The total for each line item (quantity multiplied by unit price).
Purchase Order Total - The sum of all line items on the purchase order.
Encumbrance Document Amount - The sum of all encumbrance increases and decreases.
Open Encumbrance Balance - The current encumbrance balance for posted entries.
Date Required By - The date the order is needed.
Date Promised - The date the order is due.
Date Received - The date the order was received.
Requested For - The person who requested the items.
Created By - The login name of the person who created the purchase order.
Printed By - The name of the user who printed the purchase order.
Last Modified By - The name of the user who last updated the purchase order.
Last Modified Date - The date the purchase order was last updated.
{Segment Name} Code - The account code for each segment, such as Fund Code or GL Code. One column displays per segment.
{Segment Name} Title - The title associated with each segment code. One column displays per segment.
{Segment Name} Short Title - The short title for each segment code. One column displays per segment.
{Segment Name} Group Code - The group code for each segment. One column displays per segment.
{Segment Name} Group Title - The title associated with each group code. One column displays per segment.
{Segment Name} Group Short Title - The short title for each group code. One column displays per segment.