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

From AutoCount Resource Center
(Created page with "'''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...")
 
No edit summary
Line 24: Line 24:
   
   
3) <span style='color:red'>Edit</span> and <span style='color:red'>assign</span> the base UOM and click on <span style='color:red'>Save</span>.
+
3) <span style='color:red'>Edit</span> and <span style='color:red'>assign</span> the base UOM and click on <span style='color:red'>OK</span>.
   
 
[[File:Utdstockcost not exist4.png]]
 
[[File:Utdstockcost not exist4.png]]

Revision as of 06:25, 29 January 2019

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?

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