Skip to Content
Former Member
Jun 21, 2006 at 05:24 PM

Automatic Generetion of Offsetting entry - Planning Functions



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,