Show TOC

Function documentationAccount Transformations Locate this document in the navigation structure

 

You can create a new logic file to run an account transformation rule. You run this rule by calling the stored procedure SPRUNCALCACCOUNT in any logic file.

This procedure is launched using the logic statement:

*RUN_STORED_PROCEDURE=SPRUNCALCACCOUNT(parameters list)

For example:

*RUN_STORED_PROCEDURE=SPRUNCALCACCOUNT([%APP%], [%CATEGORY_SET%], [%CURRENCY_SET%], [%SCOPETABLE%], [%LOGTABLE%],[Transformation group])

The following table describes the fields for the account transformation rules table.

Field Name

Description

Transformation group

The identifier for a group of calculations.

Source account

The name of the source account. You can also select values from TYPELIM*, DIMLIST*, aggregated, and base member.

Source flow

The source flow member. You can also select from DIMLIST*, SUBTABLES_ORIG*, aggregated, and base member. Alternatively, you can leave blank for all members.

Source data source

The name of the source DataSrc member. You can also select from DIMLIST*, DATASRC_ORIG*, aggregated, and base member. Alternatively, you can leave blank for all members.

Destination account

The name of the destination account base member or blank if the destination account is the same as the source account.

Destination flow

The name of the destination flow base member or blank if the destination flow is the same as the source flow.

Destination data source

The name of the destination data source base member or blank if the destination data source is the same as the source data source.

Reverse sign

If selected, the value of the amount is reversed.

Source period

Enter the month to process. It can be an absolute (for example, NOV or DEC) or a relative amount (for example, -2, -1, +2, or +2). Leave blank to use the current month.

Source year

Enter a year to process. It can be an absolute or a relative amount. Leave blank for the current year.

Apply to YTD

If selected, the YTD value is used in the calculation in a PERIODIC application.

Remark

A description for the rule.