StockItem details StockCategory wise based on Manufacturing Journal

Dear Experts,

I am Trying to develop a report showing the details of the RawMaterials required for a particular item based on Manufacturing journal which will be created while entrying sales order voucher.

I am not able to achieve this requirement . Experts please assist.

thanks

Tried out code is as below.

/*;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
Raw Materials Report - Stock Category, Stock group & Item Wise
*************************************************************************/

[#Menu: Gate way of Tally]

Add: Key Item : Before : @@locQuit : Raw Material Report : M : Display : HNY_RMDetails


[Report: HNY_RMDetails]

Form: HNY_RMDetails

Variable : SVFromDate,SVToDate
Set : SVFromDate : $$MonthStart:##SVCurrentDate
Set : SVToDate : $$MonthEnd:##SVCurrentDate

[Form: HNY_RMDetails]

Part : FormSubtitle,HNY_DateFld,HNY_RMDetails
Local : Field : FormSubtitle : Info : "Raw Material Requirement - Section Wise"
Local : Field : FormSubtitle : Style : TitleStyle

Button : ExplodeFlag, ChangePeriod
; BottomButton : BlankButton, RelReports, InvReports, AcctReports, Report Operations, StatRegConfigure, FilterButton, ValueButton

Buttons : PrintButton, ExportButton, UploadButton, MailButton

Width : 100% Page
Height : 100% Page

Background : Light Blue

[Style: TitleStyle]

Font : Header Title
Height : 14
Bold : Yes

[Part:HNY_DateFld]

Line: HNY_DateFld

[Line: HNY_DateFld]

Field : HNY_DateFld; ,DSP MainDateTitle
Space Bottom: 0.5

[Field : HNY_DateFld]

Info : "From : " + $$String:##SVFromDate + " To : " + $$String:##SVToDate


[Part: HNY_RMDetails]

Line : HNY_RMDetailsTitle,HNY_RMDetailsBody
Repeat : HNY_RMDetailsBody : summcollection
Scroll : Vertical
Common Border : Yes


[Line: HNY_RMDetailsTitle]

Use : HNY_RMDetailsBody
Border : Thick Top Bottom

Local : Field : RMDStkCAt : Info : "Sections"
Local : Field : RMDStkGrp : Info : "Group"
Local : Field : RMDRAwmat : Info : "Raw Materials"
Local : Field : RMDReqQty : Info : "Reqd.Qty"

Local : Field : DEfault : Style : Normal Bold
Local : Field : Default : Align : Center
Local : Field : Default : Type : String
;Local : Field : Default : Line : 0



[Line: HNY_RMDetailsBody]

Fields : RMDStkCAt, RMDStkGrp,RMDRAwmat,RMDReqQty
Space Top : 0.5

Explode : HNY_RMDStkItemsDetails

[Field: RMDStkCAt]

Set as : $T2
Border : Thin Right
Width : 35% Screen
; Space Left : 5
Style : Normal Bold

[Field: RMDStkGrp]

Set as : " "
Border : Thin Right
Width : 25% Screen

[Field: RMDRAwmat]

Set as : ""
Border : Thin Right
Width : 30% Screen

[Field: RMDReqQty]

Set as : ""
Border : Thin Right
Width : 10% Screen


; Use : Qty Primary Field
; Set as : $$ReportObject:$$CollectionFieldByKey:$BilledQtyMyFormula:HNYSummVoucher
; MyFormula : ##IName + #RMDParticulars
; Format : "NoZero"

/*[Line : HNY_RMDStkItems]

Fields : RMDStkCAt, RMDStkGrp,RMDRAwmat,RMDReqQty
Explode : HNY_RMDStkItemsDetails

Local : Field : RMDStkCAt : Set as:""
Local : Field : RMDStkGrp : Set as:"Group"
Local : Field : RMDRAwmat : Set as: ""
Local : Field : RMDReqQty : Set as: ""*/

;; Exploded part

[Part:HNY_RMDStkItemsDetails]

Line : HNY_RMDStkItemsDetails
Repeat : HNY_RMDStkItemsDetails : HNYSummVoucher

[Line : HNY_RMDStkItemsDetails]

Field : HNY_RMDStkItemsDetails

[Field : HNY_RMDStkItemsDetails]

Set as: $T1

[Collection:SourCollection]
Type:vouchers:vouchertype
Child Of:$$VchTypeMfgJrnl

[Collection:summcollection]
Source Collection:SourCollection
Walk:INVENTORYENTRIESOUT;INVENTORYENTRIESIN
Compute:T1:$INVENTORYENTRIESIN.STOCKITEMNAME
Compute:T2:$Category:StockItem:$INVENTORYENTRIESIN.STOCKITEMNAME
Compute:T3:$STOCKITEMNAME
Compute:T4:$Billedqty
Filter:cateFormula


[System:Formulae]
cateFormula:$T2="South Indian Section"

 

I also need the same. can anyone help?