Listing of Signature Payment Basis PO Lines that are Partially Paid and Not Received Report

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

Report Name
LISTING OF SIGNATURE PAYMENT BASIS PO LINES THAT ARE PARTIALLY PAID AND NOT RECEIVED

Library
Source code is located in PSPUBLIC

Use
This report lists purchase order lines that may need to be closed to receiving. The PO lines listed are only partially paid and are not closed to invoicing. As a result, these lines are not automatically closed to receiving. This report should be generated on a monthly basis.

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, amount invoiced to date, and the requisition amount for each requisition line within the buying entity. This report sorts by invoice line status, buyer ID, purchase order number, blanket release number, and purchase order line number. This report series also contains the Listing Of Signature Payment Basis PO Lines That Must Be Closed To Receiving 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- identifiesa particular line on a purhcase order. This number is unique for each purchaseorder.
  • 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 Poline 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