[613] | 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
|
---|