Annual budget exceeded Message no. FMAVC005

[former_member470479]

Dear Team,

Annual budget exceeded by 2095 USD (FM PB Availability Control) for document item 00002 Message no. FMAVC005

We are facing the error or issue in fund management. We have many entries of recurring entry. we are posting through by background job. all entries has been posted but one entry is not posting with same fund center and commitment item.

1. If budget available issue, why system has been posted another entries - rest of one

2. we have run the reconstruction report FMAVCREINIT 2-3 times but issue not resolved.

Please suggest.

@ Eli Sir Please help.

Regards

Sarvottam Tomar

[TammyPowlas]

Hello - I would turn on the trace to see which derivation rules are causing this as this SAP Note recommends: https://launchpad.support.sap.com/#/notes/0001586356

[iklovski]

Hi,

Why are you surprised that some entries have passed just one - didn't? Couldn't it be that the budget is exhausted just before posting this entry?

Please, provide more data about this entry and about the budget on FM objects impacted.

Regards,

Eli

[former_member470479]

Dear Eli,

Thanks for reply Sir.

My concern is if i am doing another entries with same fund center and commitment item entryies are posting but when i am using this entry,system is giving same error. If i have no budget so another entry should not post. but when i am going to check with same fund center and commitment item and simulate the doc, there is no error of budget.

Regards

Sarvottam Tomar

[iklovski]

I still don't get it... if you have 100$ budget, and 15 entries 10$ each, then 10 entries will pass, but 11th will be blocked. As I mentioned, before post some data about the impacted lines (budget, consumption, etc.). Also, three other aspects are important:

a) Do you have any special tolerance profiles?

b) Is there something special about AVC logic settings in your system?

c) Is there something about special about budget derivation, e.g. cover pool?

[former_member470479]

budget-error-p.png

Dear Sir,

This is the situation of budget. If we will post another entry with same FC & CC, system will post. rest of one entry.

Regards

Sarvottam

[Lakshmipathi]

Whenever you add any post to your original query, please do so under "Comment" and not under "Answer", as you were not answering to a query but only providing additional informations as required by the member. Meanwhile, I have converted your above post from Answer to Comment.

[iklovski]

Well, your report shows no budget. It shows no consumption either...

[former_member470479]

Dear Eli,

Thats my Confusion Report is showing no consumption but some document i post now after also report is showing same status. I am not able to understand how is behavior the system.

Sorry Lakshmipathi ..now i post with comment on this answer.

Regards

Sarvottam

[iklovski]

You have to examine your settings. Is it a living system or initial a test setup? You should check the tables for AVC (FMAVCT) and for consumption (FMIOI, FMIFIIT) to see that they are consistent with the postings. Also, check the nature of your commitment item; is it of category 3? What is financial transaction; is it 30?

[former_member470479]

Dear Eli,

Commitment item is financial transaction 30 and CIC is 3.

FMAVCT Table is showing 0 value for 9H and 9I fro 2018. and all previous year it is showing value. fmavct-table.png

FMIOI Table not updated for 2018 for combination of particular fund center and commitment item.but budget document posted?

FMIFIIT Table updated for particular fund center and commitment item. we are facing the in a recurring entry, last year entry is updated with same amount in which this year we are facing error.

Please find the attachment.

Regards

Sarvottam fm-table.png

[iklovski]

Check the following in IMG (SPRO):

a) Define Activation of Availability Control

b) Activate/Deactivate Funds Management

[former_member470479]

fm-spro.png

Dear Eli,

i checked the SPRO settings of AVC Budget control. i have below query.

1. Why FMAVCT table showing zero value for 2018.

2. FMIOI table also not updated for this particular fund center & Commitment Item.

Regards

Sarvottam Tomar

[iklovski]

If you don't have commitments on this FM address, then FMIOI will remain empty; there is nothing wrong. And you say that you run FMAVCREINIT on 2018 data? Try also running FMAF transaction on 2018 data to see if it shows any errors...

[former_member470479]

Dear Eli,

Yes I Run 2-3 time FMAVCREINIT . Now i run FMAF it is showing list contained no data in test Run.fmaf.png

Regards

Sarvottam tomar

[iklovski]

It's all very confusing. Without looking at your system, it's difficult to see what the problem is. If you don't have data in FMAVCT for budget, it could either mean that you didn't introduce the budget (check FMIT table for this FM address, do you have data there?) or that is something wrong with AVC, which is normally rectified by FMAVCREINIT.

