|
Posted by Mary-Pat on February 28, 2006, 1:05 pm
Please log in for more thread options
In order for an item to hit a sales report, it has to either have been sold,
or returned in a given period of time.
I'd like a report for dept. & suppliers of items with on on-hand quantity
>0, and 0 sales for a given period of time. Any suggestions?
|
|
Posted by Jeff on February 28, 2006, 2:46 pm
Please log in for more thread options
Mary-Pat,
See the attached report.
Copy it into the Program FilesMicrosoft Retail...Store Op...sReports
folder. If Manager is open, close it and then re-open it, find the report
in the Custom section, Item Movement with OnHand and Reorder #
--
*
Get Secure! - www.microsoft.com/security
You must be using Outlook Express or some other type of newsgroup reader to
see and download the file attachment. If you are not using a reader, follow
the link below to setup Outlook Express. Click on "Open with newsreader"
under the MS Retail Management System on the right.
http://tinyurl.com/75bgz
**********
In order for an item to hit a sales report, it has to either have been sold,
or returned in a given period of time.
I'd like a report for dept. & suppliers of items with on on-hand quantity
>0, and 0 sales for a given period of time. Any suggestions?
begin 666 Custom - Item Movement Report with On Hand and Reorder Number.qrp
M+RM+2T@4F5P;W)T(%-U;6UA<GD@+2TM("O#0H-"D)E9VEN(%)E<&]R=%-U
M<&]R=%1I=&QE(#T@(DET96T@36]V96UE;G0@4F5P;W)T('=I=&@@3VX@2&%N
M9"!A;F0@4F4M3W)D97(@3G5M8F5R(@T*(" @4&%G94]R:65N=&%T:6]N(#T@
M<&%G96]R:65N=&%T:6]N3&%N9'-C87!E#0H@("!3:&]W1&%T951I;650:6-K
M97(@/2!&86QS90T*(" @3W5T3&EN94UO9&4@/2!4<G5E#0H@("!'<F]U<',@
M/2 P#0H@("!'<F]U<$1E<V-R:7!T:6]N(#T@(B(-"B @($1I<W!L87E,;V=O
M(#T@5')U90T*(" @3&]G;T9I;&5.86UE(#T@(DUY3&]G;RYB;7 B#0H@("!0
M<F]C961U<F5#86QL(#T@(B(-"B @(%!R95%U97)Y,2 ]("))1B!%6$E35%,@
M*%-%3$5#5"!404),15].04U%($923TT@24Y&3U)-051)3TY?4T-(14U!+E9)
M15=3(%=(15)%(%1!0DQ%7TY!344@/2 G5FEE=TET96U-;W9E;65N="<I($12
M3U @5DE%5R!6:65W271E;4UO=F5M96YT(@T*(" @4')E475E<GDR(#T@/$)%
M1TE./@T*(" @#0H@(" @("!#4D5!5$4@5DE%5R!6:65W271E;4UO=F5M96YT
M($%3#0H@(" @("!314Q%0U0@1&5P87)T;65N="Y.86UE(&%S($1E<&%R=&UE
M;G1.86UE+ T*(" @(" @"2 @(" @0V%T96=O<GDN3F%M92!A<R!#871E9V]R
M>4YA;64L#0H@(" @(" )(" @("!3=7!P;&EE<BY3=7!P;&EE<DYA;64@87,@
M4W5P<&QI97).86UE+ T*(" @(" @(" @(" @($ET96TN271E;4QO;VMU<$-O
M9&4@05,@271E;4QO;VMU<$-O9&4L#0H@(" @(" @(" @(" @271E;2Y$97-C
M<FEP=&EO;B!!4R!)=&5M1&5S8W)I<'1I;VXL#0H)(" @("!)=&5M+E%U86YT
M:71Y($%3($]N2&%N9"P-"@D@(" @(%-U<'!L:65R3&ES="Y296]R9&5R3G5M
M8F5R($%3(%)E;W)D97).=6UB97(L#0H@(" @(" @(" @(" @271E;2Y,87-T
M4V]L9"!A<R!,87-T4V]L9"P-"B @(" @(" @(" @("!)=&5M+DQA<W1296-E
M:79E9"!A<R!,87-T4F5C96EV960L#0H@(" @(" @(" @(" @271E;2Y#;W-T
M(&%S($-O<W0L#0H@(" @(" @(" @(" @26YV96YT;W)Y5')A;G-F97),;V<N
M5'EP92!!4R!4>7!E+ T*"2 @(" @(" @(" P(&%S(%%U86YT:71Y4V]L9"P-
M"B @(" @(" @(" @("!)4TY53$P@*$EN=F5N=&]R>51R86YS9F5R3&]G+E%U
M86YT:71Y+" P*2!!4R!1=6%N=&ET>2P-"B @(" @(" @(" @(" P(&%S(%!R
M:6-E4V]L9"P-"B @(" @(" @(" @(" P(&%S($-O<W13;VQD+ T*(" @(" @
M(" @(" @($EN=F5N=&]R>51R86YS9F5R3&]G+D1A=&54<F%N<V9E<G)E9"!!
M4R!$871E5')A;G-F97)R960L#0H@(" @(" @(" @(" @,2!!4R!-;W9E9"P-
M"B @(" @(" @(" @("!#05-%($EN=F5N=&]R>51R86YS9F5R;&]G+E1Y<&4@
M5TA%3B R(%1(14X@26YV96YT;W)Y5')A;G-F97),;V<N4F5F97)E;F-E240@
M14Q312!.54Q,($5.1"!!4R!4<F%N<V%C=&EO;DYU;6)E<@T*(" @(" @(" @
M(" @( T*(" @(" @1E)/32!);G9E;G1O<GE4<F%N<V9E<DQO9R -"B @(" @
M( D)($Q%1E0@2D])3B!)=&5M($].($EN=F5N=&]R>51R86YS9F5R3&]G+DET
M96U)1" ]($ET96TN240-"B @(" @( D)($Q%1E0@2D])3B!$97!A<G1M96YT
M($].($ET96TN1&5P87)T;65N=$E$(#T@1&5P87)T;65N="Y)1 T*(" @(" @
M"0D@3$5&5"!*3TE.($-A=&5G;W)Y($].($ET96TN0V%T96=O<GE)1" ]($-A
M=&5G;W)Y+DE$#0H@(" @(" )"2!,1494($I/24X@4W5P<&QI97(@3TX@271E
M;2Y3=7!P;&EE<DE$(#T@4W5P<&QI97(N240-"@D@(" @(" @("!,1494($I/
M24X@4W5P<&QI97),:7-T($].($ET96TN4W5P<&QI97))1" ](%-U<'!L:65R
M3&ES="Y3=7!P;&EE<DE$($%.1"!)=&5M+DE$(#T@4W5P<&QI97),:7-T+DET
M96U)1 T*#0H@(" @(" @(" @(" @(" -"B @(" @(%5.24].($%,3" @(" @
M(" @(" @#0H-"B @(" @(%-%3$5#5"!$97!A<G1M96YT+DYA;64@87,@1&5P
M87)T;65N=$YA;64L#0H@(" @(" )(" @("!#871E9V]R>2Y.86UE(&%S($-A
M=&5G;W)Y3F%M92P-"B @(" @( D@(" @(%-U<'!L:65R+E-U<'!L:65R3F%M
M92!A<R!3=7!P;&EE<DYA;64L#0H@(" @(" )(" @("!)=&5M+DET96U,;V]K
M=7!#;V1E($%3($ET96U,;V]K=7!#;V1E+ T*(" @(" @(" @(" @($ET96TN
M1&5S8W)I<'1I;VX@05,@271E;41E<V-R:7!T:6]N+ T*( D@(" @($ET96TN
M475A;G1I='D@05,@3VY(86YD+ T*"2 @(" @4W5P<&QI97),:7-T+E)E;W)D
M97).=6UB97(@05,@4F5O<F1E<DYU;6)E<BP-"B @(" @(" @(" @("!)=&5M
M+DQA<W13;VQD($%3($QA<W13;VQD+ T*(" @(" @(" @(" @($ET96TN3&%S
M=%)E8V5I=F5D(&%S($QA<W1296-E:79E9"P-"B @(" @(" @(" @("!)=&5M
M(" @(" @(" @($E33E5,3" H5')A;G-A8W1I;VY%;G1R>2Y1=6%N=&ET>2P@
M,"D@05,@475A;G1I='E3;VQD+ T*(" @(" @(" @(" @(# @87,@475A;G1I
M='E4<F%N<V9E<G)E9"P-"B @(" @(" @(" @("!)4TY53$P@*%1R86YS86-T
M:6]N16YT<GDN4')I8V4L(# I(&%S(%!R:6-E4V]L9"P-"B @(" @(" @(" @
M("!)4TY53$P@*%1R86YS86-T:6]N16YT<GDN0V]S="P@,"D@87,@0V]S=%-O
M;&0L#0H@(" @(" @(" @(" @6U1R86YS86-T:6]N72Y4:6UE($%3($1A=&54
M<F%N<V9E<G)E9"P-"B @(" @(" @(" @("!#05-%(%=(14X@6U1R86YS86-T
M:6]N72Y4:6UE($E3($Y53$P@5$A%3B P($5,4T4@,2!%3D0@05,@36]V960L
M#0H@(" @(" @(" @(" @6U1R86YS86-T:6]N72Y4<F%N<V%C=&EO;DYU;6)E
M<B!!4R!4<F%N<V%C=&EO;DYU;6)E<@T*(" @(" @(" @(" @( T*(" @(" @
M1E)/32 @($ET96T-"B @(" @( D@(" @($Q%1E0@2D])3B!4<F%N<V%C=&EO
M;D5N=')Y($].(%1R86YS86-T:6]N16YT<GDN271E;4E$(#T@271E;2Y)1 T*
M(" @(" @"2 @(" @3$5&5"!*3TE.($1E<&%R=&UE;G0@3TX@271E;2Y$97!A
M3B!)=&5M+D-A=&5G;W)Y240@/2!#871E9V]R>2Y)1 T*(" @(" @(" @(" @
M($Q%1E0@2D])3B!;5')A;G-A8W1I;VY=($].(%1R86YS86-T:6]N16YT<GDN
M5')A;G-A8W1I;VY.=6UB97(@/2!;5')A;G-A8W1I;VY=+E1R86YS86-T:6]N
M3G5M8F5R#0H@(" @(" @(" @(" @3$5&5"!*3TE.(%-U<'!L:65R($].($ET
M96TN4W5P<&QI97))1" ](%-U<'!L:65R+DE$#0H)(" @("!,1494($I/24X@
M4W5P<&QI97),:7-T($].($ET96TN4W5P<&QI97))1" ](%-U<'!L:65R3&ES
M="Y3=7!P;&EE<DE$($%.1"!)=&5M+DE$(#T@4W5P<&QI97),:7-T+DET96U)
M1 T*#0H-"CQ%3D0^#0H@("!486)L97-1=65R:65D(#T@(D923TT@5FEE=TET
M96U-;W9E;65N="!,1494($I/24X@4W5P<&QI97(@3TX@5FEE=TET96U-;W9E
M;65N="Y3=7!P;&EE<DYA;64@/2!3=7!P;&EE<BY3=7!P;&EE<DYA;64B#0H@
M("!396Q#<FET97)I82 ]("(B#0H@("!'<F]U<$)Y(#T@(E9I97=)=&5M36]V
M96UE;G0N271E;4QO;VMU<$-O9&4L(%9I97=)=&5M36]V96UE;G0N3&%S=%-O
M;&0L(%9I97=)=&5M36]V96UE;G0N3&%S=%)E8V5I=F5D+"!6:65W271E;4UO
M=F5M96YT+D-O<W0L4W5P<&QI97(N4W5P<&QI97).86UE+"!6:65W271E;4UO
M=F5M96YT+D1E<&%R=&UE;G1.86UE+"!6:65W271E;4UO=F5M96YT+D-A=&5G
M;W)Y3F%M92P@5FEE=TET96U-;W9E;65N="Y)=&5M1&5S8W)I<'1I;VXL(%9I
M97=)=&5M36]V96UE;G0N4F5O<F1E<DYU;6)E<BP@5FEE=TET96U-;W9E;65N
M="Y/;DAA;F0B#0H@("!3;W)T3W)D97(@/2 B(@T*16YD(%)E<&]R=%-U;6UA
M<GD-"@T*#0HO+RTM+2!4:71L92!2;W=S("TM+2O#0H-"D)E9VEN(%1I=&QE
M4F]W#0H@("!497AT(#T@(CQ3=&]R92!.86UE/B(-"B @($9O;G0@/2 B07)I
M86PB#0H@("!&;VYT0F]L9" ](%1R=64-"B @($9O;G13:7IE(#T@,38-"B @
M($-O;&]R(#T@(D)L=64B#0I%;F0@5&ET;&52;W<-"@T*0F5G:6X@5&ET;&52
M:6%L(@T*(" @1F]N=$)O;&0@/2!4<G5E#0H@("!&;VYT4VEZ92 ](#$R#0H@
M("!#;VQO<B ](")";&%C:R(-"D5N9"!4:71L95)O=PT*#0I"96=I;B!4:71L
M95)O=PT*(" @5&5X=" ](")'96YE<F%T960@3VX@/%)E<&]R="!$871E/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@(JD@,C P-2!#:&5C:R!0
M;VEN="!3;V9T=V%R92!!;&P@<FEG:'1S(')E<V5R=F5D+B(-"B @($9O;G0@
M/2 B07)I86PB#0H@("!&;VYT0F]L9" ]($9A;'-E#0H@("!&;VYT4VEZ92 ]
M(#@-"B @($-O;&]R(#T@(D)L86-K(@T*16YD(%1I=&QE4F]W#0H-"@T*+RM
M+2T@1FEL=&5R<R M+2TO+PT*#0I"96=I;B!&:6QT97(-"B @($9I96QD3F%M
M92 ](")6:65W271E;4UO=F5M96YT+D1A=&54<F%N<V9E<G)E9"(-"B @($9I
M;'1E<D]P(#T@<F5P;W)T9FEL=&5R;W!'<F5A=&5R17%U86P-"B @($9I;'1E
M<DQO3&EM(#T@(CQ-;VYT:%-T87)T/B(-"B @($9I;'1E<DAI;&EM(#T@(CQ4
M;V1A>3XB#0I%;F0@1FEL=&5R#0H-"BO+2TM($-O;'5M;G,@+2TM+R-"@T*
M0F5G:6X@0V]L=6UN#0H@("!&:65L9$YA;64@/2 B5FEE=TET96U-;W9E;65N
M="Y)=&5M3&]O:W5P0V]D92(-"B @($1R:6QL1&]W;D9I96QD3F%M92 ]("))
M=&5M+DET96U,;V]K=7!#;V1E(@T*(" @1')I;&Q$;W=N4F5P;W)T3F%M92 ]
M("(B#0H@("!4:71L92 ]("))=&5M($QO;VMU<"!#;V1E(@T*(" @5D)$871A
M5'EP92 ]('9B4W1R:6YG#0H@("!&;W)M=6QA(#T@(B(-"B @($-O;$AI9&1E
M;B ]($9A;'-E#0H@("!#;VQ.;W1$:7-P;&%Y86)L92 ]($9A;'-E#0H@("!&
M:6QT97)$:7-A8FQE9" ]($9A;'-E#0H@("!#;VQ7:61T:" ](#(Q-C -"B @
M($=R;W5P365T:&]D(#T@9W)O=7!M971H;V1.;VYE#0H@("!#;VQ&;W)M870@
M/2 B(@T*(" @0V]L06QI9VYM96YT(#T@9FQE>$%L:6=N3&5F=$-E;G1E<@T*
M16YD($-O;'5M;@T*#0I"96=I;B!#;VQU;6X-"B @($9I96QD3F%M92 ](")6
M:65W271E;4UO=F5M96YT+D1E<&%R=&UE;G1.86UE(@T*(" @1')I;&Q$;W=N
M1FEE;&1.86UE(#T@(D1E<&%R=&UE;G0N3F%M92(-"B @($1R:6QL1&]W;E)E
M<&]R=$YA;64@/2 B(@T*(" @5&ET;&4@/2 B1&5P87)T;65N="(-"B @(%9"
M1&%T851Y<&4@/2!V8E-T<FEN9PT*(" @1F]R;75L82 ](")6:65W271E;4UO
M=F5M96YT+D1E<&%R=&UE;G1.86UE(@T*(" @0V]L2&ED9&5N(#T@5')U90T*
M(" @0V]L3F]T1&ES<&QA>6%B;&4@/2!&86QS90T*(" @1FEL=&5R1&ES86)L
M960@/2!&86QS90T*(" @0V]L5VED=&@@/2 Q-C P#0H@("!'<F]U<$UE=&AO
M9" ](&=R;W5P;65T:&]D3F]N90T*(" @0V]L1F]R;6%T(#T@(B(-"B @($-O
M;$%L:6=N;65N=" ](&9L97A!;&EG;DQE9G1#96YT97(-"D5N9"!#;VQU;6X-
M"@T*0F5G:6X@0V]L=6UN#0H@("!&:65L9$YA;64@/2 B5FEE=TET96U-;W9E
M;65N="Y#871E9V]R>4YA;64B#0H@("!$<FEL;$1O=VY&:65L9$YA;64@/2 B
M0V%T96=O<GDN3F%M92(-"B @($1R:6QL1&]W;E)E<&]R=$YA;64@/2 B(@T*
M;F<-"B @($9O<FUU;&$@/2 B(@T*(" @0V]L2&ED9&5N(#T@5')U90T*(" @
M0V]L3F]T1&ES<&QA>6%B;&4@/2!&86QS90T*(" @1FEL=&5R1&ES86)L960@
M/2!&86QS90T*(" @0V]L5VED=&@@/2 R,# P#0H@("!'<F]U<$UE=&AO9" ]
M(&=R;W5P;65T:&]D3F]N90T*(" @0V]L1F]R;6%T(#T@(B(-"B @($-O;$%L
M:6=N;65N=" ](&9L97A!;&EG;DQE9G1#96YT97(-"D5N9"!#;VQU;6X-"@T*
M#0I"96=I;B!#;VQU;6X-"B @($9I96QD3F%M92 ](")6:65W271E;4UO=F5M
M96YT+DET96U$97-C<FEP=&EO;B(-"B @($1R:6QL1&]W;D9I96QD3F%M92 ]
M("(B#0H@("!$<FEL;$1O=VY297!O<G1.86UE(#T@(B(-"B @(%1I=&QE(#T@
M(D1E<V-R:7!T:6]N(@T*(" @5D)$871A5'EP92 ]('9B4W1R:6YG#0H@("!&
M;W)M=6QA(#T@(B(-"B @($-O;$AI9&1E;B ]($9A;'-E#0H@("!#;VQ.;W1$
M:7-P;&%Y86)L92 ]($9A;'-E#0H@("!&:6QT97)$:7-A8FQE9" ]($9A;'-E
M#0H@("!#;VQ7:61T:" ](#(U,# -"B @($=R;W5P365T:&]D(#T@9W)O=7!M
M971H;V1.;VYE#0H@("!#;VQ&;W)M870@/2 B(@T*(" @0V]L06QI9VYM96YT
M(#T@9FQE>$%L:6=N3&5F=$-E;G1E<@T*16YD($-O;'5M;@T*#0I"96=I;B!#
M;VQU;6X-"B @($9I96QD3F%M92 ](")6:65W271E;4UO=F5M96YT+D]N2&%N
M9"(-"B @($1R:6QL1&]W;D9I96QD3F%M92 ]("(B#0H@("!$<FEL;$1O=VY2
M97!O<G1.86UE(#T@(B(-"B @(%1I=&QE(#T@(D]N($AA;F0B#0H@("!60D1A
M=&%4>7!E(#T@=F)3=')I;F<-"B @($9O<FUU;&$@/2 B(@T*(" @0V]L2&ED
M9&5N(#T@1F%L<V4-"B @($-O;$YO=$1I<W!L87EA8FQE(#T@1F%L<V4-"B @
M($9I;'1E<D1I<V%B;&5D(#T@1F%L<V4-"B @($-O;%=I9'1H(#T@,3 P, T*
M(" @1W)O=7!-971H;V0@/2!G<F]U<&UE=&AO9$YO;F4-"B @($-O;$9O<FUA
M=" ]("(B#0H@("!#;VQ!;&EG;FUE;G0@/2!F;&5X06QI9VY2:6=H=$-E;G1E
M<@T*16YD($-O;'5M;@T*#0I"96=I;B!#;VQU;6X-"B @($9I96QD3F%M92 ]
M(")1='E3;VQD(@T*(" @1')I;&Q$;W=N1FEE;&1.86UE(#T@(B(-"B @($1R
M:6QL1&]W;E)E<&]R=$YA;64@/2 B(@T*(" @5&ET;&4@/2 B475A;G1I='D@
M4V]L9"(-"B @(%9"1&%T851Y<&4@/2!V8D1O=6)L90T*(" @1F]R;75L82 ]
M(")354TH5FEE=TET96U-;W9E;65N="Y1=6%N=&ET>5-O;&0I(@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@,3(P
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 B4V%L97,B#0H@("!$<FEL;$1O=VY&:65L9$YA;64@/2 B(@T*
M(" @1')I;&Q$;W=N4F5P;W)T3F%M92 ]("(B#0H@("!4:71L92 ](")386QE
M<R(-"B @(%9"1&%T851Y<&4@/2!V8D-U<G)E;F-Y#0H@("!&;W)M=6QA(#T@
M(E-532A6:65W271E;4UO=F5M96YT+E%U86YT:71Y4V]L9" J(%9I97=)=&5M
M36]V96UE;G0N4')I8V53;VQD*2(-"B @($-O;$AI9&1E;B ]($9A;'-E#0H@
M("!#;VQ.;W1$:7-P;&%Y86)L92 ]($9A;'-E#0H@("!&:6QT97)$:7-A8FQE
M9" ]($9A;'-E#0H@("!#;VQ7:61T:" ](#$Q,# -"B @($=R;W5P365T:&]D
M(#T@9W)O=7!M971H;V13=6T-"B @($-O;$9O<FUA=" ]("(B#0I%;F0@0V]L
M=6UN#0H-"D)E9VEN($-O;'5M;@T*(" @1FEE;&1.86UE(#T@(E9I97=)=&5M
M36]V96UE;G0N3&%S=%-O;&0B#0H@("!$<FEL;$1O=VY&:65L9$YA;64@/2 B
M(@T*(" @1')I;&Q$;W=N4F5P;W)T3F%M92 ]("(B#0H@("!4:71L92 ]("),
M87-T(%-O;&0B#0H@("!60D1A=&%4>7!E(#T@=F)$871E#0H@("!&;W)M=6QA
M(#T@(B(-"B @($-O;$AI9&1E;B ]($9A;'-E#0H@("!#;VQ.;W1$:7-P;&%Y
M86)L92 ]($9A;'-E#0H@("!&:6QT97)$:7-A8FQE9" ]($9A;'-E#0H@("!#
M;VQ7:61T:" ](#$Q,# -"B @($=R;W5P365T:&]D(#T@9W)O=7!M971H;V1-
M87@-"B @($-O;$9O<FUA=" ]("(B#0I%;F0@0V]L=6UN#0H-"D)E9VEN($-O
M;'5M;@T*(" @1FEE;&1.86UE(#T@(E9I97=)=&5M36]V96UE;G0N0V]S="(-
M"B @($1R:6QL1&]W;D9I96QD3F%M92 ]("(B#0H@("!$<FEL;$1O=VY297!O
M<G1.86UE(#T@(B(-"B @(%1I=&QE(#T@(D-O<W0@16%C:"(-"B @(%9"1&%T
M851Y<&4@/2!V8D-U<G)E;F-Y#0H@("!&;W)M=6QA(#T@(B(-"B @($-O;$AI
M9&1E;B ]($9A;'-E#0H@("!#;VQ.;W1$:7-P;&%Y86)L92 ]($9A;'-E#0H@
M("!&:6QT97)$:7-A8FQE9" ]($9A;'-E#0H@("!#;VQ7:61T:" ](#$Q,# -
M"B @($=R;W5P365T:&]D(#T@9W)O=7!M971H;V13=6T-"B @($-O;$9O<FUA
M=" ]("(B#0I%;F0@0V]L=6UN#0H-"D)E9VEN($-O;'5M;@T*(" @1FEE;&1.
M86UE(#T@(D-O<W13;VQD(@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 B0V]S
M="!3;VQD(@T*(" @5D)$871A5'EP92 ]('9B0W5R<F5N8WD-"B @($9O<FUU
M;&$@/2 B4U5-*%9I97=)=&5M36]V96UE;G0N475A;G1I='E3;VQD("H@5FEE
M=TET96U-;W9E;65N="Y#;W-T4V]L9"DB#0H@("!#;VQ(:61D96X@/2!&86QS
M90T*(" @0V]L3F]T1&ES<&QA>6%B;&4@/2!&86QS90T*(" @1FEL=&5R1&ES
M86)L960@/2!&86QS90T*(" @0V]L5VED=&@@/2 Q,3 P#0H@("!'<F]U<$UE
M=&AO9" ](&=R;W5P;65T:&]D4W5M#0H@("!#;VQ&;W)M870@/2 B(@T*16YD
M($-O;'5M;@T*#0I"96=I;B!#;VQU;6X-"B @($9I96QD3F%M92 ](")6:65W
M271E;4UO=F5M96YT475A;G1I='DB#0H@("!$<FEL;$1O=VY&:65L9$YA;64@
M/2 B(@T*(" @1')I;&Q$;W=N4F5P;W)T3F%M92 ]("(B#0H@("!4:71L92 ]
M(").;VX@4V%L92!-;W9E;65N="(-"B @(%9"1&%T851Y<&4@/2!V8D1O=6)L
M90T*(" @1F]R;75L82 ](")354TH5FEE=TET96U-;W9E;65N="Y1=6%N=&ET
M>2DB#0H@("!#;VQ(:61D96X@/2!&86QS90T*(" @0V]L3F]T1&ES<&QA>6%B
M;&4@/2!&86QS90T*(" @1FEL=&5R1&ES86)L960@/2!&86QS90T*(" @0V]L
M5VED=&@@/2 Q.# P#0H@("!'<F]U<$UE=&AO9" ](&=R;W5P;65T:&]D4W5M
M#0H@("!#;VQ&;W)M870@/2 B(@T*16YD($-O;'5M;@T*#0I"96=I;B!#;VQU
M;6X-"B @($9I96QD3F%M92 ](")6:65W271E;4UO=F5M96YT+DQA<W1296-E
M:79E9"(-"B @($1R:6QL1&]W;D9I96QD3F%M92 ]("(B#0H@("!$<FEL;$1O
M=VY297!O<G1.86UE(#T@(B(-"B @(%1I=&QE(#T@(DQA<W0@4F5C96EV960B
M#0H@("!60D1A=&%4>7!E(#T@=F)$871E#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(#$S,# -"B @($=R;W5P365T:&]D(#T@9W)O=7!M971H;V1-87@-"B @($-O
M;$9O<FUA=" ]("(B#0I%;F0@0V]L=6UN#0H-"D)E9VEN($-O;'5M;@T*(" @
M1FEE;&1.86UE(#T@(E!U<F-H87-E3W)D97(B#0H@("!$<FEL;$1O=VY&:65L
M9$YA;64@/2 B(@T*(" @1')I;&Q$;W=N4F5P;W)T3F%M92 ]("(B#0H@("!4
M:71L92 ](")03R!-;W9E;65N="(-"B @(%9"1&%T851Y<&4@/2!V8D1O=6)L
M90T*(" @1F]R;75L82 ](")354TH0T%312!72$5.(%1Y<&4@/2 Q(%1(14X@
M25-.54Q,*%%U86YT:71Y+" P*2!%3%-%(# @14Y$*2 B#0H@("!#;VQ(:61D
M96X@/2!4<G5E#0H@("!#;VQ.;W1$:7-P;&%Y86)L92 ]($9A;'-E#0H@("!&
M:6QT97)$:7-A8FQE9" ]($9A;'-E#0H@("!#;VQ7:61T:" ](#$S,# -"B @
M($=R;W5P365T:&]D(#T@9W)O=7!M971H;V13=6T-"B @($-O;$9O<FUA=" ]
M("(B#0I%;F0@0V]L=6UN#0H-"D)E9VEN($-O;'5M;@T*(" @1FEE;&1.86UE
M(#T@(E-U<'!L:65R+E-U<'!L:65R3F%M92(-"B @($1R:6QL1&]W;D9I96QD
M3F%M92 ](")3=7!P;&EE<BY3=7!P;&EE<DYA;64B#0H@("!$<FEL;$1O=VY2
M97!O<G1.86UE(#T@(B(-"B @(%1I=&QE(#T@(E-U<'!L:65R($YA;64B#0H@
M("!60D1A=&%4>7!E(#T@=F)3=')I;F<-"B @($9O<FUU;&$@/2 B(@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,3DS-0T*(" @1W)O=7!-971H;V0@/2!G<F]U<&UE=&AO9$YO;F4-"B @($-O
M;$9O<FUA=" ]("(B#0H@("!#;VQ!;&EG;FUE;G0@/2!F;&5X06QI9VY,969T
M0V5N=&5R#0I%;F0@0V]L=6UN#0H-"D)E9VEN($-O;'5M;@T*(" @1FEE;&1.
M86UE(#T@(E9I97=)=&5M36]V96UE;G0N4F5O<F1E<DYU;6)E<B(-"B @($1R
M:6QL1&]W;D9I96QD3F%M92 ]("(B#0H@("!$<FEL;$1O=VY297!O<G1.86UE
M(#T@(B(-"B @(%1I=&QE(#T@(E)E;W)D97(@3G5M8F5R(@T*(" @5D)$871A
M5'EP92 ]('9B4W1R:6YG#0H@("!&;W)M=6QA(#T@(B(-"B @($-O;$AI9&1E
M;B ]($9A;'-E#0H@("!#;VQ.;W1$:7-P;&%Y86)L92 ]($9A;'-E#0H@("!&
M:6QT97)$:7-A8FQE9" ]($9A;'-E#0H@("!#;VQ7:61T:" ](#(P,# -"B @
M($=R;W5P365T:&]D(#T@9W)O=7!M971H;V1.;VYE#0H@("!#;VQ&;W)M870@
M/2 B(@T*(" @0V]L06QI9VYM96YT(#T@9FQE>$%L:6=N3&5F=$-E;G1E<@T*
M16YD($-O;'5M;@T*#0I"96=I;B!#;VQU;6X-"B @($9I96QD3F%M92 ](")/
M9F9L:6YE36]V96UE;G0B#0H@("!$<FEL;$1O=VY&:65L9$YA;64@/2 B(@T*
M(" @1')I;&Q$;W=N4F5P;W)T3F%M92 ]("(B#0H@("!4:71L92 ](")/9F9L
M:6YE($UO=F5M96YT(@T*(" @5D)$871A5'EP92 ]('9B1&]U8FQE#0H@("!&
M;W)M=6QA(#T@(E-532A#05-%(%=(14X@5'EP92 ](#(@3U(@5'EP92 ](#,@
M3U(@5'EP92 ](#0@5$A%3B!)4TY53$PH475A;G1I='DL(# I($5,4T4@,"!%
M3D0I("(-"B @($-O;$AI9&1E;B ](%1R=64-"B @($-O;$YO=$1I<W!L87EA
M8FQE(#T@1F%L<V4-"B @($9I;'1E<D1I<V%B;&5D(#T@1F%L<V4-"B @($-O
M;%=I9'1H(#T@,3<Q, T*(" @1W)O=7!-971H;V0@/2!G<F]U<&UE=&AO9%-U
M;0T*(" @0V]L1F]R;6%T(#T@(B(-"D5N9"!#;VQU;6X-"@T*0F5G:6X@0V]L
M=6UN#0H@("!&:65L9$YA;64@/2 B061J=7-T960B#0H@("!$<FEL;$1O=VY&
M:65L9$YA;64@/2 B(@T*(" @1')I;&Q$;W=N4F5P;W)T3F%M92 ]("(B#0H@
M("!4:71L92 ](")!9&IU<W1E9"(-"B @(%9"1&%T851Y<&4@/2!V8D1O=6)L
M90T*(" @1F]R;75L82 ](")354TH0T%312!72$5.(%1Y<&4@/2 U($]2(%1Y
M<&4@/2 V(%1(14X@25-.54Q,*%%U86YT:71Y+" P*2!%3%-%(# @14Y$*2 B
M#0H@("!#;VQ(:61D96X@/2!4<G5E#0H@("!#;VQ.;W1$:7-P;&%Y86)L92 ]
M($9A;'-E#0H@("!&:6QT97)$:7-A8FQE9" ]($9A;'-E#0H@("!#;VQ7:61T
M:" ](#$R,# -"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@(E9I97=)=&5M36]V96UE;G0N1&%T951R86YS9F5R
M<F5D(@T*(" @1')I;&Q$;W=N1FEE;&1.86UE(#T@(B(-"B @($1R:6QL1&]W
M;E)E<&]R=$YA;64@/2 B(@T*(" @5&ET;&4@/2 B1&%T92(-"B @(%9"1&%T
M851Y<&4@/2!V8D1A=&4-"B @($9O<FUU;&$@/2 B(@T*(" @0V]L2&ED9&5N
M(#T@5')U90T*(" @0V]L3F]T1&ES<&QA>6%B;&4@/2!4<G5E#0H@("!&:6QT
M97)$:7-A8FQE9" ]($9A;'-E#0H@("!#;VQ7:61T:" ](#$Q,# -"B @($=R
M;W5P365T:&]D(#T@9W)O=7!M971H;V1.;VYE#0H@("!#;VQ&;W)M870@/2 B
M(@T*16YD($-O;'5M;@T*#0I"96=I;B!#;VQU;6X-"B @($9I96QD3F%M92 ]
M(")6:65W271E;4UO=F5M96YT+DUO=F5D(@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 B36]V960B#0H@("!60D1A=&%4>7!E(#T@=F)";V]L96%N#0H@("!&
M;W)M=6QA(#T@(B(-"B @($-O;$AI9&1E;B ](%1R=64-"B @($-O;$YO=$1I
M<W!L87EA8FQE(#T@5')U90T*(" @1FEL=&5R1&ES86)L960@/2!&86QS90T*
M(" @0V]L5VED=&@@/2 Q,3 P#0H@("!'<F]U<$UE=&AO9" ](&=R;W5P;65T
F:&]D3F]N90T*(" @0V]L1F]R;6%T(#T@(B(-"D5N9"!#;VQU;6X`
`
end
|
|
Posted by Mary-Pat on February 28, 2006, 5:04 pm
Please log in for more thread options Yikes - I now see where I have to focus my markdowns! Thanks a million.
"Jeff" wrote:
> Mary-Pat,
>
> See the attached report.
>
> Copy it into the Program FilesMicrosoft Retail...Store Op...sReports
> folder. If Manager is open, close it and then re-open it, find the report
> in the Custom section, Item Movement with OnHand and Reorder #
> --
> *
> Get Secure! - www.microsoft.com/security
>
> You must be using Outlook Express or some other type of newsgroup reader to
> see and download the file attachment. If you are not using a reader, follow
> the link below to setup Outlook Express. Click on "Open with newsreader"
> under the MS Retail Management System on the right.
>
> http://tinyurl.com/75bgz
>
> **********
>
> In order for an item to hit a sales report, it has to either have been sold,
> or returned in a given period of time.
> I'd like a report for dept. & suppliers of items with on on-hand quantity
> >0, and 0 sales for a given period of time. Any suggestions?
>
>
>
|
|
Posted by NAVEED on August 28, 2006, 9:24 am
Please log in for more thread options
I could't find this report. please some one who can send me this report by
mail at
nahmad@dewan-stores.com, this will be highly Appreciated.
Regards,
"Mary-Pat" wrote:
> Yikes - I now see where I have to focus my markdowns! Thanks a million.
>
>
> "Jeff" wrote:
>
> > Mary-Pat,
> >
> > See the attached report.
> >
> > Copy it into the Program FilesMicrosoft Retail...Store Op...sReports
> > folder. If Manager is open, close it and then re-open it, find the report
> > in the Custom section, Item Movement with OnHand and Reorder #
> > --
> > *
> > Get Secure! - www.microsoft.com/security
> >
> > You must be using Outlook Express or some other type of newsgroup reader to
> > see and download the file attachment. If you are not using a reader, follow
> > the link below to setup Outlook Express. Click on "Open with newsreader"
> > under the MS Retail Management System on the right.
> >
> > http://tinyurl.com/75bgz
> >
> > **********
> >
> > In order for an item to hit a sales report, it has to either have been sold,
> > or returned in a given period of time.
> > I'd like a report for dept. & suppliers of items with on on-hand quantity
> > >0, and 0 sales for a given period of time. Any suggestions?
> >
> >
> >
|
|
Posted by Jeff on August 29, 2006, 2:38 am
Please log in for more thread options : quoted-printable
Naveed,
Setup Outlook Express to read the newsgroup and you can then see all of =
the reports and attachments in the group.
Click on the link in my tagline below to set it up.
--=20
*
Get Secure! - www.microsoft.com/security
You must be using Outlook Express or some other type of newsgroup reader =
to
see and download the file attachment. If you are not using a reader, =
follow
the link below to setup Outlook Express. Click on "Open with =
newsreader"
under the MS Retail Management System on the right.
http://tinyurl.com/75bgz
**********
I could't find this report. please some one who can send me this =
report by=20
mail at
nahmad@dewan-stores.com, this will be highly Appreciated.
Regards,
=20
"Mary-Pat" wrote:
> Yikes - I now see where I have to focus my markdowns! Thanks a =
million.
>=20
>=20
> "Jeff" wrote:
>=20
> > Mary-Pat,
> >=20
> > See the attached report.
> >=20
> > Copy it into the Program FilesMicrosoft Retail...Store =
Op...sReports=20
> > folder. If Manager is open, close it and then re-open it, find =
the report=20
> > in the Custom section, Item Movement with OnHand and Reorder #
> > --=20
> > *
> > Get Secure! - www.microsoft.com/security
> >=20
> > You must be using Outlook Express or some other type of newsgroup =
reader to
> > see and download the file attachment. If you are not using a =
reader, follow
> > the link below to setup Outlook Express. Click on "Open with =
newsreader"
> > under the MS Retail Management System on the right.
> >=20
> > http://tinyurl.com/75bgz > >=20
> > **********
> >=20
> > In order for an item to hit a sales report, it has to either have =
been sold,
> > or returned in a given period of time.
> > I'd like a report for dept. & suppliers of items with on on-hand =
quantity
> > >0, and 0 sales for a given period of time. Any suggestions?=20
> >=20
> >=20
> >
------=_NextPart_000_04FB_01C6CAFB.17A94890
Content-Type: text/html;
charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.2900.2963" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>Naveed,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Setup Outlook Express to read the newsgroup =
and you can=20
then see all of the reports and attachments in the group.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Click on the link in my tagline below to set =
it=20
up.</FONT></DIV>
<DIV><BR>-- <BR>*<BR>Get Secure! - <A=20
href=3D"http://www.microsoft.com/security">www.microsoft.com/security</A>= </DIV>
<DIV> </DIV>
<DIV>You must be using Outlook Express or some other type of newsgroup =
reader=20
to<BR>see and download the file attachment. If you are not using a =
reader,=20
follow<BR>the link below to setup Outlook Express. Click on "Open =
with=20
newsreader"<BR>under the MS Retail Management System on the right.</DIV>
<DIV> </DIV>
<DIV><A =
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A></DIV> <DIV> </DIV>
<DIV>**********<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"NAVEED" <<A=20
=
soft.com</A>>=20
wrote in message <A=20
=
68CF8-379E-4013-A509-BF7073535F9A@microsoft.com</A>...</DIV><BR>I=20
could't find this report. please some one who can send me this report =
by=20
<BR>mail at<BR><BR><A=20
this will=20
be highly =
Appreciated.<BR><BR>Regards,<BR><BR> <BR><BR><BR><BR>"Mary-Pat"=20
wrote:<BR><BR>> Yikes - I now see where I have to focus my =
markdowns! =20
Thanks a million.<BR>> <BR>> <BR>> "Jeff" wrote:<BR>> =
<BR>>=20
> Mary-Pat,<BR>> > <BR>> > See the attached =
report.<BR>>=20
> <BR>> > Copy it into the Program FilesMicrosoft =
Retail...Store=20
Op...sReports <BR>> > folder. If Manager is open, close =
it and=20
then re-open it, find the report <BR>> > in the Custom =
section, =20
Item Movement with OnHand and Reorder #<BR>> > -- <BR>> >=20
*<BR>> > Get Secure! - <A=20
=
href=3D"http://www.microsoft.com/security">www.microsoft.com/security</A>= <BR>>=20
> <BR>> > You must be using Outlook Express or some other =
type of=20
newsgroup reader to<BR>> > see and download the file =
attachment. =20
If you are not using a reader, follow<BR>> > the link below to =
setup=20
Outlook Express. Click on "Open with newsreader"<BR>> > =
under the=20
MS Retail Management System on the right.<BR>> > <BR>> > =
<A=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>> =
>=20
<BR>> > **********<BR>> > <BR>> > "Mary-Pat" <<A=20
=
rosoft.com</A>>=20
wrote in message <BR>> > <A=20
=
DD953-C905-45A6-91D8-A662FDBE3E46@microsoft.com</A>...<BR>>=20
> In order for an item to hit a sales report, it has to either have =
been=20
sold,<BR>> > or returned in a given period of time.<BR>> > =
I'd=20
like a report for dept. & suppliers of items with on on-hand=20
quantity<BR>> > >0, and 0 sales for a given period of =
time. Any=20
suggestions? <BR>> > <BR>> > <BR>>=20
></BLOCKQUOTE></BODY></HTML>
------=
|
| Similar Threads | Posted | | Report for Zero Item Movement - What *hasn't* sold | August 24, 2007, 4:32 pm |
| Report for Zero Item Movement - What *hasn't* sold | July 1, 2009, 10:29 am |
| Item Movement Report with On Hand and Reorder kudos to Akber - "Items - Item Movement Report.qrp.zip" yEnc (1/1) | April 17, 2008, 2:02 am |
| Item Value List vs Item Movement History Report (including cost) | July 1, 2009, 1:55 pm |
| Report on the item movement report should show qty on hand as we | September 1, 2005, 10:37 am |
| Item Movement Report @ HQ | December 20, 2005, 6:07 pm |
| Item qty/movement report | January 15, 2006, 12:52 am |
| Item Movement Report | July 22, 2006, 11:29 am |
| Item Movement Report | August 6, 2006, 10:38 pm |
| item movement report | July 3, 2007, 6:52 pm |
|
|