GL Financial Report Missing?

Epicor ERP 10
, ,
1

Finance dept is trying to run a GL report via Financial Reports, they have everything set up correctly as far as I know but the report errors out.

Epicor gives the error:

Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask:
System.Web.Services.Protocols.SoapException: The item ‘/EpicorLive/reports/GLFinancialReport/GLFinancialReport’ cannot be found. —>

I look in SSRS and I can’t find this folder/report in the database, not even in Epicor Test/Pilot

Can someone provide me with a copy of the stock Epicor report? Or am I missing something else here?

2

I don’t think the Financial reports are like other SSRS reports.

The Report Style Maintenance for it shows:

image

Did someone make a custom style and specify a location on the SSRS server?

3

I have that, it gives out the data in a “raw excel data” format, they want it to show in a PDF format.

I have the Standard - SSRS report style, which has the filepath in there, that’s the one they were trying

image
image790×279 7.26 KB

4

So did this used to work, and now doesn’t?

Or is this the first time you’re trying to do this?

Can’t you just do the Preview, then Print to a “PDF Printer” from the preview?

image
image651×520 21.7 KB

5

I have 2 report styles, “Print Report” and “Standard - SSRS”

Print Report works as expected and shows what you stated.

I’m looking to see why the Standard - SSRS report style does not work, it references a report file that doesn’t exist for some reason.

6

Did “Standard - SSRS” work before? Or is this something you are just now creating.

Our E10.2.300 only has the one style (“Print Report”). I can add one and manually set the fields, but I’d have to make the RDL, and I don’t even know what tables to reference in the query expression.

7

I guess I’ll just assume the Standard - SSRS style was created by someone here, been thinking it was a stock report, so I was trying to figure out why it wasn’t working.

But thanks for your insight!

8

I hope you find it, because I was able to make the core of a report that uses that data, and the way it is structured… Man that would be hard to create from scratch…

GFLRHeader and GLFRColumn look like they hold formatting and info for controlling which records from GLFRRow to display

image

image

You need to make some sort of Matrix, as GLFRRow records contain RowNum and ColNum fields.