DATEWISE DISPATCH OF ANY MONTH

Dear Sir,
I have written this given below code it helps me out but there is problem we are not able to remove blank item from report please correct the code. please help me out it is very urgent for me.

 

change with below

[Collection: SItemCollHARRY]
Source Collection : Voucher CollectionHARRY
Walk : All Inventory Entries
By : Stockitem : $StockItemName
Aggr Compute : DayWiseDispatchapr : Sum : If @@HARRYSaleVr and @@DayWiseDispatchapr Then $BilledQty Else 0
Aggr Compute : DayWiseDispatchmay : Sum : If @@HARRYSaleVr and @@DayWiseDispatchmay Then $BilledQty Else 0
Aggr Compute : DayWiseDispatchjun : Sum : If @@HARRYSaleVr and @@DayWiseDispatchjun Then $BilledQty Else 0
Aggr Compute : DayWiseDispatchjul : Sum : If @@HARRYSaleVr and @@DayWiseDispatchjul Then $BilledQty Else 0
Aggr Compute : DayWiseDispatchaug : Sum : If @@HARRYSaleVr and @@DayWiseDispatchaug Then $BilledQty Else 0
Aggr Compute : DayWiseDispatchsep : Sum :If @@HARRYSaleVr and @@DayWiseDispatchsep Then $BilledQty Else 0
Aggr Compute : DayWiseDispatchoct : Sum :If @@HARRYSaleVr and @@DayWiseDispatchoct Then $BilledQty Else 0
Aggr Compute : DayWiseDispatchnov : Sum :If @@HARRYSaleVr and @@DayWiseDispatchnov Then $BilledQty Else 0
Aggr Compute : DayWiseDispatchdec : Sum :If @@HARRYSaleVr and @@DayWiseDispatchdec Then $BilledQty Else 0
Aggr Compute : DayWiseDispatchjan : Sum :If @@HARRYSaleVr and @@DayWiseDispatchjan Then $BilledQty Else 0
Aggr Compute : DayWiseDispatchfeb : Sum :If @@HARRYSaleVr and @@DayWiseDispatchfeb Then $BilledQty Else 0
Aggr Compute : DayWiseDispatchmar : Sum :If @@HARRYSaleVr and @@DayWiseDispatchmar Then $BilledQty Else 0
Aggr Compute : DayWiseDispatchtotal : Sum :If @@HARRYSaleVr and @@DayWiseDispatchtotal Then $BilledQty Else 0
Aggr Compute : DayWiseDispatch13 : Sum :If @@HARRYSaleVr and @@DayWiseDispatch13 Then $BilledQty Else 0
Aggr Compute : DayWiseDispatch14 : Sum :If @@HARRYSaleVr and @@DayWiseDispatch14 Then $BilledQty Else 0
Aggr Compute : DayWiseDispatch15 : Sum :If @@HARRYSaleVr and @@DayWiseDispatch15 Then $BilledQty Else 0
Aggr Compute : DayWiseDispatch16 : Sum :If @@HARRYSaleVr and @@DayWiseDispatch16 Then $BilledQty Else 0
Aggr Compute : DayWiseDispatch17 : Sum :If @@HARRYSaleVr and @@DayWiseDispatch17 Then $BilledQty Else 0
Aggr Compute : DayWiseDispatch18 : Sum :If @@HARRYSaleVr and @@DayWiseDispatch18 Then $BilledQty Else 0
Aggr Compute : DayWiseDispatch19 : Sum :If @@HARRYSaleVr and @@DayWiseDispatch19 Then $BilledQty Else 0
Aggr Compute : DayWiseDispatch20 : Sum :If @@HARRYSaleVr and @@DayWiseDispatch20 Then $BilledQty Else 0
Aggr Compute : DayWiseDispatch21 : Sum :If @@HARRYSaleVr and @@DayWiseDispatch21 Then $BilledQty Else 0
Aggr Compute : DayWiseDispatch22 : Sum :If @@HARRYSaleVr and @@DayWiseDispatch22 Then $BilledQty Else 0
Aggr Compute : DayWiseDispatch23 : Sum :If @@HARRYSaleVr and @@DayWiseDispatch23 Then $BilledQty Else 0
Aggr Compute : DayWiseDispatch24 : Sum :If @@HARRYSaleVr and @@DayWiseDispatch24 Then $BilledQty Else 0
Aggr Compute : DayWiseDispatch25 : Sum :If @@HARRYSaleVr and @@DayWiseDispatch25 Then $BilledQty Else 0
Aggr Compute : DayWiseDispatch26 : Sum :If @@HARRYSaleVr and @@DayWiseDispatch26 Then $BilledQty Else 0
Aggr Compute : DayWiseDispatch27 : Sum :If @@HARRYSaleVr and @@DayWiseDispatch27 Then $BilledQty Else 0
Aggr Compute : DayWiseDispatch28 : Sum :If @@HARRYSaleVr and @@DayWiseDispatch28 Then $BilledQty Else 0
Aggr Compute : DayWiseDispatch29 : Sum :If @@HARRYSaleVr and @@DayWiseDispatch29 Then $BilledQty Else 0
Aggr Compute : DayWiseDispatch30 : Sum :If @@HARRYSaleVr and @@DayWiseDispatch30 Then $BilledQty Else 0
Aggr Compute : DayWiseDispatch31 : Sum :If @@HARRYSaleVr and @@DayWiseDispatch31 Then $BilledQty Else 0

