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