GSTR2- Error : Unknown column 'taxable_value' in 'field list

ERPNext Accounting
1

Hi Team,
While clicking on GSTR2 we facing error it’s is setting issue or bug
using erpnext on frappe cloud

Some one explain IN GSTR1 Return only Following Table available
1.B2B
2. B2C L
3.B2C S
4. CDNR
what about these table

  1. HSN Code wise sales summary
  2. Document Summary
  3. Summary For Advance Received (11B)
  4. Summary For Advance Adjusted (11B)
  5. Summary For Nil rated, exempted and non GST outward supplies (8)

SAME THING IN ALSO 2A

Error we received is given below
“pymysql.err.InternalError: (1054, “Unknown column ‘taxable_value’ in ‘field list’”)”

gstr2%20ERRO
gstr2%20ERRO1920×1080 159 KB

2

Hi,

I am also facing the issue. Any solution for the above error.

13%20PM
13%20PM730×242 11.5 KB

My ERP and Frappe version
ERPNext: v13.2.1 (version-13)
Frappe Framework: v13.2.2 (version-13)

3

Hi @TecTruth @maheshr
I had the same issue. It was coming from the “Purchase Invoice Item” table. Just add a new Custom Field in the same.

Screenshot%20from%202021-05-18%2023-25-01
Screenshot%20from%202021-05-18%2023-25-011024×345 23.2 KB