Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

Ordering a sub for a stock item process

 6 Replies
 3 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
brupp
Veteran Member
Posts: 165
Veteran Member
12/12/2017 6:38 PM

    Hello - looking for process improvement to order subs for stock items.  Currently we order the sub as xtype, then IC20 receive it under the Lawson number being subbed.  It makes for difficult order entry, we sometimes hit the wrong account which makes Finance fuss, sometimes our average cost gets out of whack, etc.  It's a broken process from the start, so we are wide open to any & all suggestions - thanks in advance!!

    Kat V
    Veteran Member
    Posts: 1020
    Veteran Member
    12/12/2017 7:19 PM
      We order as X and use negative qty on IC21.2 - this brings in the GL from IC12 and allows us to say Last Issued and letting the "cost adjustment" stay on the expense side *OR* enter the unit cost and let the average cost adjust accordingly.

      But yes, broken from start to finish here too!
      Mike Bernhard
      Veteran Member
      Posts: 101
      Veteran Member
      12/13/2017 9:20 AM
        I think Kat's process is just about as good as it gets with the Lawson IC / PO functionality. I would suggest two additional tips.

        1. Have the buyer add a note to the PO (print on receiving documents) that says something to the effect of "deliver this item to (inventory manager name); this item is a sub for Item # 44556". This way the inventory manager is alerted that they must perform an IC21.2 with a negative quantity to put the item into stock. Without this note, the item could easily end up on the shelf without a transaction.

        2. Always use the Material Management Accounting Unit for this "X" PO line. This way the inventory manager knows what AU to use when they perform the reverse inventory issue (to put the quantity in inventory). Also, it makes it easier for the inventory manager to verify that all items ordered as subs were appropriately added to inventory (using the MM80 inquiry screen or the MM280 report or whatever data extract tool you have access to)
        Kat V
        Veteran Member
        Posts: 1020
        Veteran Member
        12/13/2017 1:48 PM
          Oh - I forgot our new sub report!

          On PO20, when the buyer adds the sub, they put in the User Analysis field "SUB FOR [ITEM]" - we have an IPA running a sql for the X items for the past 3 days for the location and then printing in the department at 7am daily. This worked better with the centrals and their pallets and the EDI receipts vs manual receipts.
          Mike Bernhard
          Veteran Member
          Posts: 101
          Veteran Member
          12/13/2017 4:30 PM
            Kat - That's brilliant! Great process improvement.
            brupp
            Veteran Member
            Posts: 165
            Veteran Member
            12/18/2017 7:06 PM
              Thanks to you both for your responses. I reviewed IC21.2 with our Materials & Finance leaders and we are proceeding with the process change. Anyone know if ordering with the existing Lawson number along with PO20.7 Substitute Vendor Item is an option? Of course the sub to be shipped automatically would have to be pre-arranged with the vendor, I would think...
              David Williams
              Veteran Member
              Posts: 1127
              Veteran Member
              12/18/2017 7:11 PM
                I think that only works in the M3 world?
                David Williams