Troubleshooting: Why I couldn't delete Item Code

From AutoCount Resource Center
Jump to navigation Jump to search

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

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