Allow me to jump in and dispel the myth that IWP is green screen only. The
Windows based report designer is named Jacana and has been the primary focus
for reporting for a number of years. Jacana is amazingly powerful with the
ability to create calculations, sort, total, summarize, etc. including some
nifty tricks that cannot be handled by Query or SQL. This is an application
designed to produce complex reports in an easy interface. We also have
Valet, the Windows application for running reports and organizing
collections of reports.
While Jacana and Valet are easy to use components of IWP, there is some
training that should be taken to understand how IWP functions. Working with
IWP subsets can make report development simple - a number of subsets are
provided by Infor, and you can create your own. A little training goes a
long way to understanding those parts that make IWP seem complex and
confusing.
Momentum Utilities is the developer of IWP, JacanaForms and inTuator.
Regards,
-Greg
Gregory Novak
Manager North American Technical Services
Momentum Utilities Pty Ltd
(630) 985-1736
gnovak@xxxxxxxxxx
www.jacana.com
Making Information Work for your Business
www.intuator.com
-----Original Message-----
From: ibm [mailto:ibm@xxxxxxxxxx]
Sent: Thursday, April 30, 2009 3:49 PM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] IWP
Kevin,
We don't have system-link here yet. I saw the feature in the docs about
pulling request info right from XA's menu, but IWP is still green screen
only.
Our Mapics admin here is trying to get system-link approved. The use
would be to integrate a SQL database as well as post updates to the
AS400 server via web service.
Is this what I can expect from system-link?
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Kevin D Fox
Sent: Thursday, April 30, 2009 9:17 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] IWP
IWP hard to maintain?! That's a first!
select the system link menu option and you will get the sql statement.
Don't forget about security.
------Original Message------
From: ibm
Sender: Ximena Rodriguez
To: mapics-l@xxxxxxxxxxxx
ReplyTo: MAPICS ERP System Discussion
Sent: Apr 30, 2009 6:33 AM
Subject: [MAPICS-L] IWP
We have been using IWP reports for quite a while now but it's not easy
to work with and no one wants to maintain it within our company anymore.
I want to get all the report definitions out of Mapics and create SQL
Select queries using the .NET data provider. Any thoughts on how to get
the report definitions off the AS400 so that I can parse them out into
SQL queries?
_______________________________________________
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.
Sent from my Verizon Wireless BlackBerry
_______________________________________________
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.
midrange.com
