How to report on Tax Exempt Sales?

Posted by hitmanú™©ÝŠÇ.²È¨žÉ¢rº,¡û\¢ on September 3, 2005, 9:38 pm

Please log in for more thread options

Greetings all --

We have approx. 20% of our customers with resale licenses that we sell to as
tax exempt...looking for a way to report on this daily (total sales volume
that was tax exempt). The only related variable I can find is one of the
receipt variables:

"Customer.TaxExempt
Returns TRUE if this customer is exempt from taxes"

....but don't see how this can be manipulated to generate a report or mine
the data without manually calculating the totals from each tax-exempt
transaction...anybody else doing this, or know a better way to report on it?

Thanx!

-=Rich=-

Posted by Masta T on September 6, 2005, 1:21 pm

Please log in for more thread options

How about like this? See attached custom report.
mt E'

> Greetings all --

> We have approx. 20% of our customers with resale licenses that we sell to

> as

> tax exempt...looking for a way to report on this daily (total sales volume

> that was tax exempt). The only related variable I can find is one of the

> receipt variables:

> "Customer.TaxExempt

> Returns TRUE if this customer is exempt from taxes"

> ...but don't see how this can be manipulated to generate a report or mine

> the data without manually calculating the totals from each tax-exempt

> transaction...anybody else doing this, or know a better way to report on

> it?

> Thanx!

> -=Rich=-

