"This item is inactive..." Where is this set in GP?

(0) Share

Report

Posted on by Community Member

We are using Great Plains 9. We tried to put in an order for a couple items today, and are getting the pop-up "This item is inactive. Activate the item or enter another item." I have no idea what this is. The part is in "Sales Inventory" in Item Type, and the table (IV00101) properly shows this column as 1. I see that there is an "inactive" column on the DB on the inventory master table, but it is 0 for all parts, including the ones that aren't working. The item is lot tracked, and there is an in-stock lot available. Does anyone know where I should be looking to fix this?

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

GPDavid 2,250 on at

Like (0)

Report

Do you have Manufacturing installed? You may want to check the Item Engineering Data window (Cards | Manufacturing | Inventory | Engineering Data). You will see an "Item Status" drop-down window there. Sometimes you just have to create a record in this window for this message to disappear.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

We do have it installed, however, the part is Active there as well.

Was this reply helpful? Yes No
GPDavid 2,250 on at

Like (0)

Report

And did you confirm you are still getting the error message after opening and saving this window at least once? When opening the window for the first time, the Item Status will default to 'Active' thus leading you to believe it has always been that way, but it is not until you save the window at least once that the appropriate record gets written to the Item Engineering table.

Also, did you check to ensure that the "Effective Date" on the same window is set to a date prior to the system date?

David

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

David,

Thanks for the follow up. I resaved that record with a proper date and status, and still had that problem, so I tried setting it inactive there, then attempted to invoice. It then added another level of warning about the item being "ineffective", as well as the original error about it being inactive. This leads me to believe that the issue is elsewhere. Thanks for the idea, though, that had not occurred to me.

Jeremy

Was this reply helpful? Yes No
GPDavid 2,250 on at

Like (0)

Report

Sorry to hear that did not work for you. Are you utilizing any 3rd party products? What about other modules connected to inventory that are integrated with the Inventory Control module (e.g. Field Service, Project Accounting, etc.)?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

David,

No on both. This is a fun one. :) At least I'm learning new things.

Jeremy

Was this reply helpful? Yes No
Verified answer

Adam Page 40 on at

Like (1)

Report

More than likely this was previously a Small Business Financials (SBF) install converted to GP. In SBF, the item card had an "Inactive" checkbox. Obviously not present in GP.

To resolve, set the inactive flag to 0 in IV00101 and remove the item from IV00114. (You can also simply rename the IV00114 entry.

The T-SQL for this would be:

DECLARE @ITEM CHAR(31) = '<INSERT ITEM NUMBER>'

UPDATE dbo.IV00101

SET INACTIVE = 0

WHERE ITEMNMBR = @ITEM

DELETE IV00114

WHERE ITEMNMBR = @ITEM

GO

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

Adam Page!! Shoot me an email sometime buddy!

Was this reply helpful? Yes No