PRCPRTRA ;WISC/RFJ-transaction register report ;07 Sep 91
V ;;5.1;IFCAP;**1,142**;Oct 20, 2000;Build 5
;Per VHA Directive 2004-038, this routine should not be modified.
D ^PRCPUSEL Q:'$G(PRCP("I"))
N %,%H,%I,ALLITEMS,ITEMDA,PRCPDT,PRCPDATE,PRCPDATB,PRCPSUMM,X,Y
;
K X S X(1)="The Transaction Register Report prints all activity for specified items, including the opening and closing balances."
S X(2)="The current month-year balance on file appears under the calculated closing balance if the two values differ."
D DISPLAY^PRCPUX2(40,79,.X)
;
K X S X(1)="Enter the beginning/ending month-year for printing the transaction register. If printing 'ALL' items the beginning/ending dates MUST be the same."
D DISPLAY^PRCPUX2(2,40,.X)
DAT S Y=$E(DT,1,5)_"00" S %DT(0)=-Y
D DD^%DT
DAT1 S %DT="AEP",%DT("B")=Y
S %DT("A")="Print Transaction Register for beginning MONTH and YEAR: "
D ^%DT K %DT I Y<1 Q
S (Y,PRCPDATB)=$E(Y,1,5)
DAT2 S Y=$E(Y,1,5)_"00" D DD^%DT
S %DT="AEP",%DT("B")=Y
S %DT("A")="Print Transaction Register for ending MONTH and YEAR: "
D ^%DT K %DT I Y<1 Q
S (Y,PRCPDATE)=$E(Y,1,5)
I PRCPDATE<PRCPDATB W !," Ending date CANNOT be prior to beginning date" G DAT2
;
SELECT I PRCPDATE=$E(DT,1,5),PRCPDATB=$E(DT,1,5) D I '% Q
. K X S X(1)="You may now select to print only items whose calculated closing balance differs from the current on-hand inventory."
. D DISPLAY^PRCPUX2(2,40,.X)
. S XP="Display only items out of balance"
. S XH="Enter 'YES' to only show those items out of balance, 'NO' to select items."
. S %=$$YN^PRCPUYN(2) I '% Q
. I %=1 S PRCPSUMM=1
;
I $G(PRCPSUMM) S ALLITEMS=1 G DEVICE
;
ITEMS ;return here after printing report
; get selected item list
S HPRCPDT=PRCPDATE,PRCPDATE=""
D ITEMMAST^PRCPURS4(PRCPDATE)
S PRCPDATE=HPRCPDT K HPRCPDT
I '$O(^TMP($J,"PRCPITEMS",0)),'$D(ALLITEMS) Q
I $D(ALLITEMS),(PRCPDATB'=PRCPDATE) W !,"** All Items selection MUST use same begin/end month and year **" K ALLITEMS G DAT
;
DEVICE ; ask device
S %ZIS="Q" D ^%ZIS Q:POP
I $D(IO("Q")) D D ^%ZTLOAD K IO("Q"),ZTSK,^TMP($J,"PRCPITEMS") Q
. S ZTDESC="Transaction Register Report",ZTRTN="DQ^PRCPRTRA"
. S ZTSAVE("PRCP*")="",ZTSAVE("ALLITEMS")="",ZTSAVE("^TMP($J,""PRCPITEMS"",")="",ZTSAVE("ZTREQ")="@"
W !!,"<*> please wait <*>"
;
DQ ;queue comes here
N %,CURRQTY,CURRVAL,D,DATE,DESCR,ITEMDA,ITEMDATA,NSN,OPENQTY,OPENVAL,TOTALQTY,TOTALVAL,TRX,TT,UNIT,X,Y
K ^TMP($J,"PRCPRTRA")
S PRCPDT=PRCPDATB
D1 S ITEMDA=0,TOTALQTY=0,TOTALVAL=0
F S ITEMDA=$O(^PRCP(445.1,PRCP("I"),1,ITEMDA)) Q:'ITEMDA I $D(^(ITEMDA,1,PRCPDT,0))&($D(ALLITEMS)!($D(^TMP($J,"PRCPITEMS",ITEMDA)))) D
. S %=$$GETOPEN^PRCPUBAL(PRCP("I"),ITEMDA,PRCPDT)
. S OPENQTY=$P(%,"^",2)+$P(%,"^",3)
. S OPENVAL=+$P(%,"^",8)
. S NSN=$$NSN^PRCPUX1(ITEMDA) S:NSN="" NSN=" "
. S TOTALQTY=OPENQTY,TOTALVAL=OPENVAL
. S TRX=0
. F S TRX=$O(^PRCP(445.2,"AD",PRCP("I"),ITEMDA,TRX)) Q:'TRX D
. . S D=$G(^PRCP(445.2,TRX,0)),DATE=$P($P(D,"^",17),".")
. . I $E(DATE,1,5)=PRCPDT D
. . . S TT=$P(D,"^",4)
. . . S TT=$S($E(TT,1,2)="RC":"R",$E(TT)="R":"D",1:TT)
. . . S %=$E($P(D,"^",2),2,10) S:$E(%)?1A %=$E(%,2,10)
. . . I PRCP("DPTYPE")="P"&(TT="D"!(TT="C")!(TT="E")) D
. . . . S X=$P($P($G(^PRCP(445,+$P(D,"^",18),0)),"^"),"-",2,99)
. . . . S:X'="" X=$E("to: "_X,1,18)
. . . . S:$P(D,"^",19)="" $P(D,"^",19)=X
. . . I PRCP("DPTYPE")="S",TT="U" D
. . . . S X=$P($G(^PRCP(445.2,TRX,2)),"^",2)
. . . . S:X'="" X=$E("to: "_X,1,18)
. . . . S $P(D,"^",19)=X
. . . I $P(D,"^",22)="",$P(D,"^",23)="" D
. . . . S $P(D,"^",22)=$J($P(D,"^",7)*$S($E(TT,1,2)="R":$P(D,"^",9),1:$P(D,"^",8)),0,2)
. . . . S $P(D,"^",23)=$J($P(D,"^",7)*$P(D,"^",9),0,2)
. . . S $P(D,"^",22)=$J($P(D,"^",22),0,2)
. . . S $P(D,"^",23)=$J($P(D,"^",23),0,2)
. . . ; nonissuable
. . . I $P(D,"^",11)'="" D
. . . . S $P(D,"^",19)=$S($P(D,"^",7)<0:" TO",1:"FROM")
. . . . S $P(D,"^",19)=$P(D,"^",19)_" noniss qty: "
. . . . S $P(D,"^",19)=$P(D,"^",19)_$S($P(D,"^",7)<0:-$P(D,"^",7),1:$P(D,"^",7))
. . . . S $P(D,"^",7)=""
. . . . S $P(D,"^",22,23)="^"
. . . S TOTALQTY=TOTALQTY+$P(D,"^",7),TOTALVAL=TOTALVAL+$P(D,"^",22)
. . . S ^TMP($J,"PRCPRTRA",ITEMDA,PRCPDT,DATE,TRX)=TT_%_"^"_$P(D,"^",19)_"^"_$P(D,"^",6)_"^"_$P(D,"^",22)_"^"_$P(D,"^",23)_"^"_$P(D,"^",7)
. S ITEMDATA=$G(^PRCP(445,PRCP("I"),1,ITEMDA,0))
. S CURRQTY=$P(ITEMDATA,"^",7)+$P(ITEMDATA,"^",19)
. S CURRVAL=$P(ITEMDATA,"^",27)
. I CURRVAL="" S CURRVAL=+$J(CURRQTY*$P(ITEMDATA,"^",22),0,2)
. I $G(PRCPSUMM),CURRQTY=TOTALQTY,CURRVAL=TOTALVAL K ^TMP($J,"PRCPRTRA",ITEMDA,PRCPDT) Q
. S DESCR=$E($$DESCR^PRCPUX1(PRCP("I"),ITEMDA),1,30)
. S UNIT=$$UNIT^PRCPUX1(PRCP("I"),ITEMDA,"/")
. S ^TMP($J,"PRCPRTRA",ITEMDA,PRCPDT)=NSN_"^"_DESCR_"^"_UNIT_"^"_$$GETIN^PRCPUDUE(PRCP("I"),ITEMDA)_"^"_$$GETOUT^PRCPUDUE(PRCP("I"),ITEMDA)_"^"_$P(ITEMDATA,"^",19)_"^"_OPENQTY_"^"_OPENVAL_"^"_TOTALQTY_"^"_TOTALVAL
. I CURRQTY=TOTALQTY,CURRVAL=TOTALVAL Q
. S ^TMP($J,"PRCPRTRA",ITEMDA,PRCPDT,"BAL")=CURRQTY_"^"_CURRVAL
S PRCPDT=PRCPDT+1 S:$E(PRCPDT,4,5)=13 PRCPDT=$E(PRCPDT,1,3)+1_"01"
I PRCPDT'>PRCPDATE G D1
D PRINT^PRCPRTR1
I '$D(ZTQUEUED) W !!!! K PRCPSUMM G ITEMS
Q
--- Routine Detail --- with STRUCTURED ROUTINE LISTING ---[H[J[2J[HPRCPRTRA 5485 printed Dec 13, 2024@02:15:37 Page 2
PRCPRTRA ;WISC/RFJ-transaction register report ;07 Sep 91
V ;;5.1;IFCAP;**1,142**;Oct 20, 2000;Build 5
+1 ;Per VHA Directive 2004-038, this routine should not be modified.
+2 DO ^PRCPUSEL
if '$GET(PRCP("I"))
QUIT
+3 NEW %,%H,%I,ALLITEMS,ITEMDA,PRCPDT,PRCPDATE,PRCPDATB,PRCPSUMM,X,Y
+4 ;
+5 KILL X
SET X(1)="The Transaction Register Report prints all activity for specified items, including the opening and closing balances."
+6 SET X(2)="The current month-year balance on file appears under the calculated closing balance if the two values differ."
+7 DO DISPLAY^PRCPUX2(40,79,.X)
+8 ;
+9 KILL X
SET X(1)="Enter the beginning/ending month-year for printing the transaction register. If printing 'ALL' items the beginning/ending dates MUST be the same."
+10 DO DISPLAY^PRCPUX2(2,40,.X)
DAT SET Y=$EXTRACT(DT,1,5)_"00"
SET %DT(0)=-Y
+1 DO DD^%DT
DAT1 SET %DT="AEP"
SET %DT("B")=Y
+1 SET %DT("A")="Print Transaction Register for beginning MONTH and YEAR: "
+2 DO ^%DT
KILL %DT
IF Y<1
QUIT
+3 SET (Y,PRCPDATB)=$EXTRACT(Y,1,5)
DAT2 SET Y=$EXTRACT(Y,1,5)_"00"
DO DD^%DT
+1 SET %DT="AEP"
SET %DT("B")=Y
+2 SET %DT("A")="Print Transaction Register for ending MONTH and YEAR: "
+3 DO ^%DT
KILL %DT
IF Y<1
QUIT
+4 SET (Y,PRCPDATE)=$EXTRACT(Y,1,5)
+5 IF PRCPDATE<PRCPDATB
WRITE !," Ending date CANNOT be prior to beginning date"
GOTO DAT2
+6 ;
SELECT IF PRCPDATE=$EXTRACT(DT,1,5)
IF PRCPDATB=$EXTRACT(DT,1,5)
Begin DoDot:1
+1 KILL X
SET X(1)="You may now select to print only items whose calculated closing balance differs from the current on-hand inventory."
+2 DO DISPLAY^PRCPUX2(2,40,.X)
+3 SET XP="Display only items out of balance"
+4 SET XH="Enter 'YES' to only show those items out of balance, 'NO' to select items."
+5 SET %=$$YN^PRCPUYN(2)
IF '%
QUIT
+6 IF %=1
SET PRCPSUMM=1
End DoDot:1
IF '%
QUIT
+7 ;
+8 IF $GET(PRCPSUMM)
SET ALLITEMS=1
GOTO DEVICE
+9 ;
ITEMS ;return here after printing report
+1 ; get selected item list
+2 SET HPRCPDT=PRCPDATE
SET PRCPDATE=""
+3 DO ITEMMAST^PRCPURS4(PRCPDATE)
+4 SET PRCPDATE=HPRCPDT
KILL HPRCPDT
+5 IF '$ORDER(^TMP($JOB,"PRCPITEMS",0))
IF '$DATA(ALLITEMS)
QUIT
+6 IF $DATA(ALLITEMS)
IF (PRCPDATB'=PRCPDATE)
WRITE !,"** All Items selection MUST use same begin/end month and year **"
KILL ALLITEMS
GOTO DAT
+7 ;
DEVICE ; ask device
+1 SET %ZIS="Q"
DO ^%ZIS
if POP
QUIT
+2 IF $DATA(IO("Q"))
Begin DoDot:1
+3 SET ZTDESC="Transaction Register Report"
SET ZTRTN="DQ^PRCPRTRA"
+4 SET ZTSAVE("PRCP*")=""
SET ZTSAVE("ALLITEMS")=""
SET ZTSAVE("^TMP($J,""PRCPITEMS"",")=""
SET ZTSAVE("ZTREQ")="@"
End DoDot:1
DO ^%ZTLOAD
KILL IO("Q"),ZTSK,^TMP($JOB,"PRCPITEMS")
QUIT
+5 WRITE !!,"<*> please wait <*>"
+6 ;
DQ ;queue comes here
+1 NEW %,CURRQTY,CURRVAL,D,DATE,DESCR,ITEMDA,ITEMDATA,NSN,OPENQTY,OPENVAL,TOTALQTY,TOTALVAL,TRX,TT,UNIT,X,Y
+2 KILL ^TMP($JOB,"PRCPRTRA")
+3 SET PRCPDT=PRCPDATB
D1 SET ITEMDA=0
SET TOTALQTY=0
SET TOTALVAL=0
+1 FOR
SET ITEMDA=$ORDER(^PRCP(445.1,PRCP("I"),1,ITEMDA))
if 'ITEMDA
QUIT
IF $DATA(^(ITEMDA,1,PRCPDT,0))&($DATA(ALLITEMS)!($DATA(^TMP($JOB,"PRCPITEMS",ITEMDA))))
Begin DoDot:1
+2 SET %=$$GETOPEN^PRCPUBAL(PRCP("I"),ITEMDA,PRCPDT)
+3 SET OPENQTY=$PIECE(%,"^",2)+$PIECE(%,"^",3)
+4 SET OPENVAL=+$PIECE(%,"^",8)
+5 SET NSN=$$NSN^PRCPUX1(ITEMDA)
if NSN=""
SET NSN=" "
+6 SET TOTALQTY=OPENQTY
SET TOTALVAL=OPENVAL
+7 SET TRX=0
+8 FOR
SET TRX=$ORDER(^PRCP(445.2,"AD",PRCP("I"),ITEMDA,TRX))
if 'TRX
QUIT
Begin DoDot:2
+9 SET D=$GET(^PRCP(445.2,TRX,0))
SET DATE=$PIECE($PIECE(D,"^",17),".")
+10 IF $EXTRACT(DATE,1,5)=PRCPDT
Begin DoDot:3
+11 SET TT=$PIECE(D,"^",4)
+12 SET TT=$SELECT($EXTRACT(TT,1,2)="RC":"R",$EXTRACT(TT)="R":"D",1:TT)
+13 SET %=$EXTRACT($PIECE(D,"^",2),2,10)
if $EXTRACT(%)?1A
SET %=$EXTRACT(%,2,10)
+14 IF PRCP("DPTYPE")="P"&(TT="D"!(TT="C")!(TT="E"))
Begin DoDot:4
+15 SET X=$PIECE($PIECE($GET(^PRCP(445,+$PIECE(D,"^",18),0)),"^"),"-",2,99)
+16 if X'=""
SET X=$EXTRACT("to: "_X,1,18)
+17 if $PIECE(D,"^",19)=""
SET $PIECE(D,"^",19)=X
End DoDot:4
+18 IF PRCP("DPTYPE")="S"
IF TT="U"
Begin DoDot:4
+19 SET X=$PIECE($GET(^PRCP(445.2,TRX,2)),"^",2)
+20 if X'=""
SET X=$EXTRACT("to: "_X,1,18)
+21 SET $PIECE(D,"^",19)=X
End DoDot:4
+22 IF $PIECE(D,"^",22)=""
IF $PIECE(D,"^",23)=""
Begin DoDot:4
+23 SET $PIECE(D,"^",22)=$JUSTIFY($PIECE(D,"^",7)*$SELECT($EXTRACT(TT,1,2)="R":$PIECE(D,"^",9),1:$PIECE(D,"^",8)),0,2)
+24 SET $PIECE(D,"^",23)=$JUSTIFY($PIECE(D,"^",7)*$PIECE(D,"^",9),0,2)
End DoDot:4
+25 SET $PIECE(D,"^",22)=$JUSTIFY($PIECE(D,"^",22),0,2)
+26 SET $PIECE(D,"^",23)=$JUSTIFY($PIECE(D,"^",23),0,2)
+27 ; nonissuable
+28 IF $PIECE(D,"^",11)'=""
Begin DoDot:4
+29 SET $PIECE(D,"^",19)=$SELECT($PIECE(D,"^",7)<0:" TO",1:"FROM")
+30 SET $PIECE(D,"^",19)=$PIECE(D,"^",19)_" noniss qty: "
+31 SET $PIECE(D,"^",19)=$PIECE(D,"^",19)_$SELECT($PIECE(D,"^",7)<0:-$PIECE(D,"^",7),1:$PIECE(D,"^",7))
+32 SET $PIECE(D,"^",7)=""
+33 SET $PIECE(D,"^",22,23)="^"
End DoDot:4
+34 SET TOTALQTY=TOTALQTY+$PIECE(D,"^",7)
SET TOTALVAL=TOTALVAL+$PIECE(D,"^",22)
+35 SET ^TMP($JOB,"PRCPRTRA",ITEMDA,PRCPDT,DATE,TRX)=TT_%_"^"_$PIECE(D,"^",19)_"^"_$PIECE(D,"^",6)_"^"_$PIECE(D,"^",22)_"^"_$PIECE(D,"^",23)_"^"_$PIECE(D,"^",7)
End DoDot:3
End DoDot:2
+36 SET ITEMDATA=$GET(^PRCP(445,PRCP("I"),1,ITEMDA,0))
+37 SET CURRQTY=$PIECE(ITEMDATA,"^",7)+$PIECE(ITEMDATA,"^",19)
+38 SET CURRVAL=$PIECE(ITEMDATA,"^",27)
+39 IF CURRVAL=""
SET CURRVAL=+$JUSTIFY(CURRQTY*$PIECE(ITEMDATA,"^",22),0,2)
+40 IF $GET(PRCPSUMM)
IF CURRQTY=TOTALQTY
IF CURRVAL=TOTALVAL
KILL ^TMP($JOB,"PRCPRTRA",ITEMDA,PRCPDT)
QUIT
+41 SET DESCR=$EXTRACT($$DESCR^PRCPUX1(PRCP("I"),ITEMDA),1,30)
+42 SET UNIT=$$UNIT^PRCPUX1(PRCP("I"),ITEMDA,"/")
+43 SET ^TMP($JOB,"PRCPRTRA",ITEMDA,PRCPDT)=NSN_"^"_DESCR_"^"_UNIT_"^"_$$GETIN^PRCPUDUE(PRCP("I"),ITEMDA)_"^"_$$GETOUT^PRCPUDUE(PRCP("I"),ITEMDA)_"^"_$PIECE(ITEMDATA,"^",19)_"^"_OPENQTY_"^"_OPENVAL_"^"_TOTALQTY_"^"_TOTALVAL
+44 IF CURRQTY=TOTALQTY
IF CURRVAL=TOTALVAL
QUIT
+45 SET ^TMP($JOB,"PRCPRTRA",ITEMDA,PRCPDT,"BAL")=CURRQTY_"^"_CURRVAL
End DoDot:1
+46 SET PRCPDT=PRCPDT+1
if $EXTRACT(PRCPDT,4,5)=13
SET PRCPDT=$EXTRACT(PRCPDT,1,3)+1_"01"
+47 IF PRCPDT'>PRCPDATE
GOTO D1
+48 DO PRINT^PRCPRTR1
+49 IF '$DATA(ZTQUEUED)
WRITE !!!!
KILL PRCPSUMM
GOTO ITEMS
+50 QUIT
