RE: Shortage / Due Reporting

["David Kemp" <dkemp@xxxxxxxxxx>]

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.