Hi,
In BPC, using the standard currency conversion rules in a YTD model, I can either convert the stored YTD amount or get the system to calculate the periodic amount and convert that (select the periodic calc option).
What I am looking for, still in a YTD consolidation model, is to convert the quarterly amount, rather than the periodic one.
We collect actual data on a monthly basis but our forecast is done only quarterly. The standard YTD calculation works. But is there a way to get a quarterly conversion? So for the 2018.06 forecast the system should calculate 2018.06 minus 2018.03 (in LC), convert this amount and then add it to the YTD amount in 2018.03 and store the result as the new 2018.06 converted amount.
This is an example of what I am looking for:
Thanks,
Arnold
Sorry, but not possible!
If forecast is entered only for the last month of the quarter then the next month will be zero. And periodic measure for the next month will be minus prev month.
Options: copy forecast data to the mid month of the next quarter.
1. Script to copy 03->04,05 06->07,08 ...
2. Perform FX conversion.
Or use script logic or badi to perform currency conversion:
Calculate delta in the script, multiply on rates and add to prev quarter.