• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Enterprise Resource Planning & Manufacturing Lawson S3 Procurement

Report for number of picks by user

 4 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
JeanneS
Veteran Member Send Private Message
Posts: 49
Veteran Member
5/5/2010 11:43 PM
Can anyone tell me what tables should be used to create a report that lists the number of picks by user? Thanks.
Arvin Ojales
Advanced Member Send Private Message
Posts: 24
Advanced Member
5/6/2010 12:00 AM
You can get this info on shipment tables. WHSHIPMENT and WHSHIPLINE. Operator id exist on both tables, shipment lines has the quantities, you may need to analyze the quantity in shipment lines (in process qty, shipped qty, etc.) based on the shipment header status.

Arvin Ojales
David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
5/6/2010 9:41 AM
Just remember that the operator id that Lawson records is the id of the user who keyed the shipment on WH32 and that may not be the person who picked the goods. If you have MSCM then you can track this better.
David Williams
JeanneS
Veteran Member Send Private Message
Posts: 49
Veteran Member
5/7/2010 1:24 AM
We do have MSCM. What do you suggest to track this? Thanks.
David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
5/7/2010 9:25 AM
Within MSCM there is a Productivity Report. Try that first. If it won't do what you want, you can create your own report.
David Williams