Account Transformations 
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 |
Source flow |
The source flow member. You can also select from |
Source data source |
The name of the source |
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. |