Who's On?

	Membership:
	Latest: Raju
	Past 24 Hours: 1
	Prev. 24 Hours: 2
	Overall: 5205

	People Online:
	Visitors: 740
	Members: 0
	Total: 740

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1369
Roger French	1315
mark.cook	1244

Crystal Par Stock Out Report

5 Replies

1 Subscribed to this topic

22 Subscribed to this forum

Sort:

Author

Messages

bcarmichael99

Basic Member

Posts: 5

5/10/2016 3:41 PM

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: 1163

5/10/2016 4: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?

bcarmichael99

Basic Member

Posts: 5

5/10/2016 4: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

Veteran Member

Posts: 1163

5/10/2016 5: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.

bcarmichael99

Basic Member

Posts: 5

5/18/2016 1:09 PM

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: 1163

5/18/2016 3:47 PM

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?