PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 03/04/2019 3:52 PM by  Kat V
Cycle Count Accuracy
 4 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Me
Supply Chain Informatics Manager
Private
Veteran Member
(192 points)
Veteran Member
Posts:96


Send Message:

--
02/19/2019 11:47 AM
    We're looking to create a custom report for cycle count accuracy.  I know there's an ICACCURACY table but we're wanting to get down into the items themselves.  Do historical item counts get stored somewhere?  I cant seem to find that table.
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2824 points)
    Veteran Member
    Posts:966


    Send Message:

    --
    02/19/2019 1:34 PM
    On ITEMLOC table are LAST_COUNT_DT and CNT_ACCURACY fields that will tell you that by item.
    Me
    Supply Chain Informatics Manager
    Private
    Veteran Member
    (192 points)
    Veteran Member
    Posts:96


    Send Message:

    --
    03/01/2019 8:22 AM
    Thanks Kat.  Is there a table the stores the actual counts?
    Mike Bernhard
    Lawson Supply Chain Consultant
    Trident Edge Consulting
    Veteran Member
    (294 points)
    Veteran Member
    Posts:100


    Send Message:

    --
    03/01/2019 8:33 AM

    I don't believe so.  I haven't looked into this since version 9.x, but in the past it has been a bit challenging to analyze this.

     

    As mentioned above, you can get the last count date.  From there you can use ICTRANS to find PI adjustments.  When there is no adjustment the count was 100% accurate. Unfortunately, ICTRANS does not record PI COUNTS unless there is an adjustment

    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2824 points)
    Veteran Member
    Posts:966


    Send Message:

    --
    03/04/2019 3:52 PM
    Yeah - *while they're frozen* you can monitor the counts on ICFREEZE, but the second you post IC175, it becomes a PI transaction. You can see it on the ICTRANS table, but it's the result, not the count. You have to add SOH_QTY to QUANTITY to get the count.

    For example - I go to the shelf and count 5 on an item. This creates a +1 Transaction. On the ICTRANS, SOH_QTY: 4, QUANTITY: 1
    Or if we were short: Count 3 creates: SOH_QTY: 4, QUANTITY: -1

    Look for Doc Type "PI" and you should see them, but I don't know how to find the "last" one and it won't show at all if the count was correct..
    You are not authorized to post a reply.