Troubleshooting: Error message – The value of column Location in table IPHIST does not exist in its master file

From AutoCount Resource Center

Question: When I try to save an invoice, system prompts me an error message “The value of column Location in table IPHIST does not exist in its master file”. What should I do?

Version: 1.8 / 1.9 / 2.0

Location1.png


Possible Reason:

The location under Stock Maintenance has been deleted but invoice still capture the record of this location which does not exist in system anymore. Thus, system unable to save your invoice.


Solution:

1. Change your location to a valid location (Image 1) .


Location2.png

Image 1


2. Double check and change the default location to another location(Image 2) under Tools > Options > Miscellaneous


Location3.png

Image 2


Note: If user accidently deleted the location, create again the location and use the same name as default location set in AutoCount.


By: Ella 170921, KM 180115, P180115



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