× 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.



An FYI to the list.  Since I am on digest mode, David contacted me directly.
After he reviewed one of our tutorials, he was able to determine that the
EXPORT folder needed to be created in QDLS/INFOWP.

David also mentioned (hope you don't mind) that his solution is typically
customer specific and the subsets are unique to their business.  I am pretty
sure that if you contact David off-list he would be willing to discuss his
methods and how he approaches the process of building a customized subset
from files output by Jacana reports.

For self-paced training, please visit the JuMPZone on Momentum's web site at
www.jacana.com/jumpzone.  These are a series of multi-media presentations
that cover a wide range of topics on our products provided free to our
customers.

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: David Kemp [mailto:dkemp@xxxxxxxxxx] 
Sent: Tuesday, November 18, 2003 1:07 PM
To: MAPICS ERP System Discussion
Subject: RE: Shortage / Due Reporting


Greg,

System registry enrollment is already set-up.  The same user already
downloads output from IWP to the QDLS/INFOWP folder.  User also has all
object authority and all special authority needed to write to all AS/400
folders.

Any other ideas?

David 


-----Original Message-----
From: Greg Novak, Momentum [mailto:gnovak@xxxxxxxxxx] 
Sent: Tuesday, November 18, 2003 12:54 PM
To: 'MAPICS ERP System Discussion'
Subject: RE: Shortage / Due Reporting

David,

Sounds like you need to add either your profile or AMAPICS to the system
directory.  The easiest way is to enroll the user as a PC user.  From
the
AS/400 Main Menu, select option 11. Client Access/400 tasks, then
options
21. Enroll Client Access/400 users.

Note that you can also specify saving to previous release on the Options
menu when prompted for method.  

Hope this helps,
-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: David Kemp [mailto:dkemp@xxxxxxxxxx] 
Sent: Tuesday, November 18, 2003 9:38 AM
To: MAPICS ERP System Discussion
Subject: RE: Shortage / Due Reporting


Greg,

I have never exported an IWP report to a PC file.  When attempting to do
so as you wrote, the following error message was received after PCDOWN
was entered:

8 objects saved from library IWPEXPT.

 Member PCDISKETT2 not copied to PC document.

 Function check. IWS1612 unmonitored by O#XG8135 at statement *N,
instruction  
 Text not available for message ODX0838 file O#XM0001.

 


As a result, there is nothing in the QDLS/INFOWP/EXPORT folder.  In
fact, the folder does not exist.  QDLS/INFOWP does exist as this is
where our Excel exports typically go.

Do you know why the export did not complete?

David



-----Original Message-----
From: Greg Novak, Momentum [mailto:gnovak@xxxxxxxxxx] 
Sent: Tuesday, November 18, 2003 8:21 AM
To: 'MAPICS ERP System Discussion'
Subject: RE: Shortage / Due Reporting

David,

This sounds like a great solution to Chuck's problem.  Would you be
willing
to share your work with him (and others in this forum)?  The reports and
subsets can easily be exported from IWP to a PC file and emailed to
anyone
that wants it.

>From IWP "green screen", select Export from the Housekeep menu.  After
specifying the reports and subsets to export, use the method PCDOWN.  It
will create a file in /qdls/infowp/export that can be copied or emailed.


Regards,
-Greg

-----Original Message-----
From: David Kemp [mailto:dkemp@xxxxxxxxxx] 
Sent: Monday, November 17, 2003 2:10 PM
To: MAPICS ERP System Discussion
Subject: RE: Shortage / Due Reporting


Chuck,

We have done exactly what you are looking for with Jacana.  We took the
approach of creating some database files of our own and then building a
customized subset.  The database files can be built using Jacana and the
subset can be created using IWP.  The reason we built our own database
files and subset was to make the linking in the subset much less
complicated.  We linked a CL to a task that runs all of the reports to
build the database files and then runs the report to produce the printed
output.  This makes running the report very easy for the user.  We also
use Jacana to download this same information to Excel.

The report gives all the items that are short with all manufacturing
orders that require the item, all purchase orders for the item with
appropriate due dates, and all inventory currently on hand.  This is all
pulled live from the MAPICS files so the report is literally up to the
minute.

David Kemp  


-----Original Message-----
From: Chuck Kearney [mailto:ckearney@xxxxxxxxxxxxxxxxxx] 
Sent: Monday, November 17, 2003 7:57 AM
To: mapics-l@xxxxxxxxxxxx
Subject: Shortage / Due Reporting

To all, 

I'm looking to create a single report that will combine manufacturing
order
shortage information with purchasing information.

We currently accomplish this manually using Microsoft Word. It's a good
report but with many issues such as time, accuracy, and timeliness.

All information used to create this report comes from Mapics. So why not
let
the system do all of the work, right?

The "Manufacture Order Shortage Report --- Follow-Up Analysis ---" is
used
to show what each manufacturing order is short. We use the purchase
orders
to know when items are due.

Any ideas on how to accomplish this? We use Jacana/Valet for report
writing.


Thank you, 

Chuck Kearney
Production Planner
Hydro Systems Company
Phone (513) 271-8800
Direct line (513) 842-2511

_______________________________________________
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.






As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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.