report or query to show when item was last received in purchase or

hello,

i would like help to find out when was the last date i received an item in a 
purchase order.  not when was transferred but when it was received.

please help....
0
Utf
8/30/2010 5:44:03 PM
pos 14173 articles. 0 followers. Follow

3 Replies
890 Views

Similar Articles

[PageSpeed] 24

This query will give you the answer:

select * from purchaseorderentry e join purchaseorder p on 
e.storeid=p.storeid and e.purchaseorderid=p.id
where potype=1 and quantityreceivedtodate>0 and 
itemdescription='XYZdescription'

"RP" <RP@discussions.microsoft.com> wrote in message 
news:380A0AB4-0141-4BBC-950B-ECE34CFFD8E5@microsoft.com...
> hello,
>
> i would like help to find out when was the last date i received an item in 
> a
> purchase order.  not when was transferred but when it was received.
>
> please help.... 


0
Matt
8/30/2010 9:03:24 PM
The item movement report has a column for Last Received. I believe that is a 
standard report included with RMS. I attached a copy for you if you are 
using Outlook Express.

Marc


"RP" <RP@discussions.microsoft.com> wrote in message 
news:380A0AB4-0141-4BBC-950B-ECE34CFFD8E5@microsoft.com...
> hello,
>
> i would like help to find out when was the last date i received an item in 
> a
> purchase order.  not when was transferred but when it was received.
>
> please help.... 


