| [613] | 1 | PRCPLO2 ;WISC/RFJ/dh/DWA/DAP-stock status report (option, whse) ; 2/23/07 5:00pm
 | 
|---|
 | 2 |  ;;5.1;IFCAP;**83,41,98**;Oct 20, 2000;Build 37
 | 
|---|
 | 3 |  ;Per VHA Directive 2004-038, this routine should not be modified.
 | 
|---|
 | 4 |  ;Copied from routine ^PRCPRSSR and modified for PRC*5.1*83 (CLRS)
 | 
|---|
 | 5 |  ;
 | 
|---|
 | 6 | ENT ;This report will be called from option PRCPLO CLO GIP OPTION with fixed
 | 
|---|
 | 7 |  ;input parameters and run for all stations and active inventory points
 | 
|---|
 | 8 |  ;on a given VistA system.
 | 
|---|
 | 9 |  L +^PRCP(446.7,"STATUS"):3 I $T=0 S PRCPMSG(1)="Error encountered when attempting to run CLO GIP Reports due to other",PRCPMSG(2)="CLRS extracts in progress, please try again later." D MAIL^PRCPLO3 Q
 | 
|---|
 | 10 |  K ^PRCP(446.7)
 | 
|---|
 | 11 |  S ^PRCP(446.7,0)="CLRS REPORT STORAGE^446.7^^"
 | 
|---|
 | 12 |  N CLRSFLAG
 | 
|---|
 | 13 |  S CLRSFLAG="SS" D GETIPT^PRCPLO1
 | 
|---|
 | 14 |  ;*83 This call links the Stock on Hand Report in a series of two
 | 
|---|
 | 15 |  ;consecutive report runs to be executed on the 1st of each month.
 | 
|---|
 | 16 |  L -^PRCP(446.7,"STATUS")
 | 
|---|
 | 17 |  D ENT^PRCPLO
 | 
|---|
 | 18 |  N PRCPMSG S PRCPMSG(1)="CLO GIP Reports completed on "_$$HTE^XLFDT($H) D MAIL^PRCPLO3
 | 
|---|
 | 19 |  Q
 | 
|---|
 | 20 |  ;
 | 
|---|
 | 21 | EN1 ;*83 Call coming in from PRCPLO1 with station number and inventory point
 | 
|---|
 | 22 |  ;
 | 
|---|
 | 23 |  N %,%DT,%H,%I,DATEINAC,DATESTRT,TODAY,X,X1,X2,Y,MNT,INARNG
 | 
|---|
 | 24 |  ;*83 The following was edited to always enter the previous month as the start date
 | 
|---|
 | 25 |  D NOW^%DTC S TODAY=X,Y=$E(X,1,3),MNT=$E(X,4,5)
 | 
|---|
 | 26 |  S MNT=MNT-1
 | 
|---|
 | 27 |  I MNT=0 S MNT=12,Y=Y-1
 | 
|---|
 | 28 |  I $L(MNT)=1 S MNT=0_MNT
 | 
|---|
 | 29 |  S DATESTRT=Y_MNT_"00"
 | 
|---|
 | 30 |  ;
 | 
|---|
 | 31 |  ;*83 The following was edited to always enter a 90 day previous to 
 | 
|---|
 | 32 |  ;current date default inactivity range if no other is indicated via the
 | 
|---|
 | 33 |  ;PRCPLO INACTIVITY RANGE parameter
 | 
|---|
 | 34 |  S INARNG=$$GET^XPAR("SYS","PRCPLO INACTIVITY RANGE",1,"Q")
 | 
|---|
 | 35 |  I INARNG="" S INARNG=90
 | 
|---|
 | 36 |  S X1=TODAY,X2=(INARNG*-1) D C^%DTC S DATEINAC=$E(X,1,5)_"00"
 | 
|---|
 | 37 |  S DT=TODAY
 | 
|---|
 | 38 |  ;
 | 
|---|
 | 39 |  ;*83 Build report with station and inventory point passed in from PRCPLO1 call
 | 
|---|
 | 40 | DQ ;  queue starts here
 | 
|---|
 | 41 |  N ACCT,ADJ,ADJN,AVERAGE,D,DA,DATE,DATELONG,DUEIN,DUEOUT,INACT,INACTN,INVVAL,ISS,ISSN,ITEMDA,LONG,LONGN,NONISS,NONISSN,ONHAND,OPEN,QTY,REC,RECN,TOTAL,TOTDAYS,TRANSNO,TYPE,VALUE
 | 
|---|
 | 42 |  ;*83 Added newing of variables
 | 
