Purchase PO Analysis Report ranges and options

Options

Use Format (1)-By Product (2)-By Vendor

Specify 1 to list each product by vendor. Select this format to conduct a vendor analysis.

Specify 2 to list each product by vendor order. This format can produce a longer report because multiple detail lines are included if you purchase the product from multiple vendors. Select this format to compare vendors.

(D)etail, (S)ummary,(T)otals, or (G)rand

Specify D to include detail purchase order lines for each product with a total line for each product. A total line is also included for all orders for a product and vendor with a grand total at the end of the report.

Specify S to include this information:

  • A total line for each product
  • A total line including all orders for a vendor
  • A grand total at the end of the report

Specify T to include a total line for all orders for a vendor and a grand total at the end of the report.

Specify G to include the total number of orders. Details per product or vendor is not included on the report.

Print Only When Order Is Late?

Select Yes to only include those purchase orders that were received after the due date. Use this option to identify vendors that are chronically late. You can then review the lead times and consider using a more reliable vendor.

Print Only When Cost Is Overridden?

Select Yes to only include those purchase orders where the cost is overridden in PO Receipt of Inventory Entry or Vendor Invoice Center Entry. If the cost is based on a PD Pricing Setup record or pricing sheets from the vendor, the cost should not fluctuate between each order. If the cost is continually overridden, it might indicate a issue that requires further research. If the cost is based on the last or replacement cost, receiving the product at a different cost than when the purchase order was originally placed is not uncommon.

Page Break on Totals?

Select Yes to begin a new page for a new product or new vendor.