5
Account schedules do not handle variances correctly. As you know all we can do to calculate a variance is a simple formula where we subtract one column from another. However in financial and management reporting this doesn’t work.
To be correct a variance calculation would create this result:
Actual Budget Variance
Revenue 100 50 50
Expenses 100 50 -50
Suggestion: implement "XCR" from Management Reporter. Basically XCR says "change sign if BASEROW = C" . In Account Schedules it would mean "change sign if row has 'show opposite sign' selected". The Revenue rows would have this selected in my example. The result above would be corrected since the formula budget -actual would be correct since the result of -50 on revenue would get it's sign flipped.
To be correct a variance calculation would create this result:
Actual Budget Variance
Revenue 100 50 50
Expenses 100 50 -50
Suggestion: implement "XCR" from Management Reporter. Basically XCR says "change sign if BASEROW = C" . In Account Schedules it would mean "change sign if row has 'show opposite sign' selected". The Revenue rows would have this selected in my example. The result above would be corrected since the formula budget -actual would be correct since the result of -50 on revenue would get it's sign flipped.
STATUS DETAILS
Needs Votes
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future.
Best regards,
Business Central Team