|---|
 | 43 |  N STA,INV,TOTOPEN,TOTREC,TOTISS,TOTADJ,TOTCLOS,RECNM,TOTN,DATRN,TOTINA,TOTIS1,TOTAD1,TOTIND,TOTLNG,TOTLND,DAYS,DATRN1,ODITEM,NODE1
 | 
|---|
 | 44 |  ;*98 Modified calculations to separate ODI and Standard Items
 | 
|---|
 | 45 |  K ^TMP($J)
 | 
|---|
 | 46 |  K OPEN
 | 
|---|
 | 47 |  ;
 | 
|---|
 | 48 |  S ITEMDA=0 F  S ITEMDA=$O(^PRCP(445,PRCP("I"),1,ITEMDA)) Q:'ITEMDA  D
 | 
|---|
 | 49 |  .   S NODE1=1
 | 
|---|
 | 50 |  .   S ODITEM=$$ODITEM^PRCPUX2(PRCP("I"),ITEMDA)
 | 
|---|
 | 51 |  .   I ODITEM="Y" S NODE1=2
 | 
|---|
 | 52 |  .   S ACCT=$$ACCT1^PRCPUX1($$FSC^PRCPUX1(ITEMDA))
 | 
|---|
 | 53 |  .   S ^TMP($J,NODE1,"CNT",ACCT)=$G(^TMP($J,NODE1,"CNT",ACCT))+1
 | 
|---|
 | 54 |  ; 
 | 
|---|
 | 55 |  S ITEMDA=0 F  S ITEMDA=$O(^PRCP(445.1,PRCP("I"),1,ITEMDA)) Q:'ITEMDA  S X=$$GETOPEN^PRCPUBAL(PRCP("I"),ITEMDA,$E(DATESTRT,1,5)) I X'="" D
 | 
|---|
 | 56 |  .   S NODE1=1
 | 
|---|
 | 57 |  .   S ODITEM=$$ODITEM^PRCPUX2(PRCP("I"),ITEMDA)
 | 
|---|
 | 58 |  .   I ODITEM="Y" S NODE1=2
 | 
|---|
 | 59 |  .   S ACCT=$$ACCT1^PRCPUX1($$FSC^PRCPUX1(ITEMDA))
 | 
|---|
 | 60 |  .   S $P(^TMP($J,NODE1,"OPEN",ACCT),"^")=$P($G(^TMP($J,NODE1,"OPEN",ACCT)),"^")+$P(X,"^",2)+$P(X,"^",3)
 | 
|---|
 | 61 |  .   S $P(^TMP($J,NODE1,"OPEN",ACCT),"^",2)=$P($G(^TMP($J,NODE1,"OPEN",ACCT)),"^",2)+$P(X,"^",8)
 | 
|---|
 | 62 |  S DATE=DATESTRT F  S DATE=$O(^PRCP(445.2,"AX",PRCP("I"),DATE)) Q:$E(DATE,1,5)'=$E(DATESTRT,1,5)  S TYPE="" F  S TYPE=$O(^PRCP(445.2,"AX",PRCP("I"),DATE,TYPE)) Q:TYPE=""  D
 | 
|---|
 | 63 |  .   S DA=0 F  S DA=$O(^PRCP(445.2,"AX",PRCP("I"),DATE,TYPE,DA)) Q:'DA  D
 | 
|---|
 | 64 |  .   .   S D=$G(^PRCP(445.2,DA,0)) I '$P(D,"^",5) Q
 | 
|---|
 | 65 |  .   .   ;  non-issuable
 | 
|---|
 | 66 |  .   .   Q:$P(D,"^",11)="N"  ;count if not flagged as non-issueable
 | 
|---|
 | 67 |  .   .   S ACCT=$$ACCT1^PRCPUX1($$FSC^PRCPUX1($P(D,"^",5)))
 | 
|---|
 | 68 |  .   .   S TRANSNO=$P(D,"^",19)
 | 
|---|
 | 69 |  .   .   S INVVAL=$P(D,"^",7)*$P(D,"^",8) I $P(D,"^",22)'="" S INVVAL=$P(D,"^",22)
 | 
|---|
 | 70 |  .   .   S NODE1=1
 | 
|---|
 | 71 |  .   .   I $$ODITEM^PRCPUX2(PRCP("I"),$P(D,"^",5))="Y" S NODE1=2
 | 
|---|
 | 72 |  .   .   ;  set transno temporary for primary and secondary to
 | 
|---|
 | 73 |  .   .   ;  indicate type of transaction
 | 
