navariltd / navari_csf_ke

EXPNext Country Specific Customizations for Kenya
GNU General Public License v3.0
16 stars 25 forks source link

Error while trying to open Kenya Sales Tax Report #79

Open ramanduck opened 1 month ago

ramanduck commented 1 month ago

Getting an error while trying to open Kenya Sales Tax Report:

pymysql.err.OperationalError: (1054, "Unknown column 'tabSales Invoice.etr_serial_number' in 'field list'")
Possible source of error: csf_ke (app)
Screenshot 2024-07-27 at 3 22 52 PM
maniamartial commented 1 month ago

Try running migrations, we have a patch that needs to run and create those 'etr' fields in the sales invoice doctype.

Screenshot from 2024-07-27 17-44-41 Screenshot from 2024-07-27 17-45-26

If the issue persists, use version-15 or version-14 as we check on this(we have changes we are still fixing on our develop branch) Thank you.

ramanduck commented 1 month ago

I am using frappecloud. How to run the migrations there? I am already on version-15

maniamartial commented 1 month ago

Navigate to your site, click on tab Actions Below you'll see Migrate button

See in the image below image

ramanduck commented 1 month ago

Same error even after running migrate

Screenshot 2024-08-02 at 3 53 41 PM Screenshot 2024-08-02 at 3 50 27 PM
ramanduck commented 1 month ago

Any update?

maniamartial commented 1 month ago

@ramanduck Still looking into the issue, we've noticed all the patches are not being executed. Will get back