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?
*This post is locked for comments
Yes, we are not understanding this column at all. Thank you for the information.
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
This video explains about trial balance report, even though it is old version the concept is still the same.
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?
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,104 Most Valuable Professional
nmaenpaa 101,156