bring currency value by using lookupvalue condition where period = M

[Mahamood0218]

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,

[VishalJhaveri]

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]

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

[VishalJhaveri]

Please tell me this thing.

[Mahamood0218]

@VishalJhaveri  yes, common columns are invoice date and payment date and we have another common columns inv_currency_code and fcurr coulmns field