Excel Import Management Troubleshooting: Error message "The value of column TaxType in table AP Invoice Details does not exist in its master file" when I do Post to AP Invoice

From AutoCount Resource Center
Jump to navigation Jump to search

Question : I’m using Excel Import Management (Details) Plug-In to import AP Invoice. When I click Post to AP Invoice, system prompts me an error “The value of column TaxType in table AP Invoice Details does not exist in its master file”. What should I do?


Exc imp1.jpg


Possible Reason :

Tax code mapping issue. System failed to detect the POS GST Code - TX0 should map to which tax code in our system. It shows empty at GST code column.


Exc imp2.jpg


Solution :

1. Go to General Maintenance > User Defined List Maintenance ,


Exc imp3.jpg


2. Choose IntMapping and click on Edit.


Exc imp4.jpg


3. The list are without the mapping for TX0, please add another line for :

TX0,TX-0

TX0 is user’s other POS system tax code, TX-0 is our system tax code.


Exc imp5.jpg


4. Browse again the files and you will notice GST code column now assigned with tax code.


Exc imp6.jpg


5. Click Post to AP Invoice, and success to import.


Exc imp7.jpg



By : Aimi 180712, Lay Swan 180712, P180719




Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


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