Unable to Change Cost Method for Product with Transactions

As of Acctivate version 9.0, a product’s cost method 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 cost method will result in the following message:

5-24-2016 10-29-41 AM

Although the cost method 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

  1.  In the new product window, change the cost method to the new cost method. Name the product and click “Save”.

5-24-2016 10-41-15 AM

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 Cost Method. 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 cost method product on future inventory transactions and orders.

Posted in Inventory - Last modified on May 24, 2016
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support ticket.