| 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
 | 
|---|