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

  • From: Tracy Woods <TW@xxxxxxxxxxxxxxxxxxx>
  • To: mfw_user_group@xxxxxxxxxxxxx
  • Date: Tue, 15 Jan 2002 18:14:50 -0000

|I know our purchasing and IT department are currently writing a report on
this, although I do not have the details on it.  We do not use Crystal very
often but interrogate the data using Access, which the users here seem to
find more friendly

I can find out the details of the criteria of the report if you wish and let
you know

Regards

Tracy Woods
APPH (Bolton) Ltd

> -----Original Message-----
> From: Michael Elder 
> Sent: 15 January 2002 14:36
> To:   'mfw_user_group@xxxxxxxxxxxxx'
> Subject:      [mfw_user_group] Re: MFW User Group Enquiry: Vendor
> Performance R eport
> 
> 
> hi
> 
> 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 
> data.
> 
> 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!!
> 
> Thanks
> 
> Michael
> 
> -----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
> 
> 
> Michael,
> 
> I have not as yet done any work on this but would be extremely interested 
> in
> what you have done.
> 
> 
> Carol
> 
>       -----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
> 
> 
>       Hi
> 
>       I have previously designed a vendor performance crystal report for
> use with
>       MFW.
> 
>       The report basically gives each supplier a rating out of 100, as to
> how
>       many units they delivered on time over a set period.
> 
>       The report classifies deliveries as early, on time, late and out of
> limit.
>       As a customer we are only concerned about how many units were
> delivered on
>       time.
> 
>       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
> index
>       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
> very
>       interested to see if there is anyone who has worked on a similar
> project.
> 
>       Basically, if anyone has experience with rating vendor performance,
> and
>       uses a similar report, or knows if there are any third party
> products
>       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.
> 
>       Thanks
> 
>       Michael Elder
>       Magnetic Technologies Europe
>       Rochester, UK

Other related posts: