Fund Reservation check for decimal fraction difference

[Former Member]

We are facing few issues with Budget Check during Goods Issue in MIGO.

Error Message:

“Open amount from document XXXXX 001 exceeded by .61%”

Background:

We create Material Reservation on XXXX date for an item in Store. System creates Budget Reservation on the same date with respect to the Budget available and calculating the price of the item on that date. This item is maintained with Moving Average price which keeps changing with change in Material price. Hence, the material price at the time of goods issue changes.

Even though the Budget on Goods Issue date is available or is less than .0123 BBD (Barbadian Dollar), which occurs due to price difference of the item, the system throws error message.

“Open amount from document XXXXX 001 exceeded by .61%”.

System calculates the price differences between Budget Reservation and the Material Price as on Goods Issue Date and checks upto 1/100000 decimal differences. In general any decimal value should be rounded off and Budget should not block the Goods issue due to differences in Decimal.

Work around Solutions:

1.       Increase the Budget in T Code FMBB by .0123 BBD and try posting the MIGO.

Result: Still system throws the same error message.

2.       Change the Unit Quantity of the item to 100, 1000, 10000 in Material Master in order to remove the differences on decimal as a result clearing the budget check.

Result: We are able to resolve only 50% of the issues with similar error.

3.       If the Error is still not resolving even after changing the Unit Quantity of the Items in Material Master, then we are changing the Goods Reservation date in MB21 to the Goods Issue date.

Result: 99% of the errors are getting resolved. However, there is still 1% of issues remaining unresolved.

4.       Now inorder to resolve the final 1% of the issues, we change the Material Reservation Date in MB22 to previous date of Goods Issue and then change it back to Goods Issue date. After this we try posting Goods Issue in MIGO, the system accepts and posts the document.

The above solutions are temporary and not resolving the problem completely. Also, these steps have lot of manual intervention which should be automatically done by SAP instead.

Questions:

1. Is it possible to convert the Budget Exceeding error message to warning message only when there is a decimal difference between Budget Reservation and Material price during goods issue. Example- 1/10,1/100,1/1000,1/10000 decimal spaces.
2. Will there be any impact on other processes.

Major Issue:

1. There is inconsistency while system checks the budget only in some cases.
2. System is throwing error message for differences in 1/10, 1/100, 1/1000, 1/10000 decimal places. Eli Klovski

If we can resolve the above 2 problems, that will stop the issue permanently.

Please suggest how can we rectify the above issues.

,

[iklovski · Accepted solution]

Hi,

Without going into details of the source for differences (a more thorough analysis on the data is required in such case), increasing the budget (FMBB) obviously won't solve anything. The error you are receiving is not for the budget, but for the earmarked fund. In order to overcome small discrepancies, as a workaround, you can use tolerance limits in earmarked fund, defining possible deviation in percentage or in amount.

Regards,

Eli

[Former Member]

Hi Eli,

In our business scenario, this solution wont work.

Reason being- I will give one example.

One item costs 10.15 BBD. When we do Material Reservation for 20 items, it becomes 10.15* 20= 203 BBD. We have sufficient budget available during this time. There is Budget Reservation for an amount of 203 BBD. This happens when there is a Goods Reservation. However, the goods issue doesnot happen immediately.

Now, the Item price keeps changing and on the date of Goods Issue, the Item price becomes 10.90 BBD per unit. So the Goods Issue happens for 10.90*20= 218 BBD. This amount is too high than 203 BBD. Now, the budget is not available during goods issue. Hence we try increasing the budget,

Still the error during MIGO for Goods Issue is not resolved.

We tried changing the Unit Quantity in Material Master where we have moving average price but this doesnot work out since client wants the quantity unit to be only 1 unit.

Please suggest what can be done.

[iklovski]

You should not increase the budget, but the reservation (EMF). Did you consider manage your commitments also on quantity level, instead of amount?

[Former Member]

Please tell me the T Codes where I can maintain both. Also, in Earmarked Fund I have 3 document types

11	Funds Reservation W/O Workflow
AA	Funds Reservat. with Workflow
EF	Funds Reservation Material Int

Please suggest which one needs to be selected. When do we need to increase the earmarked fund, is it during the Goods Issue date?

I am checking the option for maintaining the Commitment Item by quantity, but not able to find any option.

Please suggest.

[iklovski]

You modify reservations via FMX2. But, did you try to run RFFMRP_MAT_RESERVATION on this document with 'Correct updated docs' option?

[iklovski]

Additionally, I suggest you to check if the following notes are implemented:

2119388 - Earmarked funds for material reservation with open remaining amount

1270480 - FMRE: Wrong amount calculated based on MM reservations

1135281 - Error RE064 when posting a GI against a Material Reservation

If you use MRP or other automatic tool for material reservations, check also these:

1478910 - Earmarked funds document updated with incorrect price

1606364 - Earmarked funds document updated with incorrect price II

What is your SAP release, by the way?