Home Page link  

Add-In? Tracking Customer Zip Codes

 

Point-Of-Sale Software - - MS Point Of Sale software discussed here 

get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Add-In? Tracking Customer Zip Codes Kinnard 01-06-2006
Posted by Kinnard on January 6, 2006, 7:27 pm
Please log in for more thread options
I have a customer who wants to track his customer's home zip codes to
determine the demographics of his customer basee. Many large chains do this,
i.e., Home Depot, Best Buy. It would need to be an enforced entry for the
cashier so they would not forget to ask. We would set up a dummy zip code
for any customer who does not want to give zip code. Obviously we would need
reporting capability. Is there an add-in for this or does anyone have a
"work-around" to capture and report on this data? Thanks for your time and
knowledge.


Posted by Jeff on January 6, 2006, 9:52 pm
Please log in for more thread options
Kinnard,

How about prompting/requiring a customer? If you are going to require one,
be ready to have some bogus ones. SO Manager | File | Configuration |
Options tab | POS options | Prompt or Require customer for orders.

As far as reporting, there is a Detailed Sales with Customer Address on
CustomerSource. CS is down right now, but look for it in the SO Modified
reports. You will want to change the format a little, then either Memorize
it or Modify it manually. Get rid of all of the customer address except the
zip code. Drag the zip code to the first column on the left and then
collapse all groups for sales $. I've attached a Top Items with Zip Code
report that I am working on right now.

Can't seem to sort on zip code and $ on opening, but by clicking on the Zip
Code header, it re-sorts by Zip Code and $.

See if it works out.

--
*
I have a customer who wants to track his customer's home zip codes to
determine the demographics of his customer basee. Many large chains do
this,
i.e., Home Depot, Best Buy. It would need to be an enforced entry for the
cashier so they would not forget to ask. We would set up a dummy zip code
for any customer who does not want to give zip code. Obviously we would
need
reporting capability. Is there an add-in for this or does anyone have a
"work-around" to capture and report on this data? Thanks for your time and
knowledge.


begin 666 Custom - Top Items with Zip Code.qrp
M+RM+2T@4F5P;W)T(%-U;6UA<GD@+2TM("O#0H-"D)E9VEN(%)E<&]R=%-U
M<&]R=%1I=&QE(#T@(E1O<"!)=&5M<R!W:71H(%II<"!#;V1E(@T*(" @4&%G
M94]R:65N=&%T:6]N(#T@<&%G96]R:65N=&%T:6]N4&]R=')A:70-"B @($]U
M=$QI;F5-;V1E(#T@5')U90T*(" @1W)O=7!S(#T@, T*(" @1W)O=7!$97-C
M<FEP=&EO;B ]("(B#0H@("!$:7-P;&%Y3&]G;R ](%1R=64-"B @($QO9V]&
M:6QE3F%M92 ](")->4QO9VN8FUP(@T*(" @4')O8V5D=7)E0V%L;" ]("(B
M#0H@("!486)L97-1=65R:65D(#T@/$)%1TE./@T*"4923TT@5')A;G-A8W1I
M;VY%;G1R>2!7251(*$Y/3$]#2RD@($E.3D52($I/24X@6U1R86YS86-T:6]N
M72!7251(*$Y/3$]#2RD@3TX@5')A;G-A8W1I;VY%;G1R>2Y4<F%N<V%C=&EO
M;DYU;6)E<B ](%M4<F%N<V%C=&EO;ETN5')A;G-A8W1I;VY.=6UB97(@#0H)
M3$5&5"!*3TE.($ET96T@5TE42" H3D],3T-+*2!/;B!4<F%N<V%C=&EO;D5N
M=')Y+DET96U)1" ]($ET96TN240-"@E,1494($I/24X@("!$97!A<G1M96YT
M(%=)5$@H3D],3T-+*2!/3B!)=&5M+D1E<&%R=&UE;G1)1" ]($1E<&%R=&UE
M;G0N240@#0H)3$5&5"!*3TE.(" @0V%T96=O<GD@5TE42"A.3TQ/0TLI($].
M($ET96TN0V%T96=O<GE)1" ]($-A=&5G;W)Y+DE$( T*"4Q%1E0@2D])3B @
M($-U<W1O;65R(%=)5$@H3D],3T-+*2!/3B!;5')A;G-A8W1I;VY=+D-U<W1O
M;65R240@/2!#=7-T;VUE<BY)1 T*"3Q%3D0^#0H@("!396Q#<FET97)I82 ]
M("(B#0H@("!'<F]U<$)Y(#T@(DET96TN271E;4QO;VM5<$-O9&4L($1E<&%R
M=&UE;G0N3F%M92P@0V%T96=O<GDN3F%M92(-"B @(%-O<G1/<F1E<B ](")3
M86QE<R!$15-#(@T*16YD(%)E<&]R=%-U;6UA<GD-"@T*#0HO+RTM+2!4:71L
M92!2;W=S("TM+2O#0H-"D)E9VEN(%1I=&QE4F]W#0H@("!497AT(#T@(CQ3
M=&]R92!.86UE/B(-"B @($9O;G0@/2 B07)I86PB#0H@("!&;VYT0F]L9" ]
M(%1R=64-"B @($9O;G13:7IE(#T@,38-"B @($-O;&]R(#T@(D)L=64B#0I%
M<&]R="!4:71L93XB#0H@("!&;VYT(#T@(D%R:6%L(@T*(" @1F]N=$)O;&0@
M/2!4<G5E#0H@("!&;VYT4VEZ92 ](#$R#0H@("!#;VQO<B ](")";&%C:R(-
M"D5N9"!4:71L95)O=PT*#0I"96=I;B!4:71L95)O=PT*(" @5&5X=" ](")'
M96YE<F%T960@3VX@/%)E<&]R="!$871E/B(-"B @($9O;G0@/2 B07)I86PB
M#0H@("!&;VYT0F]L9" ](%1R=64-"B @($9O;G13:7IE(#T@,3 -"B @($-O
M;&]R(#T@(D)L86-K(@T*16YD(%1I=&QE4F]W#0H-"D)E9VEN(%1I=&QE4F]W
M#0H@("!497AT(#T@(JD@,C P-2!#:&5C:R!0;VEN="!3;V9T=V%R92 @06QL
M(')I9VAT<R!R97-E<G9E9"XB#0H@("!&;VYT(#T@(D%R:6%L(@T*(" @1F]N
M=$)O;&0@/2!&86QS90T*(" @1F]N=%-I>F4@/2 X#0H@("!#;VQO<B ](")"
M;&%C:R(-"D5N9"!4:71L95)O=PT*#0HO+RTM+2!&:6QT97)S("TM+2O#0H-
M"D)E9VEN($9I;'1E<@T*(" @1FEE;&1.86UE(#T@(EM4<F%N<V%C=&EO;ETN
M5&EM92(-"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
M(#T@(CQ4;V1A>3XB#0I%;F0@1FEL=&5R#0H-"@T*+RM+2T@0V]L=6UN<R M
M+2TO+PT*#0I"96=I;B!#;VQU;6X-"B @($9I96QD3F%M92 ]("))=&5M3&]O
M:W5P0V]D92(-"B @($1R:6QL1&]W;D9I96QD3F%M92 ]("))=&5M+DET96U,
M;V]K=7!#;V1E(@T*(" @1')I;&Q$;W=N4F5P;W)T3F%M92 ]("(B#0H@("!4
M:71L92 ]("))=&5M($QO;VMU<"!#;V1E(@T*(" @5D)$871A5'EP92 ]('9B
M4W1R:6YG#0H@("!&;W)M=6QA(#T@(DU!6"A)=&5M+DET96U,;V]K=7!#;V1E
M*2(-"B @($-O;$AI9&1E;B ]($9A;'-E#0H@("!#;VQ.;W1$:7-P;&%Y86)L
M92 ]($9A;'-E#0H@("!&:6QT97)$:7-A8FQE9" ]($9A;'-E#0H@("!#;VQ7
M:61T:" ](#(P-34-"B @($=R;W5P365T:&]D(#T@9W)O=7!M971H;V1.;VYE
M#0H@("!#;VQ&;W)M870@/2 B(@T*16YD($-O;'5M;@T*#0I"96=I;B!#;VQU
M;6X-"B @($9I96QD3F%M92 ](")$97!A<G1M96YT+DYA;64B#0H@("!$<FEL
M;$1O=VY&:65L9$YA;64@/2 B1&5P87)T;65N="Y.86UE(@T*(" @1')I;&Q$
M;W=N4F5P;W)T3F%M92 ]("(B#0H@("!4:71L92 ](")$97!A<G1M96YT(@T*
M(" @5D)$871A5'EP92 ]('9B4W1R:6YG#0H@("!&;W)M=6QA(#T@(B(-"B @
M($-O;$AI9&1E;B ]($9A;'-E#0H@("!#;VQ.;W1$:7-P;&%Y86)L92 ]($9A
M;'-E#0H@("!&:6QT97)$:7-A8FQE9" ]($9A;'-E#0H@("!#;VQ7:61T:" ]
M(#(R,#4-"B @($=R;W5P365T:&]D(#T@9W)O=7!M971H;V1.;VYE#0H@("!#
M;VQ&;W)M870@/2 B(@T*(" @0V]L06QI9VYM96YT(#T@9FQE>$%L:6=N3&5F
M=$-E;G1E<@T*16YD($-O;'5M;@T*#0I"96=I;B!#;VQU;6X-"B @($9I96QD
M3F%M92 ](")#871E9V]R>2Y.86UE(@T*(" @1')I;&Q$;W=N1FEE;&1.86UE
M(#T@(D-A=&5G;W)Y+DYA;64B#0H@("!$<FEL;$1O=VY297!O<G1.86UE(#T@
M(B(-"B @(%1I=&QE(#T@(D-A=&5G;W)Y(@T*(" @5D)$871A5'EP92 ]('9B
M4W1R:6YG#0H@("!&;W)M=6QA(#T@(B(-"B @($-O;$AI9&1E;B ]($9A;'-E
M#0H@("!#;VQ.;W1$:7-P;&%Y86)L92 ]($9A;'-E#0H@("!&:6QT97)$:7-A
M8FQE9" ]($9A;'-E#0H@("!#;VQ7:61T:" ](#$U,34-"B @($=R;W5P365T
M:&]D(#T@9W)O=7!M971H;V1.;VYE#0H@("!#;VQ&;W)M870@/2 B(@T*(" @
M0V]L06QI9VYM96YT(#T@9FQE>$%L:6=N3&5F=$-E;G1E<@T*16YD($-O;'5M
M;@T*#0I"96=I;B!#;VQU;6X-"B @($9I96QD3F%M92 ]("))=&5M1&5S8W)I
M<'1I;VXB#0H@("!$<FEL;$1O=VY&:65L9$YA;64@/2 B(@T*(" @1')I;&Q$
M;W=N4F5P;W)T3F%M92 ]("(B#0H@("!4:71L92 ](")$97-C<FEP=&EO;B(-
M"B @(%9"1&%T851Y<&4@/2!V8E-T<FEN9PT*(" @1F]R;75L82 ](")-05@H
M271E;2Y$97-C<FEP=&EO;BDB#0H@("!#;VQ(:61D96X@/2!&86QS90T*(" @
M0V]L3F]T1&ES<&QA>6%B;&4@/2!&86QS90T*(" @1FEL=&5R1&ES86)L960@
M/2!&86QS90T*(" @0V]L5VED=&@@/2 R.#,U#0H@("!'<F]U<$UE=&AO9" ]
M(&=R;W5P;65T:&]D3F]N90T*(" @0V]L1F]R;6%T(#T@(B(-"D5N9"!#;VQU
M;6X-"@T*0F5G:6X@0V]L=6UN#0H@("!&:65L9$YA;64@/2 B471Y4V]L9"(-
M"B @($1R:6QL1&]W;D9I96QD3F%M92 ]("(B#0H@("!$<FEL;$1O=VY297!O
M5'EP92 ]('9B1&]U8FQE#0H@("!&;W)M=6QA(#T@(E-532A4<F%N<V%C=&EO
M;D5N=')Y+E%U86YT:71Y*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:" ](#$W,3 -"B @($=R;W5P365T:&]D(#T@
M9W)O=7!M971H;V13=6T-"B @($-O;$9O<FUA=" ]("(C+B,C(@T*16YD($-O
M;'5M;@T*#0I"96=I;B!#;VQU;6X-"B @($9I96QD3F%M92 ](")386QE<R(-
M"B @($1R:6QL1&]W;D9I96QD3F%M92 ]("(B#0H@("!$<FEL;$1O=VY297!O
M<G1.86UE(#T@(B(-"B @(%1I=&QE(#T@(E-A;&5S(@T*(" @5D)$871A5'EP
M92 ]('9B0W5R<F5N8WD-"B @($9O<FUU;&$@/2 B4U5-*%1R86YS86-T:6]N
M16YT<GDN4')I8V4@*B!4<F%N<V%C=&EO;D5N=')Y+E%U86YT:71Y*2(-"B @
M($-O;$AI9&1E;B ]($9A;'-E#0H@("!#;VQ.;W1$:7-P;&%Y86)L92 ]($9A
M;'-E#0H@("!&:6QT97)$:7-A8FQE9" ]($9A;'-E#0H@("!#;VQ7:61T:" ]
M(#$X,S -"B @($=R;W5P365T:&]D(#T@9W)O=7!M971H;V13=6T-"B @($-O
M;$9O<FUA=" ]("(B#0I%;F0@0V]L=6UN#0H-"D)E9VEN($-O;'5M;@T*(" @
M1FEE;&1.86UE(#T@(E!R;V9I="(-"B @($1R:6QL1&]W;D9I96QD3F%M92 ]
M("(B#0H@("!$<FEL;$1O=VY297!O<G1.86UE(#T@(B(-"B @(%1I=&QE(#T@
M(E!R;V9I="(-"B @(%9"1&%T851Y<&4@/2!V8D-U<G)E;F-Y#0H@("!&;W)M
M=6QA(#T@(E-532@H5')A;G-A8W1I;VY%;G1R>2Y0<FEC92 M(%1R86YS86-T
M:6]N16YT<GDN0V]S="D@*B!4<F%N<V%C=&EO;D5N=')Y+E%U86YT:71Y*2(-
M"B @($-O;$AI9&1E;B ]($9A;'-E#0H@("!#;VQ.;W1$:7-P;&%Y86)L92 ]
M($9A;'-E#0H@("!&:6QT97)$:7-A8FQE9" ]($9A;'-E#0H@("!#;VQ7:61T
M:" ](#$X,34-"B @($=R;W5P365T:&]D(#T@9W)O=7!M971H;V13=6T-"B @
M($-O;$9O<FUA=" ]("(B#0I%;F0@0V]L=6UN#0H-"D)E9VEN($-O;'5M;@T*
M(" @1FEE;&1.86UE(#T@(D-U<W1O;65R6FEP(@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 B6FEP($-O9&4B#0H@("!60D1A=&%4>7!E(#T@=F)3=')I;F<-
M"B @($9O<FUU;&$@/2 B34%8*$-U<W1O;65R+EII<"DB#0H@("!#;VQ(:61D
M96X@/2!&86QS90T*(" @0V]L3F]T1&ES<&QA>6%B;&4@/2!&86QS90T*(" @
M1FEL=&5R1&ES86)L960@/2!&86QS90T*(" @0V]L5VED=&@@/2 Q-38P#0H@
M("!'<F]U<$UE=&AO9" ](&=R;W5P;65T:&]D3F]N90T*(" @0V]L1F]R;6%T
M(#T@(B(-"D5N9"!#;VQU;6X-"@T*0F5G:6X@0V]L=6UN#0H@("!&:65L9$YA
M;64@/2 B6U1R86YS86-T:6]N72Y4:6UE(@T*(" @1')I;&Q$;W=N1FEE;&1.
M86UE(#T@(B(-"B @($1R:6QL1&]W;E)E<&]R=$YA;64@/2 B(@T*(" @5&ET
M;&4@/2 B1&%T92!3;VQD(@T*(" @5D)$871A5'EP92 ]('9B1&%T90T*(" @
M1F]R;75L82 ]("(B#0H@("!#;VQ(:61D96X@/2!4<G5E#0H@("!#;VQ.;W1$
M:7-P;&%Y86)L92 ](%1R=64-"B @($9I;'1E<D1I<V%B;&5D(#T@1F%L<V4-
M"B @($-O;%=I9'1H(#T@,3 S-0T*(" @1W)O=7!-971H;V0@/2!G<F]U<&UE
I=&AO9$YO;F4-"B @($-O;$9O<FUA=" ]("(B#0I%;F0@0V]L=6UN#0H`
`
end


Posted by Matt on January 11, 2006, 2:10 pm
Please log in for more thread options
Hi Jeff,

I'm trying to do something similar with a client. We want to require
customer information before every sale, so we can more accurately focus
marketing emails, etc. I went into Configureation, Options, POS Options, but
there is nothing there to Promt or Require Customer for Order. There is an
option like that in Customer Options, which is already selected.

What I mainly am looking for is that as soon as the cashier logs into POS
(login required for each transaction), the Find Customer window pops up and
the cashier can scan the loyalty card so that each sale is associated to a
customer (or dummy customer if they do not have or do not want loyalty
information). Is this possible?

Thanks,
Matt

"Jeff" wrote:

> Kinnard,
>
> How about prompting/requiring a customer? If you are going to require one,
> be ready to have some bogus ones. SO Manager | File | Configuration |
> Options tab | POS options | Prompt or Require customer for orders.
>
> As far as reporting, there is a Detailed Sales with Customer Address on
> CustomerSource. CS is down right now, but look for it in the SO Modified
> reports. You will want to change the format a little, then either Memorize
> it or Modify it manually. Get rid of all of the customer address except the
> zip code. Drag the zip code to the first column on the left and then
> collapse all groups for sales $. I've attached a Top Items with Zip Code
> report that I am working on right now.
>
> Can't seem to sort on zip code and $ on opening, but by clicking on the Zip
> Code header, it re-sorts by Zip Code and $.
>
> See if it works out.
>
> --
> *
> I have a customer who wants to track his customer's home zip codes to
> determine the demographics of his customer basee. Many large chains do
> this,
> i.e., Home Depot, Best Buy. It would need to be an enforced entry for the
> cashier so they would not forget to ask. We would set up a dummy zip code
> for any customer who does not want to give zip code. Obviously we would
> need
> reporting capability. Is there an add-in for this or does anyone have a
> "work-around" to capture and report on this data? Thanks for your time and
> knowledge

Posted by Jeff on January 11, 2006, 3:46 pm
Please log in for more thread options
Matt,

Sorry, yes, there are in Customer options. My memory is sometimes fading.

There is no need for the Find window to pop-up, just check Require _and_
Prompt for Customer selection in Customer Options and make sure that in
Options | General | the Don't remember list sorts is checked. It will then
always sort by the first column on any list. If this is a problem
elsewhere, leave it unchecked and you _may_ have the click on the Account
Number column header before scanning the card. This is assuming that the
number on the card represents the Account Number, which it should.

Do you already have the cards printed? If not, make sure to have the
Account Number bar code and/or the mag stripe scannable. A bar code will
always work, a mag stripe may have to be specially designed and created or a
second mag stripe reader will be required.

Mag stripes are usually formatted like a credit card is, you _do not_ want
this!! You want a mag stripe to contain only the Account Number and an
enter symbol. If you cannot get your card maker to do this, then you will
need a second mag stripe reader at each register. Before you have hundreds
printed and encoded, test an actual card first!!

My recommendation is to print your cards with the Account Number only as a
bar code, not a mag stripe, and with the numbers also printed on the card.
It will be easier and cheaper.

--
*
Hi Jeff,

I'm trying to do something similar with a client. We want to require
customer information before every sale, so we can more accurately focus
marketing emails, etc. I went into Configureation, Options, POS Options, but
there is nothing there to Promt or Require Customer for Order. There is an
option like that in Customer Options, which is already selected.

What I mainly am looking for is that as soon as the cashier logs into POS
(login required for each transaction), the Find Customer window pops up and
the cashier can scan the loyalty card so that each sale is associated to a
customer (or dummy customer if they do not have or do not want loyalty
information). Is this possible?

Thanks,
Matt

"Jeff" wrote:

> Kinnard,
>
> How about prompting/requiring a customer? If you are going to require
> one,
> be ready to have some bogus ones. SO Manager | File | Configuration |
> Options tab | POS options | Prompt or Require customer for orders.
>
> As far as reporting, there is a Detailed Sales with Customer Address on
> CustomerSource. CS is down right now, but look for it in the SO Modified
> reports. You will want to change the format a little, then either
> Memorize
> it or Modify it manually. Get rid of all of the customer address except
> the
> zip code. Drag the zip code to the first column on the left and then
> collapse all groups for sales $. I've attached a Top Items with Zip Code
> report that I am working on right now.
>
> Can't seem to sort on zip code and $ on opening, but by clicking on the
> Zip
> Code header, it re-sorts by Zip Code and $.
>
> See if it works out.
>
> --
> *
> I have a customer who wants to track his customer's home zip codes to
> determine the demographics of his customer basee. Many large chains do
> this,
> i.e., Home Depot, Best Buy. It would need to be an enforced entry for the
> cashier so they would not forget to ask. We would set up a dummy zip code
> for any customer who does not want to give zip code. Obviously we would
> need
> reporting capability. Is there an add-in for this or does anyone have a
> "work-around" to capture and report on this data? Thanks for your time
> and
> knowledge



Posted by Matt on January 11, 2006, 4:52 pm
Please log in for more thread options
Hi Jeff,

Thanks! Our intention is to make our own loyalty cards with a barcode on the
back. This will save a significant cost in both cards and hardware needed to
read the cards.

Thanks for the help!

Matt

"Jeff" wrote:

> Matt,
>
> Sorry, yes, there are in Customer options. My memory is sometimes fading.
>
> There is no need for the Find window to pop-up, just check Require _and_
> Prompt for Customer selection in Customer Options and make sure that in
> Options | General | the Don't remember list sorts is checked. It will then
> always sort by the first column on any list. If this is a problem
> elsewhere, leave it unchecked and you _may_ have the click on the Account
> Number column header before scanning the card. This is assuming that the
> number on the card represents the Account Number, which it should.
>
> Do you already have the cards printed? If not, make sure to have the
> Account Number bar code and/or the mag stripe scannable. A bar code will
> always work, a mag stripe may have to be specially designed and created or a
> second mag stripe reader will be required.
>
> Mag stripes are usually formatted like a credit card is, you _do not_ want
> this!! You want a mag stripe to contain only the Account Number and an
> enter symbol. If you cannot get your card maker to do this, then you will
> need a second mag stripe reader at each register. Before you have hundreds
> printed and encoded, test an actual card first!!
>
> My recommendation is to print your cards with the Account Number only as a
> bar code, not a mag stripe, and with the numbers also printed on the card.
> It will be easier and cheaper.
>
> --
> *
> Hi Jeff,
>
> I'm trying to do something similar with a client. We want to require
> customer information before every sale, so we can more accurately focus
> marketing emails, etc. I went into Configureation, Options, POS Options, but
> there is nothing there to Promt or Require Customer for Order. There is an
> option like that in Customer Options, which is already selected.
>
> What I mainly am looking for is that as soon as the cashier logs into POS
> (login required for each transaction), the Find Customer window pops up and
> the cashier can scan the loyalty card so that each sale is associated to a
> customer (or dummy customer if they do not have or do not want loyalty
> information). Is this possible?
>
> Thanks,
> Matt
>
> "Jeff" wrote:
>
> > Kinnard,
> >
> > How about prompting/requiring a customer? If you are going to require
> > one,
> > be ready to have some bogus ones. SO Manager | File | Configuration |
> > Options tab | POS options | Prompt or Require customer for orders.
> >
> > As far as reporting, there is a Detailed Sales with Customer Address on
> > CustomerSource. CS is down right now, but look for it in the SO Modified
> > reports. You will want to change the format a little, then either
> > Memorize
> > it or Modify it manually. Get rid of all of the customer address except
> > the
> > zip code. Drag the zip code to the first column on the left and then
> > collapse all groups for sales $. I've attached a Top Items with Zip Code
> > report that I am working on right now.
> >
> > Can't seem to sort on zip code and $ on opening, but by clicking on the
> > Zip
> > Code header, it re-sorts by Zip Code and $.
> >
> > See if it works out.
> >
> > --
> > *
> > I have a customer who wants to track his customer's home zip codes to
> > determine the demographics of his customer basee. Many large chains do
> > this,
> > i.e., Home Depot, Best Buy. It would need to be an enforced entry for the
> > cashier so they would not forget to ask. We would set up a dummy zip code
> > for any customer who does not want to give zip code. Obviously we would
> > need
> > reporting capability. Is there an add-in for this or does anyone have a
> > "work-around" to capture and report on this data? Thanks for your time
> > and
> > knowledge
>
>
>

Similar ThreadsPosted
How do i get the customer account number? VB6 Com addin July 19, 2006, 7:07 am
Tracking customer orders when receiving stock November 7, 2005, 10:06 pm
Need MSPOS custom report - tracking payment method and customer April 17, 2009, 1:28 pm
Post Codes in Customer Feilds December 5, 2006, 9:19 am
RE: Auto generated item lookup codes and customer numbers March 27, 2007, 7:01 pm
RE: Auto generated item lookup codes and customer numbers March 27, 2007, 7:52 pm
Auto generated item lookup codes and customer numbers March 27, 2007, 9:53 pm
How do I use C# to build COM addin? September 13, 2005, 2:41 pm
AddItem addin April 4, 2007, 11:32 am
Addin Hooks May 12, 2009, 10:21 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap