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 multiple collection in same transaction number

Knowledgebase

SkyBiz Support Ticket > SkyBiz Support Ticket > Knowledgebase

Query for checking multiple collection in same transaction number

Solution

SELECT H.D_ate, R.* FROM stk_receipt2 R INNER JOIN stk_cus_inv_hd H ON R.Doc1No = H.Doc1No WHERE H.D_ate BETWEEN '2016/06/01' AND '2016/06/30' GROUP BY R.Doc1no HAVING COUNT(R.Doc1No) > 1;

Was this article helpful? yes / no

Related articles

Query For Checking Incorrect Total Detail Tax

Query For Empty Tax Code

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

Query to Check Transactions Earlier than the Opening Date

Insert Project Budget Missing Detail From Backup

Article details

Article ID:	104
Category:	MySQL Query
Date added:	2016-07-27 01:53:47
Views:	280
Rating (Votes):	(0)

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