Troubleshooting: Save Invoice Error - The value of column ItemCode in table UTDStockCost does not exist in its master file

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

Question : When I try to save a new Invoice, system prompts an error message " The value of column ItemCode in table UTDStockCost does not exist in its master file. What should I do?

Version : 1.8 / 1.9 / 2.0

Utdstockcost not exist1.png


Possible Reason :

Some of the items in this Invoice, information/value is missing or did not maintain correctly in Stock Item Maintenance.


Solution :

1) Try to remove the item and save the Invoice. Remove one item and Save, then repeat the same steps to find out which is the item that causing issue.

Utdstockcost not exist2.png


Result showed that the problem is on item abcd.


2) Go to Stock > Stock Item Maintenance, double click the item ‘abcd’. Found that the Base UOM is empty.

Utdstockcost not exist3.png


3) Edit and assign the base UOM and click on OK.

Utdstockcost not exist4.png


4) Now you should be able to save the Invoice.

Utdstockcost not exist5.png


By : Cheryl 190118, Lay Swan 190123, P190128



Go to menu

IconAcc20.PNG AutoCount Accounting 2.0 & 2.1


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