1 | PRCH191 ;WISC/DJM Display MIN/MAX report ; 11/4/99 2:35pm
|
---|
2 | ;;5.0;IFCAP;**191**;4/21/95
|
---|
3 | ; This report will list all records that have a limit set to
|
---|
4 | ; zero (0). In file 441, Sub-File VENDOR, for fields 8 and 8.5.
|
---|
5 | ;
|
---|
6 | ; The second part of the report will list all records that have a
|
---|
7 | ; limit set to zero (0). In file 442, Sub-File ITEM, for field 9.6.
|
---|
8 | ;
|
---|
9 | START N PRCX,PRCY,PTR,MIN,MAX,TEST,AA,BB,CC,EE,MSG,DATA,STA0,STA1
|
---|
10 | ;
|
---|
11 | ; Clean up and set up.
|
---|
12 | ;
|
---|
13 | S PRCX=0
|
---|
14 | K ^TMP("DJM",$J)
|
---|
15 | F S PRCX=$O(^PRC(441,PRCX)) Q:PRCX'>0 D
|
---|
16 | . S PRCY=0
|
---|
17 | . F S PRCY=$O(^PRC(441,PRCX,2,PRCY)) Q:PRCY'>0 D
|
---|
18 | . . S PTR=$G(^PRC(441,PRCX,2,PRCY,0))
|
---|
19 | . . Q:PTR=""
|
---|
20 | . . S (MIN,MAX)=""
|
---|
21 | . . S:$P(PTR,"^",12)=0 MIN="X"
|
---|
22 | . . S:$P(PTR,"^",9)=0 MAX="X"
|
---|
23 | . . I (MIN="")&(MAX="") Q
|
---|
24 | . . S ^TMP("DJM",$J,PRCX,PRCY)=MIN_"^"_MAX
|
---|
25 | . . Q
|
---|
26 | . Q
|
---|
27 | S (TEST,DATA)=$D(^TMP("DJM",$J))
|
---|
28 | G:TEST=0 NEXT
|
---|
29 | ;
|
---|
30 | ; Now display the records in file 441 that need to be changed.
|
---|
31 | ;
|
---|
32 | 441 ; Display entries that need correcting in file 441.
|
---|
33 | ;
|
---|
34 | K MSG
|
---|
35 | S MSG(1)=" FILE 441"
|
---|
36 | S MSG(2)=" "
|
---|
37 | S MSG(3)="An X will show records with a value of 0 in the MINIMUM"
|
---|
38 | S MSG(4)="ORDER QTY (MIN) column or the MAXIMUM ORDER QTY (MAX)"
|
---|
39 | S MSG(5)="column. This patch changes both fields to accept "
|
---|
40 | S MSG(6)=".01--999999 as input."
|
---|
41 | S MSG(7)=" "
|
---|
42 | S MSG(8)="Use the 'Item File Edit' option to change records with"
|
---|
43 | S MSG(9)="field values out of range. Or set them to null/blank."
|
---|
44 | S MSG(10)="Enter the IMF IEN column value (110) to select"
|
---|
45 | S MSG(11)="the record to change. At the 'Select VENDOR:'"
|
---|
46 | S MSG(12)="prompt enter the VENDOR IEN"
|
---|
47 | S MSG(13)="column value (36300) to select the proper vendor"
|
---|
48 | S MSG(14)="containing the fields to edit."
|
---|
49 | S MSG(15)=" "
|
---|
50 | D MES^XPDUTL(.MSG)
|
---|
51 | K MSG
|
---|
52 | S MSG(1)="IMF VENDOR"
|
---|
53 | S MSG(2)="IEN IEN MIN MAX"
|
---|
54 | S MSG(3)="--- ------ --- ---"
|
---|
55 | D MES^XPDUTL(.MSG)
|
---|
56 | S PRCX=0
|
---|
57 | F S PRCX=$O(^TMP("DJM",$J,PRCX)) Q:PRCX'>0 D
|
---|
58 | . S PRCY=0
|
---|
59 | . F S PRCY=$O(^TMP("DJM",$J,PRCX,PRCY)) Q:PRCY'>0 D
|
---|
60 | . . S PTR=$G(^TMP("DJM",$J,PRCX,PRCY))
|
---|
61 | . . S AA=PRCX_" "
|
---|
62 | . . S AA=$E(AA,1,9)
|
---|
63 | . . S BB=PRCY_" "
|
---|
64 | . . S BB=$E(BB,1,10)
|
---|
65 | . . S CC=$P(PTR,"^")_" "
|
---|
66 | . . S CC=$E(CC,1,10)
|
---|
67 | . . S EE=$P(PTR,"^",2)
|
---|
68 | . . K MSG
|
---|
69 | . . S MSG(1)=" "
|
---|
70 | . . S MSG(2)=AA_BB_CC_EE
|
---|
71 | . . D MES^XPDUTL(.MSG)
|
---|
72 | . . Q
|
---|
73 | . Q
|
---|
74 | K MSG
|
---|
75 | S MSG(1)=" "
|
---|
76 | S MSG(2)=" "
|
---|
77 | D MES^XPDUTL(.MSG)
|
---|
78 | K MSG
|
---|
79 | ;
|
---|
80 | NEXT ; Now to see if there are any records in file 442 that need to be
|
---|
81 | ; corrected.
|
---|
82 | ;
|
---|
83 | S PRCX=0
|
---|
84 | K ^TMP("DJM",$J)
|
---|
85 | F S PRCX=$O(^PRC(442,PRCX)) Q:PRCX'>0 D
|
---|
86 | . S PRCY=0,(STA0,STA1)=""
|
---|
87 | . F S PRCY=$O(^PRC(442,PRCX,2,PRCY)) Q:PRCY'>0 D
|
---|
88 | . . S PTR=$G(^PRC(442,PRCX,2,PRCY,0))
|
---|
89 | . . Q:PTR=""
|
---|
90 | . . S MAX=""
|
---|
91 | . . S:$P(PTR,"^",14)=0 MAX="X"
|
---|
92 | . . Q:MAX=""
|
---|
93 | . . S STA0=$P($G(^PRC(442,PRCX,7)),"^",1)
|
---|
94 | . . S STA1=$P($G(^PRCD(442.3,STA0,0)),"^",1)
|
---|
95 | . . S MAX=MAX_" "_STA1
|
---|
96 | . . S ^TMP("DJM",$J,PRCX,PRCY)=MAX
|
---|
97 | . . Q
|
---|
98 | . Q
|
---|
99 | S (TEST,DATA)=$D(^TMP("DJM",$J))
|
---|
100 | ;
|
---|
101 | ; See if there is any data from file 441 or file 442.
|
---|
102 | ;
|
---|
103 | G:(TEST=0)&(DATA=0) EXIT
|
---|
104 | ;
|
---|
105 | ; There must be some data from file 441. DATA is not 0.
|
---|
106 | ;
|
---|
107 | G:TEST=0 FINAL
|
---|
108 | ;
|
---|
109 | 442 ; Now display the records in file 442 that need to be changed.
|
---|
110 | ;
|
---|
111 | K MSG
|
---|
112 | S MSG(1)=" FILE 442"
|
---|
113 | S MSG(2)=" "
|
---|
114 | S MSG(3)="An X will show records with a value of 0 in the MAXIMUM"
|
---|
115 | S MSG(4)="ORDER QTY (MAX) column. This patch changes the field"
|
---|
116 | S MSG(5)="to accept only .01--999999 as input."
|
---|
117 | S MSG(6)=" "
|
---|
118 | S MSG(7)="Use the 'Edit an Incomplete Purchase Order' option"
|
---|
119 | S MSG(8)="to change records with the field value out of range."
|
---|
120 | S MSG(9)="Or set them to null/blank. Please note, only P.O.s"
|
---|
121 | S MSG(10)="that have not been signed can be edited with this"
|
---|
122 | S MSG(11)="option."
|
---|
123 | S MSG(12)=" "
|
---|
124 | S MSG(13)="Enter the P.O. NAME column value (688-A90002) to"
|
---|
125 | S MSG(14)="select the record to change. At the 'Select LINE ITEM"
|
---|
126 | S MSG(15)="NUMBER:' prompt enter ` plus the ITEM IEN column value"
|
---|
127 | S MSG(16)="(`1) to select the proper line item containing the"
|
---|
128 | S MSG(17)="field to edit."
|
---|
129 | S MSG(18)=" "
|
---|
130 | D MES^XPDUTL(.MSG)
|
---|
131 | K MSG
|
---|
132 | S MSG(1)="P.O. P.O. ITEM SUPPLY"
|
---|
133 | S MSG(2)="IEN NAME IEN MAX STATUS"
|
---|
134 | S MSG(3)="---- ---- ---- --- ------"
|
---|
135 | D MES^XPDUTL(.MSG)
|
---|
136 | S PRCX=0
|
---|
137 | F S PRCX=$O(^TMP("DJM",$J,PRCX)) Q:PRCX'>0 D
|
---|
138 | . S PRCY=0
|
---|
139 | . F S PRCY=$O(^TMP("DJM",$J,PRCX,PRCY)) Q:PRCY'>0 D
|
---|
140 | . . S PTR=$G(^TMP("DJM",$J,PRCX,PRCY))
|
---|
141 | . . S AA=PRCX_" "
|
---|
142 | . . S AA=$E(AA,1,9)
|
---|
143 | . . S BB=$P($G(^PRC(442,PRCX,0)),U,1)_" "
|
---|
144 | . . S BB=$E(BB,1,15)
|
---|
145 | . . S CC=PRCY_" "
|
---|
146 | . . S CC=$E(CC,1,10)
|
---|
147 | . . K MSG
|
---|
148 | . . S MSG(1)=" "
|
---|
149 | . . S MSG(2)=AA_BB_CC_PTR
|
---|
150 | . . D MES^XPDUTL(.MSG)
|
---|
151 | . . Q
|
---|
152 | . Q
|
---|
153 | ;
|
---|
154 | FINAL ; Now display the final message. What to do with this report.
|
---|
155 | ;
|
---|
156 | K MSG
|
---|
157 | S MSG(1)=" "
|
---|
158 | S MSG(2)=" "
|
---|
159 | S MSG(3)="This report identified records that have a field(s) that"
|
---|
160 | S MSG(4)="are no longer within the input transform range of"
|
---|
161 | S MSG(5)=".01--999999."
|
---|
162 | S MSG(6)="Please contact appropriate personnel for any corrections."
|
---|
163 | S MSG(7)=" "
|
---|
164 | D MES^XPDUTL(.MSG)
|
---|
165 | ;
|
---|
166 | EXIT K ^TMP("DJM",$J),STA0,STA1
|
---|
167 | Q
|
---|