1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

How to Repeat Voucher Row wise

Discussion in 'Free Source Codes' started by Jayashri, Oct 8, 2021.

    
  1. Jayashri

    Jayashri Member


    Hi,,
    Repeat the report for voucher entry wise,,
    anyone advise or crt d code



    [#Menu: Gateway Of Tally]
    Key Item: Party-Wise Product-Wise Sales : P : Display : My Sales Vch Iteam Wise Repeate

    [Report: My Sales Vch Iteam Wise Repeate]

    Use : DSP Template
    Form : My Sales Vch Iteam Wise Repeate
    Variable : DoSetAutoColumn, SVFromDate, SVToDate,IName
    Repeat : IName
    Set : DoSetAutoColumn : Yes
    Set : DSPRepeatCollection : "Smp Stock Item"
    Set : SVFromDate : $$YearOfDate:##SVCurrentDate
    Set : SVToDate : $$YearEnd:##SVCurrentDate

    [Form: My Sales Vch Iteam Wise Repeate]


    Use : DSP Template
    Parts : My Sales Vch Iteam Wise Repeate Main Tiltes, My Sales Vch Iteam Wise Repeate
    Option : Set Auto Vch Option : ##DoSetAutoColumn AND $$SetAutoColumns:IName
    Space Top : 2
    Space Bottom: 1.2
    Delete : Page Break

    [!Form: Set Auto Vch Option]
    ;parts : My Sales Vch Iteam Wise Repeate

    [Part: My Sales Vch Iteam Wise Repeate Main Tiltes]

    Lines : My Sales Vch Iteam Wise Repeate Main Tiltes

    [Line: My Sales Vch Iteam Wise Repeate Main Tiltes]

    Field : Name Field
    Right Field : DSP MainDateTitle
    Field : My Sales Vch Iteam Wise Repeate Main Tiltes Fld
    Local : Field : Name Field : Style : Normal Bold
    Space Bottom : 1.5

    [Field: My Sales Vch Iteam Wise Repeate Main Tiltes Fld]

    Style : "Normal Bold"
    FullWidth : Yes
    Border : Thin Bottom
    Align : Centre
    Skip : Yes
    Fixed : Yes
    Width : 50% Screen
    Set As : "Voucher-Wise Product-Wise Sales Report"



    [Part: My Sales Vch Iteam Wise Repeate]

    Lines : My Sales Vch Iteam Wise Repeate Title, My Sales Vch Iteam Wise Repeate Details
    BottomLines : My Sales Vch Iteam Wise Repeate Total
    Repeat : My Sales Vch Iteam Wise Repeate Details:My Vch Wise Coll
    Scroll : Vertical
    CommonBorder: Yes
    Total : My Sales Vch Iteam Wise Repeate Name, My Sales Vch Iteam Wise Repeate Col Total

    [Line: My Sales Vch Iteam Wise Repeate Title]

    Use : My Sales Vch Iteam Wise Repeate Details
    Local : Field : Default : Type : String
    Local : Field : Default : Align : Center
    Local : Field : My Sales Vch Iteam Wise Repeate PArty : Set as : "Party Name"
    Local : Field : My Sales Vch Iteam Wise Repeate PArty : Widespaced: No
    Local : Field : My Sales Vch Iteam Wise Repeate Name : Set as : ##IName
    Local : Field : My Sales VchSno :Set as:"S.no"
    Local : Field : My Sales Vch Iteam Wise Repeate Name : Lines : 0
    Local : Field : My Sales Vch Iteam Wise Repeate ColTotal : Set as : "Total"
    Border : Flush Totals

    [Line: My Sales Vch Iteam Wise Repeate Details]

    Fields : My Sales VchSno,My Sales Vch Iteam Wise Repeate Party, My Sales Vch Iteam Wise Repeate Name, My Sales Vch Iteam Wise Repeate Col Total
    Repeat : My Sales Vch Iteam Wise Repeate Name
    Total : My Sales Vch Iteam Wise Repeate Name
    Border : Thin Right

    [Field:My Sales VchSno]
    Use:Name Field
    Set as:$$Line
    Width:5
    Border : Thin Right
    [Field: My Sales Vch Iteam Wise Repeate Name]

    Use : Name Field
    Set as : $IName
    Set as : $$ReportObject:$$CollectionFieldByKey:$BilledQty:mad:MyFormula:CFBKSummVoucher
    MyFormula : ##IName + $Pname
    Variable : Stock Item Name
    Format : "NoZero"
    Border : Thin Right
    Align : Right
    Width : 12

    [Field: My Sales Vch Iteam Wise Repeate Party]

    Use : Name field
    Set as :$PName; $Vouchertypename;$PartyLedgerNAme;$PName
    ;Border : Thin Right
    Width : 40

    [Field: My Sales Vch Iteam Wise Repeate Col Total]

    Use : Qty Primary Field
    Set as : $$Total:CFBKRepName
    Border : Thin Left
    Width : 15

    [Line: My Sales Vch Iteam Wise Repeate Total]

    Fields : My Sales Vch Iteam Wise Repeate Party, My Sales Vch Iteam Wise Repeate Name,My Sales Vch Iteam Wise Repeate Col Total
    Repeat : My Sales Vch Iteam Wise Repeate Name
    Local : Field : Default : Type : String
    Local : Field : Default : Align : Center
    Local : Field : My Sales Vch Iteam Wise Repeate Party : Set as : "Total Sales Qty"
    Local : Field : My Sales Vch Iteam Wise Repeate Party : Widespaced: Yes
    Local : Field : My Sales Vch Iteam Wise Repeate Name : Set as : $$Total:CFBKRepName
    Local : Field : My Sales Vch Iteam Wise Repeate ColTotal : Set as : $$Total:CFBKRepColTotal
    Border : Thin Top

    ;; Collection Definition

    [Collection: All Voucher Coll]

    Type : Vouchers
    Filter : IsSalesVT
    Fetch : PartyLedgerNAme,Date

    [Collection: CFBK Summ Voucher]

    Source Collection : All Voucher Coll
    Walk : Inventory Entries
    By : PName : $PartyLedgerName
    By : IName : $StockItemName
    Aggr Compute : BilledQty : SUM : $BilledQty
    Search Key : $IName + $PName

    [Collection: Smp Stock Item]

    Source Collection : All Voucher Coll
    Walk : Inventory Entries
    By : IName : $StockItemName
    Aggr Compute : BilledQty : SUM : $BilledQty
    Filter : NonEmptyQty

    [Collection: My Vch Wise Coll]

    Source Collection : All Voucher Coll
    Walk : Inventory Entries
    By : PName : $PartyLedgerName
    Aggr Compute : BilledQty : SUM : $BilledQty
    Filter : NonEmptyQty

    ;; Variable Definition

    [Variable: PName]

    Type : String
    Repeat : ##DSPRepeatCollection

    [Variable:Iname]

    Type:String
    Repeat: ##DSPRepeatCollection

    ;; System Formula

    [System: Formula]

    IsSalesVT : $$IsSales:$VoucherTypeName
    NonEmptyQty : NOT $$IsEmpty:$BilledQty

    ;; End-of-File
     

    Attached Files:

    Jayashri, Oct 8, 2021
    #1


  2. Jayashri

    Jayashri Member


    Voucher Wise Repeated success..but Billed Qty Not come



    [#Menu: Gateway Of Tally]
    Key Item: Party-Wise Product-Wise Sales : P : Display : My Sales Vch Iteam Wise Repeate

    [Report: My Sales Vch Iteam Wise Repeate]

    Use : DSP Template
    Form : My Sales Vch Iteam Wise Repeate
    Variable : DoSetAutoColumn, SVFromDate, SVToDate,IName
    Repeat : IName
    Set : DoSetAutoColumn : Yes
    Set : DSPRepeatCollection : "Smp Stock Item"
    Set : SVFromDate : $$YearOfDate:##SVCurrentDate
    Set : SVToDate : $$YearEnd:##SVCurrentDate

    [Form: My Sales Vch Iteam Wise Repeate]


    Use : DSP Template
    Parts : My Sales Vch Iteam Wise Repeate Main Tiltes, My Sales Vch Iteam Wise Repeate
    Option : Set Auto Vch Option : ##DoSetAutoColumn AND $$SetAutoColumns:IName
    Space Top : 2
    Space Bottom: 1.2
    Delete : Page Break

    [!Form: Set Auto Vch Option]
    ;parts : My Sales Vch Iteam Wise Repeate

    [Part: My Sales Vch Iteam Wise Repeate Main Tiltes]

    Lines : My Sales Vch Iteam Wise Repeate Main Tiltes

    [Line: My Sales Vch Iteam Wise Repeate Main Tiltes]

    Field : Name Field
    Right Field : DSP MainDateTitle
    Field : My Sales Vch Iteam Wise Repeate Main Tiltes Fld
    Local : Field : Name Field : Style : Normal Bold
    Space Bottom : 1.5

    [Field: My Sales Vch Iteam Wise Repeate Main Tiltes Fld]

    Style : "Normal Bold"
    FullWidth : Yes
    Border : Thin Bottom
    Align : Centre
    Skip : Yes
    Fixed : Yes
    Width : 50% Screen
    Set As : "Voucher-Wise Product-Wise Sales Report"



    [Part: My Sales Vch Iteam Wise Repeate]

    Lines : My Sales Vch Iteam Wise Repeate Title, My Sales Vch Iteam Wise Repeate Details
    BottomLines : My Sales Vch Iteam Wise Repeate Total
    Repeat : My Sales Vch Iteam Wise Repeate Details:My Vch Wise Coll
    Scroll : Vertical
    CommonBorder: Yes
    Total : My Sales Vch Iteam Wise Repeate Name, My Sales Vch Iteam Wise Repeate Col Total

    [Line: My Sales Vch Iteam Wise Repeate Title]

    Use : My Sales Vch Iteam Wise Repeate Details
    Local : Field : Default : Type : String
    Local : Field : Default : Align : Center
    Local : Field : My Sales Vch Iteam Wise Repeate PArty : Set as : "Party Name"
    Local : Field : My Sales Vch Iteam Wise Repeate PArty : Widespaced: No
    Local : Field : My Sales Vch Iteam Wise Repeate Name : Set as : ##IName
    Local : Field : My Sales VchSno : Set as:"V.no"
    Local : Field : My Sales VchSnoDate : Set as:"Date"
    Local : Field : My Sales Vch Iteam Wise Repeate Name : Lines : 0
    Local : Field : My Sales Vch Iteam Wise Repeate ColTotal : Set as : "Total"
    Border : Flush Totals

    [Line: My Sales Vch Iteam Wise Repeate Details]

    Fields : My Sales VchSno,My Sales VchSnoDate,My Sales Vch Iteam Wise Repeate Party, My Sales Vch Iteam Wise Repeate Name, My Sales Vch Iteam Wise Repeate Col Total
    Repeat : My Sales Vch Iteam Wise Repeate Name
    Total : My Sales Vch Iteam Wise Repeate Name
    Border : Thin Right
    Space Top:.30
    Border:Thin Bottom
    [Field:My Sales VchSno]
    Use:Name Field
    Set as:$PQRPartyVchNo
    Width:5
    Border : Thin Right

    [Field:My Sales VchSnoDate]
    Use:Name Field
    Set as:$PQRPartyDate
    Width:8
    Border : Thin Right
    Align:Right

    [Field: My Sales Vch Iteam Wise Repeate Name]

    Use : Name Field
    Set as : $IName
    Set as : $$ReportObject:$$CollectionFieldByKey:$BilledQty:mad:MyFormula:CFBKSummVoucher
    ;Set as : $$CollectionField:$BilledQty:#MySalesVchIteamWiseRepeateName:CFBKSummVoucher
    ;Set as : $$CollAmtTotal:CFBKSummVoucher:$BilledQty
    MyFormula : ##IName + $Pname
    Variable : Stock Item Name
    Format : "NoZero"
    Border : Thin Right
    Align : Right
    Width : 12

    [Field: My Sales Vch Iteam Wise Repeate Party]

    Use : Name field
    Set as :$PQRPartyName
    ;Border : Thin Right
    Width : 40

    [Field: My Sales Vch Iteam Wise Repeate Col Total]

    Use : Qty Primary Field
    Set as : $$Total:CFBKRepName
    Border : Thin Left
    Width : 15

    [Line: My Sales Vch Iteam Wise Repeate Total]

    Fields : My Sales Vch Iteam Wise Repeate Party, My Sales Vch Iteam Wise Repeate Name,My Sales Vch Iteam Wise Repeate Col Total
    Repeat : My Sales Vch Iteam Wise Repeate Name
    Local : Field : Default : Type : String
    Local : Field : Default : Align : Center
    Local : Field : My Sales Vch Iteam Wise Repeate Party : Set as : "Total Sales Qty"
    Local : Field : My Sales Vch Iteam Wise Repeate Party : Widespaced: Yes
    Local : Field : My Sales Vch Iteam Wise Repeate Name : Set as : $$Total:CFBKRepName
    Local : Field : My Sales Vch Iteam Wise Repeate ColTotal : Set as : $$Total:CFBKRepColTotal
    Border : Thin Top

    ;; Collection Definition

    [Collection: All Voucher Coll]
    Type:Vouchers:VoucherType
    Child Of:$$VchTypeSales

    Fetch : PartyLedgerNAme,Date

    [Collection: CFBK Summ Voucher]

    Source Collection : All Voucher Coll
    Walk : Inventory Entries
    By : PName : $PartyLedgerName
    By : IName : $StockItemName
    Aggr Compute : BilledQty : SUM : $BilledQty
    Search Key : $IName + $PName

    [Collection: Smp Stock Item]

    Source Collection : All Voucher Coll
    Walk : Inventory Entries
    By : IName : $StockItemName
    Aggr Compute : BilledQty : SUM : $BilledQty
    Filter : NonEmptyQty

    [Collection: My Vch Wise Coll]

    Source Collection : All Voucher Coll
    WALK : AllInventoryEntries;, BatchAllocations

    By : MasterID : $...MasterID
    By : StockItemName : $..StockItemName

    Compute : PQRPartyVchReference : $Reference ;SFSALESMANUDF
    Compute : PQRPartyVchNo : $VoucherNumber
    Compute : PQRPartyVchNoType : $VoucherTypeName
    Compute : PQRPartyDate : $Date
    Compute : PQRPartyName : $PartyLedgerName
    Compute : PQRLotStatuslots : $(Stockitem,$stockitem).BasicOrderRef;$BillUnit;$$FilterValue:$Stockcomn:LedgerEntries:First:Sales;$PreClosedLotNo;$Reference;C;$PreClosedLotNo;$BasicOrderRef;PreClosedLotNo
    Compute : PQRItemName : $BatchName;$StockItemName
    Compute : PQRItemNameStock : $StockItemName
    Compute : PQRHSNCode : $(Stockitem,$stockitem).GstDetails[Last].hsncode
    Compute : PQRGSTRate : $(Stockitem,$stockitem).GSTIGSTRate
    Compute : PQRQty : $BilledQuantity
    Compute : PQRQtyPerRate : $Rate


    Aggr Compute : BilledQty : SUM : $BilledQty
    Filter : NonEmptyQty

    ;; Variable Definition

    [Variable: PName]

    Type : String
    Repeat : ##DSPRepeatCollection

    [Variable:Iname]

    Type:String
    Repeat: ##DSPRepeatCollection

    ;; System Formula

    [System: Formula]

    IsSalesVT : $$IsSales:$VoucherTypeName
    NonEmptyQty : NOT $$IsEmpty:$BilledQty

    ;; End-of-File
     

    Attached Files:

    Jayashri, Oct 9, 2021
    #2


Share This Page