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
Feedback sent
We appreciate your effort and will try to fix the article