We upgraded from V9 to E10 and need a solution to replace FRX. I have seen where some people say the standard financial reporting package is pretty good where others have hinted that AFR may be going away. Can anyone give me some current advice on which direction to go ? (perhaps a 3rd option ?) …

Don’t get me wrong, I’ve got a 5 year GL history( for 10 companies, 3 big, 7 small) that I process every night and the replication is VERY efficient in bringing over just the new rows. It’s the post processing that hurts a server - but honestly it’s only for about an hour total/combined… If you hav…

I’ve used both FRX and AFR and I’ll say that they are amazing similar in structure and function. AFR is of course better in a number of ways, and play nicely with it’s SQL replication. IT’s been pretty much hands off for a few years now, while the Controller makes his own changes as he adds account …

[image] Neil: required to install it on a separate server and mirror the SQL DB As for this part - yes, I would recommend it. It is really SSRS based, but it does some cranking on SQL while it takes the data from your production DB and converts it to it’s own format (in it’s own DB). But it r…

@MikeGross thanks for that info. Any idea regarding the install req’s ? We have another VM which we use for misc E10 utilities but it has the free version of SQL and I suspect that would not work for replication.

I don’t think Replication works on Express but I’ve not confirmed that. Microsoft keeps changing the rules… As for min requirements - we run everything on VMs - 32 GB memory (minorly oversubscribed on the host), 250 GB OS disk and a 500+GB data disk depending on the needs… AFR runs perfectly fine o…

We are VM as well, horsepower isn’t an issue. I was hoping that the whole separate server thing was only necessary for situations where there was constant financial reporting. Seems like my system will spend MUCH more time replicating than reporting.

@MikeGross - WOW, that was extraordinarily helpful information. 3 things that really stand out, Your DB is likely much larger than mine. The replication is only a subset of the DB It would not be terribly difficult to move if necessary. Another question if you would be so kind, how does the end …

the end user gets to the reports via SSRS (there some tricky behind the scenes authentication against the epicor security stuff), but the report designer/writer has an application to use that allows for the creation and mgmt of all the pieces like row/column formats, report books, accounts trees, us…

good question. I don’t know, but I’ll say Yes, for all the standard DBA’s reasons of not mucking about with your production database. :slight_smile:

@MikeGross I am told to look at XL Connect because rumor has it that AFR is going away. I am going to close this and open a similar one for XL Connect. Thanks for all your valuable input.

Advanced Financial Reporting (AFR) Advice

Epicor ERP 10

Neil (Just some cat on a guitar) June 2, 2020, 9:22pm 10

If I set this up on my Production Server (which I am not worried about horsepower) do I need to do replication at all ?

Topic		Replies	Views
Best solution for Financials Epicor ERP 10 e10	7	846	June 5, 2020
AFR, EPM or Just XL Connect? Yahoo Archive	8	1618	January 14, 2014
Alternative to AFR (Epicor Financia Report Designer) Epicor ERP 10	1	785	October 5, 2017
Financial Reporting for Epicor 10 Yahoo Archive	1	479	June 10, 2014
AFR and XL Connect Epicor ERP 9 e10 , epicor	9	695	August 20, 2020

Advanced Financial Reporting (AFR) Advice

Related topics