| 1 | RCRJRTR1 ;WISC/RFJ-transaction report (print) ;1 Mar 97
 | 
|---|
| 2 |  ;;4.5;Accounts Receivable;**68**;Mar 20, 1995
 | 
|---|
| 3 |  Q
 | 
|---|
| 4 |  ;
 | 
|---|
| 5 |  ;
 | 
|---|
| 6 | PRINT ;  print the report
 | 
|---|
| 7 |  N %I,DATA,DATEDIS1,DATEDIS2,INTTOTAL,NDB,NDBFLAG,NOW,PAGE,PRINTOTL,RCRJFLAG,RCRJLINE,SCREEN,SIGN,TOTALC,TOTALT,X,Y
 | 
|---|
| 8 |  ;
 | 
|---|
| 9 |  ;  calculate new receivables from bills and store in 43C
 | 
|---|
| 10 |  I $D(TRANTYPE(43)) S NDB("43C",2)=$P($$GETNEW^RCRJRCOL(DATESTRT,DATEEND,0),"^",2)
 | 
|---|
| 11 |  ;
 | 
|---|
| 12 |  S Y=$P(DATESTRT,".") D DD^%DT S DATEDIS1=Y
 | 
|---|
| 13 |  S Y=$P(DATEEND,".") D DD^%DT S DATEDIS2=Y
 | 
|---|
| 14 |  D NOW^%DTC S Y=% D DD^%DT S NOW=Y
 | 
|---|
| 15 |  S PAGE=1,RCRJLINE="",$P(RCRJLINE,"-",81)=""
 | 
|---|
| 16 |  S SCREEN=0 I '$D(ZTQUEUED),IO=IO(0),$E(IOST)="C" S SCREEN=1
 | 
|---|
| 17 |  U IO D H
 | 
|---|
| 18 |  ;
 | 
|---|
| 19 |  S TRANTYPE="" F  S TRANTYPE=$O(^TMP($J,"RCRJRTRA",TRANTYPE)) Q:TRANTYPE=""!($G(RCRJFLAG))  D
 | 
|---|
| 20 |  .   I $Y>(IOSL-6) D:SCREEN PAUSE Q:$G(RCRJFLAG)  D H
 | 
|---|
| 21 |  .   S TYPE=$TR(TRANTYPE," ")
 | 
|---|
| 22 |  .   W !!,"TRANSACTION TYPE: ",TYPE,"  ",$P($G(^PRCA(430.3,+TYPE,0)),"^")
 | 
|---|
| 23 |  .   I TYPE="12A" W "  [ADDED]"
 | 
|---|
| 24 |  .   I TYPE="12E" W "  [EXEMPT]"
 | 
|---|
| 25 |  .   I TYPE="35C" W "  [CONTRACTUAL ADJUSTMENTS]"
 | 
|---|
| 26 |  .   I TYPE="34P" W "  [PRE-PAYMENTS]"
 | 
|---|
| 27 |  .   ;
 | 
|---|
| 28 |  .   K TOTALT
 | 
|---|
| 29 |  .   S CATDA=0 F  S CATDA=$O(^TMP($J,"RCRJRTRA",TRANTYPE,CATDA)) Q:'CATDA!($G(RCRJFLAG))  D
 | 
|---|
| 30 |  .   .   I $Y>(IOSL-6) D:SCREEN PAUSE Q:$G(RCRJFLAG)  D H
 | 
|---|
| 31 |  .   .   W !?5,"CATEGORY: ",$E($S($L(CATDA)=1:" ",1:"")_CATDA_"  "_$P($G(^PRCA(430.2,CATDA,0)),"^"),1,20),?36
 | 
|---|
| 32 |  .   .   ;
 | 
|---|
| 33 |  .   .   K TOTALC
 | 
|---|
| 34 |  .   .   S BILLDA=0 F  S BILLDA=$O(^TMP($J,"RCRJRTRA",TRANTYPE,CATDA,BILLDA)) Q:'BILLDA!($G(RCRJFLAG))  D
 | 
|---|
| 35 |  .   .   .   ;
 | 
