How to filter all non - tally transactions

Created by Cheng Kah Poh, Modified on Wed, 11 Nov, 2020 at 10:38 AM by Cheng Kah Poh

To filter non – tally Transaction (Journal)

1. Connect to Database using Microsoft SQL Server Management Studio.

 

Please refer How to install Microsoft SQL Management Studio

AND

Please refer How to Connect to Database use Microsoft SQL Server Management Studio


2. Start a new Query

 

3. Copy and Paste the following SQL Script into the New Query --Change “SampleDB” to your database name

 

USE [SampleDB]

 

 

SELECT JournalType, DocumentCode, sum(Debit) as Debit, sum(Credit) as Credit, sum(Debit-Credit) as Total

FROM GLTransactions --Key in Cut Off Date

WHERE TransactionDate >= '2014-01-01' GROUP BY JournalType, DocumentCode

HAVING (Round(sum(Debit),2) - Round(sum(Credit),2) <> 0)

 

4. Change [SampleDB] to your own database name

 

5. Change the Cut off date if required

 

6. Execute the Query

 

7. Re-save all Transaction in Results.




Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article