[iklovski]

Also, check the situation in FMAVCT for other combinations in 2018. Are they equally empty?

[former_member470479]

Sorry ELI ..I post again in answer. pLease modify to comments on answer.

[former_member470479]

Dear Eli,

We checked another FC & CI. Table FMAVCT updated with value.

FMIT table also update this fund center & Commitment item but some value is zero. where business transaction is RMRP is Zero. I attached screen shot also both table and mark it.

with this .53140102 GL showing value ZERO. this GL is using in the Financial Posting.

Regards

Sarvottam Tomarfmit-table.png

[iklovski]

For budget - record type should be '1'. Your data shows only '0' (consumption).

[former_member470479]

Dear Eli,

I am not getting whats wrong. I am not able to catch the issue.what should i do?

Regards

Sarvottam Tomar

[former_member470479]

Dear Eli,

I checked your another Post. Should i use below?

You might be required to run RGZZGLUX report first, as if you have no records at all in FMIT, this could be the solution (see note 977016).

Regards

Sarvottam

[iklovski]

Hi,

For RGZZGLUX, it would have been the case, if you had completely empty table and not just for one combination. Anyway, to sum up, you obviously don't have the budget on the line in question, as it's not shown neither in FMIT nor in FMAVCT. You can recheck it by running FMEDDW transaction.

As for consumption, try the following:

a) Post something on problematic combination

b) Post the same document on another combination

c) Check the impact in FMIFIIT, FMIT and FMAVCT tables

d) If no impact in either of two cases, repeat it preceded by activation of a trace via ST05

e) Analyse the trace via ST05 and see if totals tables were at all mentioned there

If all this still doesn't provide you an answer, raise OSS message. I'm not sure I can help further without looking at the system myself.

Regards,

Eli

[former_member470479]

Dear Eli,

This translation FMECDDW does not exist. can u recheck this transaction code.

Regards

Sarvottam

[iklovski]

I meant FMEDDW

[former_member470479]

Dear Eli,

I executed the FMEDDW report but there is no entry for 2018.all entry is previous year.Please check the attachment.

Strange behavior?

Regards

Sarvottam tomar fmeddw-report.png

[former_member470479]

Dear Eli,

Another Fund center & commitment item is showing this report for 2018. but in which FC & Commitment item i am getting error,there is no entry.

Regards

Sarvottam Tomar

[iklovski]

Nothing strange; it simply means that you have no budget introduced for this line

[former_member470479]

Dear Eli,

I observe one thing in background job. in which entry i am getting error. cost center is not updating. and in correct entry cost center update. Fm derive rule also in cost center and fund center combination in fm derive . It is creating the problem.?

FM derive rule is both for GL and fc based and Coste center and Fund center base.cc-fc.png

Regards

Sarvottam Tomar

[iklovski]

Cost centre is not significant for FM posting. As long as FM objects are properly derived.

[former_member470479]

Dear Eli,

When i am using this particular Fund center and commitment item manually. and try to simulate there is no error. but when i am using background job. I am getting error?

Regards

Sarvottam Tomar

[iklovski]

You have no budget there, so it is strange that you don't have an error. Unless, with your manual posting the items are statistical and not affecting the budget or you have something in tolerance profiles strategy. But, as I mentioned, without looking at your system, it is difficult to advance further

[former_member470479]

Dear Eli,

Thanks for sharing me the useful information.

Issue has been resolved.

Solution : We have combination of FC and cci in fm derive from cost center and fund center. commitment item will be pick from GL. In our posting we are doing entry 1 series Gl is cr and 5 series exp gl is dr. when we are putting the expense gl and cost center was 121001 then system is picking fc 121001 and commitment item 53140000. but when checked in commitment item in 1st line item commitment item was same 53140000 but fund center was driving another 121004. because finance controller assign that 121004 FC with 1 series GL in Fm derive. this error was in background job. when i run in foreground i changed 121004 fc to 121001 then document has been post without error.

we will remove from FM derive also. we have communicate to business and user will be removed.

Note - but here my query is another 3 document also post previous with same GL and commitment item but in this this issue is not coming. what reason can be for that?

Regards

Sarvottam tomar

[iklovski]

In your screenshots it was not visible at all: all the lines were pointing to 121001.

[former_member470479]

Dear Eli,

In 2nd line item of exp GL it was 121001 but in first line item it was change 121004. i checked in front process at the time of documnet simulation.

Regards

Sarvottam Tomar