Error Invalid column name ‘UnmatchedAmount’ during database upgrade.

Error Invalid column name ‘UnmatchedAmount’ during database upgrade.

*update from old version before 2018 to latest 2019 version

What to do:

1. Run below script to find out which table

SELECT * FROM

INFORMATION_SCHEMA.COLUMNS

WHERE (COLUMN_NAME = ‘UnmatchedAmount’)

AND TABLE_NAME NOT LIKE 'VW_%'

ORDER BY TABLE_NAME

      2. Run below script to add in the field

 ALTER TABLE APCN

ADD UnmatchedAmount numeric(38,12)

—

ALTER TABLE ARCN

ADD UnmatchedAmount numeric(38,12)

—

ALTER TABLE Payments

ADD UnmatchedAmount numeric(38,12)

—

ALTER TABLE Receipts

ADD UnmatchedAmount numeric(38,12)

Thank you :)