[mfw_user_group] Re: MFW User Group Enquiry: Vendor Performance R eport

  • From: Michael Elder <melder@xxxxxxxxxxxx>
  • To: "'mfw_user_group@xxxxxxxxxxxxx'" <mfw_user_group@xxxxxxxxxxxxx>
  • Date: Tue, 15 Jan 2002 14:35:45 -0000


thanks for the reply.

I have been working on and off on the report, but I keep finding problems 
in the way that Crystal handles the data. To be honest, I am starting to 
think that crystal isn't versatile enough to allow me to easily process the 

see the screenshot for an example of the report. basically quite easy to 
see what goes on.

at the start of the report the user is prompted for a specific vendor id 
and a range of order due dates.

I know that a lot of people are keen to investigate their vendors 
performance, and there isn't a set report in MFW, so anything i do hear i 
will pass on to you.

If you have any comments or ideas of how you think i could improve my 
current report I would love to hear from you.

By the way, are you very experienced with Crystal, because I have a few 
queries that I really need to be answered!!



-----Original Message-----
From:   Phillips, Carol [SMTP:Carol.Phillips@xxxxxxxxxxxxxxxxxxx]
Sent:   Tuesday, January 15, 2002 1:11 PM
To:     mfw_user_group@xxxxxxxxxxxxx
Subject:        [mfw_user_group] Re: MFW User Group Enquiry: Vendor Performance 
R       eport


I have not as yet done any work on this but would be extremely interested 
what you have done.


        -----Original Message-----
        From:   Michael Elder [SMTP:melder@xxxxxxxxxxxx]
        Sent:   Tuesday, January 15, 2002 12:53 PM
        To:     'mfw_user_group@xxxxxxxxxxxxx'
        Subject:        [mfw_user_group] MFW User Group Enquiry: Vendor
Performance Report


        I have previously designed a vendor performance crystal report for
use with

        The report basically gives each supplier a rating out of 100, as to
        many units they delivered on time over a set period.

        The report classifies deliveries as early, on time, late and out of
        As a customer we are only concerned about how many units were
delivered on

        i.e. if an order was placed for 2000 units, and 2 deliveries were
made to
        complete the order, 1600 on time and 400 late, then the performance
        would be :

        (1600/2000)*100 = 80%

        I believe this is called Lpi by many organisations.

        Overall I have found some errors in my designed  report, and I am
        interested to see if there is anyone who has worked on a similar

        Basically, if anyone has experience with rating vendor performance,
        uses a similar report, or knows if there are any third party
        available which do a similar function, then I would be very
interested to
        hear from you.

        I am using MFW version 3.5 with Crystal Reports Version 6.


        Michael Elder
        Magnetic Technologies Europe
        Rochester, UK

Other related posts: