D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Need Help With Cycle Count Functionality

  • 1.  Need Help With Cycle Count Functionality

    Posted Jun 20, 2017 10:23 AM
    Hi all,
    I appreciate any help you can give me on the cycle count functionality for Dynamics 365.  Here is my dilemma.  I have Planned Cycle Counting and Spot Cycle Counting set up they way it is supposed to, and it works on the mobile device, however,  when we do a cycle count of an item in a specific location, it is requiring us to do cycle counts of ALL items in that location.

    Here is an example.  We want to spot cycle count an item that is in our Picking location.  The picking location has over 500 unique items in it.  We only want to do a count on one of them.  When we select the item we want to count, it is setting all of the other items as if we counted zero.  I can see this when we go to review the cycle count to approve or reject.  We obviously don't want to have to go and reject all of those items in the picking location that we didn't really count.

    Is there a way or settings that would allow us to only count one specific item in a location without requiring a count of all of the items in that location?

    I appreciate any help and insight on this.
    -Lori

    ------------------------------
    Lori Bolene
    Premier Designs
    Irving TX
    ------------------------------
    Digital Acceleration Binge Day.  January 28th 2021 | 11:00 AM - 2:00 PM EST


  • 2.  RE: Need Help With Cycle Count Functionality

    D365UG/AXUG ALL STAR
    Posted Jun 20, 2017 02:26 PM
    Hi Lori,
    I know this was originally a gap in the cycle counting functionality and MS had plans to release a hotfix for the Spring release but I'm not sure if that has been released yet.

    ------------------------------
    Andrew Lencsak
    Senior Application Consultant
    eBECS
    Atlanta GA
    ------------------------------

    Digital Acceleration Binge Day.  January 28th 2021 | 11:00 AM - 2:00 PM EST


  • 3.  RE: Need Help With Cycle Count Functionality

    Posted Dec 16, 2020 10:56 AM
    Lori - we have the same needs as your company, in which we only one to count certain items within a location. Were you ever able to find a solution?

    ------------------------------
    Eddie Smith
    Universal Leaf Tobacco Company, Inc.
    Richmond VA
    ------------------------------

    Digital Acceleration Binge Day.  January 28th 2021 | 11:00 AM - 2:00 PM EST


  • 4.  RE: Need Help With Cycle Count Functionality

    Posted Dec 17, 2020 08:33 AM
    Edited by Paul Taylor Dec 17, 2020 08:33 AM

    Hi Lori, 

    The process you described of counting all items in the location is the standard cycle count functionality to my knowledge.  The cycle counting logic is based on counting all items in a location.  I am not aware of another way to do this, outside of using inventory count journals which of course does not support the mobile device.  

    If you wanted to explore inventory count journals a bit more, there is a PowerApp option to execute those counts.  Check this out - Scenario 3: Inventory Counting Assistant

    Microsoft remove preview
    Scenario 3: Inventory Counting Assistant
    An important aspect of any business dealing with products and inventory is to periodically compare system inventory records against the actual physical stock in the stores and the warehouse locations. In Finance and Operations, one way to reconcile inventory is to use Inventory Counting Journal.
    View this on Microsoft >

      



    ------------------------------
    Paul Taylor
    Avanade
    ------------------------------

    Digital Acceleration Binge Day.  January 28th 2021 | 11:00 AM - 2:00 PM EST


  • 5.  RE: Need Help With Cycle Count Functionality

    Posted Dec 17, 2020 08:57 AM

    Hi Lori,

    I may be misunderstanding part of the challenge but have you reviewed your cycle count work templates to see if they are set to break by item?  Please reference the Microsoft documentation below for partial location cycle counting.

    https://docs.microsoft.com/en-us/dynamics365/supply-chain/warehousing/partial-location-cycle-counting



    ------------------------------
    Michael Sigler
    Rangeline Solutions
    ------------------------------

    Digital Acceleration Binge Day.  January 28th 2021 | 11:00 AM - 2:00 PM EST


  • 6.  RE: Need Help With Cycle Count Functionality

    Posted Dec 17, 2020 09:12 AM

    Great suggestion Michael!  Just confirmed that works as advertised.  Was able to create cycle count work for specific items in a location.  



    ------------------------------
    Paul Taylor
    Avanade
    ------------------------------

    Digital Acceleration Binge Day.  January 28th 2021 | 11:00 AM - 2:00 PM EST


  • 7.  RE: Need Help With Cycle Count Functionality

    Posted Dec 17, 2020 03:16 PM

    Yes, thanks Michael and Paul. I was able to do so as well. One more question, is there a way to randomly count some items in a location without predefining the actual items being count (i.e. like spot counting, but not bring back all of the items in a location, just the ones the user has counted)?



    ------------------------------
    Eddie Smith
    Universal Leaf Tobacco Company, Inc.
    Richmond VA
    ------------------------------

    Digital Acceleration Binge Day.  January 28th 2021 | 11:00 AM - 2:00 PM EST


  • 8.  RE: Need Help With Cycle Count Functionality

    Posted Dec 17, 2020 05:17 PM

    I am not aware of a way to spot count without counting the entire location.  You could perhaps have a ad-hoc cycle count plan that would be setup to do partials, as mentioned above, and update that plan based on what you intend to count.  I know this is not an ideal solution but perhaps a workaround option before pursuing a mod.



    ------------------------------
    Michael Sigler
    Rangeline Solutions
    ------------------------------

    Digital Acceleration Binge Day.  January 28th 2021 | 11:00 AM - 2:00 PM EST


If you've found this thread useful, dive deeper into User Group community content by role