PO History by Item

The PO History by Item report produces a report of the purchase orders that have been created on your system in Item/Vendor Sequence.  The report allows you to print either detail or summary information for each item/vendor combination and it also allows you to select only purchase orders that have been partially or completely received (the report defaults to only include purchase order lines with receiving activity).  Additional selections are available in the report and these selections are described below.

Selection Options:  The PO History by Item report includes the following selection options.

      PO Number Range: Allows you to select only the purchase orders that are included in the specified PO Number range and that meet the other selection criteria used for the report.  Once you have checked this selection, the system will allow you to use the prompt button or the prompt key to access the Purchase Order Selection List so that you can select the purchase order number range to be used by the report.

      PO Date Range: Allows you to select only the purchase orders that are included in the specified PO Date range and that meet the other selection criteria used for the report.

      PO Type IN:  Allows you to select only the purchase orders that have the specified type and that meet the other criteria used for the report.  This selection defaults to include only Purchase Orders (Type P records).  Other valid PO types include R (requisition) and Q (request for quotation).

      PO Reference Number: Selects only purchase orders that contain the specified information in the Reference Field of the PO Header, and that meet the other selection criteria used for the report.

      Division Range: Allows you to select only purchase orders which have a division number in the specified range.  Once you have checked this selection, the system will allow you to use the prompt button or the prompt key to access the Division Selection List so that you can select the division number range to be used by the report.

      Department Range: Allows you to select only purchase orders which have a department number that is in the specified range.  Once you have checked this selection, the system will allow you to use the prompt button or the prompt key to access the Department Selection List so that you can select the department number range to be used by the report.

      Include Locations IN:  The Locations IN selection allows you to specify one or more warehouse locations.  If this selection is used, only purchase orders for the selected inventory locations will be included on the report.  Multiple selections should be separated by a comma.

      Item Number Range: Allows you to select only the purchase orders that were issued for items in the specified inventory item number range (and that meet the other selection criteria used for the report).  Once you have checked this selection, the system will allow you to use the prompt button or the prompt key to access the Catalog Selection List so that you can select the Item Number range to be used by the report.

      Inventory Product Line: Used to select only purchase orders for items assigned to the specified product line in the Inventory Master file.  Once you have checked this selection, the system will allow you to use the prompt button or the prompt key to access the Prodline Selection List so that you can select the Product Line to be used by the report.

      Inventory Type IN: The Type IN selection allows you to specify one or more inventory item types to be included on the report.  If this selection is used, only purchase orders for items with the specified types will be included on the report.  Multiple selections should be separated by a comma.

      Vendor Name Range: Allows you to select only the purchase orders that were issued to vendors in the selected vendor name range.  Once you have checked this selection, the system will allow you to use the prompt button or the prompt key to access the Vendor Selection List so that you can select the Vendor Name range to be used by the report.

      Vendor Type IN: The Vendor Type IN selection allows you to specify one or more vendor company types to be included on the report.  If this selection is used, only purchase orders issued to vendors with the specified types will be included on the report.  Multiple selections should be separated by a comma.

      Buyer Code:  Allows you to select only the purchase orders that contain the specified buyer code in the buyer field of the purchase order header.

      Requisitioned By:  Allows you to select only the purchase orders that have the specified initials in the Requisitioned By field of the purchase order header.

      Print Summary Only: The Print Summary Selection allows you to output only the total quantity and extended price for each item purchased from each vendor.  When this option is selected, the report does not output the detail from the individual purchase order lines for each item vendor combination, and it prints only the total quantity and total extended price for the item/vendor.

      New Page on Item:  If this option is selected, the report will start a new page each time the item number on the report changes.

      Only Include POs w/Received GT 0:  If this option is selected, the report will include only purchase order lines that have been partially or completely received into inventory.  This option defaults to selected.  You must uncheck this option if you wish to include purchase orders that have not been received.

Output Format:

The following section displays a sample of the output produced by the PO History by Item report. This sample is based on the default List and Label Template for the report that is provided by Cove Systems. Please note that the report output and selection information can also be customized using the Advanced Reporting Options and the Design report options that are available in the system.

Description: po_history_by_item

More:

PO History by Vendor