actually i think "on hand" in the option means the InventSum table, it selects out items which have an "unclosed" inventsum record, as long as the items has transactions before, it will be selected out.
if you really want items with on hand balance, and if you are generating counting journal trans using "today" date, you can click on the select button, link the inventsum (on hand) table to the selection, use the field PhysicalInvent != 0 as selection, then you will have only items with actual balance (could be +ve or -ve). this only works if the coutning date is today, if you r back dating, it won't works, cause today non-zero does not means last week also non- zero. www.prorsus.com --- In Axapta-Knowledge-Village@yahoogroups.com, "Jens Strandberg" <[EMAIL PROTECTED]> wrote: > > Hello, > > Thanks for your feedback. > > Yes, you are making sense. However, since the report is explicitly called > "On-hand", I would have expected to display those lines only. > > I understand your point, but this should be a separate menu item, I would > prefer. > > /Jens > > -----Oprindelig meddelelse----- > Fra: Axapta-Knowledge-Village@yahoogroups.com > [mailto:[EMAIL PROTECTED] vegne af Yifat Mervis > Sendt: 13. januar 2006 08:44 > Til: Axapta-Knowledge-Village@yahoogroups.com > Emne: RE: [Axapta-Knowledge-Village] Counting journal bug ? > > > > Hi there > > > > As far as I know, when you create the lines in the journal, it create lines > for items which have had transactions against them, it will not create lines > that have on-hand quantities only. I don't believe this is a bug... > > > > Think of this situation, item A and Item B, both have transactions against > them. According to Axapta there is nothing on hand for A, and 5 for B. > However, there is some A in on-hand in the real warehouse (i.e. the original > stock count was incorrect or the wrong batch number was sold). If the > journal does not contain item A, then the user will not count item A, and > then you would loose control of item A i.e. theft > > > > I hope I am making sense... > > > > Good luck > > > > ______________________________________ > > Yifat Mervis > > > _____ > > > From: Axapta-Knowledge-Village@yahoogroups.com > [mailto:[EMAIL PROTECTED] On Behalf Of Koh Meng > Chiat > Sent: Friday, January 13, 2006 3:31 AM > To: Axapta-Knowledge-Village@yahoogroups.com > Subject: Re: [Axapta-Knowledge-Village] Counting journal bug ? > > > > Hi Jens, > > > > Can you check on the counting group (and the counting code in the counting > group) attached to the item in the item master file? If i not not mistaken > if you leave the counting group blank for the item then the quantity with > zero stock on hand will be included in the counting journal. > > Jens Strandberg <[EMAIL PROTECTED]> wrote: > > Hi there, > > I was wondering if anyone has experienced this strange behaviour; running > Axapta 3.0 SP3. > > If I let Axapta create an on-hand counting journal based on warehouse, batch > number and location, a lot of empty lines are included, i.e. lines with an > On-hand qty of 0. > > In my case, 7.147 journal lines are produced, but only 527 lines are with a > quantity. > > In the past, I have also produced counting journals based on warehouse and > location - with the same result - empty lines. > > Has this been reported as a bug, is there a work-around or am I just missing > something ? > > Thanks in advance. > > /Jens > > > > > _____ > > > Yahoo! Photos - Showcase holiday pictures in hardcover > Photo > <http://us.rd.yahoo.com/mail_us/taglines/photobooks/*http:/pa.yahoo.c om/*htt > p:/us.rd.yahoo.com/mail_us/taglines/photos/evt=38088/*http:/pg.photos .yahoo. > com/ph/page?.file=photobook_splash.html> Books. You design it and we'll bind > it! > > > > > > > > Yifat Mervis > Consultant > Application Support > > > > Helpdesk: 0860 123 321 > Direct: 011 797 4768 > Mobile: 082 355 4011 > Fax: > Email: [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > Web Site: http://www.exordia.co.za/ > <http://www.exordia.co.za/> > > NOTICES: > The information transmitted is intended only for the person or entity to > which it is addressed and may contain confidential and/or privileged > material. Any review, retransmission, dissemination or other use of, or > taking of any action in reliance upon, this information by persons or > entities other than the intended recipient is prohibited. If you received > this in error, please contact the sender and delete the material from any > computer. > > > > Sharing the knowledge on Axapta. > Visit www.frappr.com/axapta for axapta friends. > > > > > SPONSORED LINKS > Business finance course Business to business finance Small > business finance > Business finance consultant Business finance magazine Business > finance schools > > _____ > > YAHOO! GROUPS LINKS > > > > * Visit your group " Axapta-Knowledge-Village > <http://groups.yahoo.com/group/Axapta-Knowledge-Village> " on the web. > > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED] subject=Unsubsc > ribe> > > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service > <http://docs.yahoo.com/info/terms/> . > > > _____ > Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
