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 Checking Incorrect Total Detail Tax

Knowledgebase

SkyBiz Support Ticket > SkyBiz Support Ticket > Knowledgebase

Query For Checking Incorrect Total Detail Tax

Solution

SELECT H.D_ate, H.Doc1No, H.HCDtTax, SUM(D.HCTax) AS vDtTax FROM stk_cus_inv_hd H INNER JOIN stk_cus_inv_dt D ON H.Doc1No = D.Doc1No WHERE H.HCDtTax <> 0 GROUP BY D.Doc1No HAVING H.HCDtTax <> SUM(D.HCTax) ORDER BY H.D_ate, H.Doc1No

Was this article helpful? yes / no

Related articles

Query For Empty Tax Code

Query for checking multiple collection in same transaction number

Delete journal From Point Of Sales for those posted using method "By Transaction"

Insert Project Budget Missing Detail From Backup

Article details

Article ID:	196
Category:	MySQL Query
Date added:	2016-12-29 04:04:12
Views:	152
Rating (Votes):	(0)

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