|---|
 | 74 |  .   .   I PRCP("DPTYPE")'="W" D
 | 
|---|
 | 75 |  .   .   .   I TYPE="R"!(TYPE="C")!(TYPE="E")!(TYPE="U")!(TYPE="S") S TRANSNO="--1" Q  ;issue
 | 
|---|
 | 76 |  .   .   .   I TYPE="RC" S TRANSNO=1 Q  ;receipt
 | 
|---|
 | 77 |  .   .   .   S TRANSNO="" ;adjustment
 | 
|---|
 | 78 |  .   .   ;  other adjustments
 | 
|---|
 | 79 |  .   .   I PRCP("DPTYPE")="W",$P(TRANSNO,"-",2)="" S ^TMP($J,NODE1,"ADJ",ACCT)=$G(^TMP($J,NODE1,"ADJ",ACCT))+INVVAL,^TMP($J,NODE1,"ADJN",ACCT)=$G(^TMP($J,NODE1,"ADJN",ACCT))+1 Q
 | 
|---|
 | 80 |  .   .   I TRANSNO="" S ^TMP($J,NODE1,"ADJ",ACCT)=$G(^TMP($J,NODE1,"ADJ",ACCT))+INVVAL,^TMP($J,NODE1,"ADJN",ACCT)=$G(^TMP($J,NODE1,"ADJN",ACCT))+1
 | 
|---|
 | 81 |  .   .   E  D
 | 
|---|
 | 82 |  .   .   .   ;  purchase order
 | 
|---|
 | 83 |  .   .   .   I $P(TRANSNO,"-",3)="" S ^TMP($J,NODE1,"REC",ACCT)=$G(^TMP($J,NODE1,"REC",ACCT))+INVVAL,^TMP($J,NODE1,"RECN",ACCT)=$G(^TMP($J,NODE1,"RECN",ACCT))+1 Q
 | 
|---|
 | 84 |  .   .   .   ;  usage
 | 
|---|
 | 85 |  .   .   .   S ^TMP($J,NODE1,"ISS",ACCT)=$G(^TMP($J,NODE1,"ISS",ACCT))+INVVAL,^TMP($J,NODE1,"ISSN",ACCT)=$G(^TMP($J,NODE1,"ISSN",ACCT))+1
 | 
|---|
 | 86 |  ;  calculate inactive, long supply, set non-issuable
 | 
|---|
 | 87 |  ;*98 modified long supply range to be 90 days instead of 270
 | 
|---|
 | 88 |  S X1=$E(DT,1,5)_"01",X2=-89 D C^%DTC S DATELONG=$E(X,1,5),X1=DT,X2=$E(X,1,5)_"00" D ^%DTC S TOTDAYS=X
 | 
|---|
 | 89 |  S ITEMDA=0 F  S ITEMDA=$O(^PRCP(445,PRCP("I"),1,ITEMDA)) Q:'ITEMDA  S D=$G(^(ITEMDA,0)) I D'="" D
 | 
|---|
 | 90 |  .   S ACCT=$$ACCT1^PRCPUX1($$FSC^PRCPUX1(ITEMDA))
 | 
|---|
 | 91 |  .   ;  value
 | 
|---|
 | 92 |  .   S NODE1=1
 | 
|---|
 | 93 |  .   S ODITEM=$$ODITEM^PRCPUX2(PRCP("I"),ITEMDA)
 | 
|---|
 | 94 |  .   I ODITEM="Y" S NODE1=2
 | 
|---|
 | 95 |  .   S ^TMP($J,NODE1,"VALUE",ACCT)=$G(^TMP($J,NODE1,"VALUE",ACCT))+$P(D,"^",27)
 | 
|---|
 | 96 |  .   S ^TMP($J,NODE1,"DUEIN",ACCT)=$G(^TMP($J,NODE1,"DUEIN",ACCT))+($$GETIN^PRCPUDUE(PRCP("I"),ITEMDA)*$P(D,"^",22))
 | 
|---|
 | 97 |  .   S ^TMP($J,NODE1,"DUEOUT",ACCT)=$G(^TMP($J,NODE1,"DUEOUT",ACCT))+($$GETOUT^PRCPUDUE(PRCP("I"),ITEMDA)*$P(D,"^",22))
 | 
|---|
 | 98 |  .   ;  non-issuable
 | 
|---|
 | 99 |  .   I $P(D,"^",19) S ^TMP($J,NODE1,"NISS",ACCT)=$G(^TMP($J,NODE1,"NISS",ACCT))+($J($P(D,"^",19)*$P(D,"^",22),0,2)),^TMP($J,NODE1,"NISSN",ACCT)=$G(^TMP($J,NODE1,"NISSN",ACCT))+1
 | 
