Report to show Custom Ledger entries

(0) Share

Report

Posted on by Kiptoo

Hello,

I want to create a report in NAV that fetch GL entries(table 17) per month i.e adds all credits and debits and shows in the report.Any short method of fetching the data?

this is my sample report I want .I also want to add Balance at date from table 15

GL Account	Date	credit	Debit	Balance at date

All responses (3)

Answers (1)

Kiptoo 45 on at

Like (0)

Report

RE: Report to show Custom Ledger entries

Thanks Josh,this really opened My eyes...

Another question maybe, is there code that can filter records of one day and combine credits and debits? am looking forward to see monthly and daily reports
Verified answer

YUN ZHU 73,698 Super User 2024 Season 2 on at

Like (0)

Report

RE: Report to show Custom Ledger entries

Hi, adding to Josh's reply, you can also try to use Account Schedules. You can set up various layouts to define the information that you want to extract from the chart of accounts.

More details:

https://docs.microsoft.com/en-us/dynamics-nav-app/bi-how-work-account-schedule

https://docs.microsoft.com/en-us/dynamics-nav-app/finance-account-schedule

https://www.youtube.com/watch?v=ijHG3HUsznQ

Hope this will help.

Thanks.

ZHU
Suggested answer

JAngle 33,159 on at

Like (0)

Report

RE: Report to show Custom Ledger entries

Try the detail trial balance report. You can alter the layout with a custom layout to reduce the columns if needs be