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 :)