Crystal Par Stock Out Report

Sort:
You are not authorized to post a reply.
Author
Messages
bcarmichael99
Basic Member
Posts: 5
Basic Member
    I am looking for a way to use a crystal report to show when items stock out for our par locations. I have tried querying multiple different ways but everytime I do, it throws off the number because we have updated the par level. I need a way to include whatever the par level was at the time the count was completed. Any help would be greatly appreciated.
    JonA
    Veteran Member
    Posts: 1162
    Veteran Member
      So this has nothing to do with inventory stock outs? You want to know when an end user counts a par and enters 0 (zero) as the count for an item? And over a certain time period?
      Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
      bcarmichael99
      Basic Member
      Posts: 5
      Basic Member
        Correct, but I also want to be able to use this same report for determining average daily usage and standard deviations to be able to apply statistical analysis to par levels. I am concerned if I bring in the par level it will skew my data as the par level may not have always been that level.

        JonA
        Veteran Member
        Posts: 1162
        Veteran Member
          I think you may have to pull two sets of data and combine them. REQLINE for your order history and then ITEMLOC and ICAUDIT to figure out par levels for the time period you're looking at.
          Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
          bcarmichael99
          Basic Member
          Posts: 5
          Basic Member
            I actually figured it out. The quantity field in the event_line table in MSCM is what they actually counted. The par level at the time of count is also stored in one of the generic number fields on that same field. Would have saved me a lot of time if the data dictionary mentioned that.
            JonA
            Veteran Member
            Posts: 1162
            Veteran Member
              I didn't think about going to the MSCM tables. I don't have a database connection to the MSCM server so I was only looking at Lawson. I should ask IT if I can get that. Is the MSCM server Oracle or SQL?
              Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
              You are not authorized to post a reply.