Physical Inventory List

  • Physical Inventory List

    Posted by DSC Communities on January 31, 2017 at 4:27 pm
    • Debra Rohlik

      Member

      January 31, 2017 at 4:27 PM

      We are on NAV2016 and have lot tracking turned on.  When printing the physical Inventory list and selecting show serial/lot number, we have pages of lots printing that have zero qty. 

      Do all of the lots always print?  We have only been using lots for 3 months and I can’t imagine how long that list will be at the end of 2017. 

      ——————————
      Debra Rohlik
      Accounting Process Manager
      Farmers Union Industries, LLC
      Redwood Falls MN
      ——————————

    • Rick Dill

      Member

      February 1, 2017 at 11:07 AM

      Hi Debra,

      Unfortunately yes, all lot would print, why you ask? because during a physical inventory, you don’t know what you might find for the actual lot number found in inventory. I know you think the lot you have should be the log NAV shows in inventory, but that is only true if people picked and recorded the correct lot when processing transactions.

      So what is the fix? This is relatively simple to fix because it is a printing issue. You can ask your VAR to make a change to print only certain lots. What should print would vary for each company, depending on inventory turns, lot segregation practices, etc.

      If you can define for your VAR what lots you would to see (such as only lots with remaining inventory, or created in the last 6 months, etc.), then they could print only the lot number that comply with your requirements. remember you will need a procedure on how to handle a lot that was “Counted” but not on the list

      ——————————
      Rick Dill
      Consultant
      ArcherPoint Inc.
      Waupaca WI
      ——————————
      ——————————————-

    • Caroline Brichford

      Member

      February 2, 2017 at 4:40 AM

      We are on Nav 2009 and do not use lots we use the physical inventory journals for our process.  We are able to filter out zero items from printing. As well as many other filters, shelf locations, divisions etc.  We have thousand of zero qty items and  it works.

      ——————————
      Caroline Brichford
      Furukawa Rock Drill USA
      Kent OH
      ——————————
      ——————————————-

    DSC Communities replied 8 years, 7 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Physical Inventory List’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!