RE: Print Out all accounts and sub accounts

Erik Lundby ( (no email) )
Fri, 21 Feb 1997 14:34:10 -0600

-----Original Message-----
From: Dale E. Reed Jr. [SMTP:daler@iea.com]
Sent: Friday, February 21, 1997 2:30 AM
To: emerald@iea.com
Subject: Re: Print Out all accounts and sub accounts

The new list has a limit of like 10k. Anyone posting 10k to the list,
is
having painful wrists. Its EXPLIVITLY that way to prevent attachments.
Upload the reports to /incoming on the ftp site, and I'll move it to
/emerald/contrib (either mention it in mail or on the list that you put
it up
there). I want to keep this organized so we don't get "can you send
that
again" requests which just clutter the list.

--Dale E. Reed Jr.  (daler@iea.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |    http://www.emerald.iea.com-Emerald Mailing list (emerald@iea.com)

OK, This Works. I uploaded the file to inbound. The formulas seem to work although it would have been easier with if-then logic than the way I did it.

Cost =

{SubAccounts.Active} * ({SubAccounts.DiffCost} * {SubAccounts.Cost}+(1-{SubAccounts.DiffCost}) * ({AccountTypes.Cost} * {Discounts.Percent} * .01 *(1-({AccountTypes.ApplyDiscount}*(1- ({PayPeriods.Percent}*.01))))))

This takes account into effect but tax, right?

I wanted to see gross monthly billables so i didn't include tax.

If anyone see's any glaring mistakes with the report please tell me.

begin 600 WINMAIL.DATM>)\^(@P4`0:0" `$```````!``$``0>0!@`(````Y 0```````#H``$(@ <`M& ```$E032Y-:6-R;W-O9G0@36%I;"Y.;W1E`#$(`0V ! `"`````@`"``$$MD 8`P $```$````0`````P``, (````+``\.``````(!_P\!````30``````M``"!*Q^DOJ,0&9UN`-T!#U0"`````&5M97)A;&1 96UE<F%L9"YI96$N8V]MM`%--5% `96UE<F%L9$!E;65R86QD+FEE82YC;VT`````'@`", $````%````M4TU44 `````>``,P`0```!@```!E;65R86QD0&5M97)A;&0N:65A+F-O;0`#M`!4,`0````,`_@\&````'@`!, $````:````)V5M97)A;&1 96UE<F%L9"YIM96$N8V]M)P````(!"S !````'0```%--5% Z14U%4D%,1$!%345204Q$+DE%M02Y#3TT``````P``.0`````+`$ Z`0```!X`]E\!````& ```&5M97)A;&1 M96UE<F%L9"YI96$N8V]M``(!]U\!````30````````"!*Q^DOJ,0&9UN`-T!M#U0"`````&5M97)A;&1 96UE<F%L9"YI96$N8V]M`%--5% `96UE<F%L9$!EM;65R86QD+FEE82YC;VT``````P#]7P$````#`/]?``````(!]@\!````! ``M``````+I7P$$@ $`+ ```%)%.B!0<FEN="!/=70@86QL(&%C8V]U;G1S(&%NM9"!S=6(@86-C;W5N=',`; \!!8 #``X```#-!P(`%0`.`"(`"@`%`"H!`2" M`P`.````S0<"`!4`#@`A`!X`!0`]`0$)@ $`(0```# T-S$R-CE#,S X0D0PM,3$Y0C8X,# T,#,S,S%&-D$Y`- &`0.0!@`P" ``(0````L``@`!````"P`CM```````#`"8```````L`*0```````P`N```````#`#8``````$ `.0"@YYF7M-B"\`1X`< `!````+ ```%)%.B!0<FEN="!/=70@86QL(&%C8V]U;G1S(&%NM9"!S=6(@86-C;W5N=',``@%Q``$````6`````;P@-I=6G"9Q!8LP$=": ! M,S'VJ0``'@`># $````%````4TU44 `````>`!\,`0```! ```!E<FEK0&QIM;FMU<"YN970``P`&$!;\!R,#``<0,@0``!X`"! !````90```"TM+2TM3U))M1TE.04Q-15-304=%+2TM+2U&4D]-.D1!3$5%4D5%1$I24TU44#I$04Q%4D!)M14%#3TU314Y4.D92241!62Q&14)254%263(Q+#$Y.3<R.C,P04U43SI%3452M04P``````@$)$ $````(!0``! 4``,8'``!,6D9U3P!,+ ,`"@!R8W!G,3(UM=C(`] 'W( *D`^,"`&.": K <V5T," '$X<"@P!0#[9P<G$R$+9F?0J ",@@M.PEO#C ULP* "H%U8P!0"P-C`$'%"V!N#A P,S,+IPJQAPJ$"H0+,&QI,S8!M0%<5T!<!`V!T!9!T$40QJ#8@+1G23P409PN AP= != 'D'-A9V49TQ\7%ACDM%P,+,1CF:2TQC#0T`4 8,#$X, % HPS0'7-B($8#83H,@PIB$*!$!T!E($4NM0P?P">!D($IR'_!;0%--5% Z9!^A<I) ")!A+@6@;5T7%5\>H 9@`C ?!Q[ M:2$`>4(L'K!E8G)U"L!Y"" R,2.@,3DY-RDD0#HS$*%-(>=4;]4?!V4'@'('M0&0A5B'H.'5B:AD1'P<@$#H@QE %$ (P($]U!4 '0/<#( #0!:!U`C $( !PM($#^<R@@*B<?QR*&#06KQ=6M%1H'\!N!]$8,',%0"<00"JA+_%M:05 ;V9MM+_%K'\ 64&L?\!"P;F9Y`B ?P'!O," +@&=Q,8(@=&\S$"^1, (L[Q<4! `7M%!! =C*B"K +@+1F=0,@=P40,"!S,<$"22J115A03$E64$E43%DS06$%0'?GM(X S$A(`978B@2G@`D"M`-!H!X J@2X7%%4+4/QO82! ,U()<#)@`" $(/TSM(2\+@"&A,J("(#-#`8 V<"KP,.!E(Z JPDDG=RH!!& X(" PX3,@%Q0O/2:5M+P6@`C %$!Z@*&7O,. OD 7 .-)I.Y$PX0N _ST@"W #( 6Q.Y4P`S<S,A">M=3)0*< SY05 =7 7%/D_<F4I-A(W<2F!,R$Q8"\Z4#-!! ! X6<`<&EZ52 QM<S,P=Q_ 9 (@)^<%0!L`!4 B8P.10C(0<+\JT$-6-U 7%!KP"W$B.C$^<0I0M->$UH$5 $# @:OIU,"%C"D "0#^1,U8Y)7\7%!G0"N,*@!^?/S A"RG]%Q1?M3W]0CU&?4GL7%#'0L5/C245!!@`Q$'0W@+L)<".@23L0,<%3XGPQT$I2.=!IM2F!.5".@1<\FI#R$5F >L$%1*[55(?]*X2_ !4!4D$JQ0 $$( (0?P7 )> CM<56S,= 5PS6!:$$"0' Z+R]W6W N_2:5+B<6&)(U@"Y5&V56I?\%T$"Q,J(PM`S] )JQ/!1<47$]+(Z O@$515P6P:_\V`T,A.;(@,3O#`Q ?P#,A?PN !N JM<%P0,= O@EF!;=\U@#!A$' FD#,2=V&Q*>'[,U (8&=*,##A98 U@"! ^S3!M'\!B">$F@#!@")$UH/,_83UP9BTS40.@"0`:4/YC-R([I#>"1$!6("! ,."WM2ZL(4# A/4R5%Q5[*!$Z02I%+FS0,I X(%Q]K" J/S!LC$0&D&9K4L=MPVR,M;T0K*#$;8&X_C6]$*6WD;-54>7 'D%]PI6^C;P`$\&T$4 208^,B@6W#+C QM;>!Q(7,>]$%P"U!Y=,9MP'9B;@*N4". =6% `&1U22IV(?XI>I,NS$51`9 QM8"JA*D1_0&$S(0$1&1%G,"G!`9!X]R.@&C%;`#\7&D1$8J(S,+]E`4;0`V $M$01@`C!H=]"_9S #$ M@`F 'D48A:6H2OT:B.P$*0 $`?=)+JTDQ(+<`<#(3M90$G*J(D,&<+8/\I83+ ,- P('P3: ,Z"#)0UQ^P,&!C064]`F5+JQ+!`@")M4 ,`$! ``````P`1$ $````#`( 0_____T `!S! ZL-_-B"\`4 `"#! ZL-_M-B"\`0L``8 (( 8``````, ```````!&``````.%`````````P`"@ @@!@``M````P ```````$8`````$(4````````#``. "" &``````# ````````1@``M``!2A0``' X``!X`!( (( 8``````, ```````!&`````%2%```!````! ``M`#@N, `#``6 "" &``````# ````````1@`````!A0````````L`!H (( 8`M`````, ```````!&``````Z%`````````P`'@ @@!@``````P ```````$8`M````$84````````#``B "" &``````# ````````1@`````8A0```````!X`M"8 (( 8``````, ```````!&`````#:%```!`````0`````````>``J "" &M``````# ````````1@`````WA0```0````$`````````'@`+@ @@!@``````MP ```````$8`````.(4```$````!`````````!X`/0`!````!0```%)%.B `-`````P`--/TW``!S!(4``end