NCAS Vendor Order Totals by County Report

Report Series Name
C-U-PS-VEND-ORD-TOTALS-CTY

Report Name
NCAS Vendor Order Totals by County

Library
Source code is located in PSPUBLIC

Use
This report allows the purcahsing manager to monitor the volume of purchases for vendors by county.

Content
This report lists the amount of purchase orders by vendor for the current year by county. Only vendors with a county code associated with an order from address are included.

Totals
This report gives totals for purchase order count and total purchase order amount by individual county, as well as a total for out-of-state vendors, and by paying entity.

Column Headings

• VENDOR NAME - the vendor name as listed in the NCAS Vendor File
• VENDOR NUMBER - the NCAS vendor number (Tax Identification Number)
• PURCHASE ORDER COUNT - the number of purchase orders per vendor
• TOTAL PURCHASE ORDER AMOUNT -the total PO amount for a vendor

Run Statements
The run statement member name is C-U-PS-VEND-ORD-TOTALS-CTY-RUN

000010 OPTION LIBRARY(PSPUBLIC)
000020 RUN C-U-PS-VEND-ORD-TOTALS-CTY
000100 INTO LIBRARY XXXXXXXX
000200 VARIABLE CURRENT-FISCAL-YEAR
000300 '00/00/00'
000400 SELECT CV-PAYING-ENTITY
000500 'XXXX'

Type over the displayed variable values with your agencys values. The date typed in the Current-Fical-Year variable is printed as part of the report title. It cannot be used to select another fiscal year or to select partial year information.