1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Sir Please Rectified below code Display All Sale Entries My Requirement only VAT TIN DEALERS only

Discussion in 'Requests' started by sanjaygori, May 28, 2016.

    
  1. sanjaygori

    sanjaygori New Member


    Sir Please Rectified below code Display All Sale Entries My Requirement only VAT TIN DEALERS only
    [#Menu : Gateway of Tally]
    Item : Vat : Display : Vat

    [Report : Vat]
    Form :Vat
    Variable : SVFromDate,SVToDate
    Set : SVFromDate : ##SVCurrentDate
    Set : SVToDate : ##SVCurrentDate

    [Form :Vat]
    Part :daybookhead,daybookhead1, Vat ;;,daybookhead2



    bottom Part : daybookbottam
    Button : Change Period,Print Button,Export Button,FilterButton,GRPVCH Configure
    Background : white



    [Part : daybookhead]
    Line :daybookhead
    [Line :daybookhead]
    Field : Simple Field
    ;Local : Field : Simple Field : Set As : ". Vat Dealer Sales List " + $$String:##SVCurrentDate
    Local : Field : Simple Field : Set As : " Vat Dealer Sales List " + $$String:##SVFromDate +" to " + $$String:##SVToDate
    Local : Field : Simple Field : Style : Normal Bold
    Local : Field : Simple Field : Align : Centre


    [Part : daybookhead1]
    Use : Vat
    Delete : Repeat
    Delete : Scroll
    Border : ColumnTitles
    Local : Field : Default : Type : string
    Local : Field : My Voucher Srl : Set As : "Srl.No"
    Local : Field : My Voucher Date : Set As : "Date"
    Local : Field : MyVoucherParty: Set As : "Particular"
    Local : Field : MyVchAmount1 : Set As : "Tin Number"
    Local : Field : MyVchNo : Set As : "Invoice No"
    Local : Field : MyVchType : Set As : "Voucher Type"
    Local : Field : MyVchAmount : Set As : "Sales"


    Local :Field : Default : Style : Normal
    Local: Field: Default: Align: Center
    ;;Local: Field: Default:Background: red




    [Part :Vat]
    Line : Vat
    Repeat :Vat :My Voucher Rep Collection
    tOTAL : MyVchAmount

    Scroll : Vertical
    [Line :Vat]
    Field :My Voucher Srl,My Voucher Date,MyVoucherParty,MyVchAmount1,MyVchNo,MyVchType

    Right Field : MyVchAmount

    Option : Alter On Enter

    [Field :My Voucher Srl]
    Use : Number Field
    SET AS:$$STRING:$$LINE + ""
    Width : 4% Screen
    Align: Left
    Border : Thin Right
    Style : Normal


    [Field :My Voucher Date]
    Use : Short Date Field
    Set As : $Date
    Border : Thin Right
    Style : Normal
    Format:"Short Date"

    [Field : MyVoucherParty]
    Use : NAme Field
    ;;Set As : $BuyerAddress
    Set As : $LedgerName
    Width : 35
    Style : Normal
    Border : Thin Right
    Alter : Voucher

    [Field : MyVchAmount1]
    Use : Name Field
    Set As : $BASICBUYERSSALESTAXNO
    ;;Set As : $VatTinNumber
    Width : 11
    Border : Thin Right
    Style : Normal

    [Field : MyVchNo]
    Use : NAme Field
    Set As : $VoucherNumber
    Width : 10
    Border : Thin Right
    Align:Center
    Style : Normal

    [Field : MyVchType]
    Use : Name Field
    Set As : $VoucherTypeName
    Border : Thin Right
    Width : 10
    Style : Normal

    [Field : MyVchAmount]
    Use : Amount Field
    Set As :if $VoucherTypeName CONTAINS "Sale" then $Amount else ""
    ;;Format : "DrCr"
    Border : Thin Right
    Style : Normal


    [Collection : My Voucher Rep Collection]
    Type : Ledger
    Type : Vouchers
    Filter : IsSalesVT
    Fetch : Date,Amount,VoucherTypeName ,PArtyLedgerName,VoucherNumber




    [Part: daybookbottam]



    Lines : daybookTotalLine

    [Line: daybookTotalLine]

    Use : Vat
    Local: Field: Default : Style : Small Bold
    ;;Local: Field: Default:Background: yellow
    Local: Field: Default: Type: String
    Local: Field: Default: Align: Center
    Local : Field : My Voucher Srl : Set as: ""
    Local : Field : MyVoucherParty: Set As : "Total"
    ;;Local : Field : MyVoucherParty: Color: Red
    Local : Field : MyVchNo : Set As : ""
    ;;Local : Field : MyVchNo: Color: Red
    Local : Field : MyVchType : Set As : "Amount"
    ;;Local : Field : MyVchType : Color: Red
    Local : Field : MyVchAmount : Set As : $$Total:MyVchAmount
    Border : Totals

    [System: Formula]

    IsSalesVT : $$IsSales:$VoucherTypeName
     
    sanjaygori, May 28, 2016
    #1


  2. Raju Bhanushali

    Raju Bhanushali New Member


    [#Menu : Gateway of Tally]
    Item : Vat : Display : Vat

    [Report : Vat]
    Form :Vat
    Variable : SVFromDate,SVToDate
    Set : SVFromDate : ##SVCurrentDate
    Set : SVToDate : ##SVCurrentDate

    [Form :Vat]
    Part :daybookhead,daybookhead1, Vat ;;,daybookhead2



    bottom Part : daybookbottam
    Button : Change Period,Print Button,Export Button,FilterButton,GRPVCH Configure
    Background : white



    [Part : daybookhead]
    Line :daybookhead
    [Line :daybookhead]
    Field : Simple Field
    ;Local : Field : Simple Field : Set As : ". Vat Dealer Sales List " + $$String:##SVCurrentDate
    Local : Field : Simple Field : Set As : " Vat Dealer Sales List " + $$String:##SVFromDate +" to " + $$String:##SVToDate
    Local : Field : Simple Field : Style : Normal Bold
    Local : Field : Simple Field : Align : Centre


    [Part : daybookhead1]
    Use : Vat
    Delete : Repeat
    Delete : Scroll
    Border : ColumnTitles
    Local : Field : Default : Type : string
    Local : Field : My Voucher Srl : Set As : "Srl.No"
    Local : Field : My Voucher Date : Set As : "Date"
    Local : Field : MyVoucherParty: Set As : "Particular"
    Local : Field : MyVchAmount1 : Set As : "Tin Number"
    Local : Field : MyVchNo : Set As : "Invoice No"
    Local : Field : MyVchType : Set As : "Voucher Type"
    Local : Field : MyVchAmount : Set As : "Sales"


    Local :Field : Default : Style : Normal
    Local: Field: Default: Align: Center
    ;;Local: Field: Default:Background: red




    [Part :Vat]
    Line : Vat
    Repeat :Vat :My Voucher Rep Collection
    tOTAL : MyVchAmount

    Scroll : Vertical
    [Line :Vat]
    Field :My Voucher Srl,My Voucher Date,MyVoucherParty,MyVchAmount1,MyVchNo,MyVchType

    Right Field : MyVchAmount

    Option : Alter On Enter

    [Field :My Voucher Srl]
    Use : Number Field
    SET AS:$$STRING:$$LINE + ""
    Width : 4% Screen
    Align: Left
    Border : Thin Right
    Style : Normal


    [Field :My Voucher Date]
    Use : Short Date Field
    Set As : $Date
    Border : Thin Right
    Style : Normal
    Format:"Short Date"

    [Field : MyVoucherParty]
    Use : NAme Field
    ;;Set As : $BuyerAddress
    Set As : $LedgerName
    Width : 35
    Style : Normal
    Border : Thin Right
    Alter : Voucher

    [Field : MyVchAmount1]
    Use : Name Field
    Set As : If @@IsExciseTraderOn AND (@@IsExciseMfgrInvoice OR @@IsTraderInvoice) Then If (@@IsSales OR @@IsDebitNote) AND NOT @@ICFGBuyerDetails Then $BasicBuyersSalesTaxNo Else $TraderConsVATTINNo Else @@BuyerTaxNum;$BASICBUYERSSALESTAXNO
    ;;Set As : $VatTinNumber
    Width : 11
    Border : Thin Right
    Style : Normal

    [Field : MyVchNo]
    Use : NAme Field
    Set As : $VoucherNumber
    Width : 10
    Border : Thin Right
    Align:Center
    Style : Normal

    [Field : MyVchType]
    Use : Name Field
    Set As : $VoucherTypeName
    Border : Thin Right
    Width : 10
    Style : Normal

    [Field : MyVchAmount]
    Use : Amount Field
    Set As :if $VoucherTypeName CONTAINS "Sale" then $Amount else ""
    ;;Format : "DrCr"
    Border : Thin Right
    Style : Normal


    [Collection : My Voucher Rep Collection]
    Type : Ledger
    Type : Vouchers
    Filter : IsSalesVT
    Fetch : Date,Amount,VoucherTypeName ,PArtyLedgerName,VoucherNumber




    [Part: daybookbottam]



    Lines : daybookTotalLine

    [Line: daybookTotalLine]

    Use : Vat
    Local: Field: Default : Style : Small Bold
    ;;Local: Field: Default:Background: yellow
    Local: Field: Default: Type: String
    Local: Field: Default: Align: Center
    Local : Field : My Voucher Srl : Set as: ""
    Local : Field : MyVoucherParty: Set As : "Total"
    ;;Local : Field : MyVoucherParty: Color: Red
    Local : Field : MyVchNo : Set As : ""
    ;;Local : Field : MyVchNo: Color: Red
    Local : Field : MyVchType : Set As : "Amount"
    ;;Local : Field : MyVchType : Color: Red
    Local : Field : MyVchAmount : Set As : $$Total:MyVchAmount
    Border : Totals

    [System: Formula]

    IsSalesVT : $$IsSales:$VoucherTypeName
     
    Raju Bhanushali, May 28, 2016
    #2


  3. ldharjani

    ldharjani New Member


    check this...

    [#Menu : Gateway of Tally]
    Item : Vat : Display : Vat

    [Report : Vat]
    Form :Vat
    Variable : SVFromDate,SVToDate
    Set : SVFromDate : ##SVCurrentDate
    Set : SVToDate : ##SVCurrentDate

    [Form :Vat]
    Part :daybookhead,daybookhead1, Vat ;;,daybookhead2



    bottom Part : daybookbottam
    Button : Change Period,Print Button,Export Button,FilterButton,GRPVCH Configure
    Background : white



    [Part : daybookhead]
    Line :daybookhead
    [Line :daybookhead]
    Field : Simple Field
    ;Local : Field : Simple Field : Set As : ". Vat Dealer Sales List " + $$String:##SVCurrentDate
    Local : Field : Simple Field : Set As : " Vat Dealer Sales List " + $$String:##SVFromDate +" to " + $$String:##SVToDate
    Local : Field : Simple Field : Style : Normal Bold
    Local : Field : Simple Field : Align : Centre


    [Part : daybookhead1]
    Use : Vat
    Delete : Repeat
    Delete : Scroll
    Border : ColumnTitles
    Local : Field : Default : Type : string
    Local : Field : My Voucher Srl : Set As : "Srl.No"
    Local : Field : My Voucher Date : Set As : "Date"
    Local : Field : MyVoucherParty: Set As : "Particular"
    Local : Field : MyVchAmount1 : Set As : "Tin Number"
    Local : Field : MyVchNo : Set As : "Invoice No"
    Local : Field : MyVchType : Set As : "Voucher Type"
    Local : Field : MyVchAmount : Set As : "Sales"


    Local :Field : Default : Style : Normal
    Local: Field: Default: Align: Center
    ;;Local: Field: Default:Background: red




    [Part :Vat]
    Line : Vat
    Repeat :Vat :My Voucher Rep Collection
    tOTAL : MyVchAmount

    Scroll : Vertical
    [Line :Vat]
    Field :My Voucher Srl,My Voucher Date,MyVoucherParty,MyVchAmount1,MyVchNo,MyVchType

    Right Field : MyVchAmount

    Option : Alter On Enter

    [Field :My Voucher Srl]
    Use : Number Field
    SET AS:$$STRING:$$LINE + ""
    Width : 4% Screen
    Align: Left
    Border : Thin Right
    Style : Normal


    [Field :My Voucher Date]
    Use : Short Date Field
    Set As : $Date
    Border : Thin Right
    Style : Normal
    Format:"Short Date"

    [Field : MyVoucherParty]
    Use : NAme Field
    ;;Set As : $BuyerAddress
    Set As : $LedgerName
    Width : 35
    Style : Normal
    Border : Thin Right
    Alter : Voucher

    [Field : MyVchAmount1]
    Use : Name Field

    Set As :$VATTINNumber:Ledger:$PartyLedgerName

    Width : 11
    Border : Thin Right
    Style : Normal

    [Field : MyVchNo]
    Use : NAme Field
    Set As : $VoucherNumber
    Width : 10
    Border : Thin Right
    Align:Center
    Style : Normal

    [Field : MyVchType]
    Use : Name Field
    Set As : $VoucherTypeName
    Border : Thin Right
    Width : 10
    Style : Normal

    [Field : MyVchAmount]
    Use : Amount Field
    Set As :if $VoucherTypeName CONTAINS "Sale" then $Amount else ""
    ;;Format : "DrCr"
    Border : Thin Right
    Style : Normal


    [Collection : My Voucher Rep Collection]
    Type : Ledger
    Type : Vouchers
    Filter : IsSalesVT
    Fetch : Date,Amount,VoucherTypeName ,PArtyLedgerName,VoucherNumber




    [Part: daybookbottam]



    Lines : daybookTotalLine

    [Line: daybookTotalLine]

    Use : Vat
    Local: Field: Default : Style : Small Bold
    ;;Local: Field: Default:Background: yellow
    Local: Field: Default: Type: String
    Local: Field: Default: Align: Center
    Local : Field : My Voucher Srl : Set as: ""
    Local : Field : MyVoucherParty: Set As : "Total"
    ;;Local : Field : MyVoucherParty: Color: Red
    Local : Field : MyVchNo : Set As : ""
    ;;Local : Field : MyVchNo: Color: Red
    Local : Field : MyVchType : Set As : "Amount"
    ;;Local : Field : MyVchType : Color: Red
    Local : Field : MyVchAmount : Set As : $$Total:MyVchAmount
    Border : Totals

    [System: Formula]

    IsSalesVT : $$IsSales:$VoucherTypeName
     
    ldharjani, May 30, 2016
    #3


  4. sanjaygori

    sanjaygori New Member


    thank you sir
     
    sanjaygori, Jun 10, 2016
    #4


Share This Page