Re: Shortage / Due Reporting -- MAPICS-L

Chuck,

I have a couple of questions:

1. what version of mapics are you on?
2. are you running the browser and integrator?
3. do you have operations navigator installed on one of your PCs?
4. how are you matching your MO records to you PO information?

My solution to you would involve creating an SQL view through Ops Navigator, then add that view to the browser (through the integrator) and make it available to your users. I've used IWP for report generation, but once we moved to V5R1, I switched almost all reporting to browser views. Nice thing is, the data is always live and it reduces a lot of paper pushing around the office.

Mike


Michael Crawford <mikec@xxxxxxxxxxxxxxxxxx>
Director of Information Systems
United Titanium, Inc.   330-264-2111

At 11/17/2003 08:57 AM, you wrote:

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.