Scenario: 

Created quotation and want to select tax code but unable select 

Solution:

1) At server PC, search for management studio

If don’t have management studio can search at Google and install

2) Connect to database use management studio, for guidance can refer below link

https://support.qne.com.my/support/solutions/articles/81000385373-how-to-connect-to-database-use-microsoft-sql-server-management-studio

3) After connect, select the database that unable change tax code and click New Query

4) Copy and paste below script, click execute

Update Invoices set IsNonTaxInvoice = '0' where IsNonTaxInvoice = '1'

Update ARCN set IsNonTaxInvoice = '0' where IsNonTaxInvoice = '1'

Update ARDN set IsNonTaxInvoice = '0' where IsNonTaxInvoice = '1'

Update Bills set IsNonTaxInvoice = '0' where IsNonTaxInvoice = '1'

Update APCN set IsNonTaxInvoice = '0' where IsNonTaxInvoice = '1'

Update APDN set IsNonTaxInvoice = '0' where IsNonTaxInvoice = '1'

Update Quotations set IsNonTaxInvoice = '0' where IsNonTaxInvoice = '1'

Update SalesOrders set IsNonTaxInvoice = '0' where IsNonTaxInvoice = '1'

Update DeliveryOrders set IsNonTaxInvoice = '0' where IsNonTaxInvoice = '1'

Update SalesInvoices set IsNonTaxInvoice = '0' where IsNonTaxInvoice = '1'

Update CashSales set IsNonTaxInvoice = '0' where IsNonTaxInvoice = '1'

Update SalesCN set IsNonTaxInvoice = '0' where IsNonTaxInvoice = '1'

Update SalesDN set IsNonTaxInvoice = '0' where IsNonTaxInvoice = '1'

Update PurchaseRequisitions set IsNonTaxInvoice = '0' where IsNonTaxInvoice = '1'

Update PurchaseOrders set IsNonTaxInvoice = '0' where IsNonTaxInvoice = '1'

Update GoodsReceivedNotes set IsNonTaxInvoice = '0' where IsNonTaxInvoice = '1'

Update PurchaseInvoices set IsNonTaxInvoice = '0' where IsNonTaxInvoice = '1'

Update CashPurchases set IsNonTaxInvoice = '0' where IsNonTaxInvoice = '1'

Update PurchaseReturns set IsNonTaxInvoice = '0' where IsNonTaxInvoice = '1'

Update PurchaseDN set IsNonTaxInvoice = '0' where IsNonTaxInvoice = '1'

5) After complete will show like this and can back to system and see it’s able to change the tax code

Result:

** Learn more about Azure Cloud

** Learn more about QNE Hybrid Cloud Software

Refer attachment for details