× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.