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

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

  AutoCount Accounting 2.0


  AutoCount Accounting 1.8 / 1.9
  AutoCount Payroll
  AutoCount POS


  AutoCount On The Go
  AutoCount Accounting Plug-In Documentations