D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Random Counting Journals | AX 2012 R2

  • 1.  Random Counting Journals | AX 2012 R2

    SILVER CONTRIBUTOR
    Posted Jan 08, 2020 12:34 PM
    ​Hi, we are running AX 2012 R2 and would like to know if there is a way to generate "RANDOM" counting journals.

    We wonder if anyone has had experience with this feature in AX 2012 R2.

    We really appreciate your feedback.

    Thanks!


    ------------------------------
    Armando Tinoco
    ERP Systems Admin
    Arizona Nutritional Supplements
    Chandler AZ
    ------------------------------
    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 2.  RE: Random Counting Journals | AX 2012 R2

    TOP CONTRIBUTOR
    Posted Jan 13, 2020 04:49 PM
    I don't have access to AX2012, but in D365, there is an inquiry form called "On-Hand List" and on this form there is a functionality trigger by a button of "Quantity Adjustment" allowing you to modify item quantity, effectively creating ad-hoc counting journal.

    ------------------------------
    Zvika Rimalt
    Functional Consultant
    Vancouver BC
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 3.  RE: Random Counting Journals | AX 2012 R2

    SILVER CONTRIBUTOR
    Posted Jan 14, 2020 10:55 AM
    Hi Zvika, thanks for your input.

    Actually, the "Quantity Adjustment" feature exists in AX 2012 within the On Hand form​, however, we are looking for something to generate automatically random counting journals based on some criteria.

    We have heard that AX 2012 R3 and D365 have "Cycle counting plans" and "Cycle count thresholds", unfortunately these features are not available in AX 2012 R2.

    Thanks!


    ------------------------------
    Armando Tinoco
    ERP Systems Admin
    Arizona Nutritional Supplements
    Chandler AZ
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 4.  RE: Random Counting Journals | AX 2012 R2

    TOP CONTRIBUTOR
    Posted Jan 14, 2020 01:53 PM
    It looks like we are not using the word "random" in the same way.
    Maybe if you gave an example of what you are trying to do someone can come up with a suggestion

    ------------------------------
    Zvika Rimalt
    Functional Consultant
    Vancouver BC
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 5.  RE: Random Counting Journals | AX 2012 R2

    Posted Jan 16, 2020 09:26 AM
    Check out RFSmart....we use them now for random cycle count...works great. Also use them for transfer orders, picking, receiving, etc.

    ------------------------------
    John Vaughan
    TD Associates LLC
    Egg Harbor Township NJ
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 6.  RE: Random Counting Journals | AX 2012 R2

    SILVER CONTRIBUTOR
    Posted Jan 16, 2020 02:10 PM
    Thanks John, actually we use RFSmart for most our WH processes.

    I'll take a look at the Random Journal Workflow and see if it meets the WH requirements.

    Regards,

     ​

    ------------------------------
    Armando Tinoco
    ERP Systems Admin
    Arizona Nutritional Supplements
    Chandler AZ
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 7.  RE: Random Counting Journals | AX 2012 R2

    TOP CONTRIBUTOR
    Posted Jan 17, 2020 09:39 AM
    Agree with Zvika, we need to be more clear on what we mean by "random." Most companies don't actually want it to be random, you yourself said "based on some criteria" which implies it's not random. Advanced warehousing gives more options like the thresholds and cycle counting plans but you first really need to define what that criteria is, then perhaps it could be achieved by creating an advanced query in your counting journals. The ISVs that offer random counting typically have some logic behind it as well to decide which items are "randomly" counted based on when it was last counted, ABC, high/slow movers, etc.

    ------------------------------
    Andrew Lencsak
    Solution Delivery Manager
    Arbela Technologies
    Irvine CA
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 8.  RE: Random Counting Journals | AX 2012 R2

    Posted Jan 17, 2020 09:44 AM
    They didnt have what we needed out of the box for cycle count and we paid to have it developed.

    Now if we create a counting journal by bin, you scan every item in it and it makes the quantity adjustment on the fly and posts the journal.

    ------------------------------
    John Vaughan
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


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