PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 12/18/2017 2:11 PM by  David Williams
Ordering a sub for a stock item process
 6 Replies
Sort:
You are not authorized to post a reply.
Author Messages
brupp
Mgr Supply Chain Systems
UC Health
Veteran Member
(333 points)
Veteran Member
Posts:143


Send Message:

--
12/12/2017 1: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
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2127 points)
    Veteran Member
    Posts:725


    Send Message:

    --
    12/12/2017 2: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
    Lawson Supply Chain Consultant
    Trident Edge Consulting
    Veteran Member
    (257 points)
    Veteran Member
    Posts:87


    Send Message:

    --
    12/13/2017 4: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
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2127 points)
    Veteran Member
    Posts:725


    Send Message:

    --
    12/13/2017 8:48 AM
    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
    Lawson Supply Chain Consultant
    Trident Edge Consulting
    Veteran Member
    (257 points)
    Veteran Member
    Posts:87


    Send Message:

    --
    12/13/2017 11:30 AM
    Kat - That's brilliant! Great process improvement.
    brupp
    Mgr Supply Chain Systems
    UC Health
    Veteran Member
    (333 points)
    Veteran Member
    Posts:143


    Send Message:

    --
    12/18/2017 2: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
    Private
    Private
    Veteran Member
    (3061 points)
    Veteran Member
    Posts:1031


    Send Message:

    --
    12/18/2017 2:11 PM
    I think that only works in the M3 world?
    David Williams
    You are not authorized to post a reply.