Who's On?

	Membership:
	Latest: Saef
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5226

	People Online:
	Visitors: 262
	Members: 0
	Total: 262

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

Purchase From locations

3 Replies

1 Subscribed to this topic

38 Subscribed to this forum

Sort:

Author

Messages

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: 1163

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: 1163

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.