Who's On?

	Membership:
	Latest: Saef
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5226

	People Online:
	Visitors: 208
	Members: 0
	Total: 208

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

Analytics on Killed Orders

2 Replies

2 Subscribed to this topic

38 Subscribed to this forum

Sort:

Author

Messages

bcarmichael1

New Member

Posts: 1

12/29/2015 4:25 PM

We use Mobile Supply Chain Management for our warehouses. If a picker is told to pick an item or unable to completely fill the requested item, we have a stockout board the picker is supposed to write the item number on. If I wanted to compare who killed items while picking with when the item was last adjusted, what would be the best method. I have a pretty good knowledge of queries through addins but no knowledge on LBI. Can this be figured out through queries, if so what forms should I query?

Stephanie

Veteran Member

Posts: 86

12/29/2015 4:42 PM

I would think you would want a report that relates at least WHSHIPLINE, REQLINE and ITEMLOC. Also adding in ITEM MAST, RQLOC would give you more detail.

Hope this helps!

David Williams

Veteran Member

Posts: 1127

12/30/2015 12:26 PM

For Analytics on killed quantities, you can query the shiplines for what was killed during picking but you may also want to look at ictrans to compare the Original-Qty to Quantity to find what was killed when the requisition was processed (when using Fill or Kill set to Kill).