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

All responses (2)

Answers (0)

Suggested answer

Teddy Herryanto (Th... 13,643 Moderator on at

Like (0)

Report

RE: How to extract Trail balance from Nav table

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.
Bodhi 558 on at

Like (1)

Report

RE: How to extract Trail balance from Nav table

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；