RE: Shortage / Due Reporting

["David Kemp" <dkemp@xxxxxxxxxx>]

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.