RE: Single Level Where-Used with On Hand, On Order

I have not seen anything that does exactly what you described.  I have done
several inquiries for various clients similar to what you are after. If I
understand it correctly, you want an enhanced where used inquiry that shows
the parent's quantity on hand, quantity on order, and requirements from
customer orders.  It is not that difficult of a job to do.

Good luck,

Rusty Jackson

Rusty Jackson & Associates
Knoxville, Tn
(865) 609-0390



>===== Original Message From mapics-l@midrange.com =====
>I am familiar with AVE, but I believe this product is only for COMPONENTS,
>and I'm looking one level UP, not down - looking at the availability of the
>parent item.
>
>We have lower level items that can be packaged into many different end items
>and/or kits - and need to have visibility of what the DEMAND is.  Is it
>customer order? or forecast? is it private label, OEM, or whatever.
>
>-----Original Message-----
>From: Peter_Vidal@pall.com [mailto:Peter_Vidal@pall.com]
>Sent: Thursday, September 20, 2001 4:39 PM
>To: mapics-l@midrange.com
>Subject: Re: Single Level Where-Used with On Hand, On Order
>
>
>
>I know about this company American Viking Enterprises of Florida Inc.
>(http://www.avef.com/)
>They have something called "Indented Item Availability Analysis" and
>apparently
>some of the product highlights are:
>        Highlights inventory material shortages for all components required
>to
>        build an item
>        Allows for on-line inquiry of component shortage analysis as well as
>        reports
>        Provides shortage checking across multiple warehouses
>        Componet replenishment/scheduled receipts time-phased analysis
>        Window inquiry to view MRP planned orders per component
>        Windows inquiry to view scheduled receipts per component
>        Windows inquiry to view allocations per component
>        Actual shortage quantities displayed per component
>        Optional shortage-only analysis mode
>        Features & options supported
>        Effectivity dates supported
>
>Good luck!
>Peter Vidal
>
>
>
>
>                    Philip Freimann
>                    <PFreimann@cranec        To:
>"'mapics-l@midrange.com'"
>                    ams.com>                 <mapics-l@midrange.com>
>                    Sent by:                 cc:
>                    mapics-l-admin@mi        Subject:     Single Level
>Where-Used
>                    drange.com               with On Hand, On Order
>
>
>                    09/20/01 04:23 PM
>                    Please respond to
>                    mapics-l
>
>
>
>
>
>
>This message is in MIME format. Since your mail reader does not understand
>this format, some or all of this message may not be legible.
>--
>[ Picked text/plain from multipart/alternative ]
>We have a request to provide a custom online Single Level Where Used display
>showing on-hand, on-order, and customer requirements.
>
>Are any of you aware of any third party solutions we can use to short cut
>this?
>
>
>Philip R. Freimann    <?xml:namespace prefix = o ns =
>"urn:schemas-microsoft-com:office:office" />
>
>Director of Information Technology
>
>Crane Technologies Group
>
>(386) 252-1151  ext. 1,4282
>
>mailto:pfreimann@CraneCams.com <mailto:pfreimann@CraneCams.com>
>
>_______________________________________________
>This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
>To post a message email: MAPICS-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
>or email: MAPICS-L-request@midrange.com
>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@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
>or email: MAPICS-L-request@midrange.com
>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@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
>or email: MAPICS-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/mapics-l.