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. ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
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.

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

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