|---|
| 36 |  .   .   .   S DA=0 F  S DA=$O(^TMP($J,"RCRJRTRA",TRANTYPE,CATDA,BILLDA,DA)) Q:'DA!($G(RCRJFLAG))  S DATA=^(DA) D
 | 
|---|
| 37 |  .   .   .   .   I $Y>(IOSL-5) D:SCREEN PAUSE Q:$G(RCRJFLAG)  D H
 | 
|---|
| 38 |  .   .   .   .   I RCRJSUMM=2 W !?10,$P($G(^PRCA(430,BILLDA,0)),"^"),?28,$P($G(^PRCA(433,DA,0)),"^"),?36
 | 
|---|
| 39 |  .   .   .   .   F %=1:1:4 D:RCRJSUMM=2 WRITE($P(DATA,"^",%)) I $P(DATA,"^",%)'="" S TOTALC(%)=$G(TOTALC(%))+$P(DATA,"^",%)
 | 
|---|
| 40 |  .   .   I $G(RCRJFLAG) Q
 | 
|---|
| 41 |  .   .   I RCRJSUMM=2 W !?10,$E($TR(RCRJLINE,"-","."),11,80),!?10,"TOTALS FOR CATEGORY ...",?36
 | 
|---|
| 42 |  .   .   F %=1:1:4 D WRITE($G(TOTALC(%))) I $G(TOTALC(%))'="" S TOTALT(%)=$G(TOTALT(%))+TOTALC(%)
 | 
|---|
| 43 |  .   .   I $Y>(IOSL-6) D:SCREEN PAUSE Q:$G(RCRJFLAG)  D H
 | 
|---|
| 44 |  .   ;
 | 
|---|
| 45 |  .   I $G(RCRJFLAG) Q
 | 
|---|
| 46 |  .   W !?5,$E($TR(RCRJLINE,"-","."),6,80),!?5,"TOTALS FOR TRANSACTION TYPE ...",?36
 | 
|---|
| 47 |  .   F %=1:1:4 D WRITE($G(TOTALT(%))) I $G(TOTALT(%))'="" S NDB(TYPE,%)=$G(NDB(TYPE,%))+TOTALT(%)
 | 
|---|
| 48 |  .   I $Y>(IOSL-6) D:SCREEN PAUSE Q:$G(RCRJFLAG)  D H
 | 
|---|
| 49 |  ;
 | 
|---|
| 50 |  I $G(RCRJFLAG) Q
 | 
|---|
| 51 |  ;
 | 
|---|
| 52 |  ;  set ndbflag to change header for ndb totals (see H)
 | 
|---|
| 53 |  S NDBFLAG=1
 | 
|---|
| 54 |  D:SCREEN PAUSE Q:$G(RCRJFLAG)  D H
 | 
|---|
| 55 |  ;
 | 
|---|
| 56 |  ;  print national database totals
 | 
|---|
| 57 |  S PRINTOTL=0,INTTOTAL=0
 | 
|---|
| 58 |  W !!,"NATIONAL DATABASE TOTALS (VALUES FROM THE REPORT) ...",!
 | 
|---|
| 59 |  D NDB(13,43,2)
 | 
|---|
| 60 |  D NDB(13,"43C",2)
 | 
|---|
| 61 |  D NDB(13,43,3)
 | 
|---|
| 62 |  D NDB(13,43,4)
 | 
|---|
| 63 |  D NDB(14,1,2)
 | 
|---|
| 64 |  D NDB(16,35,2)
 | 
|---|
| 65 |  D NDB(18,34,2)
 | 
|---|
| 66 |  D NDB(19,2,2)
 | 
|---|
| 67 |  D NDB(20,"35C",2)
 | 
|---|
| 68 |  D NDB(21,"34P",2)
 | 
|---|
| 69 |  D NDB(22,10,2),NDB(22,10,3),NDB(22,10,4)
 | 
|---|
| 70 |  D NDB(23,11,2),NDB(23,11,3),NDB(23,11,4)
 | 
