Budget Revaluation

[former_member584325]

Hello gurus

My client posts budget in both Local Currency (USD) and FX (EUR). Every month we have to recalculate the amounts posted in EUR to figure the difference in USD (LC) to post a document with the corresponding increase/decrease where applicable. Obviously, the reevaluation is only calculated over the available budget amounts, as commitments and open items are reevaluated through closing operations. My questions is if there is any way to reevaluate the available budget automatically?

Thanks in advance for your help.

[iklovski · Accepted solution]

Hi,

Grants, you mean via GM module? I don't think that something could be automated if this domain within the standard boundaries. Because, I don't think there is such a thing as revaluation of budget documents; at least, I'm not aware of any such algorithm even in the most recent versions. So, what doesn't exist cannot be automated 🙂 Of course, you can always build a program which will generate budgetary documents based on the same principle which is applied during their Excel calculations, if they are sufficiently straight-forward.

Regards,

Eli

[former_member584325 · Accepted solution]

Well. That's exactly what I thought, I have never seen anyone entering budget in different currencies but I had to ask just in case, one never knows. Thank you very much for your advice.

[iklovski]

Hi,

I'm not sure I follow your question... The revaluation is executed generally on the commitments and not on the budget. I don't understand the remark about having budget in two currencies; what is the currency of FM area in question?

Regards,

Eli

[former_member584325]

Hello, the local currency is USD, but some Grants are posted in EUR as Budget Entry. Since this is available budget, the client calculates the revaluation in excel based on the month's exchange rate and posts a SUPP/RETU document for the revaluation difference in USD. I have never seen anyone do this but that's what they do, so I wonder if there's any way to have the system to calculate and post the revaluation automatically.