PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 07/16/2019 10:24 AM by  Jason B.
Separating Stock/Non-Stock Deliveries Using Multiple Account Numbers
 6 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Jason B.
MMIS Coordinator
Private
New Member
(7 points)
New Member
Posts:3


Send Message:

--
06/18/2019 4:48 PM

    Our supply chain department wants to separate shipments from our main distributor into "stock" and "non-stock" pallets to ease delivery and put-away.  We have two ship-to locations, therefore the distributor provided one new additional account for each ship-to location.  We are fully integrated with this supplier via EDI/GHX (850, 855, 856, 810).

    We are struggling with how to route orders for non-stocked items to these new accounts, yet retain the same 2 original ship-to locations.  We do use Purchase From Locations for our vendors, although in most cases, there is only one pfrom loc loaded per vendor.  One thought was to employ an additional pfrom and create corresponding ED40 records that would associate the new pfrom with the new account numbers.  Going this route, however, seems that it may have major ramifications regarding setup and possibly create ongoing maintenance issues.  

    For instance, we have dozens of vendor agreements linked to this supplier/purchase from.  Since the agreements are linked to the supplier via the pfrom, would we have to identify all non-stocked items for this supplier and then break them out onto separate agreements tied to the new purchase from location?  Also, if you have one pfrom loc for stocked items and one for non-stocks, there doesn't appear to be any way for a requester to place a combined stock/non-stock requisition.  They would have to know that they are ordering stock or non-stock up front so that they are choosing the appropriate pfrom on the req header, correct?

    Perhaps I'm missing something and just overthinking it.  Has anyone else has gone down this path and if so, how did you do it?

    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2456 points)
    Veteran Member
    Posts:838


    Send Message:

    --
    06/19/2019 3:27 PM
    Our inventory departments created a non-stock par location. The IC81 gives all the non-stock their own location, own account. They then worked with Cardinal (our med surg) to have it on separate pallets from the stock location req loc.
    Jeff N
    Private
    Private
    Basic Member
    (48 points)
    Basic Member
    Posts:28


    Send Message:

    --
    06/21/2019 9:07 AM

    I am pretty certain you can use the "DEPT" translation table entries to accomplish this.

    JonA
    Private
    Private
    Veteran Member
    (3104 points)
    Veteran Member
    Posts:1094


    Send Message:

    --
    06/27/2019 3:10 PM
    We worked with our distributor to put the stock order on separate palates. We didn't need to do anything internally. They can identify our stock order because it has 70-80 lines or more. Any other orders (the nonstock orders) are palatized together separately.
    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health
    Jason B.
    MMIS Coordinator
    Private
    New Member
    (7 points)
    New Member
    Posts:3


    Send Message:

    --
    07/03/2019 6:22 PM

    Thank you all for your replies and information, it is much appreciated!  Unfortunately, we are still struggling with this issue.

     

    Among other things, we tried using the DEPT ED40 entries, which so far has gotten us closest to making this work.  However, for POs using these records, it puts the new account number (123456888) in the N1^ST02 segment and the N1^ST04 segment is populated with the account number attached to the storeroom (123456777), presumably because the REQ LOC is using that location as the 'From Loc' in RQ01?

     

    In testing this method, our stocked items mapped as expected with the appropriate account number in N1^ST04 and the PO Ship To Name (from IC02) in N1^ST02 as shown in this example:  N1^ST^YAVAPAI REGIONAL MEDICAL CTR^91^123456777~

    The Non-Stock PO mapped with the new account number from the ED40 'External Value' field to N1^ST02 and the same storeroom account number in N1^ST04 as shown in this example: N1^ST^123456888^91^123456777~

     

    The supplier suggested truncating the account number in N1^ST04 to the first 6 characters (the actual account #) then using the last three in the N1^ST02 segment do differentiate stock/non-stock and east/west location.  Doing so would appear to work for non-stocked POs, as the N1^ST02 appears to be populated by the ED40 entry, but for the stocked items, how would you go about changing the mapping for N1^ST02 to use the abbreviated account number from in place of the PO Ship To Name?

     

    I also lobbied for your solution Jon, as it would have been by far the simplest, but unfortunately the supplier denied it. 

    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2456 points)
    Veteran Member
    Posts:838


    Send Message:

    --
    07/05/2019 3:43 PM
    To get the req loc into the right EDI segment for Cardinal to read I had to create an O_DEPT_SHIPTO on ED40
    List Name: TPID_O_DEPT_SHIPTO
    Lawson Value: Company (4 digit: 0001 not 1)
    External Value: ON

    This moved the req loc account number to N1^ST04.
    Jason B.
    MMIS Coordinator
    Private
    New Member
    (7 points)
    New Member
    Posts:3


    Send Message:

    --
    07/16/2019 10:24 AM

    Thank you, Kat!  That was the missing link.  After adding the "ON" trigger, to the DEPT ED40 records, the account numbers are now populating N1^ST04 appropriately.

    Much gratitude to everyone for your time and responses.

    You are not authorized to post a reply.