Account Schedules in NAV 2013 not showing total accounts

SteveCP
SteveCP Member Posts: 6
edited 2014-01-29 in NAV Three Tier
Hi all,

I've been trying to create Profit & Loss (Income Statement) and Balance Sheet Account Schedules in NAV 2013. I am struggling to get these to work when using Total Accounts.

The screenshot attached shows I've tried to incorporate a total account '999999' which is Net Income for the year (to make the balance sheet balance) but the report always comes out blank when I run it. Interestingly, when I click on the drill down in the 'Overview' screen, it shows the Net Change/Balance/Balance at Date columns fine.

Has anyone else come across this, and managed to find out why it happens? There's a couple of existing posts on the forum but they're unanswered!

Thanks in advance.

Comments

  • clausl
    clausl Member Posts: 455
    The padding is incorrect on the Total field on the report, so it get's truncated when you see the report in Preview.

    Open the report in PrintLayout, then you will see your Totals, or you could of course go and fix the field in the RDLC report.

    /Claus Lundstrøm
    Claus Lundstrøm | MVP | Senior Product Manager | Continia.com
    I'm blogging here:http://mibuso.com/blogs/clausl and used to blog here: http://blogs.msdn.com/nav
    I'm also offering RDLC Report Training, ping me if you are interested. Thanks to the 700 NAV developers that have now already been at my training. You know you can always call if you have any RDLC report issues :-)

Categories