ERPNext Conference 2019* ERPNext.com Blog

Unknown Column 'tax_type' error on Offline POS


#1

I can’t open POS in offline mode becasue of Unknown Column ‘tax_type’ error (See screenshot)


I’ve checked the database table and confirmed that there no such a column in tabItem Tax;

Here is the result of ‘tabItem Tax’ table
MariaDB [_7f9f4ce860d7d369]> desc tabItem Tax;
±------------------±-------------±-----±----±--------±------+
| Field | Type | Null | Key | Default | Extra |
±------------------±-------------±-----±----±--------±------+
| name | varchar(140) | NO | PRI | NULL | |
| creation | datetime(6) | YES | | NULL | |
| modified | datetime(6) | YES | MUL | NULL | |
| modified_by | varchar(140) | YES | | NULL | |
| owner | varchar(140) | YES | | NULL | |
| docstatus | int(1) | NO | | 0 | |
| parent | varchar(140) | YES | MUL | NULL | |
| parentfield | varchar(140) | YES | | NULL | |
| parenttype | varchar(140) | YES | | NULL | |
| idx | int(8) | NO | | 0 | |
| item_tax_template | varchar(140) | YES | | NULL | |
| tax_category | varchar(140) | YES | | NULL | |
±------------------±-------------±-----±----±--------±------+
12 rows in set (0.002 sec)

Installation Details:
ERPNext: v12.x.x-develop () (develop)
Frappe Framework: v12.x.x-develop () (develop)
OS: Centos7
Python: 2.7
Database: mysql Ver 15.1 Distrib 10.3.16-MariaDB


V12- Offline POS Error
#2

@anastes have recently upgraded to v12.x.x?

if yes then go customize form select Item Tax DocType and Update it.

I hope this Solve your issue


#3

No, This is a fresh installation, not a upgraded version

Thanks for your reply


#4

Hi,

Did you find a fix for this?


#5

Yes.
Just change tabItem Tax to tabItem Tax Template Detail on doctype/sales_invoice/pos.py
Please check this pull request on github https://github.com/frappe/erpnext/pull/18558/files/76c3f26140bd0043f0b411578395a75984edaf40#diff-8d2e0aa2c90e83de9ef3274e86636187