|---|
| 71 |  D NDB(24,9,2),NDB(24,9,3),NDB(24,9,4)
 | 
|---|
| 72 |  D NDB(25,8,2),NDB(25,8,3),NDB(25,8,4)
 | 
|---|
| 73 |  D NDB(38,34,3),NDB(38,"34P",3),NDB(38,2,3)
 | 
|---|
| 74 |  D NDB(39,34,4),NDB(39,2,4)
 | 
|---|
| 75 |  D NDB(40,"12A",3),NDB(40,13,3)
 | 
|---|
| 76 |  D NDB(41,"12A",4),NDB(41,13,4)
 | 
|---|
| 77 |  D NDB(42,"12E",3),NDB(42,"12E",4),NDB(42,14,3)
 | 
|---|
| 78 |  D NDB(43,41,2)
 | 
|---|
| 79 |  W !,$E(RCRJLINE,1,80),!,"BALANCE GAINS/LOSSES FOR DATE RANGE",?42,"+/-",$J(PRINTOTL,13,2),$J(INTTOTAL,11,2)
 | 
|---|
| 80 |  ;
 | 
|---|
| 81 |  W !!,"  The following formula can be used to balance the values in the national"
 | 
|---|
| 82 |  W !,"  database.  Note: This report must be run for the entire month and all"
 | 
|---|
| 83 |  W !,"  transaction types must be selected.  Also, this will only balance for"
 | 
|---|
| 84 |  W !,"  the months following the installation of this patch."
 | 
|---|
| 85 |  W !,"                                                           Principal     Int/Adm",!
 | 
|---|
| 86 |  W !,"Previous months receivables from NDB (category 1)    + __________.__  _______.__"
 | 
|---|
| 87 |  W !,"Current months gains/losses from this report       +/-",$J(PRINTOTL,14,2),$J(INTTOTAL,12,2)
 | 
|---|
| 88 |  W !,$E(RCRJLINE,1,80)
 | 
|---|
| 89 |  W !,"Current months receivables from NDB (category 1)     = __________.__  _______.__"
 | 
|---|
| 90 |  ;
 | 
|---|
| 91 |  Q
 | 
|---|
| 92 |  ;
 | 
|---|
| 93 |  ;
 | 
|---|
| 94 | NDB(NDBTYPE,TRANTYPE,NODE)      ;  write ndb totals and calc end total
 | 
|---|
| 95 |  I +$G(NDB(TRANTYPE,NODE))=0 Q
 | 
|---|
| 96 |  ;
 | 
|---|
| 97 |  W !,"(",NDBTYPE,") ",$$NDBCATEG(NDBTYPE),?36
 | 
|---|
| 98 |  ;
 | 
|---|
| 99 |  S SIGN="-"
 | 
|---|
| 100 |  I TRANTYPE=1!(TRANTYPE="12A")!(TRANTYPE=13)!(TRANTYPE=43)!(TRANTYPE="43C")!(TRANTYPE=46) S SIGN="+"
 | 
|---|
| 101 |  W $J(SIGN_"  ",11),$J($G(NDB(TRANTYPE,NODE)),$S(NODE=2:11,1:22),2)
 | 
|---|
| 102 |  W ?75,"(",$J(TRANTYPE,3),")"
 | 
|---|
| 103 |  ;
 | 
|---|
| 104 |  I NODE=2 S PRINTOTL=PRINTOTL+$S(SIGN="+":$G(NDB(TRANTYPE,NODE)),1:-$G(NDB(TRANTYPE,NODE)))
 | 
|---|
| 105 |  I NODE=3!(NODE=4) S INTTOTAL=INTTOTAL+$S(SIGN="+":$G(NDB(TRANTYPE,NODE)),1:-$G(NDB(TRANTYPE,NODE)))
 | 
|---|
| 106 |  Q
 | 
|---|
| 107 |  ;
 | 
|---|
| 108 |  ;
 | 
|---|
| 109 | NDBCATEG(NDBTYPE)  ;  return ndb category
 | 
|---|
| 110 |  I NDBTYPE=13 Q "NEW RECEIVABLES"
 | 
