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.


Solution:

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