Hi Experts,
I need to create a report with column heading with splitting like :
Product wise analysis of Expiry date as on 30/04/2013
Product Code
Product Description
Plant/WH
Batch/Lot No.
Create on
Expiry on (date)
Unit
Qty
Value
break up stock as per expiry dates on future (if expired coloured by red with Date)
Manufacturing Date
Already Expired base on MFR Date
Expiry in this month base on MFR Date
2nd month
3rd month
more than 3rd month
Qty
Value
Qty
Value
Qty
Value
Qty
Value
Qty
Value
Please suggest.
Thanks in advance,
Vibhor