Changing vendor #'s

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.

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.

 

 

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.

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 #)

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.

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

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.

NOW you have totally lost me.  You are speaking a language I know nothing about.  LOL

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?

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.

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

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.

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.

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.