Filter:Zerofilter

[System: Formula]
zerovaluefilterDayWiseDispatch : $AllLedgerEntries.BillAllocations.Amount <> ""
PartyFilterMatLedDayWiseDispatch: $Ledgername = ##DayWiseDispatchPartyMatInHarryNameLed or $$IsSysName:##DayWiseDispatchPartyMatInHarryNameLed
PartyFilterMatItemDayWiseDispatch: $StockItemName = ##DayWiseDispatchHarry or $$IsSysName:##DayWiseDispatchHarry
HARRYSale Vr : $$IsSales:$VoucherTypeName
DayWiseDispatchapr : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=1
DayWiseDispatchmay : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=2
DayWiseDispatchjun : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=3
DayWiseDispatchjul : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=4
DayWiseDispatchaug : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=5
DayWiseDispatchsep : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=6
DayWiseDispatchoct : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=7
DayWiseDispatchnov : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=8
DayWiseDispatchdec : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=9
DayWiseDispatchjan : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=10
DayWiseDispatchfeb : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=11
DayWiseDispatchmar : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=12
DayWiseDispatchtotal : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter
DayWiseDispatch13 : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=13
DayWiseDispatch14 : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=14
DayWiseDispatch15 : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=15
DayWiseDispatch16 : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=16
DayWiseDispatch17 : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=17
DayWiseDispatch18 : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=18
DayWiseDispatch19 : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=19
DayWiseDispatch20 : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=20
DayWiseDispatch21 : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=21
DayWiseDispatch22 : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=22
DayWiseDispatch23 : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=23
DayWiseDispatch24 : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=24
DayWiseDispatch25 : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=25
DayWiseDispatch26 : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=26
DayWiseDispatch27 : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=27
DayWiseDispatch28 : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=28
DayWiseDispatch29 : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=29
DayWiseDispatch30 : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=30
DayWiseDispatch31 : $$MonthOfDate:$Date=##DayWiseDispatchMonthFilter and $$dayofDate:$Date=31

Zerofilter: $DayWiseDispatchTotal > 0

 

Sir,

Its not collect all the Billed Quantity, missing some date.

 

Dear Banerjee
Please remove given below filter from collection.
zerovaluefilterDayWiseDispatch

 

Sir,

After removing filter from collection. zerovaluefilterDayWiseDispatch its working fine.

 

Dear All,
In above there is problem in stock item filter section so please find the given below attached corrected code.

 

Dear Mr.

Dear Mr. Harbansh,

Thank you very much for the above TDL. very very useful. Is this TDL only for April month??