|---|
 | 100 |  .   ;  inactive
 | 
|---|
 | 101 |  .   ;  if reusable, quit
 | 
|---|
 | 102 |  .   I $$REUSABLE^PRCPU441(ITEMDA) Q
 | 
|---|
 | 103 |  .   S QTY=$P(D,"^",7)+$P(D,"^",19)
 | 
|---|
 | 104 |  .   I QTY,'$O(^PRCP(445,PRCP("I"),1,ITEMDA,2,$E(DATEINAC,1,5)-.01)),'$O(^PRCP(445,PRCP("I"),1,ITEMDA,3,DATEINAC)) D
 | 
|---|
 | 105 |  . .  S ^TMP($J,NODE1,"INACT",ACCT)=$G(^TMP($J,NODE1,"INACT",ACCT))+$P(D,"^",27),^TMP($J,NODE1,"INACTN",ACCT)=$G(^TMP($J,NODE1,"INACTN",ACCT))+1
 | 
|---|
 | 106 |  .   ;  long supply
 | 
|---|
 | 107 |  .   S DATE=DATELONG-.01,TOTAL=0 F  S DATE=$O(^PRCP(445,PRCP("I"),1,ITEMDA,2,DATE)) Q:'DATE  S TOTAL=TOTAL+$P($G(^(DATE,0)),"^",2)
 | 
|---|
 | 108 |  .   S AVERAGE=$J(TOTAL/TOTDAYS,0,2),TOTAL=$S('AVERAGE&(QTY):9999999,'AVERAGE:0,1:QTY/AVERAGE\1)
 | 
|---|
 | 109 |  .   I TOTAL>90 S ^TMP($J,NODE1,"LONG",ACCT)=$G(^TMP($J,NODE1,"LONG",ACCT))+$P(D,"^",27),^TMP($J,NODE1,"LONGN",ACCT)=$G(^TMP($J,NODE1,"LONGN",ACCT))+1
 | 
|---|
 | 110 |  ;
 | 
|---|
 | 111 |  ;*98 Create consolidated array of Standard and On-Demand Items
 | 
|---|
 | 112 |  N I,J,PRCPQ1,PRCPQ2,PRCPR1,PRCPR2,PRCPS1,PRCPS2,L,J,K,TEMPDATA
 | 
|---|
 | 113 |  F I=1:1:2 D
 | 
|---|
 | 114 |  .   S PRCPQ1="" F  S PRCPQ1=$O(^TMP($J,I,PRCPQ1)) Q:PRCPQ1=""  D
 | 
|---|
 | 115 |  ..  S PRCPQ2="" F  S PRCPQ2=$O(^TMP($J,I,PRCPQ1,PRCPQ2)) Q:PRCPQ2=""  D
 | 
|---|
 | 116 |  ... S TEMPDATA=^TMP($J,I,PRCPQ1,PRCPQ2)
 | 
|---|
 | 117 |  ... F L=1:1:2 S $P(^TMP($J,3,PRCPQ1,PRCPQ2),"^",L)=$P($G(^TMP($J,3,PRCPQ1,PRCPQ2)),"^",L)+$P(TEMPDATA,"^",L)
 | 
|---|
 | 118 |  ;
 | 
|---|
 | 119 |  F J=1:1:3 D
 | 
|---|
 | 120 |  .   S PRCPR1="" F  S PRCPR1=$O(^TMP($J,3,PRCPR1)) Q:PRCPR1=""  S ^TMP($J,J,PRCPR1,"TOTAL")=0
 | 
|---|
 | 121 |  ;
 | 
|---|
 | 122 |  F K=1:1:3 D
 | 
|---|
 | 123 |  .   S PRCPS1="" F  S PRCPS1=$O(^TMP($J,K,PRCPS1)) Q:PRCPS1=""  D
 | 
|---|
 | 124 |  ..  S PRCPS2="" F  S PRCPS2=$O(^TMP($J,K,PRCPS1,PRCPS2)) Q:+PRCPS2=0  D
 | 
|---|
 | 125 |  ... S ^TMP($J,K,PRCPS1,"TOTAL")=$G(^TMP($J,K,PRCPS1,"TOTAL"))+$G(^TMP($J,K,PRCPS1,PRCPS2))
 | 
|---|
 | 126 |  ;
 | 
|---|
 | 127 |  D ENT^PRCPLO2A
 | 
|---|
 | 128 |  ;
 | 
|---|
 | 129 |  Q
 | 
|---|