Error Invalid column name ‘UnmatchedAmount’ during database upgrade.
*update from old version before 2018 to latest 2019 version
What to do:
- 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
Feedback sent
We appreciate your effort and will try to fix the article