How to extract Trail balance from Nav table

(0) Share

Report

Posted on by SelvakumarSubramaniam

Hi,

I am not an experienced in Navision, but want to extract Opening and closing Trail balance for all GL accounts from Nav table, I cannot extract from Navision application.

Please help me to extract from backend tables.

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (0)

Bodhi 558 on at

Like (1)

Report

In Chart of Accounts: click Trail Balance Report, checcking Actual Changes and Actual Balance, In Date Filter: The date range of Opening and closing day; Preview the Report and save as Excel; Use (Actual Balance - Actual Changes) to get Opening balance ;Actual Balance is closing Trail balance；

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (0)

Report

If you want to extract from the backend sql tables, join the GL Account and GL Entry table.

You will need to sum the amount of the gl entries. Use Posting Date to get your opening and ending balance filter.

Was this reply helpful? Yes No