Troubleshooting: Import journal entry error - Column ‘TaxableAmt’ does not belong to table: Difference between revisions

From AutoCount Resource Center
(Created page with "'''Question:''' When import Journal Entry from excel, error message prompted ‘Column ‘TaxableAmt’ does not belong to table’. What should I do? [[File:Import jv1.png]...")
 
No edit summary
 
Line 1: Line 1:
 
'''Question:''' When import Journal Entry from excel, error message prompted ‘Column ‘TaxableAmt’ does not belong to table’. What should I do?
 
'''Question:''' When import Journal Entry from excel, error message prompted ‘Column ‘TaxableAmt’ does not belong to table’. What should I do?
   
  +
<b>Version:</b> 1.8 / 1.9 / 2.0
   
 
[[File:Import jv1.png]]
 
[[File:Import jv1.png]]

Latest revision as of 09:16, 21 February 2020

Question: When import Journal Entry from excel, error message prompted ‘Column ‘TaxableAmt’ does not belong to table’. What should I do?

Version: 1.8 / 1.9 / 2.0

Import jv1.png


Possible Reason:

There is an empty row in between the transaction. Empty row in between the transaction will cause the import error.


Import jv2.png



Solution:

Remove the empty space or row in between the transaction.


Import jv3.png


Import the excel template again and you will not be getting error now.


by Azirah 180112, KM 180122, P180130



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