Stock Item Details in Columnar Format

Discussion in 'Requests' started by Jeetu Mutha, Feb 23, 2014.

    
  1. Jeetu Mutha

    Jeetu Mutha New Member


    I am using the following code but in exploded view I only get the first stock item name. Kindly help.




    Code:
    [#Menu: Gateway of Tally]
       
      Item: Jeetus Report : Menu :  Jeetu Sub Menu
    ;;    Key Item    : @@locAccountsInfo            : A : Menu                : Accounts Info.            : NOT $$IsEmpty:$$SelectedCmps 
     
    [Menu: Jeetu Sub Menu]
     
      Item : Sale Register : Display : Sale Register : NOT $$IsEmpty:$$SelectedCmps
     
     
    [Report : Sale Register]
        Variables  : SV CurrentCompany, SV FromDate, SV ToDate, SV SortMethod, SVBudget, SVVariance
        Set            : SV Sort Method        : "Default"
        Set        : Is Day Book          : No
        Form        : RecReg
        Set        : SVFromDate              : ##SVCurrentDate
        Set        : SVToDate                : ##SVCurrentDate
     
    [Form : RecReg]
        Use          : Dsp Template
        Height      : 100 % Page
        Width      : 100 % Page
        Part          : RecBody
     
    [Part : RecBody]
        Lines      : Rchqlineh, Rchqline
        Repeat  : RChqline : Rctvchs
        Bottom Line    : RecBodyBLn
        Totals    : CASAmt, RFldAmt
        Scroll  : Vertical
        Common border : Yes
     
    [Line : RChqLineh]
        Fields          : RFldsl, RFldDate, RFldPart
        Right Fields    : RFldhead
     
        Local : Field : Default      : Type      : String
        Local : Field : RFldsl      : Set as      : "Voucher No."
        Local : Field : RFldDate      : Set as      : "Date"
       
        Local : Field : RFldPart      : Set as      : "Item"
        ;;Local : Field : RFldChno      : Set as      : "Chqeque No."
        ;;Local : Field : CASAmt      : Set as      : "Cash Amount"
        ;;Local : Field : RFldAmt      : Set as      : "Bank Amount"
        ;;Local : Field : RFldhead      : Set as      : "Account Head"
        Border : thin Top Bottom
       
    [Line    : RecBodyBLn]
        Use    : RChqLine
        Local : Field : RFldsl      : Set as      : ""
        Local : Field : RFldDate      : Set as      : ""
        Local : Field : RFldDate      : Type      : String
        Local : Field : RFldPart      : Set as      : ""
        ;;Local : Field : RFldChno      : Set as      : ""
        ;;Local : Field : CASAmt      : Set as      : $$Total:CASAmt
        ;;Local : Field : RFldAmt      : Set as      : $$Total:RFldAmt
        Local : Field : RFldhead      : Set as      : ""
        Border    : Totals
     
     
    [Line : RChqLine]
        Fields          : RFldsl, RFldDate, RFldPart
        Right Fields    : RFldhead
     
        Option          : AlterOnEnter : $$IsVoucher AND NOT $IsDeleted
        Explode          : RHeadDetail : $$KeyExplode OR ##ExplodeFlag
     
    [Field : RFldsl]
        Use          : Short Name Field
        Set as      : $VoucherNumber
        Width          :  7
        Align          : Right
        Alter      : Voucher  : $$IsVoucher AND NOT $IsDeleted
        ;;space Right : 2
        Border      : Thin Right
        Align        : Center
       
    [Field : RFldDate]
        Use          : Uni Date Field
        Set as      : $Date
        Border      : thin Right
        width      : 10
     
    [Field : RFldPart]
        Use          : Name Field 
        Set as      : $StockItemName
        ;;Variable    :StockItemname
        Width          : 40
        Border        : Thin Left
        ;;Line        : 0
       
     
    [Field : RFldhead]
        Use          : Name field
        Set as      : $Ledgername
        Width          : 15
        Border      : Thin left
     
    [Collection : Rctvchs]
        Collection    : Rctvchsgb
        ;;Collection  : Rctvchsgbod
     
    [Collection : Rctvchsgb]
        Type          : Vouchers
        Childof      : $$GroupSundryDebtors
        Filter      : Rctvchs
        Fetch        : Ledger, Amount, Date
     
    ;;[Collection : Rctvchsgbod]
    ;;    Type        : Voucher
    ;;    Filter        : Rctvchs
    ;;    Childof : $$GroupSundryDebtors
    ;;    Belongs To : yes
    ;;    Walk                : Inventory Entries
    ;;    By        :$VoucherNumber
     
    [System : formula] 
       
        Rctvchs        : $$IsSales:$VoucherTypeName
       
     
    [Part : RHeadDetail] 
        Line          : RChqexpln 
        Repeat      : RChqexpln : AllLedgerEntries
        ;;Option      : small size Part
     
    [Line : RChqexpln] 
        Fields          : RFldsle, RFldDatee,; RFldParte 
        Right Fields    : RFldheade 
       
     
                        [Field : RFldsle]
                            Use          : Short Name Field 
                            Set as      : "" 
                            Width          : 8
                            Align          : Right 
                            Alter      : Voucher  : $$IsVoucher AND NOT $IsDeleted 
                            space Right : 2
                            Border      : thin Right
     
                        [Field : RFldDatee]
                            Use          : Uni Date Field 
                            Set as      : "" 
                            Border      : thin Right 
                            width      : 10
     
                        [Field : RFldParte]
                            Use          : Name Field 
                            Set as      : $StockItemName
                            Width          : 8
                            Border        : Thin Left                       
                        [Field : RFldheade]
                            Use          : Name field 
                            Set as      : $Ledgername 
                            Width      : 4 
                            Border      : Thin left 
                            
     


  2. Jeetu Mutha

    Jeetu Mutha New Member


    Solved with the help of walk, by and compute.
     


  3. mpal2311

    mpal2311 Active Member


    can you please share the modified codes.
    :)
     


Share This Page