Item Status Cannot be Changed

[Former Member]

I had an existing PO with an item on it that was flagged as not being an Inventory item by mistake. It appears the system allowed the creation of the PO while the item was flagged this way. A Goods Receipt PO was generated from the PO and all products on the PO showed an increase in Inventory except for the one item, which seems to make sense but I would have expected an error message for trying to receive that item. The quantity received for that item did not get placed in the warehouse. We realized this was probably due to the fact it was flagged as non inventory. If we try an modify the item to say it is an Inventory item we get the message "Inventory Item status cannot be changed due to the existence of either postings or documents." How do I find what is preventing this change and what can I do when I find it? Using Drag and Relate I have no open documents with this item on it.

[Former Member · Accepted solution]

Hi,

To find all those problematic PO is easy. Try:

SELECT T0.DocNum, T1.ItemCode

FROM OPOR T0

JOIN POR1 T1 ON T1.DocENtry = T0.DocEntry

JOIN OITM T2 ON T2.ItemCode = T1.ItemCode AND T2.InvntItem='N'

Howeve, once you created any marketing document that includes those item codes, Inventory Item status will no longer be changeable.

Thanks,

Gordon

[Former Member · Accepted solution]

That's the main problem. We already have marketing documents against the item, the PO itself and the receipt against the PO. I would have thought that if it was set to No Inventory before the PO, we wouldn't have been able to put it on the PO and if the PO existed first, then we wouldn't have been able to change it to No to Inventory. So it sounds like SBO has allowed us to create a situation that it will not let me get out of.

[Former Member · Accepted solution]

This is by design. You are allowed to purchase non inventory material items but not allow you to change the item status.

[Former Member · Accepted solution]

Limited thinking on my part since we do not have, or should not have non-inventory items brought in by PO. But you are right, it makes sense. It does highlight a potential danger that I never even considered and will have to be more diligent, perhaps restricting the modification of the Inventory status more. Thanks

[Former Member · Accepted solution]

Out of curiosity, Gordon, is there any recourse if the Item Status gets changed by accident, which is the case here. The product was an inventory item and we will continue to receive it into our warehouse. At this point, however, it will forever act like a non-inventory item, preventing us from doing so. The changing of an item status by accident does not seem to farfetched yet the implications are tremendous.

[Former Member · Accepted solution]

If the item has transaction posted, the only way to change it would be by direct update through SQL. Make sure no user is allowed to do this.

[Former Member · Accepted solution]

Hi,

You can cancel the item and Inactive it and re-create a new item with the correct status.

THanks.

Clint

[Former Member · Accepted solution]

That is problematic since I still have open documents against the item. Additionally, I have to retain the itemcode.

[former_member218051 · Accepted solution]

Hi,

As Clint says, you re - create an item with right options set and enter your old itemcode as an additional identifier thereby creating a reference to the old item.

thanking you

Malhaar

[Former Member]

What you can try:

Create a new product with the right settings. Create for the original product a sales BOM that includes only the new product. Then you can work with both product codes but you ship only one.

[Former Member]

Hi,

Its hard to prevent this since this is a user choose or intervention.

You can try create a query that shows all items that are not flag as Inventory Item.

Thanks.

Clint

[Former Member]

Thanks Clint but find the items that are No to inventory is not the issue. That's easy to find. The problem is being able to set it back after Market documents have been created for it. According to Gordon, this sounds like it can't be done. Thanks anyway.

[Former Member]

Hi,

Is Non Inventory is still applied in your business process?

How many users are authorized to create item in Master Item date module?

thanks.

Clint

[Former Member]

In actuality, we should not have had a non-inventory item at all and have a limited number of users that can modify this but this issue has made me realize that I need to put more security on the status flag.

[Former Member]

Hi,

May you could try blocking adding item with Non-Inventor option.

Thanks.

CLint