Currency Revaluation Report Old Rate Field Source

Epicor ERP 10
1

I’m hoping this is a quick answer for someone, I’m trying to find out where the “old rate” on the currency revaluation report for Bank Accounts is coming from. It doesn’t tie to any of our exchange rates, in fact it is closer to an inverse of our rates, but not quite, and seems to jump month after month.

May

image

June
image

2

  1. Open E10 and search for “Report Style”

  2. In report style search for the report “Currency Revaluation Report”
    image

  3. Drill down to the details and you will see a report location

image

  1. Navigate to your report server and find the report based off the location
  2. Open in report builder and review your fields (Hint if you are having trouble with finding a field that matches that output of the report, change the background color on fields until you figure out what field represents the one you are looking for)
  3. Then right click on the field look at its data set/query and see where it comes from. Sometimes you may have to look at the report data definition also.
  4. Guessing its this field =First(Fields!RptLiteralsOldBaseBalance.Value, “RptLabels”)
  5. Unfortunately it looks like the reports data set it a temporary data set called FROM ttCRReport_" + Parameters!TableGuid.Value + " T1"
    9.This means the report data definition which is usually comprised of physical dataset is now temporary dataset. Unfortunately I do not know how to look into these unless you probably have the SDK or maybe you can run a trace in Epicor and see what database elements its hitting.
1 Like
3

Thanks tyler,

I had gotten about as far as you as well and got stumped after finding that it was from a temporary table. I’ll try to get a trace log and see if that helps.

4

Best of Luck.

5

The trace log was no help, just gave me information on building the report, nothing showing a direct link to data that I could use. At least, not that I’m aware of.

I can’t seem to post the code without it disappearing. I’ve attached the somewhat relevant log if anyone is interested.

Somewhat relevant code.txt (29.0 KB)

6

Perhaps a SQL Profile trace might return better results. Where does this report print from, I can trace it later to see what’s possibly going on.

7

The report prints from the same server Epicor is installed on, from our reports folder. It’s just a stock SSRS report, not customized. It’s located under [Production Reports Folder] -> reports -> CurrencyRevalueRpt -> CurrencyRevalueRpt. I’d trace it myself but I don’t have admin rights and my I.T. admin is away for a week. And sorry for the delayed response, I’ve been away for a few days.

8

For anyone curious, Epicor responded with the below image in terms of how the “Old Rate” is calculated. However, I still can’t quite prove the rate out, and the bank balance was still not reflective of our actual bank balance. After some testing I’ve discovered that I needed to “recalculate bank balance” to reflect what is shown in our bank statement processing. However, when I run the Currency Revaluation report or the G/L Currency Revaluation report, no exchange is applied on the amount. Additionally, it doesn’t factor in the items processed but not yet cleared (outstanding items on the bank statement processing report) for the overall bank balance. Does anyone know anything about this that might help? Am I missing a step to have the revaluation report calculate exchange? Does Epicor just not factor in outstanding items in the bank balance or is there another setting I should be looking in to?

Epicor%20Revaluation%20Old%20Rate%20Logic
Epicor Revaluation Old Rate Logic.png1288×651 18.9 KB

Edit: never-mind, the exchange is being applied now, but still the old rate I’m not sure of.

9

It looks like Epicor is removing the “old rate” from the report in a future update.

1 Like