PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 02/23/2017 3:21 PM by  Kat V
Changing vendor #'s
 12 Replies
Sort:
You are not authorized to post a reply.
Author Messages
LaDora
Materials Management Supervisor
Glendive Medical Center
Advanced Member
(93 points)
Advanced Member
Posts:37


Send Message:

--
01/16/2017 12:40 PM

    With Kreisers now becoming Concordance, we need to change all of our vendor numbers.  They used to use the mfg # for the vendor #, but now they have given each item its own individual #.  Is there any easy way to change this is PO25?  Or do I need to put each item on HOLD and give it a new vendor #?  (I cannot just change the vendor # in PO25 that I can tell.)  I would also like to put the numbers into PO13 (vendor items.)

    Once I put an item on HOLD, does it just stay that way forever?

    I have found that if I cannot put an item on HOLD, I need to look in PO23 and IC66 for that item.

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


    Send Message:

    --
    01/16/2017 12:50 PM
    You are correct - there is no change to Vendor#

    From the old vendor number on PO13.3, upload FC T (Inactivate) that will inactivate the old vendor number AND put the PO25.6 on hold all as one step.

    You can then upload to the PO25.6 for the new vendor with FC B (Both) and that will add the PO25.6 AND the PO13 record.

    You can dump the POINTERFAC table to find all PO23 records - you are correct, you need to have those taken care of or they'll just sit there creating errors.
    LaDora
    Materials Management Supervisor
    Glendive Medical Center
    Advanced Member
    (93 points)
    Advanced Member
    Posts:37


    Send Message:

    --
    01/18/2017 5:50 PM

    Kat:

    WOOHOO!  This seems to be working!  Is there any way to run a report of items by vendor?  I can start chipping away at that list in a more organized fashion.

     

     

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


    Send Message:

    --
    01/18/2017 5:54 PM
    PO213 will show print out all the part numbers in PO13 - but it won't show you the price files. If you are in Smart Office, you can go to PO25 and populate Procurement Group, go down and populate Vendor Number. Now use the drop down on Vendor Agreement Ref and change the search to Vendor Agreement Reference for a Vendor.

    In Smart Office, this is exportable to excel.
    LaDora
    Materials Management Supervisor
    Glendive Medical Center
    Advanced Member
    (93 points)
    Advanced Member
    Posts:37


    Send Message:

    --
    01/23/2017 3:29 PM

    Question:

     

    Thru experimentation, based on your input, my buyer may have found an easier way.

    Go to PO13.3 (enter item# and vendor, INQUIRE)

    The incorrect vendor item should appear.

    FC (R) Replace and Inactivate. 

    A screen will pop up where you put the correct vendor #.

    Change.

    Inquire.  It will set the new vendor item # to default.  It will also REPLACE the vendor # in PO25 under that Vendor Agreement. (We have a LOT of manual work to do there since many items are under KREISERS and not the actual contract #)

     

    Can you think of any reason why this would be an issue?  We would still need to put the mfg info in PO13.  That is not a huge issue. (As long as there is NO mfg # and not the WRONG mfg #)

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


    Send Message:

    --
    01/23/2017 3:52 PM
    Sorry - when you say you are changing vendor numbers -- do you mean you are switching vendors completely? 2 AP10 records - or you are changing part numbers?

    I had thought vendor number = actual vendor id on AP10

    If it is part number - you can use PO13.3 for all of them, yes.
    LaDora
    Materials Management Supervisor
    Glendive Medical Center
    Advanced Member
    (93 points)
    Advanced Member
    Posts:37


    Send Message:

    --
    01/23/2017 3:58 PM

    I apologize for the confusion.  I am not changing vendors, I am changing the Vendor number for an item.  (same vendor, just a different reorder number for an item.)

    But, on the bright side, I now know how to do both!  LOL

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


    Send Message:

    --
    01/23/2017 4:04 PM
    LOL - even better, there's an upload for it!

    _f2 Procurement Group
    _f4 Item: Lawson number
    _f5 Vendor
    _f12 Position to Vendor Item: the current part number (one your replacing)
    _f13:0 Line FC: R
    _f48:0 Vendor Item R1: the new part number
    Upload as Change Only.
    If you also want to delete the old part number, once the above is done:
    _f2 Procurement Group
    _f4 Item: Lawson number
    _f5 Vendor
    _f12 Position to Vendor Item: the old part number (one you replaced)
    _f13:0 Line FC: D
    Upload as Change Only.

    LaDora
    Materials Management Supervisor
    Glendive Medical Center
    Advanced Member
    (93 points)
    Advanced Member
    Posts:37


    Send Message:

    --
    01/23/2017 4:18 PM
    NOW you have totally lost me.  You are speaking a language I know nothing about.  LOL
    SCMaster-jk2
    SCM Analyst
    Private
    Veteran Member
    (240 points)
    Veteran Member
    Posts:100


    Send Message:

    --
    02/20/2017 10:55 AM

    Hey LaDora - definitely use the "R". This will switch out the part numbers on both the PO13.3 AND every single PO25 the item is currently on for that vendor. 

     

    Kat was talking about using add-ins to do this, do you have access to that?

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


    Send Message:

    --
    02/20/2017 12:42 PM

    Sorry - I missed this.

     

    Yes, I was referring to uploading the changes in bulk from Excel.  You are correct. You can use FC R (Replace) on PO13.3 - See attached steps.

    Attachments
    LaDora
    Materials Management Supervisor
    Glendive Medical Center
    Advanced Member
    (93 points)
    Advanced Member
    Posts:37


    Send Message:

    --
    02/22/2017 10:03 AM

    SCMaster-jk2:

    I think you all are at a higher operational level than me.  I've no idea what you are talking about.  I am a supervisor in a rural hospital with 6 other people in my department.  We HAD a Lawson support person, but she changed jobs when I started this position. (5 months ago)  Our support is the facility that we have a "management agreement" with.  I do not think any of them are quite at the expertise level as you all.  I appreciate all of you helping me but I feel real dumb sometimes because I cannot follow some of your suggestions. 

    Kat was able to give me the step by step I needed.

    Now I know to preface my inquiries with DUMB IT DOWN.  LOL!

    thank you!

    LaDora

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


    Send Message:

    --
    02/23/2017 3:21 PM
    Uploads is a program that takes columns from Excel and changes Lawson.

    So in this case, instead of figuring it out in Excel and then copy/pasting into Lawson, you could figure it out in Excel and then have Excel do the copy/paste for you. If you're stuck in this position ongoing, you'll likely want to ask if your company owns add-ins.
    You are not authorized to post a reply.