Calculate Currency using Document Date

[Former Member]

Hey All,

I have a requirement to do currency conversion at the Document Date instead of Posting Date for AP invoices. I cannot seem to find any config settings for this. Anyone know of where I can look?

Thanks,

Justin

[Former Member]

Thanks

[Former Member]

You can do this by changing the translation date type to 1 in customizing transaction code OB22. But that will apply to ALL translations in this company code, not just for AP invoices. Instead, set the value as 3 in OB22 (which is translation date). When you enter AP invoices, enter document date in translation date field in 'Local currency' tab of FB60/MIRO header.

[Former Member]

Srikanth,

The solution you mentioned look like it will work. However i find that the translation date field is auto-populated and not changeable with the value that is entered into the Posting Date Field. Is there a workaround for this?

Thanks,

Justin

You can do this by changing the translation date type to 1 in customizing transaction code OB22. But that will apply to ALL translations in this company code, not just for AP invoices. Instead, set the value as 3 in OB22 (which is translation date). When you enter AP invoices, enter document date in translation date field in 'Local currency' tab of FB60/MIRO header.

[Former Member]

I also notice there is no Translation Date Field in the Header for Miro - How can I find this field?

Thanks,

Justin

[Former Member]

You are right, I don't see that tab in MIRO. I see in FB60, though. And in our case the translation date field is pre-populated with the posting date, but the field is open for change. I looked a couple of things (like field status) but could not quite figure out why the field is greyed out in your case.

[Former Member]

A coworker has brought to my attention that the Translation Date field is not available in MIRO. You can see note 574583 for some more information. Looks like a Gap.

[Former Member]

For any other doing French GAAP. This note is the solution to this issue.