RE: MRP files KFP KMR KRO etc.

[Beth Norris <BNorris@xxxxxxxxxxx>]

I looked for the action messages myself and found only that there is a
planned reschedule date in the files.  The KMR file lists all Material
Requirements (both met and unmet needs) - the KFP lists all the planned
orders based on the KMR needs that are not met. Therefore I had to get
creative and I have written several AS/400 queries to obtain a quick glance
at the Expedite orders and releaseable orders.  This gives each planner a
list of their 'HOT' items that they can review each morning.

For open PO that need to be expedited - I use the HPO file and compare the
due date (PDDTE) to the MRP reschedule date, (PLDTE).

For open PO that are past due receipt - again I use the HPO file with any PO
that has a due date older than today's date.

For open SO - I list the shop orders by due date from the FSO file with the
MRP reschedule date available so that each planner can reschedule their own
shop orders.  (The standard BPCS report, MRP209, lists  all shop orders on
the same report.) This list is actually given to the forman on the shop
floor so that they know which shop orders to complete first.

For Planned Purchase orders - This lists the purchase orders that need to be
released that day.  I use the KFP file where the planned release date is
equal to today's date.

For Planned Release Shop Orders - We use the standard MRP250 report with
today's date only as the parameters as this lists the shortages on
components.

Primitive in some respects but it works.

Beth A. Norris
Fawn Engineering
Des Moines, IA
bnorris@wittern.com




-----Original Message-----
From: MacWheel99@aol.com [mailto:MacWheel99@aol.com]
Sent: Tuesday, October 30, 2001 8:09 AM
To: BPCS-L@midrange.com
Subject: MRP files KFP KMR KRO etc.


MRP500+600 finds conditions that show up with exception messages ib varuiys
MRP2 reports & MRP300 inquiry.

Can someone point me at field(s) containing exception condition that existed
as of last regen or net change?

Intent = list plans needing human attention, such as via query/400 or a
simple RPG or SQL program, with less baggage than found in most SSA
programs.

MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)
_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/bpcs-l
or email: BPCS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.