I want to calculate the amount in USD (the origin amount / exchange rate if it is LCY) the customer ledger entry and add that to query. I tried to create a procedure in the query to calculate it but how i can add this in the dataitem. This is my code
Yes i have tries but it does not work
Did you try to use the procedure as the source for your column?
column(Amount__USD; GetAmounsUSD(rec))
{
Caption = 'Payment Amount', Locked = true;
}
I do not think it will work so i created another query for the exchange rate and used it in power PI
hi
look this
learn.microsoft.com/.../devenv-triggers
queries have only one trigger
check my answer if it helped you, thanks
DAniele
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156