USD to LC currency conversion!!!
Hello, I am familiar with LC to Reporting currencies conversion. but my client has a requirement of USD to LC currency conversion, can someone give me an idea on how to do that with lookup?
1) You do not need to define scope for datasrc if you only send either one and want either one triggered. In your case if you send miscadj then corpadj gets included as well but we normally do not need that. These records will be handled when they are sent. Removeing xdim_memberset will improve performance.
2) For the rate lookup you need to define any dimensions that are not common or are variable:
Time is already defined, category as well;
We need source currency and destination currency. In the end you'd have something like this:
RateEntity = Global
RateDim = AccountDim.Ratetype
RateSrc = RateInput
SourceCurr:InputCurrency = USD
DestCurr:InputCurrency = CompanyDim.Currency // This is local currency
// Now we have two variable to look up
3) We need to multiply %value% with the rate stored in the appropriate intersection, in this case whatever local currency is and USD. Which one is divided by which one, depends how you store your rates.
IS miscadj, corpadj // We want to makse sure only these will be handled