Item Type is grayed out

  • Item Type is grayed out

    Posted by DSC Communities on December 13, 2016 at 1:52 pm
    • Chase Landorf


      December 13, 2016 at 1:52 PM

      We have an item number that is not set correct. The area that needs to change, is grayed out. Where do I go to do this?

      Chase Landorf
      Inventory Control & Accounting
      Ideal Deals, LLC dba Ideal Aluminum Products
      Saint Augustine FL

    • Beat Bucher


      December 14, 2016 at 8:49 AM

      Hi Chase,

      Not much you can do… unless there are transactions attached to this item, in which case you can’t delete it, I would just remove it from GP and recreate the item with the proper type.


      Beat Bucher
      Business Analyst, Dynamics GP MVP
      Ultra-Electronics Forensic Technology Inc.
      Montreal QC/Canada
      Montreal QC GPUG Chapter Leader
      GP2013R2 / MR2012 CU14



      December 14, 2016 at 8:59 AM

      Or you can use the backend (SQL) to change the item type. That’s is what I was used to do

      Syed Arshad
      IT Business Analyst
      Supreme Oil
      englewood NJ

    • Don Pugh


      December 15, 2016 at 1:42 PM

      If nothing has been posted to the item, and there are no unposted transactions, then delete the item, and reenter it.  If there are only unposted transactions, delete the transactions, then delete/add the item, then recreate the transactions.

      If you have posted transactions, then one option would be do discontinue the old item number, and recreate a new similar item number, with a suffix/prefix to make the distinction.

      Each of the item types has an underlying business process associated with it, so I would be reluctant to change the item type from the backend, because the first transactions were done one way, and subsequent transactions will be different.  Plus on hand inventory might be a bit confused.

      I suggest using item classes, and this will insure that the correct settings are done for an item, such as item type and decimal places, etc.


      Don Pugh
      GP Consultant
      Sandon Associates
      Woodside CA

    • Leslie Vail


      December 21, 2016 at 1:01 AM


      That is what I would do too. It’s an easy change because there cannot be any existing quantities to worry about, so there wouldn’t be any ‘costs’ to be concerned with. It would be helpful if there weren’t any unposted transactions outstanding, but even that isn’t a deal killer.

      Kind regards,


      Leslie Vail
      Accounting Systems Consulting, Inc.
      Dallas TX

    • Jan G


      October 31, 2017 at 5:21 PM

      ??Syed and Leslie — Can you please describe the process of making this Item Type change in SQL?
      I need to change Service Type to Discontinued.  Thank you.  Jan

      Jan G
      Accounting / AIS Manager
      California Radiographics, Inc.
      Soquel CA

    DSC Communities replied 7 years, 7 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Item Type is grayed out’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!