File1
=====
Sales Order 
Item 
Sch Line
Conf Date
Season
Collection
Material
year 
Period
Confirmed Qty
Delivered Qty

File2
=====
Sales Order 
Item 
Sch Line
Material
Act GI Date

Output
======

Fields:
Sales Order 
Item 
Sch Line
Conf Date
Act GI Date(Act-conf > 0)
No of Days
Season
Collection
Material
year 
Period

Grouping: Period then no of days
2014, Stock, AC Performance
June
 1 day late = ### qty
 2 days late = ### qty