How to check Currency based on Company Code?

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!

 

Best Answer

  • 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