| 1 | PRCPRSSR ;WISC/RFJ/dh/DWA/DAP-stock status report (option, whse) ;3.13.98
 | 
|---|
| 2 |  ;;5.1;IFCAP;**17,41,98**;Oct 20, 2000;Build 37
 | 
|---|
| 3 |  ;Per VHA Directive 2004-038, this routine should not be modified.
 | 
|---|
| 4 |  ;
 | 
|---|
| 5 |  ;*83 Routine PRCPLO2 associated with PRC*5.1*83 is a modified copy of
 | 
|---|
| 6 |  ;this routine and any changes made to this routine should also be
 | 
|---|
| 7 |  ;considered for that routine as well.
 | 
|---|
| 8 |  ;
 | 
|---|
| 9 |  ;*98 Changed previous displays of "issues" to "usage"
 | 
|---|
| 10 |  ;
 | 
|---|
| 11 |  D ^PRCPUSEL Q:'$D(PRCP("I"))
 | 
|---|
| 12 |  N %,%DT,%H,%I,DATEINAC,DATESTRT,TODAY,X,X1,X2,Y
 | 
|---|
| 13 |  K X S X(1)="The Stock Status Report will print a summary of all usage, receipts, and adjustments with the opening and closing balances by account codes."
 | 
|---|
| 14 |  S X(2)="It will calculate the turnover rate, inactive item percent, long supply percent, and non-issuable percent."
 | 
|---|
| 15 |  D DISPLAY^PRCPUX2(40,79,.X)
 | 
|---|
| 16 |  K X S X(1)="Enter the date (month-year) for the Stock Status Report." D DISPLAY^PRCPUX2(2,40,.X)
 | 
|---|
| 17 |  D NOW^%DTC S TODAY=X,Y=$E(X,1,5)_"00" S %DT(0)=-Y D DD^%DT S %DT="AEP",%DT("B")=Y,%DT("A")="Print Stock Status for MONTH and YEAR: " D ^%DT K %DT I Y<1 Q
 | 
|---|
| 18 |  S DATESTRT=$E(Y,1,5)_"00"
 | 
|---|
| 19 |  K X S X(1)="The inactive item percent is calculated for items which have not had activity (receipts or usage) after a specified cutoff date." D DISPLAY^PRCPUX2(40,79,.X)
 | 
|---|
| 20 |  K X S X(1)="Enter the Inactivity cutoff date." D DISPLAY^PRCPUX2(2,40,.X)
 | 
|---|
| 21 |  S X1=TODAY,X2=-90 D C^%DTC S Y=$E(X,1,5)_"00" D DD^%DT
 | 
|---|
| 22 |  S %DT(0)=-($E(TODAY,1,5)_"00"),%DT="AEP",%DT("B")=Y,%DT("A")="Enter Inactivity Cutoff MONTH and YEAR: " D ^%DT K %DT I Y<1 Q
 | 
|---|
| 23 |  S DATEINAC=$E(Y,1,5)_"00"
 | 
|---|
| 24 |  ;
 | 
|---|
| 25 |  ;*98 Branch to PRCPRSSP if the inventory point being reported is a 
 | 
|---|
| 26 |  ;primary or secondary
 | 
|---|
| 27 |  ;
 | 
|---|
| 28 |  I PRCP("DPTYPE")'="W" D ENT^PRCPRSSP Q
 | 
|---|
| 29 |  ; 
 | 
|---|
| 30 |  N ZTDESC,ZTRTN,ZTSAVE,POP
 | 
|---|
| 31 |  W ! S %ZIS="Q" D ^%ZIS Q:POP  I $D(IO("Q")) D  D ^%ZTLOAD K IO("Q"),ZTSK Q
 | 
|---|
| 32 |  .   S ZTDESC="Stock Status Report",ZTRTN="DQ^PRCPRSSR"
 | 
|---|
| 33 |  .   S ZTSAVE("PRCP*")="",ZTSAVE("DATE*")="",ZTSAVE("ZTREQ")="@"
 | 
|---|
| 34 |  W !!,"<*> please wait <*>"
 | 
|---|
| 35 |  ;
 | 
|---|
| 36 | DQ ;  queue starts here
 | 
|---|
| 37 |  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
 | 
|---|
| 38 |  K OPEN
 | 
|---|
| 39 |  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
 | 
|---|
| 40 |  .   S ACCT=$$ACCT1^PRCPUX1($$FSC^PRCPUX1(ITEMDA))
 | 
|---|
| 41 |  .   S $P(OPEN(ACCT),"^")=$P($G(OPEN(ACCT)),"^")+$P(X,"^",2)+$P(X,"^",3)
 | 
|---|
| 42 |  .   S $P(OPEN(ACCT),"^",2)=$P($G(OPEN(ACCT)),"^",2)+$P(X,"^",8)
 | 
|---|
| 43 |  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
 | 
|---|
| 44 |  .   S DA=0 F  S DA=$O(^PRCP(445.2,"AX",PRCP("I"),DATE,TYPE,DA)) Q:'DA  D
 | 
|---|
| 45 |  .   .   S D=$G(^PRCP(445.2,DA,0)) I '$P(D,"^",5) Q
 | 
|---|
| 46 |  .   .   ;  non-issuable
 | 
|---|
| 47 |  .   .   Q:$P(D,"^",11)="N"  ;count if not flagged as non-issueable
 | 
|---|
| 48 |  .   .   S ACCT=$$ACCT1^PRCPUX1($$FSC^PRCPUX1($P(D,"^",5)))
 | 