begin 666 Items - Item Movement Report.qrp
M+R\M+2T@4F5P;W)T(%-U;6UA<GD@+2TM("\O#0H-"D)E9VEN(%)E<&]R=%-U
M;6UA<GD-"B @(%)E<&]R=%1Y<&4@/2!R97!O<G1T>7!E271E;7,-"B @(%)E
M<&]R=%1I=&QE(#T@(DET96T@36]V96UE;G0@4F5P;W)T(@T*(" @4&%G94]R
M:65N=&%T:6]N(#T@<&%G96]R:65N=&%T:6]N3&%N9'-C87!E#0H@("!3:&]W
M1&%T951I;650:6-K97(@/2!&86QS90T*(" @3W5T3&EN94UO9&4@/2!4<G5E
M#0H@("!'<F]U<',@/2 P#0H@("!'<F]U<$1E<V-R:7!T:6]N(#T@(B(-"B @
M($1I<W!L87E,;V=O(#T@5')U90T*(" @3&]G;T9I;&5.86UE(#T@(DUY3&]G
M;RYB;7 B#0H@("!0<F]C961U<F5#86QL(#T@(B(-"B @(%!R95%U97)Y,2 ]
M("))1B!%6$E35%,@*%-%3$5#5"!404),15].04U%($923TT@24Y&3U)-051)
M3TY?4T-(14U!+E9)15=3(%=(15)%(%1!0DQ%7TY!344@/2 G5FEE=TET96U-
M;W9E;65N="<I($123U @5DE%5R!6:65W271E;4UO=F5M96YT(@T*(" @4')E
M475E<GDR(#T@/$)%1TE./@T*(" @#0H@(" @("!#4D5!5$4@5DE%5R!6:65W
M271E;4UO=F5M96YT($%3#0H@(" @("!314Q%0U0@1&5P87)T;65N="Y.86UE
M(&%S($1E<&%R=&UE;G1.86UE+ T*(" @(" @"2 @(" @0V%T96=O<GDN3F%M
M92!A<R!#871E9V]R>4YA;64L#0H@(" @(" )(" @("!3=7!P;&EE<BY3=7!P
M;&EE<DYA;64@87,@4W5P<&QI97).86UE+ T*(" @(" @(" @(" @($ET96TN
M271E;4QO;VMU<$-O9&4@05,@271E;4QO;VMU<$-O9&4L#0H@(" @(" @(" @
M(" @271E;2Y$97-C<FEP=&EO;B!!4R!)=&5M1&5S8W)I<'1I;VXL#0H@(" @
M(" @(" @(" @271E;2Y,87-T4V]L9"!A<R!,87-T4V]L9"P-"B @(" @(" @
M(" @("!)=&5M+DQA<W1296-E:79E9"!A<R!,87-T4F5C96EV960L#0H@(" @
M(" @(" @(" @271E;2Y#;W-T(&%S($-O<W0L#0H@(" @(" @(" @(" @26YV
M96YT;W)Y5')A;G-F97),;V<N5'EP92!!4R!4>7!E+ T*"2 @(" @(" @(" P
M(&%S(%%U86YT:71Y4V]L9"P-"B @(" @(" @(" @("!)4TY53$P@*$EN=F5N
M=&]R>51R86YS9F5R3&]G+E%U86YT:71Y+" P*2!!4R!1=6%N=&ET>2P-"B @
M(" @(" @(" @(" P(&%S(%!R:6-E4V]L9"P-"B @(" @(" @(" @(" P(&%S
M($-O<W13;VQD+ T*(" @(" @(" @(" @($EN=F5N=&]R>51R86YS9F5R3&]G
M+D1A=&54<F%N<V9E<G)E9"!!4R!$871E5')A;G-F97)R960L#0H@(" @(" @
M(" @(" @,2!!4R!-;W9E9"P-"B @(" @(" @(" @("!#05-%($EN=F5N=&]R
M>51R86YS9F5R;&]G+E1Y<&4@5TA%3B R(%1(14X@26YV96YT;W)Y5')A;G-F
M97),;V<N4F5F97)E;F-E240@14Q312!.54Q,($5.1"!!4R!4<F%N<V%C=&EO
M;DYU;6)E<@T*(" @(" @(" @(" @( T*(" @(" @1E)/32!);G9E;G1O<GE4
M<F%N<V9E<DQO9R -"B @(" @( D)($Q%1E0@2D])3B!)=&5M($].($EN=F5N
M=&]R>51R86YS9F5R3&]G+DET96U)1" ]($ET96TN240-"B @(" @( D)($Q%
M1E0@2D])3B!$97!A<G1M96YT($].($ET96TN1&5P87)T;65N=$E$(#T@1&5P
M87)T;65N="Y)1 T*(" @(" @"0D@3$5&5"!*3TE.($-A=&5G;W)Y($].($ET
M96TN0V%T96=O<GE)1" ]($-A=&5G;W)Y+DE$#0H@(" @(" )"2!,1494($I/
M24X@4W5P<&QI97(@3TX@271E;2Y3=7!P;&EE<DE$(#T@4W5P<&QI97(N240-
M"B @(" @(" @(" @(" @( T*(" @(" @54Y)3TX@04Q,(" @(" @(" @(" -
M"@T*(" @(" @4T5,14-4($1E<&%R=&UE;G0N3F%M92!A<R!$97!A<G1M96YT
M3F%M92P-"B @(" @( D@(" @($-A=&5G;W)Y+DYA;64@87,@0V%T96=O<GE.
M86UE+ T*(" @(" @"2 @(" @4W5P<&QI97(N4W5P<&QI97).86UE(&%S(%-U
M<'!L:65R3F%M92P-"B @(" @( D@(" @($ET96TN271E;4QO;VMU<$-O9&4@
M05,@271E;4QO;VMU<$-O9&4L#0H@(" @(" @(" @(" @271E;2Y$97-C<FEP
M=&EO;B!!4R!)=&5M1&5S8W)I<'1I;VXL#0H@(" @(" @(" @(" @271E;2Y,
M87-T4V]L9"!!4R!,87-T4V]L9"P-"B @(" @(" @(" @("!)=&5M+DQA<W12
M96-E:79E9"!A<R!,87-T4F5C96EV960L#0H@(" @(" @(" @(" @271E;2Y#
M;W-T($%3($-O<W0L#0H@(" @(" @(" @(" @.3D@05,@5'EP92P-"B @(" @
M(" @(" @("!)4TY53$P@*%1R86YS86-T:6]N16YT<GDN475A;G1I='DL(# I
M($%3(%%U86YT:71Y4V]L9"P-"B @(" @(" @(" @(" P(&%S(%%U86YT:71Y
M5')A;G-F97)R960L#0H@(" @(" @(" @(" @25-.54Q,("A4<F%N<V%C=&EO
M;D5N=')Y+E!R:6-E+" P*2!A<R!0<FEC95-O;&0L#0H@(" @(" @(" @(" @
M25-.54Q,("A4<F%N<V%C=&EO;D5N=')Y+D-O<W0L(# I(&%S($-O<W13;VQD
M+ T*(" @(" @(" @(" @(%M4<F%N<V%C=&EO;ETN5&EM92!!4R!$871E5')A
M;G-F97)R960L#0H@(" @(" @(" @(" @0T%312!72$5.(%M4<F%N<V%C=&EO
M;ETN5&EM92!)4R!.54Q,(%1(14X@,"!%3%-%(#$@14Y$($%3($UO=F5D+ T*
M(" @(" @(" @(" @(%M4<F%N<V%C=&EO;ETN5')A;G-A8W1I;VY.=6UB97(@
M05,@5')A;G-A8W1I;VY.=6UB97(-"B @(" @(" @(" @(" -"B @(" @($92
M3TT@("!)=&5M#0H@(" @(" )(" @("!,1494($I/24X@5')A;G-A8W1I;VY%
M;G1R>2!/3B!4<F%N<V%C=&EO;D5N=')Y+DET96U)1" ]($ET96TN240-"B @
M(" @( D@(" @($Q%1E0@2D])3B!$97!A<G1M96YT($].($ET96TN1&5P87)T
M;65N=$E$(#T@1&5P87)T;65N="Y)1"!,1494($I/24X@0V%T96=O<GD@3TX@
M271E;2Y#871E9V]R>4E$(#T@0V%T96=O<GDN240-"B @(" @(" @(" @("!,
M1494($I/24X@6U1R86YS86-T:6]N72!/3B!4<F%N<V%C=&EO;D5N=')Y+E1R
M86YS86-T:6]N3G5M8F5R(#T@6U1R86YS86-T:6]N72Y4<F%N<V%C=&EO;DYU
M;6)E<@T*(" @(" @(" @(" @($Q%1E0@2D])3B!3=7!P;&EE<B!/3B!)=&5M
M+E-U<'!L:65R240@/2!3=7!P;&EE<BY)1 T*#0H\14Y$/@T*(" @5&%B;&5S
M475E<FEE9" ](")&4D]-(%9I97=)=&5M36]V96UE;G0B#0H@("!396Q#<FET
M97)I82 ]("(B#0H@("!'<F]U<$)Y(#T@(E9I97=)=&5M36]V96UE;G0N271E
M;4QO;VMU<$-O9&4L(%9I97=)=&5M36]V96UE;G0N3&%S=%-O;&0L(%9I97=)
M=&5M36]V96UE;G0N3&%S=%)E8V5I=F5D+"!6:65W271E;4UO=F5M96YT+D-O
M<W0L5FEE=TET96U-;W9E;65N="Y3=7!P;&EE<DYA;64L(%9I97=)=&5M36]V
M96UE;G0N1&5P87)T;65N=$YA;64L(%9I97=)=&5M36]V96UE;G0N0V%T96=O
M<GE.86UE+"!6:65W271E;4UO=F5M96YT+DET96U$97-C<FEP=&EO;B(-"B @
M(%-O<G1/<F1E<B ]("(B#0I%;F0@4F5P;W)T4W5M;6%R>0T*#0H-"B\O+2TM
M(%1I=&QE(%)O=W,@+2TM+R\-"@T*0F5G:6X@5&ET;&52;W<-"B @(%1E>'0@
M/2 B/%-T;W)E($YA;64^(@T*(" @1F]N=" ](")!<FEA;"(-"B @($9O;G1"
M;VQD(#T@5')U90T*(" @1F]N=%-I>F4@/2 Q-@T*(" @0V]L;W(@/2 B0FQU
M92(-"D5N9"!4:71L95)O=PT*#0I"96=I;B!4:71L95)O=PT*(" @5&5X=" ]
M("(\4F5P;W)T(%1I=&QE/B(-"B @($9O;G0@/2 B07)I86PB#0H@("!&;VYT
M0F]L9" ](%1R=64-"B @($9O;G13:7IE(#T@,3(-"B @($-O;&]R(#T@(D)L
M86-K(@T*16YD(%1I=&QE4F]W#0H-"D)E9VEN(%1I=&QE4F]W#0H@("!497AT
M(#T@(D=E;F5R871E9"!/;B \4F5P;W)T($1A=&4^(@T*(" @1F]N=" ](")!
M<FEA;"(-"B @($9O;G1";VQD(#T@5')U90T*(" @1F]N=%-I>F4@/2 Q, T*
M(" @0V]L;W(@/2 B0FQA8VLB#0I%;F0@5&ET;&52;W<-"@T*#0HO+RTM+2!&
M:6QT97)S("TM+2\O#0H-"D)E9VEN($9I;'1E<@T*(" @1FEE;&1.86UE(#T@
M(E9I97=)=&5M36]V96UE;G0N1&%T951R86YS9F5R<F5D(@T*(" @1FEL=&5R
M3W @/2!R97!O<G1F:6QT97)O<$=R96%T97)%<75A; T*(" @1FEL=&5R3&],
M:6T@/2 B/$UO;G1H4W1A<G0^(@T*(" @1FEL=&5R2&EL:6T@/2 B/$UO;G1H
M4W1A<G0^(@T*16YD($9I;'1E<@T*#0HO+RTM+2!#;VQU;6YS("TM+2\O#0H-
M"D)E9VEN($-O;'5M;@T*(" @1FEE;&1.86UE(#T@(E9I97=)=&5M36]V96UE
M;G0N271E;4QO;VMU<$-O9&4B#0H@("!$<FEL;$1O=VY&:65L9$YA;64@/2 B
M271E;2Y)=&5M3&]O:W5P0V]D92(-"B @($1R:6QL1&]W;E)E<&]R=$YA;64@
M/2 B(@T*(" @5&ET;&4@/2 B271E;2!,;V]K=7 @0V]D92(-"B @(%9"1&%T
M851Y<&4@/2!V8E-T<FEN9PT*(" @1F]R;75L82 ]("(B#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 R,38P#0H@
M("!'<F]U<$UE=&AO9" ](&=R;W5P;65T:&]D3F]N90T*(" @0V]L1F]R;6%T
M(#T@(B(-"B @($-O;$%L:6=N;65N=" ](&9L97A!;&EG;DQE9G1#96YT97(-
M"D5N9"!#;VQU;6X-"@T*0F5G:6X@0V]L=6UN#0H@("!&:65L9$YA;64@/2 B
M5FEE=TET96U-;W9E;65N="Y$97!A<G1M96YT3F%M92(-"B @($1R:6QL1&]W
M;D9I96QD3F%M92 ](")$97!A<G1M96YT+DYA;64B#0H@("!$<FEL;$1O=VY2
M97!O<G1.86UE(#T@(B(-"B @(%1I=&QE(#T@(D1E<&%R=&UE;G0B#0H@("!6
M0D1A=&%4>7!E(#T@=F)3=')I;F<-"B @($9O<FUU;&$@/2 B5FEE=TET96U-
M;W9E;65N="Y$97!A<G1M96YT3F%M92(-"B @($-O;$AI9&1E;B ](%1R=64-
M"B @($-O;$YO=$1I<W!L87EA8FQE(#T@1F%L<V4-"B @($9I;'1E<D1I<V%B
M;&5D(#T@1F%L<V4-"B @($-O;%=I9'1H(#T@,C$V, T*(" @1W)O=7!-971H
M;V0@/2!G<F]U<&UE=&AO9$YO;F4-"B @($-O;$9O<FUA=" ]("(B#0H@("!#
M;VQ!;&EG;FUE;G0@/2!F;&5X06QI9VY,969T0V5N=&5R#0I%;F0@0V]L=6UN
M#0H-"D)E9VEN($-O;'5M;@T*(" @1FEE;&1.86UE(#T@(E9I97=)=&5M36]V
M96UE;G0N0V%T96=O<GE.86UE(@T*(" @1')I;&Q$;W=N1FEE;&1.86UE(#T@
M(D-A=&5G;W)Y+DYA;64B#0H@("!$<FEL;$1O=VY297!O<G1.86UE(#T@(B(-
M"B @(%1I=&QE(#T@(D-A=&5G;W)Y(@T*(" @5D)$871A5'EP92 ]('9B4W1R
M:6YG#0H@("!&;W)M=6QA(#T@(B(-"B @($-O;$AI9&1E;B ](%1R=64-"B @
M($-O;$YO=$1I<W!L87EA8FQE(#T@1F%L<V4-"B @($9I;'1E<D1I<V%B;&5D
M(#T@1F%L<V4-"B @($-O;%=I9'1H(#T@,C$V, T*(" @1W)O=7!-971H;V0@
M/2!G<F]U<&UE=&AO9$YO;F4-"B @($-O;$9O<FUA=" ]("(B#0H@("!#;VQ!
M;&EG;FUE;G0@/2!F;&5X06QI9VY,969T0V5N=&5R#0I%;F0@0V]L=6UN#0H-
M"D)E9VEN($-O;'5M;@T*(" @1FEE;&1.86UE(#T@(E9I97=)=&5M36]V96UE
M;G0N4W5P<&QI97).86UE(@T*(" @1')I;&Q$;W=N1FEE;&1.86UE(#T@(E-U
M<'!L:65R+E-U<'!L:65R3F%M92(-"B @($1R:6QL1&]W;E)E<&]R=$YA;64@
M/2 B(@T*(" @5&ET;&4@/2 B4W5P<&QI97(B#0H@("!60D1A=&%4>7!E(#T@
M=F)3=')I;F<-"B @($9O<FUU;&$@/2 B(@T*(" @0V]L2&ED9&5N(#T@5')U
M90T*(" @0V]L3F]T1&ES<&QA>6%B;&4@/2!&86QS90T*(" @1FEL=&5R1&ES
M86)L960@/2!&86QS90T*(" @0V]L5VED=&@@/2 R,38P#0H@("!'<F]U<$UE
M=&AO9" ](&=R;W5P;65T:&]D3F]N90T*(" @0V]L1F]R;6%T(#T@(B(-"B @
M($-O;$%L:6=N;65N=" ](&9L97A!;&EG;DQE9G1#96YT97(-"D5N9"!#;VQU
M;6X-"@T*0F5G:6X@0V]L=6UN#0H@("!&:65L9$YA;64@/2 B5FEE=TET96U-
M;W9E;65N="Y)=&5M1&5S8W)I<'1I;VXB#0H@("!$<FEL;$1O=VY&:65L9$YA
M;64@/2 B(@T*(" @1')I;&Q$;W=N4F5P;W)T3F%M92 ]("(B#0H@("!4:71L
M92 ](")$97-C<FEP=&EO;B(-"B @(%9"1&%T851Y<&4@/2!V8E-T<FEN9PT*
M(" @1F]R;75L82 ]("(B#0H@("!#;VQ(:61D96X@/2!&86QS90T*(" @0V]L
M3F]T1&ES<&QA>6%B;&4@/2!&86QS90T*(" @1FEL=&5R1&ES86)L960@/2!&
M86QS90T*(" @0V]L5VED=&@@/2 R,38P#0H@("!'<F]U<$UE=&AO9" ](&=R
M;W5P;65T:&]D3F]N90T*(" @0V]L1F]R;6%T(#T@(B(-"B @($-O;$%L:6=N
M;65N=" ](&9L97A!;&EG;DQE9G1#96YT97(-"D5N9"!#;VQU;6X-"@T*0F5G
M:6X@0V]L=6UN#0H@("!&:65L9$YA;64@/2 B471Y4V]L9"(-"B @($1R:6QL
M1&]W;D9I96QD3F%M92 ]("(B#0H@("!$<FEL;$1O=VY297!O<G1.86UE(#T@
M(B(-"B @(%1I=&QE(#T@(E%U86YT:71Y(%-O;&0B#0H@("!60D1A=&%4>7!E
M(#T@=F)$;W5B;&4-"B @($9O<FUU;&$@/2 B4U5-*%9I97=)=&5M36]V96UE
M;G0N475A;G1I='E3;VQD*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:" ](#$R,# -"B @($=R;W5P365T:&]D(#T@
M9W)O=7!M971H;V13=6T-"B @($-O;$9O<FUA=" ]("(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 ](")354TH5FEE=TET96U-;W9E;65N
M="Y1=6%N=&ET>5-O;&0@*B!6:65W271E;4UO=F5M96YT+E!R:6-E4V]L9"DB
M#0H@("!#;VQ(:61D96X@/2!&86QS90T*(" @0V]L3F]T1&ES<&QA>6%B;&4@
M/2!&86QS90T*(" @1FEL=&5R1&ES86)L960@/2!&86QS90T*(" @0V]L5VED
M=&@@/2 Q,3 P#0H@("!'<F]U<$UE=&AO9" ](&=R;W5P;65T:&]D4W5M#0H@
M("!#;VQ&;W)M870@/2 B(@T*16YD($-O;'5M;@T*#0I"96=I;B!#;VQU;6X-
M"B @($9I96QD3F%M92 ](")6:65W271E;4UO=F5M96YT+DQA<W13;VQD(@T*
M(" @1')I;&Q$;W=N1FEE;&1.86UE(#T@(B(-"B @($1R:6QL1&]W;E)E<&]R
M=$YA;64@/2 B(@T*(" @5&ET;&4@/2 B3&%S="!3;VQD(@T*(" @5D)$871A
M5'EP92 ]('9B1&%T90T*(" @1F]R;75L82 ]("(B#0H@("!#;VQ(:61D96X@
M/2!&86QS90T*(" @0V]L3F]T1&ES<&QA>6%B;&4@/2!&86QS90T*(" @1FEL
M=&5R1&ES86)L960@/2!&86QS90T*(" @0V]L5VED=&@@/2 Q,3 P#0H@("!'
M<F]U<$UE=&AO9" ](&=R;W5P;65T:&]D36%X#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+D-O<W0B#0H@("!$<FEL;$1O=VY&:65L9$YA
M;64@/2 B(@T*(" @1')I;&Q$;W=N4F5P;W)T3F%M92 ]("(B#0H@("!4:71L
M92 ](")#;W-T(@T*(" @5D)$871A5'EP92 ]('9B0W5R<F5N8WD-"B @($9O
M<FUU;&$@/2 B(@T*(" @0V]L2&ED9&5N(#T@1F%L<V4-"B @($-O;$YO=$1I
M<W!L87EA8FQE(#T@1F%L<V4-"B @($9I;'1E<D1I<V%B;&5D(#T@1F%L<V4-
M"B @($-O;%=I9'1H(#T@,3$P, T*(" @1W)O=7!-971H;V0@/2!G<F]U<&UE
M=&AO9%-U;0T*(" @0V]L1F]R;6%T(#T@(B(-"D5N9"!#;VQU;6X-"@T*0F5G
M:6X@0V]L=6UN#0H@("!&:65L9$YA;64@/2 B0V]S=%-O;&0B#0H@("!$<FEL
M;$1O=VY&:65L9$YA;64@/2 B(@T*(" @1')I;&Q$;W=N4F5P;W)T3F%M92 ]
M("(B#0H@("!4:71L92 ](")#;W-T(%-O;&0B#0H@("!60D1A=&%4>7!E(#T@
M=F)#=7)R96YC>0T*(" @1F]R;75L82 ](")354TH5FEE=TET96U-;W9E;65N
M="Y1=6%N=&ET>5-O;&0@*B!6:65W271E;4UO=F5M96YT+D-O<W13;VQD*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:" ](#$Q,# -"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;G11=6%N=&ET>2(-"B @
M($1R:6QL1&]W;D9I96QD3F%M92 ]("(B#0H@("!$<FEL;$1O=VY297!O<G1.
M86UE(#T@(B(-"B @(%1I=&QE(#T@(DYO;B!386QE($UO=F5M96YT(@T*(" @
M5D)$871A5'EP92 ]('9B1&]U8FQE#0H@("!&;W)M=6QA(#T@(E-532A6:65W
M271E;4UO=F5M96YT+E%U86YT:71Y*2(-"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:" ](#$X,# -"B @($=R;W5P365T
M:&]D(#T@9W)O=7!M971H;V13=6T-"B @($-O;$9O<FUA=" ]("(B#0I%;F0@
M0V]L=6UN#0H-"D)E9VEN($-O;'5M;@T*(" @1FEE;&1.86UE(#T@(E9I97=)
M=&5M36]V96UE;G0N3&%S=%)E8V5I=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 B3&%S="!296-E:79E9"(-"B @(%9"1&%T851Y<&4@/2!V8D1A=&4-
M"B @($9O<FUU;&$@/2 B(@T*(" @0V]L2&ED9&5N(#T@1F%L<V4-"B @($-O
M;$YO=$1I<W!L87EA8FQE(#T@1F%L<V4-"B @($9I;'1E<D1I<V%B;&5D(#T@
M1F%L<V4-"B @($-O;%=I9'1H(#T@,30P, T*(" @1W)O=7!-971H;V0@/2!G
M<F]U<&UE=&AO9$UA> T*(" @0V]L1F]R;6%T(#T@(B(-"D5N9"!#;VQU;6X-
M"@T*0F5G:6X@0V]L=6UN#0H@("!&:65L9$YA;64@/2 B4'5R8VAA<V5/<F1E
M<B(-"B @($1R:6QL1&]W;D9I96QD3F%M92 ]("(B#0H@("!$<FEL;$1O=VY2
M97!O<G1.86UE(#T@(B(-"B @(%1I=&QE(#T@(E!/($UO=F5M96YT(@T*(" @
M5D)$871A5'EP92 ]('9B1&]U8FQE#0H@("!&;W)M=6QA(#T@(E-532A#05-%
M(%=(14X@5'EP92 ](#$@5$A%3B!)4TY53$PH475A;G1I='DL(# I($5,4T4@
M,"!%3D0I("(-"B @($-O;$AI9&1E;B ](%1R=64-"B @($-O;$YO=$1I<W!L
M87EA8FQE(#T@1F%L<V4-"B @($9I;'1E<D1I<V%B;&5D(#T@1F%L<V4-"B @
M($-O;%=I9'1H(#T@,3<Q, T*(" @1W)O=7!-971H;V0@/2!G<F]U<&UE=&AO
M9%-U;0T*(" @0V]L1F]R;6%T(#T@(B(-"D5N9"!#;VQU;6X-"@T*0F5G:6X@
M0V]L=6UN#0H@("!&:65L9$YA;64@/2 B3V9F;&EN94UO=F5M96YT(@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 B3V9F;&EN92!-;W9E;65N="(-"B @(%9"
M1&%T851Y<&4@/2!V8D1O=6)L90T*(" @1F]R;75L82 ](")354TH0T%312!7
M2$5.(%1Y<&4@/2 R($]2(%1Y<&4@/2 S($]2(%1Y<&4@/2 T(%1(14X@25-.
M54Q,*%%U86YT:71Y+" P*2!%3%-%(# @14Y$*2 B#0H@("!#;VQ(:61D96X@
M/2!4<G5E#0H@("!#;VQ.;W1$:7-P;&%Y86)L92 ]($9A;'-E#0H@("!&:6QT
M97)$:7-A8FQE9" ]($9A;'-E#0H@("!#;VQ7:61T:" ](#$W,3 -"B @($=R
M;W5P365T:&]D(#T@9W)O=7!M971H;V13=6T-"B @($-O;$9O<FUA=" ]("(B
M#0I%;F0@0V]L=6UN#0H-"D)E9VEN($-O;'5M;@T*(" @1FEE;&1.86UE(#T@
M(D%D:G5S=&5D(@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 B061J=7-T960B
M#0H@("!60D1A=&%4>7!E(#T@=F)$;W5B;&4-"B @($9O<FUU;&$@/2 B4U5-
M*$-!4T4@5TA%3B!4>7!E(#T@-2!/4B!4>7!E(#T@-B!42$5.($E33E5,3"A1
M=6%N=&ET>2P@,"D@14Q312 P($5.1"D@(@T*(" @0V]L2&ED9&5N(#T@5')U
M90T*(" @0V]L3F]T1&ES<&QA>6%B;&4@/2!&86QS90T*(" @1FEL=&5R1&ES
M86)L960@/2!&86QS90T*(" @0V]L5VED=&@@/2 Q-S$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=F5M96YT+D1A=&54<F%N<V9E<G)E9"(-"B @($1R:6QL1&]W;D9I
M96QD3F%M92 ]("(B#0H@("!$<FEL;$1O=VY297!O<G1.86UE(#T@(B(-"B @
M(%1I=&QE(#T@(D1A=&4B#0H@("!60D1A=&%4>7!E(#T@=F)$871E#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
M:&]D3F]N90T*(" @0V]L1F]R;6%T(#T@(B(-"D5N9"!#;VQU;6X-"@T*0F5G
M:6X@0V]L=6UN#0H@("!&:65L9$YA;64@/2 B5FEE=TET96U-;W9E;65N="Y-
M;W9E9"(-"B @($1R:6QL1&]W;D9I96QD3F%M92 ]("(B#0H@("!$<FEL;$1O
M=VY297!O<G1.86UE(#T@(B(-"B @(%1I=&QE(#T@(DUO=F5D(@T*(" @5D)$
M871A5'EP92 ]('9B0F]O;&5A;@T*(" @1F]R;75L82 ]("(B#0H@("!#;VQ(
M:61D96X@/2!4<G5E#0H@("!#;VQ.;W1$:7-P;&%Y86)L92 ](%1R=64-"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
2=" ]("(B#0I%;F0@0V]L=6UN
`
end

0
MarcR
8/31/2010 3:06:04 PM
I don't think the Item.LastReceived field does anything in HQ, and the store 
field doesn't differentiate between received as PO or received as transfer. 
To find the PO items, you have to look at PurchaseOrderEntry from PO of type 
1:

select max(e.lastupdated) from purchaseorderentry e join purchaseorder p on
e.storeid=p.storeid and e.purchaseorderid=p.id
where potype=1 and quantityreceivedtodate>0 and
itemdescription='XYZdescription'

"MarcR" <marc_nospam_@beverlyspet.com> wrote in message 
news:e1RIL4RSLHA.4736@TK2MSFTNGP06.phx.gbl...
> The item movement report has a column for Last Received. I believe that is 
> a standard report included with RMS. I attached a copy for you if you are 
> using Outlook Express.
>
> Marc
>
>
> "RP" <RP@discussions.microsoft.com> wrote in message 
> news:380A0AB4-0141-4BBC-950B-ECE34CFFD8E5@microsoft.com...
>> hello,
>>
>> i would like help to find out when was the last date i received an item 
>> in a
>> purchase order.  not when was transferred but when it was received.
>>
>> please help....
>
>
> 


0
Matt
8/31/2010 8:33:26 PM
Reply:

Similar Artilces:

Sequentially numbered Purchase orders
In the past with Office 97. I used a purchase order template that would basically self number itself. when it opened a small box would appear and by clicking it the PO received a unique number. How can I accomplish this using Office XP. ...

Getting an Error when there is nothing to show
-- The bottom of my report which is a statement shows #Error when there is no Invoices to add up. Can I have it blank instead. this my text Box Control Source thanks for any Help....Bob =Reports!rptOwnerPaymentMethod!subChildOwnerInvoiceAmount!tbAmount.Value Try: =IIf([subChildOwnerInvoiceAmount].[HasData], [subChildOwnerInvoiceAmount].[tbAmount]) Explanation in: Bring the total from a subreport onto a main report at: http://allenbrowne.com/casu-18.html -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.h...

how to query my web site from VBA and return a value to VBA
Hello All, From VBA I would like send a value to my web site, and have it return a value. I've learned how to use FollowHyperlink to send a value to an ASP script, but how can the ASP script send a value back to VBA?? Thanks, Brian Austin, TX You can use xmlhttp to make a request to your web page: '********************************************************* Sub Tester() MsgBox WebResponse("http://www.mydomain.com/myactualpage.asp? info=3Dblah") End Sub Private Function WebResponse(sURL As String) As String Dim XmlHttpRequest As Object Se...

hyperlinking to an item in Global Address List Options
I have had success linking via html from web page to opening a specific contact record from Microsoft Outlook. I have done it like this: outlook://Big%20Contacts/Contacts/~Peter%20Crawford However, my very large contact database also has people with basically the same name, like John Smith. In the current "Address Card" view inside Microsoft Outlook, one of the John Smith's is always sorted first. If I enter outlook://Big%20Contacts/Contacts/~John%20Smith the first John Smith in the sort order is always opened. However, I want to specify one of the other John Smith's....

Tax software report
I am unable to view any of my "Insurance : Health" category transactions when I run the "Tax software report" in the Reports section. To be sure, I confirmed that I previously check the tax form, Schedule A, and Doctors - medicine - etc. tax line in the tax manager. The error seems most perculiar given all of my "Healthcare" category transactions are viewable when I run the same report. Any suggestions? ...

OWA Password page not showing up.
I installed the hotfix from kb 833734. I've also tried to follow the steps found at kb 327843. However, when I set an account to "change password at next logon" and go to that account in OWA on a FE that's using forms based auth, it doesn't redirect to the page for changing an expired password. However if i direct my browser to that page manually and fill in the form, it unexpires my password just fine. Is this how it's supposed to work? Shouldn't it detect that it's expired and thus redirect me to the page for resetting my password? Thanks. This ...

http://crm/Reports vs. http://crm/Reportserver
I have several MS CRM reports residing on a SQL Server 2005 that were migrated from 3.0. I can access the reports via the following url: http://crm/Reports then clicking the folder and opening up a report. However, When I try and use http://crm/Reportserver and click on the reports I see the same folder and reports but I get an error message (below) and cannot open any reports? I believe this to be a SRS issue. In the following the GUID appears to be the link and the reports are in a 4.0 folder. Wednesday, April 02, 2008 11:38 AM 23166 {5a8355f1-e300- dd11-a47f-001aa03779ca} ...

Send/Receive Problem
I am using Outlook 2002 on an XP platform. I cannot get Outlook to check for Email at regular intervals. I have the my Outlook set to Send and Receive all my accounts every 10 minutes but nothing happens. The only way I can receive Emails is by manually using the Send/Recv button or pressing F9. Can anyone offer any help. In case it is relevant I am using Norton Internet Security 2003. PWS Not sure it it Yor problem, but Outlook has some problems with Noroton Antivirus runing and chekking e-mails. As far as I know, Outlook may stop recieving e-mails from POP3 servers due to very le...

Pulling counts out of query results
I have a query that has one field Type which is set to Count The query results are used in a report. The report has the fields in the detail section as TYPE and CountOfType (1 line only in the detail section) The report looks like this when displayed AS 28 AV 17 OR 5 I need to be able to get the individual AS No (28) and add it to another number elswhere in the report. How can I do this? I have tried using a textbox with an if function (if [type]="AS",CountOfType,0 but that did not work. Any help appreciated. Ray I think you will need to do it in the query. But try addi...

form and query problem. please help.
All tables are linked with weak entities. However, when i enter data on the form I can't get it to let me enter more than one partipicant without access generating a new invoice id. however i need one invoice to many participants. It wont work and i have no idea what to do at this point. in addition the workshop will not let me add workshop to invoice. this is a small mdb and i'd like to email it to anyone who can assist me with the relationships as I think this is the problem but I don't know what to do. please help me. INVOICE invoiceNO - autonumber invoice prices WORKSHOP wo...

Report Error 11-24-04
When attempting to run CRM Reports for the first time we are receiving the error "Information is needed before this report can be processed" I have found documentation that states that this can happen if your server has an underscore. Our server does not it is named ourcompany.server.eeecrm Can the periods have the same effect as the underscore. Or does anyone have another cause? Thank you Hi There - Hope you don't mind but I wish to piggy-back on your post. I get the same error on our custom reports that use OLE DB to connect to another SQL server other than the MS CRM ...

Delay receiving email
Hi, We use Exchange 2000 and Windows 2000. I have recently been expeirencing intermitent delays in receiving email from two seperate domains.The delays are usually 3 hours but sometimes even longer. In the header info the delay happens at the last hop before reaching our domain. I have checked the exchange logs as well as the logs on our gateway but they do not indicate any delay once we receive the email. I am not sure what else I should do. Any help would be appreciated. Thanks, Bryan ...

SetParameterFields in CCrystalCtrl Activex(Crystal Report)
Hi , I am trying to call a Crystal Report from my VC program.In that i am facing problem while trying to send a selection criteria for my report (the equivalant in VB is SelectionFormula) I want to make selection based on a Date feild and another extension filed (say date between '01/01/2003' and '01/01/2004' and extn_no = 100) How can i do that.Any idea???????????? Reny ...

Keeping Sent Items in sync across two PCs
I asked this question a few days ago in the microsoft.public.outlook.general forum but didn't get any replies, so I thought I'd try here instead... I have two computers, and both use Outlook 2000 for email. I don not use an Exchange server - email is by POP3/SMTP. Both computers collect the same email by POP3, and are set up to leave messages on the server for 30 days so nothing is missed on either PC. This works well, but the only problem is that when I send an email, it is only in the Sent Items fold of the PC that I used to send the email. Is there a way to 'copy' group...

Not receiving messages correctly
I have a Microsoft Outlook XP client that is used to get mail from an Exchange 5.5 server that is not receiving meesages in a timely manner. If I send a message to the mailbox it takes an average of 20 minutes to get delivered. Doing a manual send/receive does not help. The message only comes through when I change the message that I am viewing in the preview screen by cycling through the messages with the arrow keys. The message that is sent can be seen when logging into webmail though. Has anyone heard of this before? All of the service packs and latest updates are installed, and they have...

Reports in Money Small Business 2004
Since "upgrading" from Money SB 2002 to SB 2004, when I run a Sales Analysis Report (ie, "All Projects" or any project for that matter) . . . NONE of the sales/invoices are included (except as $zero) for the dates BEFORE I "upgraded" the software. The paid (or unpaid) invoice (s) for all of the projects are still there, showing the correct amount of money, they are not, however included in ANY type of report I try to run. In other words, I can ONLY get totals within a report SINCE I "upgraded" (since 6/1/04). IF I were to run any sales reports...

Count Unique Items with Multiple Criteria
I am trying to get a list of how many lots a particular car model is on. For example, say we have a spreadsheet that looks like: Model License Lot Ford xjd-394 1 Chevy gwg-394 2 Ford sdf-333 1 Ford lkj-111 3 Toyota skd-333 4 Toyota shk-584 4 I am loking for a way to get data that says how many unique lots each car is on, so for example: Ford: 2 Chevy: 1 Toyota: 1 I was trying to do this with Pivot tables and the count functionality, but it isn't quite getting me the results I want. I can get the results with a pivot table ...

Show only extended description on receipt
I have RMS set up in such a way that it shows the extended description of the items at the POS along with the regular description. When i print a receipt both descriptions print. Is it possible to print only the extended description, if so, how?? Hi Terry, You might downloaded the receipt format or done yourself customization. Just try to find first Entry.Item.ExtendedDescription and if you see another variable called Entry.Description Just remove the row or column with name "Entry.Description" It will work, let me know or send me email address I have already the customized o...

zz report date truncation
We run only z reports at end of day. We will be running cashier shifts soon and would like to run z and zz reports the way they were intended. Is there any way to truncate the zz report date for each register without it running since the beginning of time and using a truckload of paper? Thanks in advance! This may not be the most graceful solution, but you could simply turn off your printer before 'printing' the zz report. Then manually delete all print tasks for that printer before turning it back on. The report won't print, but RMS will think it did. "TV hardwa...

Site-specific config items
I've got an ASP.NET 3.5 website on a shared-hosting server, and of course my own development copy. Data is in a SQL Server database. I've looked at some of the strategies available to configure the connections string appropriately for each site without accidentally overwriting one with the other. One of them, to define the data connection string in machine.config, is unavailable to me on the production website, but I was thinking about doing it this way: Suppose my site is as follows Root --App1 --App2 I have two ASP.NET applications, and I don't have anything d...

show last data point in chart
Hello, I am charting a range of observations/data points. Is there a way to make the last data point show up differently on the chart (different color/shape)? Thank you. Nathan - > I am charting a range of observations/data points. Is there a way to make the last data point show up differently on the chart (different color/shape)? < Click the charted data once to select the entire data series. Pause. Click the single point to select it. Then use the Format menu. - Mike www.mikemiddleton.com Thanks for your reply. Well, that would work if I knew which point on the chart ...

E2K3
Our company is preparing for E2K3, one of the new policies we wanted to enforce was Prohibit Send and Receive limits. We did not enforce this in Ex5.5, but now we want to. Planned E2K3 limits would be 90MB-Warning, 100MB - Prohibit Send and 300MB - Prohibit Send and Receive. In our initial testing, it appears as though the Prohibit Send and Receive limit is not checked or enforced until the MAINTENANCE INTERVAL (MI)is run. We have this (MI) set to run at 1am-5am, so it looks like a user could continue to receive mail, say up to 900MB+ prior to the MI run, and after it runs, mail would ...

Showing the perimeter of a set of (X,Y) data!
Good day all, I need to plot the perimeter of a set of data. I have a set of (X,Y) data with error bar and it is a nice mess so I just actually need to see (show) the area were the data can be found. Then hopefully overlay an other set of (X',Y') data and show that they both cover the same surface of existence. i.e this is a set of metrology measurement in X and Y of a part build from different mould. Obviously you get a nice cloud of X and Y but does the new material offer the same 'cloud' ? Thank you I think the easiest way to do this is plot the data on a XY Scatter cha...

Cashier over short report
Does anyone have a cashier over short report that they would share? I am having problems building my own. Thanks ...

Report for single record
I have a report that shows much data about a single record that I am trying to reuse from a previous database. In my new DB, the project manager is set in an intermediate table between project data and contact data. How do I reference a table outside the forms data source? Can I run a query in a form without having to build a query? Several possibilities. If you just need to look up a single value from another table so you can limit the report to the correct value, DLookup() should do that for you. See: Getting a value from a table: DLookup() at: http://allenbrowne.com/casu-07...