Home   Package List   Routine Alphabetical List   Global Alphabetical List   FileMan Files List   FileMan Sub-Files List   Package Component Lists   Package-Namespace Mapping  
Routine: RCYPAY

RCYPAY.m

Go to the documentation of this file.
  1. RCYPAY ;WISC/LDB-Date Sorted Payment report ;18 Aug 97
  1. V ;;4.5;Accounts Receivable;**91**;Mar 20, 1995
  1. N ADM,AMT,BILL,CAT,CNT,DAT,DATE,DATESTRT,DATEEND,DATEX,DATEY,INT,LN,NOW,OUT,PG,POP,PRIN,RECPT,SUM,TN,TN0,TN1,TN3,TOT,TYP,X,Y,Z,ZTDESC,ZTRTN,ZTSAVE,%ZIS
  1. K ^TMP($J,"PAY"),^TMP($J,"CAT")
  1. ;
  1. ; select date range
  1. D DATESEL("PAYMENT POSTED") I '$G(DATEEND) Q
  1. S DATEEND=DATEEND+.99
  1. ;
  1. ; select summary or detail
  1. S DIR(0)="S^S:SUMMARY;D:DETAILED",DIR("A")="Summary or Detailed ",DIR("B")="S",DIR("?")="Detailed will include individual bill amounts."
  1. D ^DIR Q:$D(DIRUT)
  1. K DIR
  1. S SUM=Y
  1. ;
  1. CAT ;select category
  1. K DIC S Y=0
  1. W !,"CATEGORY OF BILL: "_$S('$O(^TMP($J,"CAT",0)):"ALL// ",1:"")
  1. R X:DTIME I '$T!(X="^") Q
  1. I ((X="")!(X="ALL")),'$O(^TMP($J,"CAT",0)) S (CAT,X)="ALL" S ^TMP($J,"CAT",0)="ALL" G QUE
  1. S DIC="^PRCA(430.2,",DIC(0)="QEMZ"
  1. D ^DIC S CAT=+Y
  1. I X["?" W !!,"Enter 'ALL' for all categories or category name.",! G CAT
  1. I CAT'="ALL",(+CAT>0) S ^TMP($J,"CAT",+CAT)="" G CAT
  1. I X="" G QUE
  1. Q:X="^"
  1. G:+CAT<0 CAT
  1. ; select device
  1. QUE W !,"This report requires 132 column display."
  1. W ! S %ZIS="Q" D ^%ZIS Q:POP
  1. I $D(IO("Q")) D D ^%ZTLOAD K IO("Q"),ZTSK Q
  1. . S ZTDESC="Date Sorted Payment Report",ZTRTN="DQ^RCYPAY"
  1. . S (ZTSAVE("DATESTRT"),ZTSAVE("DATEEND"),ZTSAVE("SUM"),ZTSAVE("^TMP($J,"))="",ZTSAVE("ZTREQ")="@"
  1. W !!,"<*> please wait <*>"
  1. DQ D PROC D:SUM="D" DPRNT D:SUM="S" SPRNT
  1. D ^%ZISC K ^TMP($J,"PAY"),^TMP($J,"CAT") Q
  1. ;
  1. PROC ; report (queue) starts here
  1. U IO
  1. F TYP=2,34 S DAT=DATESTRT-.01 F S DAT=$O(^PRCA(433,"AT",TYP,DAT)) Q:'DAT!(DAT>DATEEND) D
  1. .S TN=0 F S TN=$O(^PRCA(433,"AT",TYP,DAT,TN)) Q:'TN D
  1. ..S TN0=$G(^PRCA(433,+TN,0))
  1. ..S TN1=$G(^PRCA(433,+TN,1))
  1. ..S TN3=$G(^PRCA(433,+TN,3))
  1. ..S BILL=$P(TN0,"^",2) Q:'BILL S CAT=$P($G(^PRCA(430,+BILL,0)),"^",2) Q:'CAT
  1. ..I $G(^TMP($J,"CAT",0))'="ALL" Q:'$D(^TMP($J,"CAT",CAT))
  1. ..S RECPT=$P(TN1,"^",3)
  1. ..S DATE=$P(TN1,"^")
  1. ..S AMT=$P(TN1,"^",5),PRIN=+TN3,INT=$P(TN3,"^",2),ADM=$P(TN3,"^",3)
  1. ..S ^TMP($J,"PAY",CAT,BILL,TN)=DATE_"/"_DAT_"^"_RECPT_"^"_AMT_"^"_PRIN_"^"_INT_"^"_ADM
  1. TOT S CAT=0 F S CAT=$O(^TMP($J,"PAY",CAT)) Q:'CAT D
  1. .S ^TMP($J,"PAY",CAT,"TOT")=0
  1. .S BILL=0 F S BILL=$O(^TMP($J,"PAY",CAT,BILL)) Q:'BILL D
  1. ..S TN=0 F S TN=$O(^TMP($J,"PAY",CAT,BILL,TN)) Q:'TN D
  1. ...F Z=2:1:5 S $P(^TMP($J,"PAY",CAT,"TOT"),"^",Z-1)=$P(^TMP($J,"PAY",CAT,BILL,TN),"^",Z+1)+$P(^TMP($J,"PAY",CAT,"TOT"),"^",Z-1)
  1. ...F X=1:1:4 S $P(^TMP($J,"PAY","TOT"),"^",X)=$P($G(^TMP($J,"PAY",CAT,"TOT")),"^",X)+$P($G(^TMP($J,"PAY","TOT")),"^",X)
  1. ;
  1. ;start print
  1. S (OUT,PG)=0
  1. S Y=DATESTRT D DD^%DT S DATEX=Y
  1. S Y=DATEEND D DD^%DT S DATEY=$P(Y,"@")
  1. D NOW^%DTC S Y=% D DD^%DT S NOW=Y
  1. I $E(IOST,1,2)="C" W @IOF
  1. D HDR D:SUM="S" HDR2 D:SUM="D" HDR1
  1. Q
  1. ;
  1. HDR ;header
  1. W:$E(IOST,1,2)="C-" @IOF
  1. S PG=PG+1
  1. W !,"DATE SORTED REPORT"_$S(SUM="D":" Detailed",1:" Summary")
  1. W ?45,NOW,?68,"PAGE ",PG
  1. W !,?20,"FOR DATES: ",DATEX," - ",DATEY
  1. S LN="",$P(LN,"-",IOM)=""
  1. ;W !,LN
  1. Q
  1. ;
  1. HDR1 ;detailed header
  1. W !,"BILL",?13,"POSTED DATE",?25,"PAYMENT DATE",?38,"RECEIPT",?54,"AMOUNT",?69,"PRIN",?83,"INT",?95,"ADM"
  1. W !,LN
  1. Q
  1. ;
  1. HDR2 ;summary header
  1. W !,?26,"AMOUNT",?37,"PRIN",?46,"INT",?57,"ADM"
  1. W !,LN
  1. Q
  1. ;
  1. DPRNT ;print
  1. S ^TMP($J,"PAY","TOT")=0
  1. S (CAT,CNT,CNT(2),OUT)=0 F S CAT=$O(^TMP($J,"PAY",CAT)) Q:'CAT!OUT D W !
  1. .F X=1:1:4 S $P(^TMP($J,"PAY","TOT"),"^",X)=$P($G(^TMP($J,"PAY","TOT")),"^",X)+$P($G(^TMP($J,"PAY",CAT,"TOT")),"^",X)
  1. .W !,"CATEGORY: ",$P($G(^PRCA(430.2,+CAT,0)),"^")
  1. .S (CNT,CNT(1),BILL)=0 F S BILL=$O(^TMP($J,"PAY",CAT,BILL)) Q:BILL=""!OUT D
  1. ..S:BILL'="TOT" CNT=CNT+1
  1. ..I BILL="TOT" D
  1. ...W !,"TOTAL BILLS: ",CNT,?52,$J($P(^TMP($J,"PAY",CAT,"TOT"),"^"),9,2)
  1. ...W ?65,$J($P(^TMP($J,"PAY",CAT,"TOT"),"^",2),9,2),?78,$J($P(^("TOT"),"^",3),8,2),?90,$J($P(^("TOT"),"^",4),8,2)
  1. ...S TOT=^TMP($J,"PAY",CAT,"TOT")
  1. ...W !,"TOTAL PAYMENTS:",?52,$J(CNT(1),9),?65,$J(CNT(1),9),?77,$J(CNT(1),9),?89,$J(CNT(1),9)
  1. ...W !,"SUBMEAN:"
  1. ...W ?52,$S($P(TOT,"^"):$J($P(TOT,"^")/CNT(1),9,2),1:"")
  1. ...W ?65,$S($P(TOT,"^",2):$J($P(TOT,"^",2)/CNT(1),9,2),1:"")
  1. ...W ?77,$S($P(TOT,"^",3):$J($P(TOT,"^",3)/CNT(1),9,2),1:"")
  1. ...W ?89,$S($P(TOT,"^",4):$J($P(TOT,"^",4)/CNT(1),9,2),1:"")
  1. ..S TN=0 F S TN=$O(^TMP($J,"PAY",CAT,BILL,TN)) Q:'TN!OUT D
  1. ...S CNT(1)=CNT(1)+1,CNT(2)=CNT(2)+1
  1. ...S TN0=^TMP($J,"PAY",CAT,BILL,TN)
  1. ...W !,$P($G(^PRCA(430,+BILL,0)),"^")
  1. ...W ?13 S Y=$P($P(TN0,"^"),"/",2) X ^DD("DD") W Y
  1. ...Q:OUT S Y=$P($P(TN0,"^"),"/") X ^DD("DD") W ?26,Y
  1. ...W ?38,$P(TN0,"^",2),?52,$J($P(TN0,"^",3),9,2),?65,$J($P(TN0,"^",4),9,2),?78,$J($P(TN0,"^",5),8,2),?90,$J($P(TN0,"^",6),8,2)
  1. ..Q:OUT I $Y+10>IOSL D
  1. ...N DIR,DIRUT
  1. ...I $E(IOST,1,2)="C-" S DIR(0)="E" D ^DIR S:$D(DIRUT) OUT=1
  1. ...Q:OUT W @IOF D HDR,HDR1
  1. S TOT=^TMP($J,"PAY","TOT")
  1. Q:OUT W !,"TOTAL:",?52,$J($P(TOT,"^"),9,2)
  1. W ?65,$J($P(TOT,"^",2),9,2),?77,$J($P(TOT,"^",3),9,2),?89,$J($P(TOT,"^",4),9,2)
  1. W !,"COUNT",?52,$J(CNT(2),9),?65,$J(CNT(2),9),?77,$J(CNT(2),9),?89,$J(CNT(2),9)
  1. W !,"MEAN"
  1. W ?52,$S($P(TOT,"^"):$J($P(TOT,"^")/CNT(2),9,2),1:"")
  1. W ?65,$S($P(TOT,"^",2):$J($P(TOT,"^",2)/CNT(2),9,2),1:"")
  1. W ?77,$S($P(TOT,"^",3):$J($P(TOT,"^",3)/CNT(2),9,2),1:"")
  1. W ?89,$S($P(TOT,"^",4):$J($P(TOT,"^",4)/CNT(2),9,2),1:"")
  1. W:$O(^TMP($J,"PAY",0))="" !?30,"NONE IN THIS DATE RANGE"
  1. I $E(IOST,1,2)="C-" R !,"PRESS RETURN TO CONTINUE",X:DTIME
  1. D ^%ZISC
  1. K ^TMP($J,"PAY")
  1. Q
  1. ;
  1. ;
  1. ;
  1. DATESEL(DESCR) ; select starting and ending dates in days
  1. ; returns datestrt and dateend
  1. N %,%DT,%H,%I,DEFAULT,X,Y
  1. K DATEEND,DATESTRT
  1. START S Y=$E(DT,1,5)_"01" D DD^%DT S DEFAULT=Y
  1. S %DT("A")="Start with "_$S(DESCR'="":DESCR_" ",1:"")_"Date: ",%DT("B")=DEFAULT,%DT="AEP",%DT(0)=-DT D ^%DT I Y<0 Q
  1. I $E(Y,6,7)="00" S Y=$E(Y,1,5)_"01"
  1. S DATESTRT=Y
  1. S Y=DT D DD^%DT S DEFAULT=Y
  1. S %DT("A")=" End with "_$S(DESCR'="":DESCR_" ",1:"")_"Date: ",%DT("B")=DEFAULT,%DT="AEP",%DT(0)=-DT D ^%DT I Y<0 Q
  1. I $E(Y,6,7)="00" S Y=$E(Y,1,5)_"01"
  1. I Y<DATESTRT W !,"END DATE MUST BE GREATER THAN OR EQUAL TO THE START DATE.",! G START
  1. S DATEEND=Y,Y=DATESTRT D DD^%DT
  1. W !?5,"*** Selected date range from ",Y," to " S Y=DATEEND D DD^%DT W Y," ***"
  1. Q
  1. ;
  1. ;
  1. SPRNT ;Print Summary
  1. S ^TMP($J,"PAY","TOT")=0
  1. S (CAT,CNT(2))=0 F S CAT=$O(^TMP($J,"PAY",CAT)) Q:'CAT!(OUT) D
  1. .I $Y+7>IOSL D
  1. ..I $E(IOST,1,2)="C-" S DIR(0)="E" D ^DIR S:$D(DIRUT) OUT=1
  1. ..Q:OUT W @IOF D HDR,HDR2
  1. .Q:OUT
  1. .W !!,"CATEGORY: ",$P(^PRCA(430.2,+CAT,0),"^")
  1. .W !,"TOTAL BILLS: "
  1. .S (BILL,CNT)=0 F S BILL=$O(^TMP($J,"PAY",CAT,BILL)) Q:'BILL S CNT=CNT+1
  1. .W CNT
  1. .S (CNT(1),BILL,TN)=0 F S BILL=$O(^TMP($J,"PAY",CAT,BILL)) Q:'BILL D
  1. ..S TN=0 F S TN=$O(^TMP($J,"PAY",CAT,BILL,TN)) Q:'TN S CNT(1)=CNT(1)+1,CNT(2)=CNT(2)+1
  1. .S TOT=^TMP($J,"PAY",CAT,"TOT")
  1. .W ?22,$J($P(TOT,"^"),9,2),?33,$J($P(TOT,"^",2),9,2),?43,$J($P(TOT,"^",3),8,2),?54,$J($P(TOT,"^",4),8,2)
  1. .F X=1:1:4 S $P(^TMP($J,"PAY","TOT"),"^",X)=$P(TOT,"^",X)+$P($G(^TMP($J,"PAY","TOT")),"^",X)
  1. .W !,"TOTAL PAYMENTS",?22,$J(CNT(1),9),?33,$J(CNT(1),9),?41,$J(CNT(1),9),?53,$J(CNT(1),9)
  1. .W !,"SUBMEAN",?22,$S($P(TOT,"^"):$J($P(TOT,"^")/CNT(1),9,2),1:"")
  1. .W ?33,$S($P(TOT,"^",2):$J($P(TOT,"^",2)/CNT(1),9,2),1:"")
  1. .W ?42,$S($P(TOT,"^",3):$J($P(TOT,"^",3)/CNT(1),9,2),1:"")
  1. .W ?53,$S($P(TOT,"^",4):$J($P(TOT,"^",4)/CNT(1),9,2),1:"")
  1. S TOT=^TMP($J,"PAY","TOT")
  1. Q:OUT W !!,"TOTAL",?22,$J($P(TOT,"^"),9,2),?33,$J($P(TOT,"^",2),9,2)
  1. W ?42,$J($P(TOT,"^",3),9,2),?53,$J($P(TOT,"^",4),9,2)
  1. W !,"COUNT",?22,$J(CNT(2),9),?33,$J(CNT(2),9),?42,$J(CNT(2),9),?53,$J(CNT(2),9)
  1. W !,"MEAN",?22,$S($P(TOT,"^"):$J($P(TOT,"^")/CNT(2),9,2),1:"")
  1. W ?33,$S($P(TOT,"^",2):$J($P(TOT,"^",2)/CNT(2),9,2),1:"")
  1. W ?42,$S($P(TOT,"^",3):$J($P(TOT,"^",3)/CNT(2),9,2),1:"")
  1. W ?53,$S($P(TOT,"^",4):$J($P(TOT,"^",4)/CNT(2),9,2),1:"")
  1. W:$O(^TMP($J,"PAY",0))="" !?30,"NONE IN THIS DATE RANGE"
  1. I $E(IOST,1,2)="C-" R !,"PRESS RETURN TO CONTINUE",X:DTIME
  1. Q