Dealing with Multiple Vendor Item Numbers

Sort:
You are not authorized to post a reply.
Author
Messages
SCMaster-jk
New Member
Posts: 3
New Member

    Hey everyone,

     

    Long time lurker, first time poster. We're a fairly large health system who just went live with Lawson 10.0 at 3 of our hospitals. 

    I'll get right into it. Medline has different vendor numbers for the same item depending on the UOM. for example:

     

    • IV cath - B-D383335 for the Case
    • IV cath - B-D383335Z for the Box

     

    We have a single Lawson number for this item and it has multiple PO13s, one for the Z item number and one without (this one is the default po13)

     

    In PO25.6, there are two lines for this item: 

    • One with the Z that has BX as the UOM, as well as the BX price
    • One without the Z that has CA as the UOM, as well as the CA price

     

    If the requisitioner uses Requistion Center (RQC), they're able to change the UOM and the vendor item number and price automatically changes to whatever that UOM is associated with, perfect!

     

    However, if a buyer creates a PO20 with the same item and wants to buy it at the BX instead of the CA, the CA vendor number is populated. As you know this causes problems when it gets to Medline and the order gets held up since they're not sure if we're trying to buy at the box or case. 

     

    Does anyone know how to get PO20 to populate with the vendor number that the UOM is associated with in PO25.6?

     

    Kat V
    Veteran Member
    Posts: 1020
    Veteran Member
      They have to change the part number, UOM and blank out the price.

      So on PO13.3, Vendor Buy UOM and Vendor Price UOM are populated for both part numbers.

      On PO20, add item. It defaults to Case.
      Put FC C(Change) on the line and use the select value by the vendor item to find the other part number (or just put the Z in if you know it)
      Change UOM to Box.
      Delete Case price.
      Click CHANGE on the header.

      Part, UOM and new cost populate.

       

       (EDIT: I'm on v9.01)

      JonA
      Veteran Member
      Posts: 1162
      Veteran Member
        I was just testing this also. I was hoping that you could just change the UOM and everything else- price, vendor cat, would follow suit. No joy there but I did find that if you just change the vendor cat to the one with BX as the VBUY UOM, FC=C on the line and hit change the UOM and unit price will automatically change and the quantity will update to whatever the conversion is from CA to BX.

        Also on v9.0.1
        Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
        SCMaster-jk
        New Member
        Posts: 3
        New Member
          I can confirm this changes it as well. Problem is that the buyer would then need to physically check every single line one to make sure the correct V# populates according to the UOM. I wish it was automatic like RQC. Thanks for the help!
          Kat V
          Veteran Member
          Posts: 1020
          Veteran Member
            Where is the buyer getting the order from? If they are manually keying into PO20, they must already be manually checking the lines - no?

            A quick poll of my buyers - the overwhelming majority would tell their users "we can only order by Case - I need an approved req to override it to BX - sorry"
            SCMaster-jk2
            Veteran Member
            Posts: 100
            Veteran Member
              Ah, I forgot my password so I had to make this new account.

              Anyway, yes the buyer is manually keying into PO20 but I don't think they're keying in Vendor #s since those autopopulate once you add the line. So they'd just need to check ever line to make sure the correct V# is attached then I guess.

              As far as telling requestors that they only order by the case or whatever, this would be ideal. However, some of our hospitals are small and they may need to break bulk for certain items so ordering a case could be overkill for them.
              Kat V
              Veteran Member
              Posts: 1020
              Veteran Member
                As someone who has keyed in orders, yes, I don't look at the part number, but the UOM that populates and the totals should be reviewed prior to release. Make'em work!
                SCMaster-jk2
                Veteran Member
                Posts: 100
                Veteran Member
                  Haha, yeah, they're definitely putting in the correct UOM (which also brings in the correct price) but it's just the vendor # won't change to the "z" one. The buyers are definitely going to need to make sure the part numbers are correct before sending out the PO.
                  Kat V
                  Veteran Member
                  Posts: 1020
                  Veteran Member
                    AH - then there may actually be a flag somewhere that can help - when I change UOM without changing part, PO20 went right back to the original UOM and cost. That's why I couldn't figure out how your buyers didn't see it. Lawson was actively ignoring me until I fixed the part.
                    You are not authorized to post a reply.