http://forums.method.me/cs/forums/13.aspxAsk technical support questions, how do I? Questions... Or anything else you want to know from the Method Team and other Method users.enCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/thread/25062.aspxSun, 04 Jan 2015 02:16:15 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:25062fran0http://forums.method.me/cs/forums/thread/25062.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=25062<p><span id="mce_0_start" style="overflow:hidden;">HI Marcelo,</span></p> <p><span id="mce_0_start" style="overflow:hidden;"></span><span id="mce_18_start" style="overflow:hidden;"><span id="mce_42_start" style="overflow:hidden;">That is always a</span></span>&nbsp;challenin<span id="mce_44_start" style="overflow:hidden;"></span>g<span id="mce_45_start" style="overflow:hidden;"> question</span>.<span id="mce_43_start" style="overflow:hidden;"></span> <span id="mce_3_start" style="overflow:hidden;"><span id="mce_49_start" style="overflow:hidden;"></span><span id="mce_7_start" style="overflow:hidden;"><span id="mce_51_start" style="overflow:hidden;"></span>A<span id="mce_39_start" style="overflow:hidden;"></span>sssume you are going <span id="mce_11_start" style="overflow:hidden;"></span>after In<span id="mce_53_start" style="overflow:hidden;"></span>ventory Cost.</span></span>&nbsp;<span id="mce_31_start" style="overflow:hidden;"> You could take the last purchased cos<span id="mce_65_start" style="overflow:hidden;"></span>t times Qty on Hand<span id="mce_32_start" style="overflow:hidden;"> t<span id="mce_33_start" style="overflow:hidden;"></span>hru <span id="mce_36_start" style="overflow:hidden;"><span id="mce_38_start" style="overflow:hidden;"></span></span><span id="mce_40_start" style="overflow:hidden;"></span>R<span id="mce_40_end" style="overflow:hidden;"></span>etreive Value from table co<span id="mce_54_start" style="overflow:hidden;"></span>mmands<span id="mce_46_start" style="overflow:hidden;"> and so<span id="mce_56_start" style="overflow:hidden;"></span>me math calculation</span>.&nbsp;</span></span><span id="mce_1_start" style="overflow:hidden;"><span id="mce_2_start" style="overflow:hidden;"></span><span id="mce_2_end" style="overflow:hidden;"></span><span id="mce_25_start" style="overflow:hidden;"><span id="mce_26_start" style="overflow:hidden;"><span id="mce_27_start" style="overflow:hidden;"><span id="mce_28_start" style="overflow:hidden;"><span id="mce_29_start" style="overflow:hidden;"></span></span></span></span></span><span id="mce_30_start" style="overflow:hidden;"><span id="mce_34_start" style="overflow:hidden;">What <span id="mce_58_start" style="overflow:hidden;"></span>cost<span id="mce_58_end" style="overflow:hidden;"></span> you want to use for Qty<span id="mce_59_start" style="overflow:hidden;"></span> <span id="mce_59_end" style="overflow:hidden;"></span>On Hand is the main question<span id="mce_61_start" style="overflow:hidden;">, since cost is a single event and Qty on Hand is<span id="mce_66_start" style="overflow:hidden;"></span> an accumulation of events.<span id="mce_64_start" style="overflow:hidden;"><span id="mce_68_start" style="overflow:hidden;"><span id="mce_70_start" style="overflow:hidden;"> Otherwise use the Inventory Vavluation Report from QB.&nbsp;</span></span></span></span></span></span></span></p> <p><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;">Hope that helps..<span id="mce_63_start" style="overflow:hidden;"></span> Fran<span id="mce_62_start" style="overflow:hidden;"><span id="mce_67_start" style="overflow:hidden;"><span id="mce_69_start" style="overflow:hidden;"></span></span></span></span></span></span></span></p>http://forums.method.me/cs/forums/thread/25041.aspxFri, 02 Jan 2015 04:01:44 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:25041Marcelo117560http://forums.method.me/cs/forums/thread/25041.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=25041<p><span id="mce_0_start" style="overflow:hidden;">In the inventoty item table I have a field &quot;purchsed cost&quot; and &quot;quantity on hand&quot;, is there a field that ill give me the total amount for each item depending how many I have on hand o do I have to use actions to get that number. If this is the case, will you point me in the right direction.</span></p>