Invalid Column Name 'IsTaxInclusiveOnly' prompted when upgrade database in Optimum

Created by QNE Software Sdn bhd, Modified on Thu, 22 Dec, 2022 at 5:24 PM by QNE Software Sdn bhd

Scenario 

When upgrade database in QNE Optimum prompted “Invalid Column Name 'IsTaxInclusiveOnly'’.

 

This might happen when upgrading a very old Database version to latest database version

 

Solution 

1. Launch SSMS and connect to your database

https://support.qne.com.my/a/solutions/articles/81000385373 

2. Click “New Query” button

3. Copy and paste below query

alter table APCN add IsTaxInclusiveOnly bit

alter table APDN add IsTaxInclusiveOnly bit

alter table ARCN add IsTaxInclusiveOnly bit

alter table ARDN add IsTaxInclusiveOnly bit

alter table Bills add IsTaxInclusiveOnly bit

alter table CashPurchases add IsTaxInclusiveOnly bit

alter table CashSales add IsTaxInclusiveOnly bit

alter table DeliveryOrders add IsTaxInclusiveOnly bit

alter table GoodsReceivedNotes add IsTaxInclusiveOnly bit

alter table Invoices add IsTaxInclusiveOnly bit

alter table Journals add IsTaxInclusiveOnly bit

alter table Payments add IsTaxInclusiveOnly bit

alter table PurchaseDN add IsTaxInclusiveOnly bit

alter table PurchaseInvoices add IsTaxInclusiveOnly bit

alter table PurchaseOrders add IsTaxInclusiveOnly bit

alter table PurchaseRequisitions add IsTaxInclusiveOnly bit

alter table PurchaseReturns add IsTaxInclusiveOnly bit

alter table Quotations add IsTaxInclusiveOnly bit

alter table Receipts add IsTaxInclusiveOnly bit

alter table SalesCN add IsTaxInclusiveOnly bit

alter table SalesDN add IsTaxInclusiveOnly bit

alter table SalesInvoices add IsTaxInclusiveOnly bit

alter table SalesOrders add IsTaxInclusiveOnly bit

4. Click “Execute” button

5. Re-launch QNE Optimum

6. Continue to upgrade database

 

** Learn more about Azure Cloud

** Learn more about QNE Hybrid Cloud Software

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