Documentation >
MAC-PAC Technical Library >
Distribution >
Purchasing >
Programs >
Item/Vendor Analysis Inquiry - Purpose >
Item/Vendor Analysis Inquiry - Calculations
Item/Vendor Analysis Inquiry - Calculations
PO940E
A. Housekeeping
1. See Common Processing Routines - Housekeeping of this manual for a general discussion of the Housekeeping routine. Processing specific to this program is described below.
2. A parameter list is set up for the fast path and help screen parameters.
3. Key lists are defined for each file retrieved by the program.
4. Workfields are defined and program constants are initialized.
5. The following records are retrieved from the Reference file (REFERP):
a. The date format record (category 049) is retrieved. If this record is not found, the date format defaults to MMDDYY.
b. The default company/warehouse is retrieved from the workstation assignment record (category 428).
c. All company/warehouses to which the user is authorized are retrieved from the user company/warehouse authorization record (category 409) and loaded into an array. If no records are found for the user, a flag is set authorizing the user to all company/warehouses.
d. The current purchasing period calendar (category 490) is retrieved and the number of periods (12 or 13) is saved.
e. The last purchasing period posted (category 488) is retrieved and saved.
6. All valid company/warehouse combinations are retrieved from the Warehouse Description file (IC170M) and stored in an array. The corresponding plant name is retrieved and stored in a separate array. The default company/warehouse retrieved above is validated against the valid company/warehouse array; if not found, a message is displayed and the user must enter a valid company/warehouse before processing can continue.
7. The multiple currency environment is set by checking the multiple currency flag on the system options record (category 133) on the Reference file.
8. The location defaults data (category 132) is retrieved from the Reference file (REFERP), and the VAT (Value Added Tax) status is checked.
B. Select
1. The Item/Vendor Analysis Inquiry Function Select screen (PO940S01) is displayed.
2. After the user presses the ENTER key, the user input is validated. See the Purchasing User Manual, Inquiry Screens - Purchasing Control, for validation rules.
3. A primary read is performed according to the entered maintenance code, and the next screen is displayed.
a. If the Request Code = 1 (Selected Item/Vendor Relationship), the detail screen is displayed.
b. If the Request Code = 2 (Vendors by Item), a priming read is made on the logical Item/Vendor or Vendor Master Relationship Join file (PO140JL2), keyed by part number. If no records are found, an error message is displayed. Otherwise, the vendor list screen is displayed.
c. If the Request Code = 3 (Item by Vendor), a priming read is made on the logical Part Master and Item/Vendor Join file (PO140JL3), keyed by vendor number. If no records are found, an error message is displayed. Otherwise, the item list screen is displayed.
C. Vendor List
1. The vendor list screen subfile is initialized with the data from the logical Item/Vendor Relationship Join file (PO140JL2).
2. The Item/Vendor Analysis Inquiry Vendor List screen (PO940S02) is displayed.
3. User input is validated. One X may be entered in the Select field. If more than one X is entered, an error message is displayed.
4. The next screen is displayed based on the command key the user has pressed.
|
|
|
F4 - Display Detail
|
Detail screen (PO940S04)
|
F10 - Display Prompt
|
Function Select screen (PO940S01)
|
F14 - Delivery Perf.
|
Delivery Performance screen (PO940S05)
|
F16 - Price Perf.
|
Price Performance screen (PO940S06)
|
F18 - Quality Perf.
|
Quality Performance screen (PO940S07)
|
D. Item List
1. The item list screen subfile is initialized with data from the logical Item/Vendor Join file (PO140JL3).
2. The Item/Vendor Analysis Inquiry Item List screen (PO940S03) is displayed.
3. User input is validated. One X may be entered in the Select field. If more than one X is entered, an error message is displayed.
4. The next screen is displayed based on the command key the user has pressed.
|
|
|
F4 - Display Detail
|
Detail screen (PO940S04)
|
F10 - Display Prompt
|
Function Select screen (PO940S01)
|
F14 - Delivery Perf.
|
Delivery Performance screen (PO940S05)
|
F16 - Price Perf.
|
Price Performance screen (PO940S06)
|
F18 - Quality Perf.
|
Quality Performance screen (PO940S07)
|
E. Detail
1. The detail screen subfile is initialized with data from the Item/Vendor Analysis file (PO270M).
2. The following calculations are performed:
TOTAL
RELEASES
|
=
|
ON-TIME
RELEASES
|
plus
|
EARLY
RELEASES
|
plus
|
LATE
RELEASES
|
|
TOTAL
QUANTITY
|
=
|
ACCEPTED
QUANTITY
|
plus
|
REJECTED QUANTITY
|
|
|
|
STANDARD COST
VARIANCE
|
=
|
VOLUME AT
STANDARD COST
|
minus
|
VOLUME AT
UNIT COST
|
ON-TIME RELEASE
PERCENTAGE
|
=
|
ON-TIME RELEASES
TOTAL RELEASES
|
times
|
100
|
|
EARLY RELEASE
PERCENTAGE
|
=
|
EARLY RELEASES
TOTAL RELEASES
|
times
|
100
|
|
LATE RELEASE
PERCENTAGE
|
=
|
LATE RELEASES
TOTAL RELEASES
|
times
|
100
|
|
ACCEPTED
PERCENT
|
=
|
ACCEPTED QUANTITY
TOTAL QUANTITY
|
times
|
100
|
|
REWORK
PERCENT
|
=
|
REWORK QUANTITY
TOTAL QUANTITY
|
times
|
100
|
|
REJECTED
PERCENT
|
=
|
REJECTED QUANTITY
TOTAL QUANTITY
|
times
|
100
|
|
RETURN
PERCENT
|
=
|
RETURN QUANTITY
TOTAL QUANTITY
|
times
|
100
|
|
PRICE
INDEX
|
=
|
VOLUME AT UNIT COST
VOLUME AT STANDARD COST
|
times
|
100
|
|
AVERAGE
PRICE
|
=
|
VOLUME AT UNIT COST
TOTAL QUANTITY
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3. The Item/Vendor Analysis Inquiry Detail screen (PO940S04) is displayed.
4. The next screen is displayed according to the command key the user has pressed:
|
|
|
F8 - Return to List
|
Vendor List screen (PO940S02) or Item List screen (PO940S03)
|
F10 - Display Prompt
|
Function Select screen (PO940S05)
|
F14 - Delivery Perf.
|
Delivery Performance screen (PO940S05)
|
F16 - Price Perf.
|
Price Performance screen (PO940S06)
|
F18 - Quality Perf.
|
Quality Performance screen (PO940S07)
|
F. Delivery Performance
1. The graphic array, if not already loaded, is loaded with 12 or 13 periods of item/reader analysis data.
2. The graphic display screen is loaded and the following calculations are performed:
TOTAL
RELEASES
|
=
|
EARLY SHIPPED
RELEASES
|
plus
|
ON-TIME SHIPPED
RELEASES
|
plus
|
LATE SHIPPED
RELEASES
|
ON-TIME
PERCENT
|
=
|
ON-TIME SHIPPED RELEASES
TOTAL RELEASES
|
times
|
100
|
|
EARLY
PROMPT
|
=
|
EARLY SHIPPED RELEASES
TOTAL RELEASES
|
times
|
100
|
|
LATE
PERCENT
|
=
|
LATE SHIPPED RELEASES
TOTAL RELEASES
|
times
|
100
|
|
|
|
|
|
|
|
|
|
|
|
3. The Delivery Performance screen (PO940S05) is displayed.
4. The next screen is displayed based on the command key the user has pressed:
|
|
|
F4 - Display Detail
|
Detail screen (PO940S04)
|
F7 - Previous Periods
|
Previous range of periods is displayed.
|
F8 - Next Periods
|
Next range of periods (if posted) is displayed.
|
F10 - Display Prompt
|
Function Select screen (PO940S01)
|
F16 - Price Perf.
|
Price Performance screen (PO940S06)
|
F18 - Quality Perf.
|
Quality Performance screen (PO940S07)
|
F19 - New Range
|
User can change the upper and lower limits of the y-axis (defaults are 100 and 0). The user can also select any one or all three indicators (early, on-time, late) for graphic display. If only one of the three is selected, the graph is shown with solid bars. When all three are selected, bars representing early, on-time and late shipped releases are made up of the letters E, O and L, respectively.
|
G. Price Performance
1. The graphic array, if not already loaded, is loaded with 12 or 13 periods of item/vendor analysis data.
2. The graphic display screen is loaded, the following calculation is performed, and the variance table is loaded.
IF VOLUME AT STD COST IS NOT = 0 THEN VARIANCE
|
|
|
=VOLUME AT UNIT COST - VARIANCE AT STD COST
VOLUME AT STD COST
|
times
|
100
|
3. The Price Performance screen is displayed (PO940S06).
4. The next screen is displayed based on the command key the user selects.
|
|
|
F4 - Display Detail
|
Detail screen (PO940S04)
|
F7 - Previous Periods
|
Previous range of periods is displayed.
|
F8 - Next Periods
|
Next range of periods (if posted) is displayed.
|
F10 - Display Prompt
|
Function Select screen (PO940S01)
|
F14 - Delivery Perf.
|
Delivery Performance screen (PO940S05)
|
F18 - Quality Perf.
|
Quality Performance screen (PO940S07)
|
F19 - New Range
|
User can specify a new range percentage for variance. (Default is 50.)
|
H. Quality Performance
1. The graphic array, if not already loaded, is loaded with 12 or 13 periods of item/vendor analysis data.
2. The graphic display screen is loaded and the following calculations are performed:
TOTAL
QUANTITY
|
=
|
ACCEPTED QUANTITY
|
plus
|
REJECTED QUANTITY
|
ACCEPTED
PERCENT
|
=
|
ACCEPTED QUANTITY
TOTAL QUANTITY
|
times
|
100
|
|
REJECTED
PERCENT
|
=
|
REJECTED QUANTITY
TOTAL QUANTITY
|
times
|
100
|
|
3. The Quality Performance screen is displayed (PO940S07).
4. The next screen is displayed based on the command key the user selects.
|
|
|
F4 - Display Detail
|
Detail screen (PO940S04)
|
F5 - Previous Periods
|
Previous range of periods is displayed.
|
F6 - Next Periods
|
Next range of periods (if posted) is displayed.
|
F10 - Display Prompt
|
Function Select screen (PO940S01)
|
F14 - Delivery Perf.
|
Delivery Performance screen (PO940S05)
|
F16 - Price Perf.
|
Price Performance screen (PO940S06)
|
F19 - New Range
|
User can specify new upper and lower percentage limits (defaults are 100 and 0). The user can also specify either Accepted, Rejected, or both quantity percentages for display.
|