;;SHREE GANESHAY NAMHH;; ;; [ In SALES Voucher ];; [#Form :SALES Color];; Add Print in SALES Add : Print : GD LABEL Add : Button :GDLABEL [Button : GDLABEL] Action rint Report:GD LABEL Key :ctrl+F6 [Report : GDLabel];;;;;;;;;;;;;;;;;;print in report titles in printing section;;;;;;;;;;;; Form : GDLabel Object :Voucher Print Set: ReportTitle : $$LocaleString:"PRINT GODOWN" [Form : GDLabel] Full Height:Yes Full Width:Yes Parts : GDLAbleTop,GDLABLETOP1 Space Left :5 Space Top : 1 [Part : GDLAbleTop] Line:GDTITLE [Line:GDTITLE] Border :THIN TOPBOTTOMRIGHT Fields :GDNAME,ITMNAME,GDQTY,GDAMT Local : Field : Default : Type : String Local : Field : Default : Align : Centre Local : Field : Default : Style : Normal Bold [Field:GDNAME] Set as:"GODOWN NAME" Width :25% PAGE Border:THIN LEFTRIGHT [Field:ITMNAME] Set as:"ITEM NAME" Width :25% PAGE Border:THIN RIGHT [Field:GDQTY] Set as:"QUANTITY" Width :25% PAGE Border:THIN RIGHT [Field:GDAMT] Set as:"AMOUNT" Width :25% PAGE [Part:GDLABLETOP1] Line :GDLINE Repeat : GDLINE : Inventory Entries.BatchAllocations Scroll : Vertical [Line : GDLINE] Field : GDGDWN,GDITEMNAME,GDQUANT,GDamount [Field : GDGDWN] Use : Name Field Scroll :Yes Set as : $GodownName Align : Center Width :25% Page Border :THIN LEFTRIGHT [Field : GDITEMNAME] Use : Name Field Set as : $StockItemName Width :25% Page Align : Center Border :THIN RIGHT [Field : GDQUANT] Use : Number Field Set as : $BilledQty Width :25% Page Align : Center Border :THIN RIGHT [Field : GDamount] Use : Number Field Set as : $Amount Width :25% Page Align : Center Border :THIN RIGHT ;;
Repeat GD Line over inventory entries, and you can add an explode in that line, and in the exploded part, repeat the line over batch allocations
Good..Can you please share that Explode code from your TDL, as I am too working on Cost Center report and I am getting only 1st cost centre and not all. Tnx..
[Report : GDLabel];;;;;;;;;;;;;;;;;;print in report titles in printing section;;;;;;;;;;;; Form : GDLabel Object : Voucher Print Set: ReportTitle : $$LocaleString:"PRINT GODOWN" [Form : GDLabel] Part : GDLAbleTop,GDLABLETOP1 Space Left :5 Space Top : 2 [Part : GDLAbleTop] Line:GDTITLE [Line:GDTITLE] Border :THIN TOPBOTTOMRIGHT Fields :GDNAME,ITMNAME,GDQTY,GDAMT Local : Field : Default : Type : String Local : Field : Default : Align : Centre Local : Field : Default : Style : Normal Bold [Field:GDNAME] Set as:"GODOWN NAME" Width :30% PAGE Border:THIN LEFTRIGHT [Field:ITMNAME] Set as:"ITEM NAME" Width :35% PAGE Border:THIN RIGHT [Field:GDQTY] Set as:"QUANTITY" Width :15% PAGE Border:THIN RIGHT [Field:GDAMT] Set as:"AMOUNT" Width :20% PAGE [Part:GDLABLETOP1] Line :GDLINE Repeat : GDLINE : InventoryEntries Scroll : Vertical [Line : GDLINE] Fields: GDGDWN,GDITEMNAME,GDQUANT,GDamount Explode:exp1:Yes [Part:exp1] Line:exp1 Repeat:exp1:BatchAllocations Scroll:Vertical [Line:exp1] Fields:GDGDWN1,GDITEMNAME1,GDQUANT1,GDamount1 [Field : GDGDWN] Set as : "" [Field : GDITEMNAME] Set as : "" [Field : GDQUANT] Set as :"" [Field : GDamount] Set as : "" [Field : GDGDWN1] Use : Name Field Scroll :Yes Set as : $GodownName Align : Center Width :30% Page [Field : GDITEMNAME1] Use : Name Field Set as : $StockItemName Width :35% Page Align : Center [Field : GDQUANT1] Use : Number Field Set as : $BilledQty Width :15% Page Align : Center [Field : GDamount1] Use : Number Field Set as : $Amount Width :20% Page Align : Center