Purchase From locations - LawsonGuru.com

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3288
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1348
Roger French	1311
mark.cook	1244

Bev Edwards

Veteran Member

Posts: 366

2/16/2016 9:27 PM

I have an item that I need to change the Stock Unit of Measure (IC11) from SL to PK, but I'm getting a message Quantities exist at location; cannot change.

The only place I see the SL uom is on an old agreement now on hold.

I removed the hold, tried to change it in PO25.6 and received the message Vendor 1990 R1 location is inactive.

How do I get to the R1 location??

JonA

Veteran Member

Posts: 1162

2/17/2016 12:54 PM

The error regarding quantities existing at a location means you have stock quantities in one or more inventory locations. Use IC40 to view inventory availability by location. The screen will include par locations so you have to page through unless you use a report group with just your inventory locations.

Bev Edwards

Veteran Member

Posts: 366

2/17/2016 9:46 PM

I don't have access to IC40, but I have requested it. Thank you for letting me know about that report.

I ran a query on all locations from the ITEMLOC table and I changed all the uoms to PK, so I don't know what the IC40 report will show me that the ITEMLOC table isn't.

The only place left I see SL at is on a pricing agreement in PO25.6.

JonA

Veteran Member

Posts: 1162

2/17/2016 11:56 PM

IC40 is just an inquiry screen that will show if there are any quantities in inventory. If you can query the ITEMLOC table you should be able to see if there are on hand or backorder quantities. The problem is not the uom, it's the quantity. Once you eliminate the quantity you'll be able to change the stock uom.