How to check Currency based on Company Code?

Options
algrigore
algrigore
in Modeling

Hello,

 Which formula should I use in order to bring the correct Currency based on the Company Code?

algrigore_0-1644058755497.png

I try with FINDITEM and LOOKUP functions, but I guess I'm doing something wrong, as I have errors.

 

Thank you in advance for your help!

 

Tagged:

Best Answer

  • TonyViGrand
    TonyViGrand
    Answer ✓
    Options

    Hi @algrigore 

     

    You wanted the formula to be put in Local Currency Line Item in DIM00_Input Data Module right?

     

    Try this formula:

     

    'ATT05 CMC02 Company Code L2'.'Currency (CUR01)'[Lookup:'Company Code']

     

    Regards,

    Tony

     

Answers

  • ManjunathKN
    ManjunathKN
    Options

    Hi @algrigore 

    you should have relation between Currency and Country list as an Attribute either in list property or in system module.

    then you have to use the lookup formula on Attribute as mapping.

    Thanks,
    Manjunath

  • algrigore
    algrigore
    Options

    I have as Attributes : 

    algrigore_0-1644060408764.png

    algrigore_1-1644060452676.png

    and also the Market module 

    algrigore_2-1644060493537.png

    but I don't know how to do it, how to make the connection.

    I would really appreciate your help.

    Br,

     

  • ManjunathKN
    ManjunathKN
    Options

    Hi @algrigore 

    Try this

    Local Currency[lookup : ATT05 CMC02 Company Code L2.Currency (CUR01)] in Local Currency check line item.

    Thanks,
    Manjunath

  • ManjunathKN
    ManjunathKN
    Options

    What is the dimension you have in DIM00_input date module? 


    Thanks

  • algrigore
    algrigore
    Options

    already tried, doesn't work

    algrigore_0-1644062661442.png

     

  • algrigore
    algrigore
    Options

    algrigore_0-1644062709607.png

    algrigore_1-1644062754501.png

     

     

     

  • algrigore
    algrigore
    Options

    Thanks a lot! now it's working!

  • ManjunathKN
    ManjunathKN
    Options

    Hi @TonyViGrand 

    thank you for solution! but if we lookup from system module and map it company code then there will be no relevancy on "Local currency" line item in DIM00_input module right?

    Thanks,
    Manjunath 

Categories