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