RE: Shortage / Due Reporting

Chuck:

The On-Time Orders (OTTO) software provides a standard reports for 
manufacturing orders, in a multi-level indented presentation, showing order 
information, component(s) due, when it is due, and from what manufacturing 
orders or purchase orders the component is being sourced.  

Additional information is available at www.mandisinc.com

--
Best regards,

Mike Dreimiller
Mandis Inc.
410-526-5996
Mandis-Inc@xxxxxxx
> 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.
>