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

Solution

Below is query to delete journal posted from Point Of Sales and posted using method "By Transaction":

Delete From journal1 Where D_ate Between 'yyyy/mm/dd' And 'yyyy/mm/dd' And TranType = 'GJ' And StockType = 'CS' And Doc1No Like '%xxx%'

NB : Please do backup your database before do query, and please take own risks if any data loss due to incorrect syntax during execution of SQL query.

Was this article helpful? yes / no

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

Query For Empty Tax Code

Delete General Journal

Article details

Article ID:	4
Category:	MySQL Query
Date added:	2016-03-03 07:45:23
Views:	296
Rating (Votes):	(2)

« Go back