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



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.





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.