MIDRANGE dot COM Mailing List Archive



Home » MAPICS-L » April 2008

Re: Accounting



fixed

Just remember there might be hidden costs since an IT person would probably
be required to provide assistance in building these reports from Crystal or
Query. A tool like FRx or Spreadsheet Server doesn't require IT support for
report design as the interface has been built and users don't have to know
file structures.

Vanessa King



-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of mainstay MAINSTAY
Sent: Monday, April 14, 2008 9:10 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] Accounting



Want to second what Cork said about the new DB2 WebQuery. Saw a lot of
stuff on it at Common this year. It's replacing Query/400 and it kicks a$$.
Includes options to create spreadsheets as output.




---------- Original Message ----------------------------------
From: "Gindlesperger, Dale" <DGindle@xxxxxxxxxxxx>
Reply-To: MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
Date: Mon, 14 Apr 2008 08:12:37 -0400

Wow, hard to argue with $500. Also, (and this is a big benefit of being
on i5/OS, or as it will be called with V6R1, "i for business") is the new
DB2 WebQuery. If you have Query/400, it's FREE (that's even better) except
for the software maintenance (separate from your normal SWMA), and it offers
some VERY nice reporting options.

As your IBM business partner for more info!

Dale "Cork" Gindlesperger
Midrange Account Manager
Link Computer Corporation
Stadium Drive
Bellwood, PA 16617
Phone: 814-742-7700 Ext. 351
Fax: 814-742-7900
Cell: 814-442-1291

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of Dean Eggert
Sent: Monday, April 14, 2008 8:06 AM
To: mapics-l@xxxxxxxxxxxx
Subject: Re: [MAPICS-L] Accounting

Teresa,



Another option for you (reporting wise) may be Crystal Reports Server.
I have implemented Crystal Reports for Mapics about 2 years ago and have
not looked back since. The report designer is very intuitive and the
cost is low ($500). The 'server' portion runs on a windows IIS server
and the users can request their own reports ad-hoc or the server can
schedule the reports to run (print/email, etc) at any time. For the
$500, you get a less then full function server, but it hasn't bothered
me yet.



Thanks,



Dean Eggert

I.T. Manager

The Masterson Company, Inc.





message: 4

date: Fri, 11 Apr 2008 19:08:15 -0400

from: "Vanessa King" <VanessaKing@xxxxxxxxx>

subject: Re: [MAPICS-L] Accounting



Teresa,



Take a look at Spreadsheet Server by Global Software. Spreadsheet Server
is an Excel add-on and is real time (no data loads). It's definitely
worth a look. Since it's Excel, it seems very intuitive for Finance as
they seem to prefer using Excel anyway. It works with AM Financials as
well as IFM.

Two of my clients that currently use FRx are in the process of
purchasing Spreadsheet Server (and are planning to stop using FRx). I
saw the demo with them and it looks very slick. Their contact at Global
is Deana Mitchell-Tavolacci who could give you more info about it if you
are

interested: Deana.Tavolacci@xxxxxxxxxxx



I haven't used the product myself yet, so I can't give you first hand
knowledge. One of my clients has started their pilot and can't stop
talking about how wonderful it is. He says he wrote more reports in 3
hours than he has written in FRx in a year, so I'll be taking a closer
look at it!



Infor never created a real-time load for FRx Reporter, so you have to
run a load (full or delta) to a SQL database each time you want updated
information (like when you are entering journal entries at month end and
trying to get updated financials quickly). FRx is an excellent product
once the data is there, but the load is a pain and is somewhat finicky.
I have some clients using the product that are very happy with it but I
also have some that are looking at alternatives like Spreadsheet Server.
Just do some research and decide which is best for you.



One more tidbit - FRx was purchased by Microsoft and has been absorbed
by them. Microsoft has a new reporting package called Management
Reporter. The last time I checked, Infor had not decided if they would
write the interface to the new product. I have heard that FRx Reporter
will be supported but not enhanced by Microsoft. They are trying to move
their direct customers to Management Reporter.



Vanessa King

IFM and FRx Reporter Consultant



_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.



_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact