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

From AutoCount Resource Center
m (Protected "Troubleshooting: Why I couldn't delete Item Code" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite) [Delete=Allow only administrators] (indefinite)))
No edit summary
 
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