Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Account Schedule repor...
Microsoft Dynamics NAV (Archived)

Account Schedule report layout customisation

(0) ShareShare
ReportReport
Posted on by Royce Lithgo

The report generated from an Account Schedule has some layout issues.

  • It always defaults to Landscape orientation even when the report data easily fits on Portrait.
  • It uses a tiny font size - looks like 7 point. 
  • There is far too much vertical spacing between rows.
  • It takes up too many pages when printed.
  • Headings aren't formatted nicely

Is it possible to customise this report? 

The workaround is to output to Excel and format manually. But that is far too much work. Our current in-house finance system has far nicer reports than NAV.

ps. I am not asking how to setup an Account Schedule. I am asking how to customise the print layout of Account Schedules.

*This post is locked for comments

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,565 Super User 2024 Season 2 on at
    RE: Account Schedule report layout customisation

    Hi, hope the following helps.

    How to: Create and Modify a Custom Report or Document Layout

    https://docs.microsoft.com/en-us/dynamics-nav-app/ui-how-create-custom-report-layout

    Thanks.

    ZHU

  • JPB 2022 Profile Picture
    JPB 2022 140 on at
    RE: Account Schedule report layout customisation

    Hello, I have the same situacion.. How do you access to the layout? how do you change it?

    If you could explain to me will be very helpfull.!! i am playing with the system but not good luck..

  • Royce Lithgo Profile Picture
    Royce Lithgo on at
    RE: Account Schedule report layout customisation

    Many thanks for your assistance. I have taken a look at the Report layout and can now see that I will be able to make all the layout changes that we require.

  • Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Account Schedule report layout customisation

    Yes

  • Royce Lithgo Profile Picture
    Royce Lithgo on at
    RE: Account Schedule report layout customisation

    Are you referring to Report 25 Account Schedule?

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Account Schedule report layout customisation

    You need to take help of developer/partner to modify the report as per your requirement.

  • Royce Lithgo Profile Picture
    Royce Lithgo on at
    RE: Account Schedule report layout customisation

    How do you accomplish that?

  • Verified answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Account Schedule report layout customisation

    You can customized the report according to your requirement.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans