Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

Cycle Count Accuracy

 4 Replies
 1 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
Me
Veteran Member
Posts: 96
Veteran Member
2/19/2019 4:47 PM
    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
    Veteran Member
    Posts: 1020
    Veteran Member
    2/19/2019 6:34 PM
      On ITEMLOC table are LAST_COUNT_DT and CNT_ACCURACY fields that will tell you that by item.
      Me
      Veteran Member
      Posts: 96
      Veteran Member
      3/1/2019 1:22 PM
        Thanks Kat.  Is there a table the stores the actual counts?
        Mike Bernhard
        Veteran Member
        Posts: 101
        Veteran Member
        3/1/2019 1:33 PM

          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
          Veteran Member
          Posts: 1020
          Veteran Member
          3/4/2019 8: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..