Sage XRT Advanced 3.2

Handling of decimals during import/export process by structure

Three fields have been added to the structure setup, to specify the number of decimals to handle when processing import or export by structure.

Decimals Number

This field enables you to specify the number of decimals for “Number” fields other than amounts (Rates, Versions, Numbers in Cash Flows entity, etc.).

During the import process, the rounding based on IEEE754 (2008) standard applies.

• All Significant: The exact number of decimals used in the imported file or in the database of Sage XRT Advanced is applied.

• 1 to 9: a number from 1 up to 9 decimals is applied.

Decimal Separator for Amounts

In this field, you can specify the symbol used to separate the integer part from the fractional part of numbers.

• ".": dot

• ",": comma

• None: without separator

• As Decimal (default): the option selected for Decimal Format is applied.

Decimals Number for Amounts

This field allows you to specify a specific number of decimals for amounts.

• All Significant: The exact number of decimals used in the imported file or in the database of Sage XRT Advanced is applied.

• 1 to 9: a number from 1 up to 9 decimals is applied.

• By Currency: the number of decimals set up for the currency is applied.

• As Decimal (default): the option selected for Decimals Number is applied.

"Replace" option for imports by structure

When importing files via a structure, Sage XRT Advanced allows you to remove specific data matching a condition.

You must have defined the condition first and assigned it to the import task (manual or automatic).

User Defined Fields: increased length of "String" field

You can now set a length of 512 alphanumeric characters, instead of 256, for String fields.

Attachments for bank accounts

In Setup, you can now attach multiple documents to bank accounts.

In the General information tab, click the Add button in the Attachments section, specify a document type, select the file, and save it with the account.

Simplified display of properties on view configuration box

When you click the View button or select the Edit action next to the current view name, the configuration box appears.

To simplify setting up the view, the display of paths in the Property column of the Columns tab has been improved.

Added date control option for bank imports

For bank imports, linked to Cash and Reconciliation modules, the dates control is now separated from the balances control. In the Global Application Settings of the Administration module, the Balances Control option has been replaced by two new options.

Balances amounts continuity check

When the option is disabled, no control is performed on bank statement balances.

When enabled, the check is performed when statements are posted to the current module. A statement can be posted if:

• its initial balance matches the final balance of the last posted statement,

• there are no rejected entries.

Warning: This option must be activated before the production phase.

Balances dates continuity check

This drop-down list offers the following options:

• None (default): no control is performed on bank statement dates.

• Later or Equal: the initial balance date must be later than or equal to the final balance date of the day-1 statement.

• Later only: the initial balance date must be strictly after the final balance date of the day-1 statement.

• Equal only: The initial balance date must be strictly equal to the final balance date of the day-1 statement.

Improved security of encryption key password

Password management for the encryption key is now subject to a security policy.

By default, users do not have access to this feature.

Reminder: file encryption is not applied to the file import function (bank, accounting, forecasts, etc.).

Addition of Discount and Bond Credit instruments

Two new transaction types are available in the Debts & Investments module: Discount and Bond Credit.

Discount

This new "In Fine” instrument, which typically does not generate a maturity flow, conforms to what already exists in the module.

The following features are available:

• actions: Update Currency Rates and Update Interest Rates

• life cycle: Change On Date, Change Participants, and Change Currency

As with other instruments, it is taken into account in:

• Outstanding

• Net Treasury

• Balance Sheet Notes

Credit Bond

This new "In Fine” instrument, which typically does not generate an initial flow, conforms to what already exists in the module.

The following features are available:

• actions: Update Currency Rates and Update Interest Rates

• life cycle: Change to date, Change Participants, Change Currency, Carry Forward and Early Redemption

As with other instruments, it is taken into account in:

• Outstanding

• Net Treasury

• Balance Sheet Notes

Financing Lines and Investment Lines

Debts & Investments enables you to manage Financing and Investment Lines, with the following characteristics:

• global amount in single currency with possible currency breakdown

• global amount split by entities and possible currency distribution

• management of available amounts according to specific events

In the Analysis - Portlets menu, a dedicated report is available: Fin./Inv. Line Report, with the following characteristics:

• display, in grid or graph form, of authorization, use and available amounts for each Financing or Investment Line

• view display in either global mode or global by currency mode, with or without details

• grid display in either financing and investment line currency or report currency

New default filters available

In the Cash Flow Ledger, you can now select the default filter Forecast not realized.

In the Bank Transactions menu, the filter Transactions on hold allows you to display the unreconciled bank transactions.

Tooltips on Cash Position Worksheet

When hovering the balance types in the Cash Position Worksheet, you can read hints giving you details about the calculation method used for a specific type.

• Initial: Balance on the beginning of selected period, based on all CFs for selected account(s).

• Initial Partial: It is based only on CFs selected by CPW filter. Excluding some CF statuses can result to Initial differs Initial Partial.

• Final: Operating balance + all CFs impact from decision flow codes and others.

• Final Partial: Operating partial + all CFs impact from decision flow codes and others.

You can optionally edit the hints in the CPW Structure settings.

New display option for Cash Position Worksheet and Discrepancy and Account Analysis

You can now hide the details of bank accounts from the Cash Position Worksheet and the Discrepancy and Account Analysis.

Enable the Hide accounts rows option in the Groupings tab of the dedicated structure.

Example of display without accounts

Example of display with accounts

Multi-account Processing

The Multi-Account Processing feature enables the reconciliation of:

• a bank entry from one account with a forecast from another

• multiple bank entries from one account with a forecast from another

The Account Code of the bank entry then replaces that of the forecast.

The other columns are filled in according to the usual reconciliation rules.

Optimized reconciliation engine

In order to limit Timeouts, you can specify the number of entries impacted by the Group by combination option.

The Max. records in group field allows you to set a number between 2 and 10.

New Widget services

New services are integrated as widgets into the Bank Area module:

• Service Bank Statements

• Bank Communication service

New Widget services

New services are integrated as widgets into the Payment module:

• Payment services

• Anti-Fraud services