Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / "This item is ina...
Microsoft Dynamics GP (Archived)

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

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: "This item is inactive..." Where is this set in GP?

    Adam Page!!  Shoot me an email sometime buddy!

  • Verified answer
    Adam Page Profile Picture
    Adam Page 40 on at
    Re: "This item is inactive..." Where is this set in GP?

    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: "This item is inactive..." Where is this set in GP?

    David,

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

    Jeremy

  • GPDavid Profile Picture
    GPDavid 2,250 on at
    Re: "This item is inactive..." Where is this set in GP?

    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.)?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: "This item is inactive..." Where is this set in GP?

    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

  • GPDavid Profile Picture
    GPDavid 2,250 on at
    Re: "This item is inactive..." Where is this set in GP?

    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: "This item is inactive..." Where is this set in GP?

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

  • GPDavid Profile Picture
    GPDavid 2,250 on at
    Re: "This item is inactive..." Where is this set in GP?

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans