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,