We recently upgraded our xTuple version from 3.8.3 to 4.4.0. After this upgrade, we noticed that the bank reconciliation portion of the app is not working as expected. When we navigate to Accounting -> Bank Reconciliation -> Reconcile..., we receive the following SQL error in the log:
Tue Jul 3 12:45:01 2018 ERROR: column "bankrecitem_effdate" does not exist
LINE 5: COALESCE(bankrecitem_effdate, gltrans_date) AS f_date...
When we try to manually add the bankrecitem_effdate column into the public.bankrecitem table, the bank reconciliation functionality seems to work. However, with this also comes a huge performance hit. When we navigate to Accounting -> Bank Reconciliation -> Reconcile... again, the query to open the Reconcile Bank Account menu takes anywhere from a minute to a minute and a half to open. Any actions in this menu also take a similar amount of time to carry out. I'm just wondering if there is something I could be missing when adding this missing column in? Or if there could be more that I need to add/change in the database rather than just adding this column.
Thanks in advance!