Troubleshooting: Why I couldn't delete Item Code: Difference between revisions
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''' |
+ | '''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
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
AutoCount Accounting 2.0
|
AutoCount Accounting 1.8 / 1.9
|
![]() |
AutoCount Payroll
|
AutoCount POS
|
AutoCount On The Go
|
![]() |
AutoCount Accounting Plug-In Documentations
|