PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 05/18/2016 11:47 AM by  JonA
Crystal Par Stock Out Report
 5 Replies
Sort:
You are not authorized to post a reply.
Author Messages
bcarmichael99
Manager of Distribution
Private
Basic Member
(11 points)
Basic Member
Posts:5


Send Message:

--
05/10/2016 11:41 AM
    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
    Private
    Private
    Veteran Member
    (2766 points)
    Veteran Member
    Posts:972


    Send Message:

    --
    05/10/2016 12:22 PM
    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 - Supply Chain Analyst - Materials Management - MidMichigan Health
    bcarmichael99
    Manager of Distribution
    Private
    Basic Member
    (11 points)
    Basic Member
    Posts:5


    Send Message:

    --
    05/10/2016 12:59 PM
    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
    Private
    Private
    Veteran Member
    (2766 points)
    Veteran Member
    Posts:972


    Send Message:

    --
    05/10/2016 1:43 PM
    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 - Supply Chain Analyst - Materials Management - MidMichigan Health
    bcarmichael99
    Manager of Distribution
    Private
    Basic Member
    (11 points)
    Basic Member
    Posts:5


    Send Message:

    --
    05/18/2016 9:09 AM
    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
    Private
    Private
    Veteran Member
    (2766 points)
    Veteran Member
    Posts:972


    Send Message:

    --
    05/18/2016 11:47 AM
    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 - Supply Chain Analyst - Materials Management - MidMichigan Health
    You are not authorized to post a reply.