Purchasing Statistics Update - Purpose

The Purchasing Statistics Update program (PO260E) updates the Item/Vendor Statistics file, the Item/Buyer Statistics file, and the Vendor Purchasing History file.  Each file contains purchasing statistics for four time frames:

·      Current period

·      Year to date

·      Prior year

·      Next period

If the last period of the year is being processed, statistics are rolled from the year-to-date fields into the prior-year fields.  The year-to-date fields are initialized with the next period fields.

If the last period of the year is not being processed, the next period fields are added to the year-to-date fields.

For all periods, the current period fields are initialized with the next period fields.  The next period fields are set to zero.

The Item/Vendor Statistics file and the Item/Buyer Statistics file are also used to create Item/Vendor and Item/Buyer Analysis File records for the current processing period.

If there is no activity over a two-year period on the Item/Vendor Statistics file or the Item/Buyer Statistics file, the statistics record is deleted and all corresponding analysis records are deleted from the Item/Vendor or Item/Buyer Analysis file.  If a Vendor Purchase History File record has no activity over a two-year period, the record is deleted.

For all files, a file control reorganization report is printed showing the keys of the deleted records and the total number of deletions.

PO260E Program Menu

• Purpose
• Calculations
• Files
• Reports