Error Invalid column name ‘UnmatchedAmount’ during database upgrade.

Created by Hazel Ng, Modified on Tue, 17 Nov, 2020 at 11:33 AM by Hazel Ng

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

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article