Funds Management : Budget Transfer along with stock transfer

[jasbir_rajput]

Hello Friends,

We have a Fund Center Hierarchy as follows :

Zone ---> Division ----> Sub-Division

Budget is allocated at the start of the year in each division and sub-division by the zonal management.

However while doing stock transfer from Division to Sub-division, we have found that system post correct FI journal entries

i.e. Stock A/c Dr (Fund Center 1) - 100

To Stock A/c Cr (Fund Center 2) - 100

But what happens is that the Budget of FC1 is increased by 100 and in the similar way Budget of FC2 is decreased by 100.

When we view the FMRP_RW_BUDCON report, we find that the actual budget allocated for the year is not reduced / increased, whereas the consumption/commitment column has values increased /decreased.

We want that whenever there is a stock transfer the budget in proportion to the FI amount should be transferred also,

This will ensure that the available budget remains same , and there is no need for refurbishing budget manually.

Our OFUP settings have both GR/IR Update selected.

Can somebody point in correct direction.?

[iklovski · Accepted solution]

Hi,

Your description is not that clear, I'm afraid. What are you trying to achieve?

If what you seek is to make stock transfer not to impact your budget, then it is easy. You would need simply to divert stock transfer transactions to a dummy commitment item in FMDERIVE. You can distinguish stock transfers either by document type or movement type, both are available as source parameters in FMDERIVE.

However, if you have something else in mind, elaborate.

Regards,

Eli

[jasbir_rajput · Accepted solution]

Thanks a lot Eli, for your reply.

My question is reverse of what you answered

I will try to explain with an example/

Suppose Budget allocated for FC1 is 1000 and FC2 is 500

PO created for FC1 - 200, so now budget available in FC1 is 1000 - 200 = 800

MIGO done for PO in FC1 = 200, budget available remains same = 1000 - 200 = 800 (commitments squared off)

Now stock transfer from FC1 to FC2 of amount 200.

In the current scenario (SAP Standard config), the journal entries would be

Stock A/c Dr (FC1) 200

Stock A/c Cr (FC2) 200

so now budget of FC1 would be like this

Budget Allocated = 1000

Budget Consumed = 200

Transfer out = -200

Budget Available (1000 -200 - (-200) ) = 1000

Budget of FC2 will be as follows :

Budget Allocated = 500

Budget consumed = 0

Transfer In = 200

Budget Available (500 - 0 - (200) ) = 300

We want that along with Stock Transfer, if possible, an allocated budget transfer should also happen for 200

So if the budget transfer is possible, then system would show the budget available as

Hope you understand now, what is my requirement.

The steps currently i have on mind are

1.) Insert BADI , User Exit in MB1A / MB1B / MIGO - Trf Movt Type

2.) In that badi / exit, if the user is clicking on post , then system calls , BAPI_0050_CREATE to post a FM Budget Document for Budget Transfer and if successful (without any budget exceeded error message) then continue with stock transfer posting.

3. ) If user clicks on document check / simulation in the above transactions, then we can call the same bapi with simulation check enabled for error checking prior to posting.

If any better solution, please please advise. I have been unable to find any standard solution for the above.

[jasbir_rajput · Accepted solution]

Sorry journal entry would be

Stock A/c Dr (FC2)

Stock A/c Cr (FC1)

[iklovski]

Hi,

Oh? So, you want the budget to be moved following the consumption? I'm afraid this is not possible in standard. Of course, you can write a program which would be looking for stock transfers and perform budget transfer accordingly. You can use a standard BAPI for budget document creation for this goal (indeed, BAPI_0050_CREATE).

There is a drawback for this solution as there will be a gap between stock transfer and budget re-allocation. Solution with intervention just after stock transfer would be more swift, but I don't think you would find a user-exit for this. Hence, you would need to modify standard code.

However, you should think of the possibility to exclude stock transfer from budget operation entirely in the way I described in the first reply. The eventual impact on the available budget would be the same. So, why do you want to touch consumption and budget, while making developments in the system, if the ultimate result would be the same?

Regards,

Eli

[jasbir_rajput]

Hi Eli

Thanks a lot for your reply, Now that you have got my logic clear. I would like to add further.

1.) Regarding Budget Transfer on Stock Transfer.

The desired process change is for the reason, that if FC1 is procuring some material and transferring via STO to FC2,
then primarily the budget should have been allocated to FC2 itself. But due to previous year analysis and other observations if was allocated to FC1, so at the time of transfer it would correctly move to FC2.

This would ensure that if budget would have been allocated to FC2 in first place, this would not impact the current budget allocation and accordingly FC1 would have budget allocation lesser by that amount.

Example :

FC1 - Budget allocation would have been 800 instead of 1000
FC2 - Budget allocation would have been 700 instead of 500.

2.) Your solution regarding excluding stock transfer from budget operation completely.

This cannot be achieved since the commitment item for procurement and stock transfer are same in both transactions.

3.) I could not understand what do you mean by drawback.

Is the answer in Point 1. above connecting to what you mean.

4.) Solution with intervention just after stock transfer would be more swift ?

I would differ on this point, sorry about that, but if stock transfer posting in MM is successful and if in background mode i try to post budget transfer (Re-allocation) which fails due to budget exceeded, then i would not be able to control the MM posting.

I need to check before such posting as this would avoid the overhead of reversing the posting if done wrongly.

Hope you agree.

Voila...

After your 2nd reply, i got an idea, please put some light on this whether is it feasible or not?

In FMDerive (if possible) to write a derivation rule ,where the sender commitment item will be budgeted and receiver commitment item will be statistical

Can the above be achieved as in point no 2 i have told that commitment item remains same at stock transfer.

[iklovski]

1) Clear, though still ambiguous from functional perspective. However, I see the point.

2) You can alternate commitment item for stock transfer via FMDERIVE

3) With a timely job, for certain period, your budget won't be totally regularized; hence, unauthorized consumption can occur

4) Subjective. Both solutions of budget transfer have their cons. It would be better to take out stock transfer out of the budget flow completely, as I suggested.

[jasbir_rajput]

Thanks a lot, Eli,

We are trying to convince the department. If successful, this would be the best solution.

Else as i had suggested, need to do development.

Thanks for your time and patience