Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Trial Balance - Changing a column calculation

(0) ShareShare
ReportReport
Posted on by 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

  • edwardl Profile Picture
    edwardl 2 on at
    RE: Trial Balance - Changing a column calculation

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

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Trial Balance - Changing a column calculation

    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
    RE: Trial Balance - Changing a column calculation

    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 43,745 on at
    RE: Trial Balance - Changing a column calculation

    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

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans