Skip to Content
0
Jul 22, 2016 at 01:43 PM

BPC NW 10.1 embedded BW 7.4SP13 : fox - distribution by pro rata by month

39 Views

Hi,

Needs : for budget process, the user has to enter a global amount in the period 012 and this amount must be allocate all periods in accordance with a key figure 'pro rata

For example, the amount entered is equal to 120 euros and the pro rata is 3 months, so the amount by month is 120/3=40

Before distribution:

Cost center 0VTYPE 0FISCPER3 KF : PRORATA 0AMOUNT CC1 3 012 3 120

After distribtion

Cost center 0VTYPE 0FISCPER3 KF : PRORATA 0AMOUNT CC1 4 010 # 40 CC1 4 011 # 40 CC1 4 012 # 40

So the calculation is dependent on the number of month

I started the Fox with two fields to be changed : 0FiSCPER 3 and 0VTYPE