Error in Purchase Invoice "Field not permitted in query: export_type"

Gupta_123 · October 28, 2023, 5:14am

Getting an error When I Select Supplier in Purchase Invoice
“Field not permitted in query: export_type”
How to make sure that this error will not occur again?

Gembira_IT_Tech · October 28, 2023, 8:37am

heloo…
what you try to do.?

Gupta_123 · October 28, 2023, 8:41am

I make a purchase Invoice Entry when I select a supplier message that has occurred.

“Field not permitted in query: export_type”

Gembira_IT_Tech · October 28, 2023, 8:45am

did you edit/custom your purchase invoice before?
theres problem with field called export_type.

try to edit your puchase invoice doctype, locate the export_type field and remove it.

Vinod_Nadar · February 17, 2024, 6:04am

Did anyone get solution to this?

Vinod_Nadar · February 17, 2024, 4:43pm

@snv
Hi Sagar, i think this is something to do with India Compliance App?

I see in the code that the export_type field gets deleted while installation.

github.com

resilient-tech/india-compliance/blob/0335e42c55dbded9ed46a4c5b9c5d7e585dbbc38/india_compliance/patches/post_install/remove_old_fields.py#L20


      
                  "Delivery Note",
                  "Sales Invoice",
                  "POS Invoice",
              ),
          )
          
          delete_old_fields(
              ("reason_for_issuing_document", "ecommerce_gstin"), "Purchase Invoice"
          )
          delete_old_fields("pan_details", "Company")
          delete_old_fields("export_type", ("Customer", "Supplier"))
          delete_old_fields("company_address", "Journal Entry")

Thanks in advance

Kabir · February 17, 2024, 6:13pm

Dear Mr. @Gupta_123,

This issue is connected with Custom Field export_type. Search for custom fields in ERP Next and search for this field. Share the screenshot of this field completely.

For this supplier, check for the GST status. What is the category of GST selected?

The above both should fix this. Basically, a condition on the custom field “export_type” is triggering this alert.