2446809 - Money format in the statements is not default money format defined in the form template

 A column in the worksheet will be using the default money format.

Example :  

<comp-number-format-ext id="defMoneyFormat" mode="round" useFor="money">
<comp-number-format-ext-format><![CDATA[###,###,##0.00]]></comp-number-format-ext-format>
</comp-number-format-ext>

But in the statement you will see same column value will be displayed in different money format as below.

Amount column in the instance have default money format as ###,###,0.00 but in the statements the money format of the column is ###,###,0.00000000000.

Compensation and Varible pay

There will be multiple money formats configured in the Compensation template xml. During statement generation, system will always format fields with default money format. Last money format in the list defined will be the default number format for the statements.

Convention used is - last money format in the list will be the default form.

NOTE : We do not support field based number formatting for success store statement templates. All the fields are formatted with default money.

Example: (This is what you might see in the compensation template)

      <comp-number-format-ext id="defMoneyFormat" mode="round" useFor="money">
        <comp-number-format-ext-format><![CDATA[###,###,##0.00]]></comp-number-format-ext-format>
      </comp-number-format-ext>
      <comp-number-format-ext id="defPercentFormat" mode="round" useFor="percent">
        <comp-number-format-ext-format><![CDATA[#,##0.00]]></comp-number-format-ext-format>
      </comp-number-format-ext>
      <comp-number-format-ext id="defAmountFormat" mode="round" useFor="amount">
        <comp-number-format-ext-format><![CDATA[###,###,##0.00]]></comp-number-format-ext-format>
      </comp-number-format-ext>
      <comp-number-format-ext id="defRatingFormat" mode="round" useFor="rating">
        <comp-number-format-ext-format><![CDATA[0.##]]></comp-number-format-ext-format>
      </comp-number-format-ext>
      <comp-number-format-ext id="defRatioValueFormat" useFor="ratio-value">
        <comp-number-format-ext-format><![CDATA[#,##0.00]]></comp-number-format-ext-format>
      </comp-number-format-ext>
      <comp-number-format-ext id="defProrationFormat" useFor="proration">
        <comp-number-format-ext-format><![CDATA[#,##0.00]]></comp-number-format-ext-format>
      </comp-number-format-ext>
      <comp-number-format-ext id="multiDecimalRounding_hidden" mode="round" useFor="money">
        <comp-number-format-ext-format><![CDATA[###,###,##0.0000000000]]></comp-number-format-ext-format>
      </comp-number-format-ext>
      <comp-number-format-ext id="TotalPercent" mode="round" useFor="percent">
        <comp-number-format-ext-format><![CDATA[#,##0.0000]]></comp-number-format-ext-format>
      </comp-number-format-ext>

In this case last money format defined in the template will be used as default money fromat in the statement templates.

You need to declare/configure the default money format at the end of the list to resolve the issue.

Compensation statement, Variblepay statement, Combined statement, Statement, Money format. , KBA , LOD-SF-VRP-PS , Personal Statements , How To