|---|
| 49 |  .   .   S TRANSNO=$P(D,"^",19)
 | 
|---|
| 50 |  .   .   S INVVAL=$P(D,"^",7)*$P(D,"^",8) I $P(D,"^",22)'="" S INVVAL=$P(D,"^",22)
 | 
|---|
| 51 |  .   .   ;  set transno temporary for primary and secondary to
 | 
|---|
| 52 |  .   .   ;  indicate type of transaction
 | 
|---|
| 53 |  .   .   I PRCP("DPTYPE")'="W" D
 | 
|---|
| 54 |  .   .   .   I TYPE="R"!(TYPE="C")!(TYPE="E")!(TYPE="U")!(TYPE="S") S TRANSNO="--1" Q  ;usage
 | 
|---|
| 55 |  .   .   .   I TYPE="RC" S TRANSNO=1 Q  ;receipt
 | 
|---|
| 56 |  .   .   .   S TRANSNO="" ;adjustment
 | 
|---|
| 57 |  .   .   ;  other adjustments
 | 
|---|
| 58 |  .   .   I PRCP("DPTYPE")="W",$P(TRANSNO,"-",2)="" S ADJ(ACCT)=$G(ADJ(ACCT))+INVVAL,ADJN(ACCT)=$G(ADJN(ACCT))+1 Q
 | 
|---|
| 59 |  .   .   I TRANSNO="" S ADJ(ACCT)=$G(ADJ(ACCT))+INVVAL,ADJN(ACCT)=$G(ADJN(ACCT))+1
 | 
|---|
| 60 |  .   .   E  D
 | 
|---|
| 61 |  .   .   .   ;  purchase order
 | 
|---|
| 62 |  .   .   .   I $P(TRANSNO,"-",3)="" S REC(ACCT)=$G(REC(ACCT))+INVVAL,RECN(ACCT)=$G(RECN(ACCT))+1 Q
 | 
|---|
| 63 |  .   .   .   ;  usage
 | 
|---|
| 64 |  .   .   .   S ISS(ACCT)=$G(ISS(ACCT))+INVVAL,ISSN(ACCT)=$G(ISSN(ACCT))+1
 | 
|---|
| 65 |  ;
 | 
|---|
| 66 |  ;  calculate inactive, long supply, set non-issuable
 | 
|---|
| 67 |  ;
 | 
|---|
| 68 |  ;*98 Modified long supply range to be 90 days instead of 270 days for 
 | 
|---|
| 69 |  ;warehouse, primary, and secondary reporting
 | 
|---|
| 70 |  ;
 | 
|---|
| 71 |  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
 | 
|---|
| 72 |  S ITEMDA=0 F  S ITEMDA=$O(^PRCP(445,PRCP("I"),1,ITEMDA)) Q:'ITEMDA  S D=$G(^(ITEMDA,0)) I D'="" D
 | 
|---|
| 73 |  .   S ACCT=$$ACCT1^PRCPUX1($$FSC^PRCPUX1(ITEMDA))
 | 
|---|
| 74 |  .   ;  value
 | 
|---|
| 75 |  .   S VALUE(ACCT)=$G(VALUE(ACCT))+$P(D,"^",27)
 | 
|---|
| 76 |  .   S DUEIN(ACCT)=$G(DUEIN(ACCT))+($$GETIN^PRCPUDUE(PRCP("I"),ITEMDA)*$P(D,"^",22))
 | 
|---|
| 77 |  .   S DUEOUT(ACCT)=$G(DUEOUT(ACCT))+($$GETOUT^PRCPUDUE(PRCP("I"),ITEMDA)*$P(D,"^",22))
 | 
|---|
| 78 |  .   ;  non-issuable
 | 
|---|
| 79 |  .   I $P(D,"^",19) S NONISS(ACCT)=$G(NONISS(ACCT))+($J($P(D,"^",19)*$P(D,"^",22),0,2)),NONISSN(ACCT)=$G(NONISSN(ACCT))+1
 | 
|---|
| 80 |  .   ;  inactive
 | 
|---|
| 81 |  .   ;  if reusable, quit
 | 
|---|
| 82 |  .   I $$REUSABLE^PRCPU441(ITEMDA) Q
 | 
|---|
| 83 |  .   S QTY=$P(D,"^",7)+$P(D,"^",19)
 | 
|---|
| 84 |  .   I QTY,'$O(^PRCP(445,PRCP("I"),1,ITEMDA,2,$E(DATEINAC,1,5)-.01)),'$O(^PRCP(445,PRCP("I"),1,ITEMDA,3,DATEINAC)) S INACT(ACCT)=$G(INACT(ACCT))+$P(D,"^",27),INACTN(ACCT)=$G(INACTN(ACCT))+1
 | 
|---|
| 85 |  .   ;  long supply
 | 
|---|
| 86 |  .   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)
 | 
|---|
| 87 |  .   S AVERAGE=$J(TOTAL/TOTDAYS,0,2),TOTAL=$S('AVERAGE&(QTY):9999999,'AVERAGE:0,1:QTY/AVERAGE\1)
 | 
|---|
| 88 |  .   I TOTAL>90 S LONG(ACCT)=$G(LONG(ACCT))+$P(D,"^",27),LONGN(ACCT)=$G(LONGN(ACCT))+1
 | 
|---|
| 89 |  ;
 | 
|---|
| 90 |  ;*98 Routed printing based on Warehouse
 | 
|---|
| 91 |  D PRINT^PRCPRSS0
 | 
|---|
| 92 |  Q
 | 
|---|