I need to generate a report like the following
ITEM DATE CH-NO: D.ROSE LT GREY SEND RED BLCK TOTAL S/THREAD REQUIRD 143 557 337 40 980 2057 RCVD 21.03.2020 3704 143 557 337 40 980 2057 RCVD 0 TOTAL 0 143 557 337 40 980 0 2057 BALANCE 0 0 0 0 0 0 0 0 Main label REQUIRD 35816 35816 RCVD 23.03.2020 5441 4511 RCVD 18.05.2020 5478 27115 27115 RCVD 18.05.2020 5476 4190 4190 TOTAL 0 35816 0 0 0 0 0 35816 BALANCE 0 0 0 0 0 0 0 0 CARE LABEL REQUIRD 132582 132582 RCVD 21.03.2020 3704 30640 RCVD 22.03.2020 5428 74480 74480 RCVD 22.03.2020 5436 27462 27462 TOTAL 0 132582 0 0 0 0 0 132582 BALANCE 0 0 0 0 0 0 0 0 BARCODE LABEL REQUIRD 52804 52804 RCVD 21.03.2020 3704 12014 RCVD 22.03.2020 5428 13010 13010 RCVD 22.03.2020 5436 9154 9154 TOTAL 0 34178 0 0 0 0 0 34178 BALANCE 0 -18626 0 0 0 0 0 -18626
From the source excel sheet as below
Order No Item Name Color Req qty Rcvd Qty Bal to Rcv Rcv Date Rcv Invoice. Uunit NHK/19-20/PRKG/80 Hangers BLACK 89794 6000 83794 01/06/2020 4599/01 Pieces NHK/19-20/PRKG/80 Hangers BLACK 89794 26400 63394 02/06/2020 4599/02 Pieces NHK/19-20/PRKG/80 Adhesive Paper WHITE 1258 1258 0 02/06/2020 Gs/2020/306 Pieces NHK/19-20/PRKG/80 Snap Button SILVER 32006 32006 0 11/06/2020 B0001801 Pieces NHK/19-20/PRKG/80 Snap Button SILVER 359176 100800 258376 13/06/2020 B0001849 Pieces NHK/19-20/PRKG/80 Sewing Thread(M) GREY 1108000 1108000 0 15/06/2020 29948 Mts NHK/19-20/PRKG/80 Label - Care BLACK 21275 4000 17275 16/06/2020 419 Pieces NHK/19-20/PRKG/80 Label - Care BLACK 16446 4000 12446 16/06/2020 419 Pieces NHK/19-20/PRKG/80 Label - Care BLACK 9409 9409 0 16/06/2020 419 Pieces
Access report source excel file and report format.zip