Scenario

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

Solution

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

Qne is the author of this solution article.

Did you find it helpful? Yes No