Automatic Generetion of Offsetting entry - Planning Functions

[Former Member]

Hi,

I'm working on a project that will facilitate the users to enter planning data for the capital projects. I have a business requirement for plan transfers between individual projects.

In my planning layout, I have Project ID, Sender/Reciever Project ID and the Net Transfer Amount. The problem with that is I need to enter this with the offsetting so that the reporting will be meaningful.

So, the user will have to enter the transfer like:

Proj. S/R Proj. Net Transfer

10011 40078 15,000 USD

40078 10011 -15,000 USD

The above entries show that $15,000 is taken out of proj. 40078 to fund proj. 10011.

Is there any planning function to produce the second line once the fist one is entered? Keep in mind Project ID and Sender/Receiver Project ID are two seperate info objects with the same master data table.

I'd appreciate any help/suggestions,

Thanks,

[Former Member · Accepted solution]

Hi,

I am not sure about a standard function for this, but this can be achieved by using an exit function.

let me know if you need any help with this.

thanks

[Former Member · Accepted solution]

Hi Anand,

Thank you for the suggestion.

Could you please explain more about the user exit function and the coding logic that goes with it?

I'd appreciate any details on that,

Thanks again,

Baris

[Former Member · Accepted solution]

Hi,

If you are using SEM4.0 and above, there exists a planning fn 'Offsetting entry'.

If you are using BW3.5 but not SEM, then I believe you could use the 'Repost' and/or 'Distribute by Keys from Sender to Receiver' if the user knows which % of fund to be moved. If they only know exact amount, then 'Repost' might be used.

HTH,

regards,

Nataraj.

[Former Member · Accepted solution]

Hi,Nataraj:

I think "repost" can not achieve that goal.I suggest the guy to use EXIT function to copy a new row in the dataset.If you want to learn more about Exit Function,You can use SE37 and display the Example function in Function Group UPFX.

Wish a little help to you.

[Former Member]

Another option is to create the second posting in FOX when the entry is saved. Include the Sender and Receiver (as separate columns) in your layout and create a FOX formula which creates a positive posting to the receiver and a negative of the same amount to the sender.

If you are going to do this, you need to create a "Layout" key figure to capture the amount of the transfer. The FOX formula then creates a posting using the "Real" key figure (eg. 0AMOUNT).

[Former Member]

Thank you all for the suggestions. Seems that it will take some coding to get what I want. Offsetting Entry function works fine but I have to input,in the parameter group, the sender-receiver relations for individual projects. It's not feasible considering that the number of projects may exceed 500. and there's no functionality that offers variables in the parameter group itself.

The alternative solution in my mind is through copying the inital entry into a different version and then swapping the positions of Project ID and Sender/Receiver Project ID using an easy FOX formula.

I've just posted a separate discussion thread for that and would appreciate your thoughts.

Thanks,