Unable select or change tax code

Created by Ariel Hoong, Modified on Wed, 20 Mar at 12:41 PM by Ariel Hoong

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    

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