Troubleshooting: Why I couldn't delete Item Code: Difference between revisions

From AutoCount Resource Center
(Created page with "'''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"...")
 
No edit summary
 
(One intermediate revision by one other user not shown)
Line 1: Line 1:
'''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"
+
'''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"
   
  +
<b>Version:</b> 1.8 / 1.9 / 2.0
   
 
[[File:Delete item.png]]
 
[[File:Delete item.png]]

Latest revision as of 09:29, 20 February 2020

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.


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