Account Schedule Issue

Shinis

Hi All,

In the account schedule, we have ticked "Show Opposite Sign" for all the Revenue accounts as the customer want to show the amounts in positive to avoid confusion. In the column layout we have set a formula
(current mth actual - current mth Bdgt) / current mth Bdgt for the Variance column. But the Variance is correct for Expense accounts and showing wrong sign of Revenue accounts due to the tick "Show Opposite Sign" in account schedule. Since the formula is same for all the account schedule lines, is there any workaround to fix the above issue?

Kindly advice.

Thanks.

Troelsh

There's no easy workaround ...

You will have to look into the code of CodeUnit 8 - AccSchedManagement. It's done in the calccell function.

Shinis

Yes, Got it. Thank you very much buddy. =D>