Standard Financial Report Print Error

Epicor ERP 10
1

We are trying to run the standard, out of the Box financial reports that have worked on other databases, but on our database, the Excel looking file does not come up and all we get is an error message in the Report section of the System Monitor.

ERROR: Run in preview mode from System Monitor for details. The report selected does not have any da

I assume it says there is not data, but we have a lot of GL Activity that we’ve DMT’d into the system.

Any ideas?

Thanks,
John

2

What is the report you are trying to run? What is the full error message? And what happens if you try to run that report in Preview Mode from the System Monitor? Sometimes running it in Preview Mode gives you even better information on the exact problem…

3

Hello Heather,

When trying to run either Balance sheet or Income statement, it acts as if it is running, then the excel looking preview file enver comes up. When you go to system monitor, you see the error in the message field. That’s the whole error.

I’ve used the same report on another system and it works fine. I’ve never seen this issue before.

Thanks,
John Gillenwater

4

John,
Are all of you transactions at this point entered thru DMT? I was just looking at my Trial balance report and do not see anything in the chart for entries made with either of the Open load (AP/AR) modules. I can run an aged receivables / payables and it matches to the penny but nothing shows in trial balance or when I look in chart tracker.

5

Hello Chris,

Thanks for the reply.

The transactions are historical journal entries that we entered so we’d have data for YTD, etc. I’m guessing it’s a DMR error of some type but not sure what field would be causing the report writer not to work. We have live data too and it’s not seeing that either which is hard to understand.

Other than that, maybe a COA setting of some kind or do you need some special software loaded to pull up that Excel like data file? We’ve got a call into support, but no feedback yet.

Thanks,
John Gillenwater

6

John,
I also loaded historical GL data thru DMT and that shows just like it should on the trial balance. What I don’t see is the records that I loaded thru AP/AR open load and posted. The AP/AR ageing reports and Invoice balance reports tie out with the correct amounts but it is not in the COA anywhere.

7

Hello Chris,

Just read your message again. The AP and AR open invoice load don’t post to GL, only to the subledger. The process is to load your open AR and AP, post, run agings, then load GL Balances as the last step. So you are loading the GL balance that already contains the open AR and AP.

Hope that makes sense.

Thanks,
John

8

John,
Thanks for confirming that. On my drive home tonight I was thinking I read that somewhere and I was going to have to find it.

As to your issue did you run c&p and or close the preceding period. I think I had to do one or both before the entries showed on my trial balance.