|
Posted by Jason on October 26, 2007, 2:10 pm
Please log in for more thread options
Report Attached.
I have a strange problem with several items. For this particular item's
history, I have two PO's totalling qty 150 being transferred in. Then I have
several sales, totalling 58 units. When I do an item movement report, the
quantity reported is 92, which matches my physical inventory and should
match my on hand quantity. However, the item properties reports -58 on hand.
If there were a manual adjustment, it should have showed up on the movement
report.
I do not understand what can cause this to happen. Actually, I have one
idea - what would happen if HQ processed a 260 worksheet and the HQ quantity
was zero? Would that show up as an adjustment on the movement report.
begin 666 movement.gif
M1TE&.#EAC@*X`??_`(JLV(:HU(*DT2Y*B8&BT!TY>U)QJ(ROVG^@SJ+&[9N^
MYN[N[FJ*O+RO&R,OH^QW&."MALV>6B(NWV>S)W Z%5TJC11CD1BG 0$!(2F
MTQ8Q=&" M'N<RT9DGI"RW4IHH6Z/P/__^N'AX>;FY@AWV)2WX5]^LQ(L<3%.
MC.GIZ9FY1(2$@PF:Y*UWXVPVYJ:FD)@FMG9V393D XH;4QJHE1RJ4YLI"9"
M@E=VK"A$A%!OIC!-BUUL7B9R0``@O[^_G&1PB1 @$%>F:#$Z^OKZY_"ZG:7
MQW25Q>KJZF6%N T-#7.4Q @("'*2PRI&AJ##ZA0N<EIYKUEXKG^ASSM8E#Y<
MEVN<UG*3Q'&2PR,^?RM(AU%PIUIZKUMZL+G2VADT=SE6DCU:EA<7%R$?B
M?3Q:E1,X@3Q9E0!KSCY;EG*6RA J;Q[?!%V0DA82,_@ %OT/___ @>6"(B
M(K7/V(" @$! 0*;* ``__S_/W]_8 ``/O[^# P$U-3?KZ^O#P/GY^:>G
MI_;V]OCX^/?W]Y>ZXV:&N2I ?6AH:/+RMWAZA@S=DEGH(* `96XX6>'NHBJ
MUJ7)[XFKUYB[Y%Q[L):YXJ'%[%AWK766QGF:R9&TWF2$M_7U]?3T])RFPEML
MF?'Q_/S]W=W69F9@#_`#I7DTAFG_``(R,C,W2X.[O]-#0T'Q?+W$UC,S
M,V^0P6*!M5Y]LGJ;RG>8R)J]Y9[!Z9["Z7Z?S6!_M(6GU'R=S"I&A:3([I.V
MX)R_YS-0C41$1$!=F/'Q4ULI!DR<T]NI3=4D;*RLHR8N!$K<#I/AZRUS&M[
MI<S,S$I=D:JJJJ/'[9.VWY6XXJ+%[*3'[EU]LGF;RG"0P7>8QXJLUUEXK9J]
MYFV-OVF)NVF*O(NMV6N+O8>IU8BKUZ3([X.ETFZ.OSA5DB$]?E55525!@2]+
MBD%?F3]=F"=#@T-AFT)?FHB(B'=W=WN)K___`(2"A*K2XSZ7Y0D?7 1-H62C
MX0HD:M30R ```/___P```"'Y! $``/`+ ````".`K@!``C_`/D)'$BPH,&#
M"!,J7,BPH<.'$"-*G$BQHL6+&#-JW,BQH>/($.*'$FQCITZ=03N6FRI<N7
M*UG(G"ESALV;-M?H7*.LYXF?0$] &4H4BH:C2),R6LKHB],O$:)*G5J@JM6J
M;+)F)4-FS!AT8+.(S?*F;)"S0=2IO<'VAKNW.>+&Y467EQ,G6O+JU3*@K]]U
M@ 'O&$P8A6$4P!(KML"XL8S',HY)/G:N,IC+8$QIIL*9RIG/9<*(3D.ZBNDJ
M[80)$):"#MV&#(?D?[W87;N#OHWMWAE.]3C8(W^D#`XWCR&D06T[,AG-C
MT*/KF+ZE^A8#V&MHWUZAN_<*.,*'_=$?IL4*5'21^'2I4NE]Y5XR+=F398L
M$_ASZ<^UH7^L_[% (." G!3(21(('J+@(9 T*,&#$G@CX3<,5!C.A0YDZ$ W
M')KC(0@@@@`++-@`82(06Q!4L7K'$BT?$>$0F-!IAHQ'9T$)+#SSVH,F/
MUPR"P=$<K#+D1,D.0$N3"+@) )31$G E%0*8*65Y629P9:Z=*E+`&"*(Z8X
MD90YSB1H:@,``."TV>8!<,;IPIP/U/F !WCBN<F>>[;@IS2^!%K"H(4.HTE
MB!JBJ"&4-*K"HRK44@LW"E3ZRZ6_4*"I+9S:<LLM13PAZA-#E'K)J=0DH&HT
MK%;32R_D2/BZQVTUFKKK;CFJNNNNPID$DHJP20L3#31A!-.._'D4U _%454
M4M!JP%133TUE;0177:755EU]%=989;V!5EIKM?66.W+-5===>^GEUU^!K4-8
M88<IMEACC$$6V625G8-99IMU]MD9H8U6VFFIK=;::['-5AMNN?&FVV_ "5><
M<<D=QUQSST4'W70Z6'===MMI]YUWXHU7WGGJK=<>?/'-5]]]^>W7WP8`!CB@
M@ 8>F.""#4("88035LC A>%HN&&''X8X8HDGIKABBRN(>.,-=Z8XXX]_JA)
M9YX>-GGGX'Z,F@)A3YR:**+-DH)I)%.6JD"F&:Z::>?ACIJJ4.<>DFJJ[;Z
M:JRSJKZZJSGZNM)*?&S$@EMM$$"[;7?#@<)N^?S4K$S'7M3LCTIPVRSSAH5
M+5+3/@75M5)E:]6V;'#E%5CHC$6666BII4Y;;L&5;EUVX=4N7^.$*^\^YP
M&&+V`H-OOI!-1IEEF&EF2F>>@29:&*1)PVE0HYK6N 8VLH%!;6P#L0M(;&*_
M$<YPBI,QC3''.3;PV,>H8QWL&*!D)CL9>%)&'DR8!SWJ88][X",?'M#'/O@Q
MP7[XXQ`[8QG!D)0$A;$( =!2$+>H)"%_S"D(0YUPT/F")&(2'0B%*FH12Z"
MD8QHE(D;X4A'/?(1D(14)",A24E,PL63H"2EM1&@;6[3$I>!*8`C(E,9D+3
M)-3$)K[Y[6]TLA/A"F<X/[4`4((BE*$098E%,<I1D)(4I2R%*4U1H%.>`M6H
M2&4J5*DJ`:R*AJM@)2M)T,H?H RE*$=IAU&:4I1V^.0I3YG*.[P.6++;!QK0
M/7!Q[RS>`]^YTI4#K'K?.E37[S:Y[YZQ6]^%M"7_?KU+_WQ;V %`^#!3),P
M`S(L@0MLH ,?2/Q"5ZL@LJY8,<!C*1>1"$-1#A",53PA.V3(4P:^$+:29#
MF]7P/S>$0,]TR,.@#0V(0CP:$3-D1"0J6E-E!H4JW8U*EIQ:UGT&MBZ.+:R
MA7&,:3/C&=OVMKC-K8UOO%O>YK@W.]X1<(+;H^$VX4= *DZ0CB.D(25'.45>
M+G..A&3G)@DZT9$.DZ;C9.KT1"3D)4A)OED65OYRMBM) 9>B*M<Y4H'+]!!
M%??X94N"R8)A$G,GQ3N>4)*GS*,TKUK.Q!8TI=DM[&DO7./*IKG$)Q=OFJ]=
MX5P?.=7/_G-3YWPM]EW"DP_QE,@ @KX,(0Z##:Z/.!O8F@Q2A8P8W_85"#
MQBAH!TE6,H6F# <-95D*79"F<&P9OJY6<XRNM&?*<BC/RS:$)-61*8ET6E,
MC-H3J2;%&+E4:UCLVA;#1J2:@O%L3LJI&='8TS5V":AVBZ/>ZNBF.QX`J7HD
MW%*;FKC%->YQA8P<(A]E549>*JN<D^3G*CFZ2V9RDZCSY!W.NA"S"J0?&,YP
MG9)8Q5H%E-'<UC3!(LHL@%)<W2L76[8YOKJ LEV@S.PXV?9<WZV?J'UUV5
MAL+T0+2X+IQ9#&>H7!O>L+D[!)H/'P12HR%-:25M&HA0JMVIL8BE4R:C6 J
MWJ]Q46Q?3-)-T5;&M;%7C7)C8]W$)%0YTI%OX+ O?NNDU#XB+I",&R3D%$75
M1%K.P)I[9((])ZJN6K)TFCQ=)SM<X5)>6,,:YO"$!X)A@E0;Q!.<;!(?.)N
MQP&4+&[)BXLUX^$!UIA!P;$_C@)*:.WX><[,%I 9>STB^T,L1XZLDL.'KB;3
M)91Z":64`[-9<]H+G:"5##NW[(N4^'+H1'S/ DHC#,?L&$*?%@#V^P/WX R
M./^LK4 SJ,'IV+DZ!__-LPA_&]P^NVR%[Y&HH)%+0YP9>F>([NBBB19$1X]T
M:4>4]!*A9B*5<M=JF:XB>+G&(YE^NKRA-IL82:VV]?(4U3]=-1SQYNJBUO>H
M>:2U?FW]Q_Y"%<!3'7#E%HFY1FZ.4UM=<.B.#=9DBU7"%%:(A?G1CX/T'=O,
MYOO?KPUX5V(;EBX.01RZW6U_6*'%H&1!Y&4BRAE4'I1K`&5/0/D343JKW1H`
M?>A#N9112D6440&R/PH@2C: LGJ-M3>^0WD64;)EE#D(93>=#'!1]D64@ &E
MO$ Y&%$B9I06"&6^1"F943(<E/R#>)C],69_F$:4%0_E:T1)&U!>P!_?!W__
M!T#)&U!ZW!@%^5Q1LD<44('E,;P1YU#.3(]W;E>S:A</U,W)@;EZ*$=E$Z
M@W,YY%P])#31U7/3!6G6=5+9573;=6G=A35*MVGAU73C15-1-VKI56IL<R7M
ME6KOI76M-E^P)FMA-SAYLE^W]E2Y%E6[=DB3XVMLAU5O%TG$1DESUV#(!F'+
M-FT>=E9_5Q!_EU9 2&T;-A!&V%;;QGA.^'@L$7F3%WGE9A.8IWG*P'F<=P*@
M5!2@]X7KQ@B@)(;^X!2@% %GB(;^H(:JMWI97I#)GM&Y@](!DIJ`4HW`$IO
M`4IQ`4KDXP].($I:$&51-@#")WP[0'R@9!B@! R-_^B(_L 8H)1_O 8H'0,
MH%09H 0&7+8_G7%*U5<%9&9F_H!FH"0;H/0.HA1^#D1^NV%^I_!QC0!*Q %*
M-&"+M^@/Q !*S@%_HC1_=X90>L90?/90_1<S@79<%95<`LA<!9AHS[5SC;:
MU15TUS5I#^A$EA9%2.==FG9%3*=%GD9>7D0VYS5U'5AUIG9U<.->=.-&<5U
M!;&$AR=BW.:$)P:%+N8/DJ>1&]E75N@/,Z83HM1YH^2%HH04ID2&9KB&:7B&
M0%85R9DL8<.H#1[=3A*>?_H#WOH#WWH#W^(%TVB/Y@B$-)E,$72L4W2I"8
M&)-(B93(?)EX#IO8B='G#V F9F2&?=EGBOZ BOZ@BN"'&Z(D,6X6'*:4B^NG
MB[QH`[[H#[D%C"C'6]R!?2H?R[W9_Z7C !H43:'48?VC#J'@(PF72)%7235
M@-A%=-JX4A/X7188CDY'CN8E:NA%1NKX@5B"=:H&CZPF7T1%7WU3CRE8:WS"
M7[CV7U(E8#-(8+6D,&F50I6D#MXD&$588&7$'LWA-;FD$28A-+&A+%4D199
M8E8@!QDY2AU9A99'8YD72B2)/"8Y>B@9ADP!2BNIAJG'DJL'DVXHD_5&D_<V
M&7'41V:B&$I;Z1JG" .IZ'UB&4IDV7&R.(O^`&=IF9:[Z ^]Z);P9W+^$(PJ
M=S(L5XS#!7/(.%&#QI?+]9<%PE&*)I@%U*/5HTFE9@I%8'<V%+?R&D8.(X:
M:(Z4B8Z6J5.GUHXB^(Y!Y9FO1H]R,IIC5YHMN(PV(R6%6M:8/"!G>QJ8->
MY6"U^8,/B1"YV9"%EW?71G@2J6W!J7C#66)J8)PCY@_[0'D:284?&9(L85<
MZ _0211@R&[467IE^ 4NN8;8^9*LUYUP.),U*9ZUYP_D_ZF3YLF3Z/F34#:4
MA?B>.D/A+&(]4*?D>B4][DOF.@/FN@/G,B?57F5`6I]IP%*!<H.!YJ@8;F@
M#P2+LDB+&(.6N5BA%QI_;JFA''I_'II_#A6B$?5_)<J,?3F ! *8*_I1A/FB
MAVF-#JB81B>!W4B!+W6!XCA3H,:C4H=3'C@E0>I3FUFDOB9)PAV@9-?*YB/
M9O>":*>:4EJ#;E>E.,A5!JFE=F>;1PAMNOFE!E&$K41AA"=XOSF1V[9X:1H'
M1"FH/2F';F1,K:<((EY=8JG0%&2>KIN?,JGI&=ZV=F2VF=_N!Z)1N'1?8&
MM!<$.%F>Y^F'ZCFIOQ=*4)F?J2DL)B9(8B3(P2J$ZJL]WJ@`:BEHI!-KG
MJJ'4?;%Z&ZY8?AT''!_W`:.4BZ'4?J'T?KVJH1N:<L#Z'1]JE8HHC*GC &8
MK,Z8H@8(78.I@(7)@-(JHY7&F-?JF. 84QG8K395F>JUCB"HF2/(F5LW5$?Z
M=:*YKF+7KDQ:=J?)CVFWFFMW5?4*FSEH;#Q8=SZHD,6;4KH;(+GKP)[FUZ:
M;;"S;:!48JL4!VL*3,'D55D/#=&6(4U+=8);] #34&F%7%836(!64GV/9/5
M;Y6U+NOI+NFC651F</>"+PEW/UHV6@X'3_30&6F6FC&6AGG6K+*3[(%<K2%
MYHT56+>=QJU0YZT<^*-6U[="FG6 6X+HBJ1X9+CWR$>)JX]GEYK^Z+@`2:62
M9KOT1DV/=4WDXKM+1EGJ0A??A%G%.V7S4F4'=V7XF67M]+RF)4^H14_4>W'X
MI'%,ZP^PU4]O=JNX^+VXI5OC*XQTJ3)@2ZR 1J+LVXPHZC/QJ[8MZG.&:;]"
M1VD0N(W[BZU+9[<ZBK?G"*Z7*:[L2*Y_:ZZ"ZW6AF:0.3)J'_Z.X+HB:,=AK
MK$FO`FFO!(FE=(>0=_=)*+')G-S)I=3)H+S)`QO*H2RZB+<2;I#*JKS*J8P/
M;O [JSM,K2M8R%18R[04S918..R=.FQ-2(9-^9DP2O$PYL7`R<8QVL8G85P
M6*9PH@4P_=D_8'9:TZLPU8MQ^;1QVNL;_M2]R>'%)2>^]2?&YDO&Z/MRQ:J7
MQUIS)_J^;!R8^NB/Q=IUSAT,VK'C7FCVAJ9.YJW/KJWF)E&!URN5C(H!EK
MZII42[K($@RO%!RE- BYDYS!<I>E/9B0$F8'&KW1'-W1'OW1'$TK( W2M *<
MPW+2>Q7+PC/+K^LLMOQN-[Q8O.Q8OO^L;S[,;]QD6>>#/N]BO$>,O(G!S$OL
MS,T+S>_TQ-*;6M9,Q6KV6MM<,=PKH1D#SN$;,K]:OEXKK/N'SF<<O(SC>W
MK/ +SPDHSW%,S]-ZSW)KH_V+H]OZ=.7HSWX,I('LCO#5F><ZN(?<P J-N S]
MKHX,I9#N,"&8%8ZN?EZT9G<.HS=V+IBTBB-TBXLRS!,RS./#"MRS*-NS.Y
MP[_<P]H$Q+M'S#M]S.SSTIL9<K;S,S;Q-$,O=2LU/9DO=G,9D_=S5+]S2/W
MQ>+,M5B-,EI]E<XMGN)K.TLUN_<K&4-QVY[O_8<MT?'UMD*F7<;P')-=71M
MP(),I 7==0?_C8*)O-!,U:03_,C_.*61.VP:;-&6B]&._=[P#9PD,=_T7=_V
M?=_XG=_ZO=_W=_^_=`OKFP%. $7N &?N (GN *ON ,WN @8::K%.$2/N$4
M7N$6?N$8GN$:ON$<WN$>_N$@'N(B/N(D7N(F?N(HGN(JON(L?DJQ`^$.'N,R
M/N,T7N,V?N,X#N O3L(4!DJQD^,/0<I"SLE="N1&?N1(GN1*CN0[#DL]#F(9
M40=%KN-G)>7 |
| Similar Threads | Posted | | 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 |
| Re: Item Movement with On Hand & Reorder | November 17, 2007, 11:56 pm |
| Discrepancies between on-hand quantity and item movement report | September 12, 2007, 12:24 pm |
| Item movement report should include quantity on-hand. | September 17, 2007, 1:30 pm |
| quantity on hand needs to be included in item movement report | February 4, 2008, 1:54 pm |
| Report on the item movement report should show qty on hand as we | September 1, 2005, 10:37 am |
| how do I match the Edc Batch time to match my local time | September 7, 2006, 8:39 pm |
| Item Movement/Movement History and Item Qty reports | October 13, 2005, 9:24 pm |
| Mix and Match with RMS | September 7, 2005, 11:34 am |
| Mix and Match / Discounting (HQ) | January 6, 2006, 6:58 pm |
|
|