Home Page link  

Movement does not match On Hand

 

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

 Post an article  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
Movement does not match On Hand Jason 10-26-2007
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(06&#1Q!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 ThreadsPosted
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

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