GET PREVIOUS PERIOD DATA INTO CURRENT PERIOD IN SALES VOUCHER

Discussion in 'Tally Developer' started by Naitesh, Apr 11, 2019.

    
  1. Naitesh

    Naitesh Member


    HELLO EXPERT SIR,

    I HAVE CREATE BasicUserDescription LIST NEXT TO STOCKITEM
    SAME COMPANY I HAVE CREATE NEW PERIOD
    I WANT TO LIST OF BasicUserDescription OF SAME STOCKITEM OF PREVIOUS PERIOD

    I HAVE TRIED THIS BUT IT NOT SHOWS PREVIOUS PERIOD DATA

    PLEASE HELP ME TO CORRECT CODE
    THANK YOU

    [#Line: EI InvInfo]
    add:Fields:After: VCH StockItem: NUDescription1

    [#Line: EI ColumnOne]
    add:Fields: After:VCH ItemTitle : NTDescription1

    [#Line: EI ColumnTwo]
    add:Fields:After:VCH ItemTitle :NTDescription1
    Local:Field: NTDescription1:Set as:""

    [#Field: VCH ItemTitle]
    Width : 30

    [Field:NTDescription1]

    Use: Name Field
    Set as: "Description"
    Width: 20
    Align: Right
    Skip: Yes

    [Field:NUDescription1]
    Use : Name Field
    Width : 20
    Align : Left
    Set Always:Yes
    Storage:BasicUserDescription
    Table : ColCatFinal,endoflist,New Number
    Show Table : Always
    Trigger:New Number: $$IsSysNameEqual:NewNumber:$$EditData
    CommonTable : No
    Dynamic : ""
    Skip on : $$IsEnd:$StockItemName

    [System: Formula]
    FilterVchAndDate : $$IsSales:$VoucherTypeName $Date > $$Date:'31-03-2018'
    FilterVchStkItemAndCat : $StockItemName = #VCHStockItem

    [Collection : ColCatMaster]
    Type : Voucher
    Belongs To:Yes
    Fetch : BasicUserDescription
    Filter:FilterVchAndDate

    [Collection : ColCatFinal]
    Source Collection :ColCatMaster
    Belongs To:Yes
    Walk : InventoryEntries
    Format : $BasicUserDescription,30
    Title:"Item Detail"
    Fetch : BasicUserDescription
    Filter : FilterVchStkItemAndCat
     

    Attached Files:



Share This Page