manjari use this below code: Issue has solved

Discussion in 'General Discussions' started by Sangam, Oct 1, 2014.

    
  1. Sangam

    Sangam New Member


    [#Menu:GatewayofTally]
    Add:Item:Voucher List:Display:Voucher List

    [Report:Voucher List]
    Form:Voucher Form
    Title:"Voucher List"

    [Form:Voucher Form]
    Use:DSP Template
    Parts:Voucher Part
    Button:Invoice Btn
    Width:100% Screen
    Height:100% Screen
    Background:Grey

    [Part:Voucher Part]
    Lines:Voucher Title,Voucher Line
    Repeat:Voucher Line: TestVchColl ;Voucher Details
    Common Border:Yes
    Scroll:Vertical

    [Line:Voucher Title]
    Use:Voucher Line
    Local:Field:Default:Type:String
    Local:Field:Default:Align:Center
    Local:Field:Default:Style:Normal Bold
    Local:Field:Voucher Date:Set as:"Date"
    Local:Field:Invoice No:Set as:"Invoice No"
    Local:Field:Bill No:Set as:"Bill No"
    Local:Field:Voucher Party:Set as:"Customer/Buyer"
    Local:Field:Item:Set as:"Item Name"
    Local:Field:Description:Set as:"Desc"
    Local:Field:Voucher Type:Set as:"Voucher Type"
    Local:Field:Voucher No:Set as:"V.No"
    Local:Field:Amount:Set as:"Amount"
    Border:Thin Top Bottom

    [Line:Voucher Line]
    Fields:Voucher Date, Invoice No, Bill No, Voucher Party,Item,Description, Voucher Type, Voucher No, Amount
    Option:AlterOnEnter

    [Field :Voucher Date]
    Use : Short Date Field
    Set As : $Date
    Border:Thin Right
    Width:10
    Alter:Voucher
    Align:Center

    [Field:Invoice No]
    Use:Name Field
    Set as:$Reference
    Border:Thin Right

    [Field:Bill No]
    Use:Name Field
    Set as:$Narration
    Border:Thin Right

    [Field : Voucher Party]
    Use : NAme Field
    Set As : $PArtyLedgerName
    Border:Thin Right

    [Field:Item]
    Use:Name Field
    Set as:$StockItemName
    Border:Thin Right

    [Field:Description]
    Use:Name Field
    Set as: $BDescription
    Border:Thin Right
    Color : Red

    [Field : Voucher No]
    Use : NAme Field
    Set As : $VoucherNumber
    Border:Thin Right
    Align:Center
    Width:10

    [Field :Voucher Type]
    Use : Name Field
    Set As : $VoucherTypeName
    Border:Thin Right

    [Field : Amount]
    Use : Amount Field
    Set As :$Amount
    Format : "CRDR"

    [Button:Invoice Btn]
    Key:Alt+I
    Action:Execute:Invoice Rpt
    Title:Find Invoice

    [Report:Invoice Rpt]
    Form:Invoice Frm
    Title:Find Invoice
    Filter:$Reference

    [Form:Invoice Frm]
    Part:Invoice Prt
    Add : On : Form Accept : yes : Action:Alter:Voucher

    [Part:Invoice Prt]
    Line:Invoice Ln

    [Line:Invoice Ln]
    Field:Medium Prompt, Invoice Fld
    Local:Field:Medium Prompt:Set as:"Select Invoice No"
    Option: AlterOnEnter : $$IsVoucher


    [Field:Invoice Fld]
    Table:Invoice Col
    Show Table:Always
    Use:Name Field
    Width:50
    Border:Thin Box
    Alter:Voucher
    Option: AlterOnEnter : $$IsVoucher

    [Collection:Invoice Col]
    Type:Vouchers
    Belongs To:Yes
    Format:$Reference
    Option:AlterOnEnter

    [Collection :Voucher Details]
    ;;Collection:cre col ;;, deb col

    ;; [Collection:cre col]
    Type : Vouchers

    Belongs To:Yes

    [Collection : TestVchColl]

    Type : Voucher
    Belongs To : Yes

    ;;Source Collection : Voucher Details

    ;;Walk : InventoryEntries , BasicUserDescription

    Compute : BDescription : $AllInventoryEntries.BasicUserDescription.BasicUserDescription

    Fetch : Date,Amount,Reference,VoucherTypeName,PArtyLedgerName,VoucherNumber,StockItemName,Narration

    ;; [Collection: deb col]
    ;;Type : Description : StockItem
    ;;Child of : #VCHStockItem

    ;;[System: UDF]
    ;;Description : String : 20001
     


  2. mpal2311

    mpal2311 Active Member



Share This Page