Forum Discussion

Mahamood0218's avatar
Mahamood0218
Icon for Helper II rankHelper II
3 years ago

bring currency value by using lookupvalue condition where period = M

Hi PBI,

I have two tables "ap_invoice" and "Tcurr'' , i need to bing "Kcrust" field from "Tcurr" table into "ap_invoice" table where                "Periond = M" by using "Lookupvalue" function.

Output like 

Could you please suggest.

 

Thanks,

 

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    In the question you asked, I cannot see any "ukurs" field in Tcurr table. 
    Can you please check the question and update it properly?

    Thank you.

    • Mahamood0218's avatar
      Mahamood0218
      Icon for Helper II rankHelper II
      3 years ago

      Anonymous  just now i have changed question ,we need to bring "Kcrust"  field from "Tcurr" table not "ukurs"

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Please tell me this thing.