Multi-period consolidation

[Former Member]

Hi there,

We have a consolidation process that includes the following steps:

- carry-forward of LC balances

- conversion to group currency

- carry-forward of group currency balance for equity accounts

- consolidation automatic adjustments

To ensure that closing balances are correct, this 4-step process needs to run for each month. However, if we submit 2 or more months, it executes all months at each step.

How can I run these stored procedures one month at a time when the user selects multiple months (which he may do when he consolidates a budget, a forecast or a long-term plan).

Thanks in advance,

Regis

[steelblu]

You may try Runlogic syntax for runtime parsing of %time_set%.

[Former Member]

Hi Jungho,

We tried this method but to no avail. We are now reconsidering the approach of capturing monthly flows rather than YTD flow which seems to be the most common practice.

Thanks,

Regis