Dear Admin & Friends I have created Batch Wise Item wise Report but it is not Triggered please help in this code. ;Jai Shree Shyam [#Menu: Gateway of Tally] Item: My Batch : Display Collection : Batch Report [Collection : Batch Report] Collection: MyBodyPart Variable: MyVar Report: ItemReport Trigger: MyTrigger [Variable: MyVar] Type: String [Report: MyTrigger] Form : TriggerForm Variable: MyVar [Form: TriggerForm] Parts: TriggerPart Height: 100% Page Width: 20% Page [Part: TriggerPart] Lines: TriggerLine [Line: TriggerLine] Field: TriggerField [Field: TriggerField] Use: Name Field Table: BatchReport Show Table: Always Variable: MyVar Modifies: MyVar ;============================Collections BATCHES================================= [Collection: BatchOpSrc] Type : Stock Item Fetch : BatchName, StockItemName [Collection : BatchOp] Source Collection : BatchOpSrc Walk : Batch Allocations By : BName : $BatchName [Collection: BatchPurSrc] Type : Voucher ; Filter : MyPurchaseFilter [Collection : BatchPur] Source Collection : BatchPurSrc Walk : Inventory Entries, Batch Allocations By : BName : $BatchName [Collection: MyBodyPart] Collection : BatchPur, BatchOp Fetch : BName Format : $BName, 20 Variable : MyVar Sort : Default : $BName [System: Formula] MyPurchaseFilter : $$IsPurchase:$VoucherTypeName ;=========================== ITEM REPORT================================= [Report: Item Report] Use : DSP Template Form : ItemForm Set : SV FromDate : $$MonthStart:$LastVoucherDate:Company:##SVCurrentCompany Set : SV ToDate : $$MonthEnd:$LastVoucherDate:Company:##SVCurrentCompany [Form: ItemForm] Use SP Template Parts: ItemTitlePart, ItemBodyPart [Part: ItemTitlePart] Use: DSP Template Lines: ItemBatchTitle, ItemNameTitle [Line: ItemBatchTitle] Field: ItemBatchTitle Right Field: ItemDateTitle [Field: ItemBatchTitle] Use: Name Field Set as: "B.E. No.: " + #BeName [Field: ItemDateTitle] Use: Date Field Set as: #SVTodate Style: Normal Bold [Line: ItemNameTitle] Field: BeItemNameTitle Right Field: ItemBalanceTitle, ItemRateTitle, ItemValueTitle Border: Column Titles [Field: BeItemNameTitle] Set as: "ItemName" Style: Normal Bold [Field: ItemBalanceTitle] Set as: "Qty" Width: 12 Align: Right Style: Normal Bold [Field: ItemRateTitle] Set as: "Rate" Width: 12 Align: Right Style: Normal Bold [Field: ItemValueTitle] Set as: "Value" Width: 14 Align: Right Style: Normal Bold [Part: ItemBodyPart] Lines: ItemBodyPart Bottom Line: ItemTotalLine Total: ItemValue Repeat: ItemBodyPart : MyItemBodyPart Scroll: Vertical Common Border: Yes [Line: ItemBodyPart] Field: BeItemName Right Field: ItemBalance, ItemRate, ItemValue [Field: BeItemName] Use: Name Field Set as: $IName Style: Normal [Field: ItemBalance] Set as: $MyQty Width: 12 Align: Right [Field: ItemRate] Set as: $MyRate Width: 12 Align: Right [Field: ItemValue] Use: Amount Field Set as: $MyValue Width: 12 Align: Right [Line: ItemTotalLine] Right Field: ItemTotalName Right Field: ItemTotalValue Border: Column Titles [Field: ItemTotalName] Use: Name Field Set as: TOTAL [Field: ItemTotalValue] Use: Amount Field Set as: $$Total:ItemValue ;============================== COLLECTION ITEM ====================== [Collection : ItemOp] Source Collection : BatchOpSrc Walk : Batch Allocations By : BName : $BatchName By : IName : $StockItemName Compute : MyQty : $$FilterValue:$ClosingbalanceSDBATCHEXTRACT:1:isCorrectBatch Compute : MyRate : $$FilterValue:$ClosingRateSDBATCHEXTRACT:1:isCorrectBatch Compute : MyValue : $$FilterValue:$ClosingValueSDBATCHEXTRACT:1:isCorrectBatch [Collection : ItemPur] Source Collection : BatchPurSrc Walk : Inventory Entries, Batch Allocations By : BName : $BatchName By : IName : $StockItemName Compute : MyQty : $$FilterValue:$ClosingbalanceSDBATCHEXTRACT:1:isCorrectBatch Compute : MyRate : $$FilterValue:$ClosingRateSDBATCHEXTRACT:1:isCorrectBatch Compute : MyValue : $$FilterValue:$ClosingValueSDBATCHEXTRACT:1:isCorrectBatch [Collection: MyItemBodyPart] Collection : ItemOp, ItemPur Fetch : IName, BName ;, MyQty, MyRate, MyValue Sort : Default : $IName Filter : MyItemFilter Filter : NotEmptyMyQty [Collection : DSD BATCH EXTRACT] Type : Batch Child of : ##pvItemName ParmVAR : pvItemName : String : $StockItemName Fetch : GodownName, ClosingBalance, Date, ClosingRate, ClosingValue, MfdOn, ExpiryPeriod [System: Formula] MyItemFilter : #BeName = $BName isCorrectBatch : $Name=$$ReqObject:$BatchName NOTEmptyMyQty : NOT $$IsEmpty:$MyQty
Mr. Gopaal, do not you think it would be better to attach the code in text file; so that members can go through it; instead of pasting it in the forum. Thank you
[Field: TriggerField] Use: Name Field Table: BatchReport Show Table: Always Sub Form :Item Report Variable: MyVar Modifies: MyVar
