Troubleshooting: Why I couldn't delete Item Code

Revision as of 07:42, 8 December 2017 by Keatmeng (talk | contribs) (Protected "Troubleshooting: Why I couldn't delete Item Code" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite) [Delete=Allow only administrators] (indefinite)))

Question: Item code cannot be deleted. Error message prompted: "The value of column ItemCode and UOM in table Purchase Invoice detail does not exist in its master file"

Delete item.png

Possible Reason:

The stock item was used in some transactions, and may be referred in some database table. That's why the item code is not allowed to be deleted.


1. Make sure there was no transaction involving this item before you can delete it.

2. Set the item to inactive in Item Maintenance.

By:KM 170605, 170721, P170801

Go to menu

  AutoCount Accounting 2.0

  AutoCount Accounting 1.8 / 1.9
  AutoCount Payroll
  AutoCount POS

  AutoCount On The Go
  AutoCount Accounting Plug-In Documentations