Enabling the Flexible Decimal Places Feature

The Flexible Decimal Places Feature Console page enables the Flexible Decimal Places feature so that currencies with zero decimal places are supported and reflected in Accounting.

We recommend that you read this page carefully before you enable the Flexible Decimal Places feature.

Warnings:
  • When this feature is enabled it cannot be disabled.
  • When this feature is enabled the Salesforce currencies in the Manage Currencies tab override the existing Accounting currencies in the Accounting Currencies tab.
  • After enabling this feature any batches being posted to Accounting using third party APIs will be rejected if the batch contents contain monetary fields with incorrect decimal values. Each document has to contain decimal values that match the decimal places of the document currency.
Notes:
  • This feature is only available in multi-currency orgs.
  • Standard Salesforce rounding doesn't apply. Only round and summarize is used.
  • Compatibility with customizations made by Product Services may be limited.

Changes Made by Enabling the Flexible Decimal Places Feature

When enabling the Flexible Decimal Places Feature Console, you have to select a First Financial Year (FY01) for each company to apply the new validation and rounding rules in the entire product.

Immediate Changes

The following changes are made immediately:

  • Accounting Currency decimal places are overridden by Salesforce Currency decimal places.
  • Translation to currency using zero decimal places are rounded to integers. For example: Document Currency with two decimal places translated to Home Currency with zero decimal places.
Notes:
  • The existing Trading - Home - Dual Currency Definitions in Accounting remain, only the number of decimal places will be overridden.
  • When there is no currency translation, the monetary values in a currency with zero decimal places are not immediately rounded to zero decimal places after enabling the Feature Console.

Changes From FY01

The following changes apply from your selected FY01:

  • Decimal values of user input is validated - should be “.00” if zero decimal place currency.
  • Calculated monetary values are rounded to the decimal place of the document currency.
  • All monetary values of Transaction Line Items are rounded to the appropriate decimal place.
Note:

If you select the current financial year as FY01, the above changes will apply immediately.

Considerations on the Timing of Enabling Flexible Decimal Places

If you create documents in currencies using zero decimal places, and they have document values and outstanding values other than “.00”, you must round the outstanding values of those documents to zero decimals. For example:

  • For documents posted in FY01 and earlier years you must round the outstanding values of those documents to zero decimals before enabling the Flexible Decimal Places feature.
  • For documents posted in the current Financial Year, you must round the outstanding values of those documents to zero decimals before closing the current Financial Year.

If you use Home or Dual currencies that have zero decimal places, and post transactions with monetary values in Home or Dual currencies that have decimal places other than “.00”:

  • For transactions posted to FY01 and earlier, before enabling the feature you need to round the Trial Balance values to zero decimal places for each financial year and company affected.
  • For transactions posted to the current financial year the Year End process will round the values in the opening journal to FY01.
Note:

The Year End process rounds the GLA - Dimension Values combination Trial Balance only, not the account and document outstanding values. Therefore, it is recommended that you round those values before closing the current financial year.

Enabling Flexible Decimal Places

To enable the Flexible Decimal Places feature:

  1. Click the Feature Console tab.
  2. In the Features list, click Flexible Decimal Places.
  3. For each manual feature step listed, complete the tasks required. When finished click Mark as Done.
  4. For each feature step listed, click Perform. When the step has completed, the Status changes from "NOT DONE" to "DONE".
  5. When all the feature steps have been completed, turn the slider from (off) to (on).
Notes:
  • When this feature is enabled, if in Allocations the allocation currency has zero decimal places, you can only allocate Journals. Transactions cannot be allocated.
  • The default of rounding to two decimal places is not applicable to the Japanese Yen (JPY).

Rounding Outstanding Document Values

If you have any of the following and the invoice currency has zero decimal places, you cannot write-off the remaining decimal values after the new rounding and validations rules have been applied because you can only post integer monetary values in that currency.

  • Sales Invoices
  • Sales Credit Notes
  • Payable Invoice
  • Payable Credit Notes
Tip:

It is recommended that you reconcile sales and payable invoices, and credit notes, before rounding.

Identifying Documents for Rounding

Select the Reports tab and open the Flexible Decimal Places Rounding Reports folder. Ther following reports are available:

In order to assist with the manual rounding process, the Accounting Expansion Pack contains the following reports in the Flexible Decimal Places Rounding Reports folder:

  • Purchase Credit Notes - Outstanding Value
  • Purchase Invoices - Outstanding Value
  • Sales Credit Notes - Outstanding Value
  • Sales Invoices - Outstanding Value

You can add further filters to a report to decrease the number of rows. For example:

  • Document Currency: To display only documents in a currency that has zero decimal places.
  • Outstanding Value: To display only documents with outstanding values other than “0.00”.
  • Company: To display documents of the selected company only.
Note:

Standard reports display a maximum of 2,000 rows. If you have more documents, you can export the list view or All Sales Invoices, or create a new list view by adding the above mentioned filters and further Outstanding Value columns.

Rounding Document Values

You can use the Cash Matching feature to round outstanding values to zero decimal places. To write-off, select the GLA for which you want the rounded decimal values to be booked, then select the relevant accounts and write off the decimal values.

Tip:

You can input values to the Write-Off fields even if there is no cash entry posted for the account used.

Note:

After the Feature Console feature is enabled, for transactions in FY01 and earlier years, you can only input integers if the Matching Currency uses zero decimal places.

Rounding Trial Balances

For companies using Home or Dual Currency with zero decimal places, if there are already transactions posted with monetary values ending in a decimal place other than “.00”, a rounding journal should be posted. This ensures that the Trial Balance report for a financial year has only integer balances in a currency that has zero decimal places.

Identifying Trail Balances for Rounding

If a company does not use Dimensions, you can use the Trial Balance report. This report lists the GLAs and closing balances. You have to filter the report by:

  • Company: To display companies that use Home or Dual Currency with zero decimal places there must be a separate report for each relevant company.
  • Transaction Date: Ensure that you round balances for each affected financial year separately.

If the company uses Dimensions, you have to round the year end balance of each GLA - Dimension Value Combination. To find those balances you can use the Transactions and their Related GLA & Dimensions report in the Flexible Decimal Places Rounding Reports folder, filtered by company and financial year. You can export the filtered report to a spreadsheet and calculate the year end balances using subtotals or a Pivot table.

Note:

Standard reports display a maximum of 2,000 rows. If you have more rows, you can filter and export the All List View on the Reporting Balances tab.

Rounding Trial Balance Values

Calculate the decimal values to be rounded.

If you use the half-up rounding method, the total of the values will be zero.

If you use another rounding method, you need to define a GLA for the rounding difference to ensure a zero total in the rounding journal.

You can create the rounding journal manually or you can use Journal Loader. For more information, see About Journal Loader.