<![CDATA[FrontAccounting forum — Error on transaction update FA]]> 2021-02-13T12:47:10Z PunBB https://frontaccounting.com/punbb/viewtopic.php?id=9190 <![CDATA[Re: Error on transaction update FA]]> Setup->Fiscal Year.  Add the current year.

See http://mantis.frontaccounting.com/view.php?id=5338 for reason.

]]> https://frontaccounting.com/punbb/profile.php?id=41493 2021-02-13T12:47:10Z https://frontaccounting.com/punbb/viewtopic.php?pid=39124#p39124 <![CDATA[Error on transaction update FA]]> On a fresh install (or on a recent one when restoring), i get this message error while trying to update any journal, bank, etc transaction:
ex here: journal.
DATABASE ERROR : Cannot update audit gl_seq
error code : 1048

error message : Column 'fiscal_year' cannot be null
sql that failed was : UPDATE 0_audit_trail audit LEFT JOIN 0_fiscal_year year ON year.begin<='2021-02-11' AND year.end>='2021-02-11' SET audit.gl_seq = IF(audit.id=41, 0, NULL),audit.fiscal_year=year.id WHERE type='0' AND trans_no='2'



Why?
Vps ubuntu 18.04, php 7.4, FA 2.4.9 and 2.4.8

]]> https://frontaccounting.com/punbb/profile.php?id=20268 2021-02-13T05:59:09Z https://frontaccounting.com/punbb/viewtopic.php?pid=39122#p39122