Warning: mysqli_connect(): (HY000/2002): No route to host in /home/skybizgl/public_html/ticket/header-uc.php on line 38

Warning: mysqli_query() expects parameter 1 to be mysqli, bool given in /home/skybizgl/public_html/ticket/header-uc.php on line 39

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/skybizgl/public_html/ticket/header-uc.php on line 40

Query For Empty Tax Code
Knowledgebase
SkyBiz Support Ticket > SkyBiz Support Ticket > Knowledgebase

Search help:


Query For Empty Tax Code

Solution

SELECT H.D_ate, D.RunNo, D.ItemCode, D.Description, D.Qty, D.HCUnitCost, D.HCTax, ((6/106)*D.HCLineAmt) as vHCTax, D.HCLineAmt, D.DetailTaxCode, D.TaxRate1 FROM stk_cus_inv_dt D INNER JOIN stk_cus_inv_hd H ON D.Doc1No = H.Doc1No WHERE H.D_ate BETWEEN '2016/04/01' AND '2016/04/30' AND D.DetailTaxCode = ''

 
Was this article helpful? yes / no
Related articles Query For Checking Incorrect Total Detail Tax
Query for checking multiple collection in same transaction number
Query to Check Transactions Earlier than the Opening Date
Delete journal From Point Of Sales for those posted using method "By Transaction"
GST Seminar: GST Treatment For Retail & Wholesale - Issue & Updates 22 September 2016
Article details
Article ID: 103
Category: MySQL Query
Date added: 2016-07-21 15:48:22
Views: 255
Rating (Votes): Article not rated yet (0)

 
« Go back

 
Powered by Help Desk Software HESK, brought to you by SysAid