web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Trial Balance - Changi...
Microsoft Dynamics NAV (Archived)

Trial Balance - Changing a column calculation

(0) ShareShare
ReportReport
Posted on by edwardl 2

Right now when we run a Trial Balance report (10022), the last two columns are calculated from 01/01/15..31/12/15 even though the first 4 columns are calculated until the "As Of" date specific when running the report. 

We need Budgeted, Balance and Balance Variance to be calculated the same way as the first columns. Would anyone know how I would go about changing this?

TrialBalance.jpg

*This post is locked for comments

I have the same question (0)
  • edwardl Profile Picture
    edwardl 2 on at

    Yes, we are not understanding this column at all. Thank you for the information.

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,251 Super User 2025 Season 2 on at

    Check out this link, it will give you more information about the columns

    msdn.microsoft.com/.../hh934652%28v=nav.71%29.aspx;MSPPError=-2147217396

    It depends on what you select on the show comparison

    www.youtube.com/watch

    This video explains about trial balance report, even though it is old version the concept is still the same.

  • Verified answer
    edwardl Profile Picture
    edwardl 2 on at

    So I did a little more digging. When I run the report for the first day of the year, it shows a typical balance in the thousands and a budgeted balance of ~40 million. Is there carry-over from the previous year or are we not understanding this column?

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,251 Super User 2025 Season 2 on at

    Edward,

    I don't think the date calculation is different, the variance column calculation depends on other columns, but i don't think those are different.

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans