Troubleshooting: Why I couldn't delete Item Code

From AutoCount Resource Center
Revision as of 09:29, 20 February 2020 by LaySwan (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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"

Version: 1.8 / 1.9 / 2.0

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

IconAcc20.PNG AutoCount Accounting 2.0

IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS

Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations