RE: supplier report

[Mark Dunn <mark.dunn@xxxxxxxxx>]

We have something similar.
A query that is run against PLNORD , select by warehouse and vendor, and
then sort by item then date(ascending)
This picks up all open orders and all future requirements.
We email this to our suppliers - and where that's not possible we fax it.
Our vendors are grateful for the forward notice that this gives them and
they can plan to give us better service because of it.

Regards,

Mark Dunn
Business Analyst
PDL Electronics
New Zealand


-----Original Message-----
From: DaleGindlesperger@fft-inc.com
[mailto:DaleGindlesperger@fft-inc.com]
Sent: Wednesday, 27 February 2002 9:25
To: mapics-l@midrange.com
Subject: Re: supplier report


This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Yes, we do that.  We wrote a reformatted version of the MRP report data
and fax it to them automatically or on demand on a weekly basis.  We also
include new P.O.'s on the report.  We use Cornerstone Communications
Unifier/400 that allows us to easily route reports to either a fax# or an
e-mail address with no (or minimal) programming.

Here's an example:

SM6246                FLEETWOOD FOLDING TRAILERS        DATE  2/26/02 PAGE
   1
                        VENDOR PLANNING REPORT          TIME 15:21:59
VENDOR: V17052                            BUYER: 16    ANNA L. VOGEL
        PAGE BEDDING COMPANY              PHONE: 814/443-7296
                                            FAX: 814/443-7330
        850 EISENHOWER BLVD
        JOHNSTOWN                PA  15904
        FAX: 1-814-266-7500
      PHONE: 800-422-0669
    CONTACT: BOB TROTZ/WALTER PAGE
4756E563
CUSHION ASSY-3551 MESA-
3594 WESTLAKE-3591 SUN VALLEY-CARPOSTAN FRESNO AUTUMN W/ROS PALM-'01
CARAVAN
                                     ORDERING  DELIVERY    QUANTITY
ITEM NO./DESCRIPTION       P/O #       DATE      DATE      REQUIRED
         OPEN ORDERS
                           P305319              2/27/02      20.000
                           P305319              3/01/02      20.000
                           P305461              3/07/02      20.000
                           P305774              3/07/02      20.000
                           P305774              3/13/02      20.000
                            TOTAL QUANTITY ON ORDER:        100.000
         PLANNED ORDERS
                                      2/20/02   3/11/02        20.000
                                      2/26/02   3/15/02        20.000
                                      2/28/02   3/19/02        20.000
                                      3/05/02   3/22/02        20.000
                                      3/08/02   3/27/02        20.000
                                      3/12/02   4/01/02        20.000
                                      3/15/02   4/04/02        20.000
                                      3/19/02   4/08/02        20.000
                                      3/22/02   4/11/02        20.000
                                      3/26/02   4/15/02        20.000
                                      4/01/02   4/18/02        20.000
                                      4/03/02   4/22/02        20.000


Pretty simple to write, too.

Dale Gindlesperger
Fleetwood Folding Trailers, Inc.






"Jim Wiedl" <WIEDLJ@timesaversinc.com>
Sent by: mapics-l-admin@midrange.com
02/26/02 12:21 PM
Please respond to mapics-l


        To:     <mapics-l@midrange.com>
        cc:
        Subject:        supplier report


Does anyone gather demand (MRP) related data by supplier(vendor) and
transmit to them?  (alias- supply chain management)



***********************************************************
This email has been scanned for viruses.
***********************************************************

_______________________________________________
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.


The contents of this E-mail may contain information that is legally
privileged and/or confidential to the named recipient. This information is
not to be used by any other person and/or organisation. The views expressed
in this document do not necessarily reflect those of the company.