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