How to Filter transactions that used Parent GL Account in QNE Delphi?

Created by QNE Software Sdn bhd, Modified on Thu, 22 Dec, 2022 at 5:05 PM by QNE Software Sdn bhd

Scenario

Found a transaction created but double entry posting did not post to Financial Report like Trial Balance

1. Go to File > Utilities > QNE Management Tools

2. Once QNE Management Tools prompted, go to Tools > Intelligence SQL Queries

3. Click on Import Script button, select script (download from below link) and click Execute button.

4. The result at bottom part will list out all those transactions that is posting to a Parent GL Account

5. Open up all the listed transactions and re-select the correct GL Account

(Parent GL Account are not meant for GL posting, it is meant for Grouping GL Account for report purposes only)

6. Close QNE Management Tool

7. Now your Financial Report Double entry will be tally

** Learn more about Azure Cloud

Attachments (1)

How to Filte....pdf
412 KB