I CAN'T FETCH ALL STOCK ITEM IN MY SALES CLR PRINT,ONLY GIVE ME A FIRST STOCK ITEM ENTRY ,PLS HELP!

Discussion in 'Free Source Codes' started by Nikhil dixit, Jan 11, 2020.

    
  1. Nikhil dixit

    Nikhil dixit New Member


    ;;SHREE GANESHAY NAMHH;;


    ;; [ In SALES Voucher ];;


    [#Form :SALES Color];; Add Print in SALES
    Add : Print : GD LABEL
    Add : Button :GDLABEL
    [Button : GDLABEL]
    Action :print 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



    ;;
     


  2. Ria

    Ria Member


    Repeat the line over inventory entries, not inventoryentries.batchallocations
     


  3. Nikhil dixit

    Nikhil dixit New Member


    mam i want all godown name & quantity and amount of all entry of stock item plss help mam!
     


  4. Nikhil dixit

    Nikhil dixit New Member


    attached images mam plss check!
     

    Attached Files:



  5. Ria

    Ria Member


    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
     


  6. Nikhil dixit

    Nikhil dixit New Member


    Mam i cant know the use of explode..please edit the code..pls mam
     


  7. Nikhil dixit

    Nikhil dixit New Member


    Thankyou mam i got the output
     


  8. Ria

    Ria Member


    :)
     
    naijaind likes this.


  9. naijaind

    naijaind Member


    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..
     


  10. Rohit001

    Rohit001 Member




    [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
     


Share This Page