Stock Analysis - Opening Qty and Amount of Stock not traded during the year not showing. Please Help

Dear All Experts

In the Stock Summary, is not easy to identify whether INWARDS is the sum of Purchases, Stock Journal Inwards and also Manufacturing Journals making it very difficult to analyze. Same is the case of OUTWARDS. So in order to overcome this defect. I have prepared Stock Itemwise Analysis Report - which bifurcates all transactions (both qty and amount) into the following:
1. OPENING STOCK
2. PURCHASE
3. STOCK JOURNAL INWARDS
4. MANUFACTURING JOURNAL INWARDS
5. SALE
6. STOCK JOURNAL OUTWARDS
4. MANUFACTURING JOURNAL OUTWARDS.

Report was working until today, when I cross checked with Stock Summary, I realized that those Stock Items having Opening Quantity and Value but no transactions happened during the year are not getting reflected in my Report. In other words, stock items having opening balance and not traded during the year does not get reflected.

I believe that there is some mistake in my collection which I'm unable to identify. Dear experts please help me.

[Collection:Item Rate Coll1]
Type : Vouchers ;: VoucherType
;Fetch : Inventory Entries

[Collection:Item Rate Coll2]
Source Collection : Item Rate Coll1

Walk : All Inventory Entries
By : StockItemName : $StockItemName

Sort : @@SortAlphaIncr : $Parent:StockItem:$StockItemName

Aggr Compute : AshtaPurchaseQty : Sum : If @@AshtaPurchaseVoucherType Then $BilledQty Else 0
Aggr Compute : AshtaPurchaseAmt : Sum : If @@AshtaPurchaseVoucherType Then $Amount Else 0
Aggr Compute : AshtaDebitNoteQty : Sum : If @@AshtaDebitNoteVoucherType Then $BilledQty Else 0
Aggr Compute : AshtaDebitNoteAmt : Sum : If @@AshtaDebitNoteVoucherType Then $Amount Else 0
Aggr Compute : AshtaSaleQty : Sum : If @@AshtaSalesVoucherType Then $BilledQty Else 0
Aggr Compute : AshtaSaleAmt : Sum : If @@AshtaSalesVoucherType Then $Amount Else 0
Aggr Compute : AshtaCreditNoteQty : Sum : If @@AshtaCreditNoteVoucherType Then $BilledQty Else 0
Aggr Compute : AshtaCreditNoteAmt : Sum : If @@AshtaCreditNoteVoucherType Then $Amount Else 0
Aggr Compute : AshtaStkJrnlQtyOut : Sum : If @@AshtaStkJrnlVoucherType And NOT $$IsInwards:$BilledQty Then $BilledQty Else 0
Aggr Compute : AshtaStkJrnlAmtOut : Sum : If @@AshtaStkJrnlVoucherType And NOT $$IsInwards:$BilledQty Then $Amount Else 0
Aggr Compute : AshtaStkJrnlQtyIn : Sum : If @@AshtaStkJrnlVoucherType And $$IsInwards:$BilledQty Then $BilledQty Else 0
Aggr Compute : AshtaStkJrnlAmtIn : Sum : If @@AshtaStkJrnlVoucherType And $$IsInwards:$BilledQty Then $Amount Else 0
Aggr Compute : AshtaMfgJrnlQtyOut : Sum : If @@AshtaMfgJrnlVoucherType And NOT $$IsInwards:$BilledQty Then $BilledQty Else 0
Aggr Compute : AshtaMfgJrnlAmtOut : Sum : If @@AshtaMfgJrnlVoucherType And NOT $$IsInwards:$BilledQty Then $Amount Else 0
Aggr Compute : AshtaMfgJrnlQtyIn : Sum : If @@AshtaMfgJrnlVoucherType And $$IsInwards:$BilledQty Then $BilledQty Else 0
Aggr Compute : AshtaMfgJrnlAmtIn : Sum : If @@AshtaMfgJrnlVoucherType And $$IsInwards:$BilledQty Then $Amount Else 0

 

I also tried adding List of Stock Items collections but is not working. In that case it only shows Opening and Closing Balance (both Qty and Amount). Rest all the heads are blank.

 

please help i am facing same problem
and how to union two of those collection its not working please help

 

send the code to chinniruchitha1992@gmail.com