Financial Statement calculation column behavior with Currency Converter

  • Article

Problem:

When using the currency converter on a Financial Statement, calculation columns are restated.  In some cases, this may not be desirable as the calculation column may already contain information as needed.  An example would be a calculation column consisting of a sum of two columns that contain secondary currency information.

Resolution:

To resolve this issue the class \Classes\LedgerBalanceSheetDimPrint\buildFields can be modified as follows.  The changes consist of moving one of the case statements to an earlier point in the code. 

From:

...

                            case LedgerColumnTypeDim::CurrentCur,
                                LedgerColumnTypeDim::BudgetCur,
                                LedgerColumnTypeDim::CovCur :
                               

                                reportRealField.extendedDataType(extendedtypenum(AmountCur));
                                reportRealField.dataMethod(#methodDisplayAmountCur);
                                break;

...

To:

...

                            case LedgerColumnTypeDim::CurrentCur,
                                LedgerColumnTypeDim::BudgetCur,
                                LedgerColumnTypeDim::CovCur,
                                LedgerColumnTypeDim::CalcExpression :

                                reportRealField.extendedDataType(extendedtypenum(AmountCur));
                                reportRealField.dataMethod(#methodDisplayAmountCur);
                                break;

...

and remove\comment the code in the following case statement.

case LedgerColumnTypeDim::CalcExpression :
                                reportRealField.extendedDataType(extendedtypenum(AmountMST));
                                reportRealField.dataMethod(#methodDisplayAmountMst);
                                break;