FDMEE Extrapolation based on period
Hi
We have to load data each month based on trial balances received a quarter in arrears e.g. for September we load June's trial balance. We need to extrapolate the income statement amounts in the trial balance based on the period e.g. loading June into September will be amount x 9/6.
What is the best way to do this type of extrapolation based on the month in FDMEE with none to limited manual intervention?
I considered:
Import scripts - but not sure if I can use variables relating to the period so that we don't have to manually update the script every month.