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

Phil,

To speed up item related inquiries, i have written a program to display
any item related information in one central place simply using function
keys to show:

- balances
- customer orders
- pruchase orders
- manuf. orders and allocs
- bill of materials
- item where used
- sales prices
- stock transactions
- routers & operations

It looks like this:

------------------------------------------------------------------------
--------
 SELMFGEU  QSECOFR     YY   Item Information Center     Wareh: B
21/09/01
 Item Number.... FX00136          SUPRA PRODUCT/LICENCE LABEL
07:59:53
 Item Type...... 2    Fabrictd   Planner....        133 SELKIRK UNITED
KINGDOM
 Unit of Measure EA   Each       Batch Qty..      1.000 On Hand
.000
 Item Class.....                 Lot Size...       .000 CustOrd
.000
 Department.....                 Labor Time.       .000 Mfg Alc
.000
 Tax Code... P/S     /           Std Cost...        .00 open PO
.000
 EAN Code.......                 Weight (KG)       .000 open MO
.000
 Eng. Drawing No FX00136R2       LdT Typ/M/P M   2      Annual Usg.
.000


 5 Master Item     Item Description      Quant. per UM Qty on Hand   Qty
avail.
   4010113         1000MM LENGTH SUPRA        1.000 EA   1,463.000
907.000
   4010115         1000MM LENGTH SUPRA        1.000 EA     964.000
206.000
   4010118         1000MM LENGTH SUPRA        1.000 EA      78.000
731.000-
   4010120         1000MM LENGTH SUPRA        1.000 EA     186.000
348.000-
   4010125         1000MM LENGTH SUPRA        1.000 EA     328.000
490.000-
   4010130         1000MM LENGTH SUPRA        1.000 EA     197.000
38.000
   4010135         1000MM LENGTH SUPRA        1.000 EA      62.000
52.000-
   4010211         458MM LENGTH SUPRA 0       1.000 EA      35.000
29.000
   4010213         458MM LENGTH SUPRA 0       1.000 EA     747.000
706.000

More...
 F3Þnd F4Ü/o F5Ö/o&p/o F6ÙrodStruct F7ÖfgAllocs F8Ýransactions
F9Ðhs/Loc
 F2ÛaseData   F10Ûouting   F11ÐhereUsed    F13ßorecast
F14Üales Price
 Option 1Ýisplay this item number  5Öore details
------------------------------------------------------------------------
--------


It is of course fit to our needs but i am willing to give it away
including the source code. Please contact me directly if you are
interested in a copy.

Mit freundlichen Grüßen / Kind Regards

Axel Niederquell / EDV
SELKIRK Schornsteintechnik GmbH
Wiehler Str. 5    D-51545 Waldbröl
+49 2291 84210  Fax +49 2291 84133
http://www.selkirk.de


-----Original Message-----
From: mapics-l-admin@midrange.com [mailto:mapics-l-admin@midrange.com]
On Behalf Of Philip Freimann
Sent: Thursday, September 20, 2001 10:24 PM
To: 'mapics-l@midrange.com'
Subject: Single Level Where-Used with On Hand, On Order


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 
.rn: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.