begin 666 Custom - Customer Tax Expt.qrp
M+RM+2T@4F5P;W)T(%-U;6UA<GD@+2TM("O#0H-"D)E9VEN(%)E<&]R=%-U
M(%!A9V5/<FEE;G1A=&EO;B ]('!A9V5O<FEE;G1A=&EO;E!O<G1R86ET#0H@
M("!/=71,:6YE36]D92 ](%1R=64-"B @($=R;W5P<R ](# -"B @($=R;W5P
M;V=O1FEL94YA;64@/2 B37E,;V=O+F)M<"(-"B @(%!R;V-E9'5R94-A;&P@
M/2 B(@T*(" @5&%B;&5S475E<FEE9" ](")&4D]-(%1R86YS86-T:6]N16YT
M<GD@5TE42"A.3TQ/0TLI("!)3DY%4B!*3TE.(%M4<F%N<V%C=&EO;ET@5TE4
M2"A.3TQ/0TLI($].(%1R86YS86-T:6]N16YT<GDN5')A;G-A8W1I;VY.=6UB
M97(@/2!;5')A;G-A8W1I;VY=+E1R86YS86-T:6]N3G5M8F5R($Q%1E0@2D])
M3B!#=7-T;VUE<B!7251(*$Y/3$]#2RD@3TX@6U1R86YS86-T:6]N72Y#=7-T
M;VUE<DE$(#T@0W5S=&]M97(N240B#0H@("!396Q#<FET97)I82 ]("(H0W5S
M=&]M97(N5&%X17AE;7!T/3$I(@T*(" @1W)O=7!">2 ](")#=7-T;VUE<BY!
M8V-O=6YT3G5M8F5R(@T*(" @4V]R=$]R9&5R(#T@(E-A;&5S($1%4T,B#0I%
M;F0@4F5P;W)T4W5M;6%R>0T*#0H-"BO+2TM(%1I=&QE(%)O=W,@+2TM+R-
M(" @1F]N=" ](")!<FEA;"(-"B @($9O;G1";VQD(#T@5')U90T*(" @1F]N
M=%-I>F4@/2 Q-@T*(" @0V]L;W(@/2 B0FQU92(-"D5N9"!4:71L95)O=PT*
M#0I"96=I;B!4:71L95)O=PT*(" @5&5X=" ]("(4F5P;W)T(%1I=&QE/B(-
M"B @($9O;G0@/2 B07)I86PB#0H@("!&;VYT0F]L9" ](%1R=64-"B @($9O
M;G13:7IE(#T@,3(-"B @($-O;&]R(#T@(D)L86-K(@T*16YD(%1I=&QE4F]W
M#0H-"D)E9VEN(%1I=&QE4F]W#0H@("!497AT(#T@(D=E;F5R871E9"!/;B
M4F5P;W)T($1A=&4^(@T*(" @1F]N=" ](")!<FEA;"(-"B @($9O;G1";VQD
M(#T@5')U90T*(" @1F]N=%-I>F4@/2 Q, T*(" @0V]L;W(@/2 B0FQA8VLB
M#0I%;F0@5&ET;&52;W<-"@T*#0HO+RTM+2!&:6QT97)S("TM+2O#0H-"D)E
M9VEN($9I;'1E<@T*(" @1FEE;&1.86UE(#T@(EM4<F%N<V%C=&EO;ETN5&EM
M92(-"B @($9I;'1E<D]P(#T@<F5P;W)T9FEL=&5R;W!"971W965N#0H@("!&
M:6QT97),;TQI;2 ]("(665A<E-T87)T/B(-"B @($9I;'1E<DAI;&EM(#T@
M(CQ4;V1A>3XB#0I%;F0@1FEL=&5R#0H-"@T*+RM+2T@0V]L=6UN<R M+2TO
M+PT*#0I"96=I;B!#;VQU;6X-"B @($9I96QD3F%M92 ](")!8V-O=6YT3G5M
M8F5R(@T*(" @1')I;&Q$;W=N1FEE;&1.86UE(#T@(D-U<W1O;65R+D%C8V]U
M;G1.=6UB97(B#0H@("!$<FEL;$1O=VY297!O<G1.86UE(#T@(B(-"B @(%1I
M=&QE(#T@(D%C8V]U;G0@(R(-"B @(%9"1&%T851Y<&4@/2!V8E-T<FEN9PT*
M(" @1F]R;75L82 ](")-05@H0W5S=&]M97(N06-C;W5N=$YU;6)E<BDB#0H@
M("!#;VQ(:61D96X@/2!&86QS90T*(" @0V]L3F]T1&ES<&QA>6%B;&4@/2!&
M86QS90T*(" @1FEL=&5R1&ES86)L960@/2!&86QS90T*(" @0V]L5VED=&@@
M/2 Q-#@U#0H@("!'<F]U<$UE=&AO9" ](&=R;W5P;65T:&]D3F]N90T*(" @
M0V]L1F]R;6%T(#T@(B(-"D5N9"!#;VQU;6X-"@T*0F5G:6X@0V]L=6UN#0H@
M("!&:65L9$YA;64@/2 B0W5S=&]M97).86UE(@T*(" @1')I;&Q$;W=N1FEE
M;&1.86UE(#T@(B(-"B @($1R:6QL1&]W;E)E<&]R=$YA;64@/2 B(@T*(" @
M5&ET;&4@/2 B3F%M92(-"B @(%9"1&%T851Y<&4@/2!V8E-T<FEN9PT*(" @
M1F]R;75L82 ](")-05@H0W5S=&]M97(N3&%S=$YA;64@*R G+" G("L@0W5S
M=&]M97(N1FER<W1.86UE*2(-"B @($-O;$AI9&1E;B ]($9A;'-E#0H@("!#
M;VQ.;W1$:7-P;&%Y86)L92 ]($9A;'-E#0H@("!&:6QT97)$:7-A8FQE9" ]
M($9A;'-E#0H@("!#;VQ7:61T:" ](#$Y-3 -"B @($=R;W5P365T:&]D(#T@
M9W)O=7!M971H;V1.;VYE#0H@("!#;VQ&;W)M870@/2 B(@T*16YD($-O;'5M
M;@T*#0I"96=I;B!#;VQU;6X-"B @($9I96QD3F%M92 ](")#=7-T;VUE<D-O
M;7!A;GDB#0H@("!$<FEL;$1O=VY&:65L9$YA;64@/2 B(@T*(" @1')I;&Q$
M;W=N4F5P;W)T3F%M92 ]("(B#0H@("!4:71L92 ](")#;VUP86YY(@T*(" @
M5D)$871A5'EP92 ]('9B4W1R:6YG#0H@("!&;W)M=6QA(#T@(DU!6"A#=7-T
M;VUE<BY#;VUP86YY*2(-"B @($-O;$AI9&1E;B ]($9A;'-E#0H@("!#;VQ.
M;W1$:7-P;&%Y86)L92 ]($9A;'-E#0H@("!&:6QT97)$:7-A8FQE9" ]($9A
M;'-E#0H@("!#;VQ7:61T:" ](#$Y-3 -"B @($=R;W5P365T:&]D(#T@9W)O
M=7!M971H;V1.;VYE#0H@("!#;VQ&;W)M870@/2 B(@T*16YD($-O;'5M;@T*
M#0I"96=I;B!#;VQU;6X-"B @($9I96QD3F%M92 ](")1='E3;VQD(@T*(" @
M1')I;&Q$;W=N1FEE;&1.86UE(#T@(B(-"B @($1R:6QL1&]W;E)E<&]R=$YA
M;64@/2 B(@T*(" @5&ET;&4@/2 B471Y(%-O;&0B#0H@("!60D1A=&%4>7!E
M(#T@=F)$;W5B;&4-"B @($9O<FUU;&$@/2 B4U5-*%1R86YS86-T:6]N16YT
M<GDN475A;G1I='DI(@T*(" @0V]L2&ED9&5N(#T@1F%L<V4-"B @($-O;$YO
M=$1I<W!L87EA8FQE(#T@1F%L<V4-"B @($9I;'1E<D1I<V%B;&5D(#T@1F%L
M<V4-"B @($-O;%=I9'1H(#T@,3,Y-0T*(" @1W)O=7!-971H;V0@/2!G<F]U
M<&UE=&AO9%-U;0T*(" @0V]L1F]R;6%T(#T@(B,N(R,B#0I%;F0@0V]L=6UN
M#0H-"D)E9VEN($-O;'5M;@T*(" @1FEE;&1.86UE(#T@(E-A;&5S(@T*(" @
M1')I;&Q$;W=N1FEE;&1.86UE(#T@(B(-"B @($1R:6QL1&]W;E)E<&]R=$YA
M;64@/2 B(@T*(" @5&ET;&4@/2 B4V%L97,B#0H@("!60D1A=&%4>7!E(#T@
M=F)#=7)R96YC>0T*(" @1F]R;75L82 ](")354TH5')A;G-A8W1I;VY%;G1R
M>2Y0<FEC92 J(%1R86YS86-T:6]N16YT<GDN475A;G1I='DI(@T*(" @0V]L
M2&ED9&5N(#T@1F%L<V4-"B @($-O;$YO=$1I<W!L87EA8FQE(#T@1F%L<V4-
M"B @($9I;'1E<D1I<V%B;&5D(#T@1F%L<V4-"B @($-O;%=I9'1H(#T@,38R
M, T*(" @1W)O=7!-971H;V0@/2!G<F]U<&UE=&AO9%-U;0T*(" @0V]L1F]R
M;6%T(#T@(B(-"D5N9"!#;VQU;6X-"@T*0F5G:6X@0V]L=6UN#0H@("!&:65L
M9$YA;64@/2 B4')O9FET(@T*(" @1')I;&Q$;W=N1FEE;&1.86UE(#T@(B(-
M"B @($1R:6QL1&]W;E)E<&]R=$YA;64@/2 B(@T*(" @5&ET;&4@/2 B4')O
M9FET(@T*(" @5D)$871A5'EP92 ]('9B0W5R<F5N8WD-"B @($9O<FUU;&$@
M/2 B4U5-*"A4<F%N<V%C=&EO;D5N=')Y+E!R:6-E("T@5')A;G-A8W1I;VY%
M;G1R>2Y#;W-T*2 J(%1R86YS86-T:6]N16YT<GDN475A;G1I='DI(@T*(" @
M0V]L2&ED9&5N(#T@1F%L<V4-"B @($-O;$YO=$1I<W!L87EA8FQE(#T@1F%L
M<V4-"B @($9I;'1E<D1I<V%B;&5D(#T@1F%L<V4-"B @($-O;%=I9'1H(#T@
M,38R, T*(" @1W)O=7!-971H;V0@/2!G<F]U<&UE=&AO9%-U;0T*(" @0V]L
M1F]R;6%T(#T@(B(-"D5N9"!#;VQU;6X-"@T*0F5G:6X@0V]L=6UN#0H@("!&
M:65L9$YA;64@/2 B6U1R86YS86-T:6]N72Y4:6UE(@T*(" @1')I;&Q$;W=N
M1FEE;&1.86UE(#T@(B(-"B @($1R:6QL1&]W;E)E<&]R=$YA;64@/2 B(@T*
M(" @5&ET;&4@/2 B1&%T92!3;VQD(@T*(" @5D)$871A5'EP92 ]('9B1&%T
M90T*(" @1F]R;75L82 ]("(B#0H@("!#;VQ(:61D96X@/2!4<G5E#0H@("!#
M;VQ.;W1$:7-P;&%Y86)L92 ](%1R=64-"B @($9I;'1E<D1I<V%B;&5D(#T@
M1F%L<V4-"B @($-O;%=I9'1H(#T@,3 S-0T*(" @1W)O=7!-971H;V0@/2!G
M<F]U<&UE=&AO9$YO;F4-"B @($-O;$9O<FUA=" ]("(B#0I%;F0@0V]L=6UN
M#0H-"D)E9VEN($-O;'5M;@T*(" @1FEE;&1.86UE(#T@(E1A>$YU;6)E<B(-
M"B @($1R:6QL1&]W;D9I96QD3F%M92 ]("(B#0H@("!$<FEL;$1O=VY297!O
M=&%4>7!E(#T@=F)3=')I;F<-"B @($9O<FUU;&$@/2 B34%8*$-U<W1O;65R
M+E1A>$YU;6)E<BDB#0H@("!#;VQ(:61D96X@/2!&86QS90T*(" @0V]L3F]T
M1&ES<&QA>6%B;&4@/2!&86QS90T*(" @1FEL=&5R1&ES86)L960@/2!&86QS
M90T*(" @0V]L5VED=&@@/2 Q.34P#0H@("!'<F]U<$UE=&AO9" ](&=R;W5P
M;65T:&]D3F]N90T*(" @0V]L1F]R;6%T(#T@(B(-"D5N9"!#;VQU;6X-"@T*
`
end

Posted by hitmanú™©ÝŠÇ.²È¨žÉ¢rº,¡û\¢ on September 6, 2005, 7:35 pm

Please log in for more thread options

Thanks, but how do I can an attachment here??

R.

"Masta T" wrote:

> How about like this? See attached custom report.

> mt E'

> >

> > Greetings all --

> >

> > We have approx. 20% of our customers with resale licenses that we sell to

> > as

> > tax exempt...looking for a way to report on this daily (total sales volume

> > that was tax exempt). The only related variable I can find is one of the

> > receipt variables:

> >

> > "Customer.TaxExempt

> > Returns TRUE if this customer is exempt from taxes"

> >

> > ...but don't see how this can be manipulated to generate a report or mine

> > the data without manually calculating the totals from each tax-exempt

> > transaction...anybody else doing this, or know a better way to report on

> > it?

> >

> > Thanx!

> >

> > -=Rich=-

Posted by Masta T on September 7, 2005, 10:51 am

Please log in for more thread options

Have your reseller hook you up with the steps to get this in Outlook Express
Newsreader.
mt

> Thanks, but how do I can an attachment here??

> R.

> "Masta T" wrote:

>> How about like this? See attached custom report.

>> mt E'

>> >

>> > Greetings all --

>> >

>> > We have approx. 20% of our customers with resale licenses that we sell

>> > to

>> > as

>> > tax exempt...looking for a way to report on this daily (total sales

>> > volume

>> > that was tax exempt). The only related variable I can find is one of

>> > the

>> > receipt variables:

>> >

>> > "Customer.TaxExempt

>> > Returns TRUE if this customer is exempt from taxes"

>> >

>> > ...but don't see how this can be manipulated to generate a report or

>> > mine

>> > the data without manually calculating the totals from each tax-exempt

>> > transaction...anybody else doing this, or know a better way to report

>> > on

>> > it?

>> >

>> > Thanx!

>> >

>> > -=Rich=-

Posted by hitmanú™©ÝŠÇ.²È¨žÉ¢rº,¡û\¢ on September 7, 2005, 11:15 am

Please log in for more thread options

Thank's MT!

In the meantime, if you'd be so kind as to forward the attachment onto my
personal address (rmuller@pacbell.net) it would be much appreciated!!

Best regards,

Rich

"Masta T" wrote:

> Have your reseller hook you up with the steps to get this in Outlook Express

> Newsreader.

> mt

> > Thanks, but how do I can an attachment here??

> >

> > R.

> >

> > "Masta T" wrote:

> >

> >> How about like this? See attached custom report.

> >> mt E'

> >>

> >> >

> >> > Greetings all --

> >> >

> >> > We have approx. 20% of our customers with resale licenses that we sell

> >> > to

> >> > as

> >> > tax exempt...looking for a way to report on this daily (total sales

> >> > volume

> >> > that was tax exempt). The only related variable I can find is one of

> >> > the

> >> > receipt variables:

> >> >

> >> > "Customer.TaxExempt

> >> > Returns TRUE if this customer is exempt from taxes"

> >> >

> >> > ...but don't see how this can be manipulated to generate a report or

> >> > mine

> >> > the data without manually calculating the totals from each tax-exempt

> >> > transaction...anybody else doing this, or know a better way to report

> >> > on

> >> > it?

> >> >

> >> > Thanx!

> >> >

> >> > -=Rich=-

> >>