Listing of Signature Payment Basis PO Lines that Must be Closed to Receiving Report

Report Series Name
C-U-PS-OPEN-ORDERS

Report Name
State of North Carolina Purchasing System Listing of Signature Payment Basis PO Lines That Must Be Closed to Receiving

Library
Source code is located in PSPUBLIC

Use
To list signature payment basis PO lines that must be closed to receiving.

Content
This report lists the purchase order number, blanket release number, purchase order line number, buyer ID, line receipt status, line invoice status, vendor promise date, purchase order line base permit-to-pay amount, purchase order amount invoiced to date, and the requisition amount for each requisition line within the buying entity. This report sorts by invoice status, buyer ID, purchase order number, blanket release number, and purchase order line number. The report series also contains the Listing Of Signature Payment Basis PO Lines That Are Partially Paid And Not Received report.

Totals
N/A

Column Headings

  • BUY. ENT. - Buying Entity
  • PO NUMBER - a unique identifier for a particular Purchase Order
  • BLKT REL NUMBER- Blanket Release Number- uniquely identifies a release being made against a blanket purchase order
  • PO LINE NBR - PO Line Number- identifies a particular line on a purchase order. This number is unique for each purchase order.
  • BUYER ID -NCAS Buyer ID
  • LINE RECEIPT STATUS - indicates the status of a line to receiving (open, partial receipt or closed)
  • LINE INVOICE STATUS- indicates the status of a line to invoicing (open, partial or closed)
  • VENDOR PROMISE DATE -date vendor promised to deliver the item
  • PO LINE BASE PERMIT TO PAY - If payment basis is receipt, then this amount will be the total amount from the receipt line; otherwise the base permit to pay amount will be the quantity received multiplied by the PO line price. This calculated amount will be used at invoice entry to calculate the permit to pay for the invoice, which is the base permit to pay less the amount invoiced to date for the PO line.
  • PO AMOUNT INVOICE TO DATE- Amount invoiced to date against the PO line.
  • DIFFERENCE- the difference between the PO line base permit to pay and the PO amount invoice to date.

Run Statements
The run statement member name is: C-U-PS-OPEN-ORDERS-RUN

000100 OPTION LIBRARY(PSPUBLIC)
000110 RUN C-U-PS-OPEN-ORDERS
000120 INTO LIBRARY XXXXXXXX
000200 *REPORT PSCLOSE
000300 *SELECT PUR-PO-BUYING-ENTITY
000400 * 'XX'
000500 *REPORT PSOPEN
000600 *SELECT PUR-PO-BUYING-ENTITY
000700 * 'XX'

Type over the displayed variable values with your agencys values