|---|
| 111 |  I NDBTYPE=14 Q "TOTAL INCREASE ADJUSTMENTS"
 | 
|---|
| 112 |  I NDBTYPE=16 Q "TOTAL DECREASE ADJUSTMENTS"
 | 
|---|
| 113 |  I NDBTYPE=18 Q "COLLECTIONS - FULL PAYMENT"
 | 
|---|
| 114 |  I NDBTYPE=19 Q "COLLECTIONS - PART PAYMENT"
 | 
|---|
| 115 |  I NDBTYPE=20 Q "COLLECTIONS - CONTRACT ADJ"
 | 
|---|
| 116 |  I NDBTYPE=21 Q "COLLECTIONS - PREPAYMENTS"
 | 
|---|
| 117 |  I NDBTYPE=22 Q "COLLECTIONS - WAIVED IN FULL"
 | 
|---|
| 118 |  I NDBTYPE=23 Q "COLLECTIONS - WAIVED IN PART"
 | 
|---|
| 119 |  I NDBTYPE=24 Q "COLLECTIONS - TERM COMPROMISE"
 | 
|---|
| 120 |  I NDBTYPE=25 Q "COLLECTIONS - TERM FISCAL OFF"
 | 
|---|
| 121 |  I NDBTYPE=38 Q "COLLECTIONS - INTEREST"
 | 
|---|
| 122 |  I NDBTYPE=39 Q "COLLECTIONS - ADMIN"
 | 
|---|
| 123 |  I NDBTYPE=40 Q "INTEREST ADDED"
 | 
|---|
| 124 |  I NDBTYPE=41 Q "ADMINISTRATIVE COST ADDED"
 | 
|---|
| 125 |  I NDBTYPE=42 Q "INTEREST/ADMIN COST EXEMPT"
 | 
|---|
| 126 |  I NDBTYPE=43 Q "REFUNDS"
 | 
|---|
| 127 |  Q "UNKNOWN"
 | 
|---|
| 128 |  ;
 | 
|---|
| 129 |  ;
 | 
|---|
| 130 | WRITE(VALUE)       ;  write value
 | 
|---|
| 131 |  I VALUE="" W $J(VALUE,11) Q
 | 
|---|
| 132 |  W $J(VALUE,11,2)
 | 
|---|
| 133 |  Q
 | 
|---|
| 134 |  ;
 | 
|---|
| 135 |  ;
 | 
|---|
| 136 | PAUSE ;  pause at end of page
 | 
|---|
| 137 |  N X U IO(0) W !,"Press RETURN to continue, '^' to exit:" R X:DTIME S:'$T X="^" S:X["^" RCRJFLAG=1 U IO Q
 | 
|---|
| 138 |  ;
 | 
|---|
| 139 |  ;
 | 
|---|
| 140 | H ;  header
 | 
|---|
| 141 |  S %=NOW_"  PAGE "_PAGE,PAGE=PAGE+1 I PAGE'=2!(SCREEN) W @IOF
 | 
|---|
| 142 |  W $C(13),"AR TRANSACTION LISTING REPORT",?(80-$L(%)),%
 | 
|---|
| 143 |  W !,"  FOR THE DATE RANGE: ",DATEDIS1,"  TO  ",DATEDIS2,?65,$J("TYPE: "_$S(RCRJSUMM=1:"SUMMARY",1:"DETAILED"),15)
 | 
|---|
| 144 |  ;
 | 
|---|
| 145 |  I '$G(NDBFLAG) W !?26,$J("TRANSACTION AMOUNT",21),$J("PRINCIPAL",11),$J("INTEREST",11),$J("ADMIN",11)
 | 
|---|
| 146 |  I $G(NDBFLAG) W !,"NATIONAL DATABASE CATEGORY",?26,$J("ADD (+)/SUB (-)",21),$J("PRINCIPAL",11),$J("INT/ADM",11),$J("TRANSTYPE",11)
 | 
|---|
| 147 |  ;
 | 
|---|
| 148 |  W !,RCRJLINE
 | 
|---|
| 149 |  Q
 | 
|---|