Changing vendor #'s

 14 Replies
 0 Subscribed to this topic
 98 Subscribed to this forum
Sort:
Author
Messages
LaDora
Veteran Member
Posts: 48
Veteran Member

    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
    Veteran Member
    Posts: 1020
    Veteran Member
      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
      Veteran Member
      Posts: 48
      Veteran Member

        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
        Veteran Member
        Posts: 1020
        Veteran Member
          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
          Veteran Member
          Posts: 48
          Veteran Member

            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
            Veteran Member
            Posts: 1020
            Veteran Member
              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
              Veteran Member
              Posts: 48
              Veteran Member

                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
                Veteran Member
                Posts: 1020
                Veteran Member
                  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
                  Veteran Member
                  Posts: 48
                  Veteran Member
                    NOW you have totally lost me.  You are speaking a language I know nothing about.  LOL
                    SCMaster-jk2
                    Veteran Member
                    Posts: 100
                    Veteran Member

                      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
                      Veteran Member
                      Posts: 1020
                      Veteran Member

                        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
                        Veteran Member
                        Posts: 48
                        Veteran Member

                          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
                          Veteran Member
                          Posts: 1020
                          Veteran Member
                            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.
                            THouser
                            Basic Member
                            Posts: 7
                            Basic Member
                              We have a replace and inactivate function in PO13.3. Use Function "R" and then at the bottom next to Details it says Replace with. Click on replace with and then you put in your new vendor # and hit change. Then hit inquire and you'll see it automatically put your old vendor # on hold and will change any active agreements to the new vendor # so you never have to go back to inactivate the old in PO13 since it does it for you. Love this function.
                              THouser
                              Basic Member
                              Posts: 7
                              Basic Member

                                Sorry, just saw the changing vendors and not vendor # so ignore my response.  For the AP vendor, we just upload the items to the new vendor with it's new vendor cat # and it automatically puts a PO13 record for you.