Re: Financial Report Writers

Jason Blanchette <jblanchette-fUqqJf+ygNcsA/[email protected]>
Newsgroups gmane.comp.systems.as400.mapics
Message-ID <[email protected]>
We use SQL Server reporting services and analysis services for all our reporting. The SQL Server BI suite. We've found because we have more than XA in our environment we are able to pull data from the multiple systems together very well. We can build an environment where the users can build their own reports once we set up the environment. 

Jason Blanchette
Manager, Application Development
Palliser Furniture Ltd.
www.palliser.com


On 2011-08-15, at 9:17 PM, "Richard Stover - Guide" <[email protected]> wrote:

> Suggest you look at INFOR's PM10.  In its basic form replaces FRx (since
> that is a dead product), but will also receive input from disparate systems
> (INFOR and non-Infor) including Excel uploads and manual entry.
> Additionally will perform consolidations and eliminations, and currency
> conversions.  Reporting examples beyond the standard P&L and Balance Sheet
> are departmental statements, product lines profitability and so on. PM10
> also provides the capability to drill back to the originating transactions.
> It also has the capability to handle other reporting outside of the pure
> finance world depending on what data you have available.  If you want to go
> fairly simple and are good with Excel and pivot tables then INFOR's F9
> product will do. Similar to Spreadsheet Server.  If you are looking for a
> "one product does all" and have some extra $$ laying around then look at
> Cognos.
> 
> 
> Best Regards
> 
> Richard (Dick) Stover
> Consulting Manager
> GUIDE TECHNOLOGIES LLC
> INFOR GOLD LEVEL CHANNEL PARTNER
> www.guidetechnologies.com
> [email protected]
> 215-499-8530
> 
> SAVE THE DATE - System i User Conference 2011 - Gaylord Opryland; Nashville,
> TN; October 2-5
> 
> 
> 
> -----Original Message-----
> From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]]
> On Behalf Of LeLeux, James
> Sent: Monday, August 15, 2011 9:59 PM
> To: MAPICS ERP System Discussion
> Subject: [MAPICS-L] Financial Report Writers
> 
> Hello everyone,
> 
> I know this topic has come up before as I was searching thru the ML
> archives, but it seemed a bit dated.
> 
> Looking for some tips on acquiring a financial report writer to be used by
> the finance team - not IT.
> 
> Looking at traditional accounting reports, but also looking to report across
> the system, tapping into standard costing, item master, inventory, etc  as
> accountants often do.
> 
> Most likely looking for a graphical tool that is not AS400 specific so that
> it is portable (think Syteline in x years...)
> 
> 
> I came up with this list, and am about to jump in feet first, but I would
> appreciate any tips on these or others.
> 1.    Infor (looking to XA 9.X)
> 2.    Advanced Logic Solutions, Inc.
> 3.    Enterprise 21
> 4.    Global Software's Spreadsheet Server and EDash
> 5.    Jacana
> 6.    FRx
> 7.    Cognos
> 
> 
> I am very open to anyone contacting me directly, as I know email can be
> tough to write experiences/opinions when you're busy.
> 
> I do not have problems with vendors contacting me directly either.
> We are willing to do the setup if there is a good product (FRx, Cognos) that
> works, but lacks the mappings.
> 
> Thanks in advance for any input!
> 
> 
> James LeLeux
> IT Director: Cherry, Shur-Lok, & SPS Santa Ana
> 2701 South Harbor Blvd
> Santa Ana, CA 92704
> M   714-929-8063
> SKYPE james.leleux
> [email protected]
> 
> 
> _______________________________________________
> This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
> To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected]
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/mapics-l
> or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
> 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-Zwy7GipZuJhWk0Htik3J/[email protected]
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/mapics-l
> or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
> 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-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.