GL Ledger report giving bad information

Epicor ERP 10
,
1

No matter what fiscal year you put on the GL Ledger parameter form, data will always be fiscal year 2015. The periods you choose are correct. So if you enter 2018, period 2 to period 4, you get 2015 period 2 to period 4

The calendars are correct, the periods are created. I re-ran verify balances, no errors show.
Data is correct in GLJRNDTL.
Balances are correct and all looks good in GLPERIODBAL.
I created an SQL query that correctly returns same gljrndtl rows as would be expected in the Epicor GL Ledger report.

If I run a report for say period 5 in 2019, the printed report reflects that parameter correctly in the header, however data prints out for 2015.

As you probably know, this report is one of those few in Epicor that don’t address tables directly, but instead generate the dataset through code. So, I’m not really sure how I can even check where to look that may have 2015 hard-coded, as an example.

One other item, we have ~20 companies on Epicor 10, however 19 of them moved to AX in 2018. The 19 others are not used except for reviewing those things we didn’t move in to AX.
I mention it because if I go back in to any of these other companies, and run the GL Ledger report, they all show the same behavior, i.e. pick any fiscal year for your report, it will always show 2015.

Epicor 10.0.700.2, this is both with the Crystal default and the SSRS reports.

Any ideas where to look to see what is causing this?

Thank you

2

Do you get this with the Standard report Style that Epicor supplied?

image
image721×313 11.9 KB

Do others that run the report see the same thing?

Try the following:

  1. Launch the GL Report form
  2. Enable Tracing, Just track changes. Click “Apply”. Click “Clear log”
  3. Enter a 2019 in the Fiscal Year field and hit tab. Do nothing else on this form.
  4. Back in the tracing window, Disable tracing, click apply, and then select View Log.

There should be a section like:
(search for FiscalYrSearchImpl)

image
image1156×321 6.22 KB

In the “whereClause” line, do you see the year you entered in step 3? Or does it show 2015?

3

Hi Calvin,
Yes, I get the same results for both the default standard styles:
Standard - SSRS and Standard (the Crystal report version).

I tested the tracing, and the year I type in the box is the year that the tracing log shows

image
image1278×541 60.7 KB

4

Re-enable tracing, and submit the report. Then go back into the log and see if there is anywhere that FY 2015 is referenced.

5

Calvin, thank you for helping.
Running Standard SSRS, using year 2017, periods 3 to 4, and searching the resulting trace log for the text 2015 returns nothing.
Looking at the resulting report, it’s all periods 3 and 4 for year 2015