Reply: 4

Auto translated

Reporting date for currency translation

Hello all,
In SAP ERP ECC 6.06 SP 16 (Basis 731 SP 17), is it possible to set whether the document date or the posting date is used to determine the exchange rate from table TCURR?
It is about the translation of foreign currency invoices into local currency. Not about the separate translation of any tax amounts.
Thank you very much for your advice.
Best regards
AnWo

You must be logged in to post a reply.

Login now

4 Answers

  • MrBojangles
    MrBojangles
    Hello Anwo,
    I am not aware of a changeover in FI Customizing from conversion date = document date, instead of posting date. Of course you can specify the conversion date manually in the document header or try to work with the substitution.
    Have fun with SAP...
    Cheers
    MrB.
    Blog
  • AFR
    AFR (Author)
    Hello Mr.B
    Thank you very much for the quick reply.
    I have never consciously taken note of the "Conversion date" field.
    The department should be able to work with this.
    Many greetings
    AnWo
  • Akarin
    Akarin
    Hello AnWo,
    such possibility exists with a simple coding inside the BADI FI_TRANS_DATE_DERIVE. This BADI is filter dependent where the filter is set as country.
    In BADI SAP provides us 2 data:
    Posting date (I_BUDAT)
    Document date (I_BLDAT)
    and in addition document type (I_BLART).
    A simple coding for activation of voucher date as conversion date:
    constants: lc_fbb1 type sy-tcode value 'FBB1'.
    if sy-tcode ne lc_fbb1. "F.05/FAGL_FCV valuation uses this transaction
    E_WWERT = I_BLDAT.
    endif.
    This sets the conversion date as the document date by default. However, this can still be overwritten by the user (if necessary). This BADI works for MIRO/invoices (SD) as well as FI postings (FB60/50/70/ FB01 etc.).
    Greetings from Poland,
    Marek
  • MrBojangles
    MrBojangles
    Hello Marek,
    thanks for the hint with the BadI. I knew there was something else, but I didn't find it in a hurry.
    LG + Continue to have fun with SAP...
    Cheers
    MrB.
    Blog