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