Hi,
Could you please offer some advice on following?
Our current accounts package sage 50, cannot calculate any on time delivery performance natively so I have to out reports to excel I have two worksheets in the same work book for monitoring supplier performance,
Sheet 1 “Supplier Register” pulls data down at account level. And incorporates account data to use as a supplier risk database.
Sheet2 “Sup OTD” pulls itemised delivery data for each supplier/order. Delivery performance is calculated using the difference between delivery due date, and date received in the either Early, On Time or Late.
I am looking to
Summarize the on time delivery performance per supplier from sheet 2 “Sup OTD”
Pull or push the summarised on time delivery performance through to Sheet 1 “Supplier Register” for the relevant supplier.
Sample work book link
https://drive.google.com/open?id=1CB...nzcY_pjzImnW_v
Notes.
If it makes things easier Early and On Time can be changed to be on time.
Best Regards
Mark
Could you please offer some advice on following?
Our current accounts package sage 50, cannot calculate any on time delivery performance natively so I have to out reports to excel I have two worksheets in the same work book for monitoring supplier performance,
Sheet 1 “Supplier Register” pulls data down at account level. And incorporates account data to use as a supplier risk database.
Sheet2 “Sup OTD” pulls itemised delivery data for each supplier/order. Delivery performance is calculated using the difference between delivery due date, and date received in the either Early, On Time or Late.
I am looking to
Summarize the on time delivery performance per supplier from sheet 2 “Sup OTD”
Pull or push the summarised on time delivery performance through to Sheet 1 “Supplier Register” for the relevant supplier.
Sample work book link
https://drive.google.com/open?id=1CB...nzcY_pjzImnW_v
Notes.
If it makes things easier Early and On Time can be changed to be on time.
Best Regards
Mark