Unable to Change Item Type for Product with Transactions

A product’s item type, whether it is non-inventoried, inventoried, drop ship, etc, cannot be changed if there are any posted inventory transactions for that product. If the Transactions tab of the Product window shows any transaction history, attempting to change the Item Type will result in the following message:

Although the item type can’t be changed on this product, you can achieve the same results by copying the product and creating a new one. There are a couple of steps in this process:

  1. Click the “Copy” button at the top of the product window to create a new product. You have the option to copy Vendor Product IDs and  Vendor Prices as well, clicking “OK” will open a new product window in Edit mode.

5-24-2016 10-30-57 AM

2. In the new product window, change the Item Type to the new Item Type. Name the product and click “Save”.

To take things one step further, you can also discontinue the old product and move its on hand quantity to the new product. This can be accomplished in a few steps:

  1. Open the Product window for the old product with the original Item Type. Click “Edit“, then rename the product to add “_old” to the end of the original name (or something to distinguish that it is no longer in use). Uncheck the “Active” checkbox to exclude this product from future lookup windows.
  2. Now you will need to move the adjust the remaining quantity of the old product out out and adjust the same quantity in to the new product. Go to Inventory > Inventory Balance Adjustment. Click New, then assign the same warehouse used on the original product.
  3. On the detail lines, add the old product. In the quantity field, set the number to 0. This will remove the current quantity for the old product from the specified warehouse.
  4. On the second detail line, add the new product. In the quantity field, enter the original on hand quantity from the old product. Set the unit cost match the unit cost from detail line 1.
  5.  Click “Save” to save the balance adjustment, then “Post” to apply the changes to your inventory.

5-24-2016 10-38-51 AM

After the adjustment has been posted, you can now use your new item type product on future inventory transactions and orders.

You may want to change any open PO’s or Sales Orders to use the New product as well after the On hand Quantity has been moved over.

Tagged with: , , , , , , , ,
Posted in Inventory - Last modified on March 24, 2017Eva Rhees
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support request.