Help : How to get stock item value in this code.

Discussion in 'Free Source Codes' started by VISHNU RATHI, Jan 27, 2021.

    
  1. VISHNU RATHI

    VISHNU RATHI Member


    /*
    Dear members,

    can any one help me with this code.
    i need stockitem value also with quantity.
    Currently it is showing only quantity.

    */

    [#Menu: Gateway of Tally]
    Add : Key Item :Before : @@locQuit : Partywise Itemwise Sales : I : Display : GWLW Rep

    [Report: GWLW Rep]

    Use : DSP Template
    Form : GWLW Rep
    Variable : DoSetAutoColumn, PName
    Repeat : PName
    Set : DoSetAutoColumn : Yes
    Set : DSPRepeatCollection : "GWLW Party"
    Set : SVFromDate : $$MonthStart:##SVCurrentDate
    Set : SVToDate : $$MonthEnd:##SVCurrentDate

    [Form: GWLW Rep]

    Use : DSP Template
    Parts : GWLW Rep
    Option : Set Auto Vch Option : ##DoSetAutoColumn AND $$SetAutoColumns:pName

    [!Form: Set Auto Vch Option]

    [Part: GWLW Rep]

    Lines : GWLW Rep Title, GWLW Rep Details
    BottomLines : GWLW Rep Total
    Repeat : GWLW Rep Details : Smp Stock Item
    Scroll : Vertical
    CommonBorder: Yes
    Total : GWLW Rep Party, GWLW Rep Col Total

    [Line: GWLW Rep Title]

    Use : GWLW Rep Details

    Local : Field : Default : Type : String
    Local : Field : Default : Align : Center
    Local : Field : GWLW Rep Name : Set as : "Particulars"
    Local : Field : GWLW Rep Name : Widespaced: Yes
    Local : Field : GWLW Rep Party : Set as : ##PName
    Local : Field : GWLW Rep Party : Lines : 0
    Local : Field : GWLW Rep ColTotal : Set as : "Total"
    Border : Flush Totals

    [Line: GWLW Rep Details]

    Fields : GWLW Rep Name, GWLW Rep Party, GWLW Rep Col Total
    Repeat : GWLW Rep Party
    Total : GWLW Rep Party

    [Field: GWLW Rep Name]

    Use : Name Field
    Set as : $IName
    Display : Stock Vouchers
    Variable : Stock Item Name

    [Field: GWLW Rep Party]

    Use : Qty Primary Field
    Set as : $$ReportObject:$$CollectionFieldByKey:$BilledQty:mad:MyFormula:GWLWSummVoucher
    MyFormula : ##PName + #GWLWRepName
    Format : "NoZero"
    Border : Thin Left

    [Field: GWLW Rep Col Total]

    Use : Qty Primary Field
    Set as : $$Total:GWLWRepParty
    Border : Thin Left

    [Line: GWLW Rep Total]

    Fields : GWLW Rep Name, GWLW Rep Party, GWLW Rep Col Total
    Repeat : GWLW Rep Party
    Local : Field : Default : Type : String
    Local : Field : Default : Align : Center
    Local : Field : GWLW Rep Name : Set as : "Total"
    Local : Field : GWLW Rep Name : Widespaced: Yes
    Local : Field : GWLW Rep Party : Set as : $$Total:GWLWRepParty
    Local : Field : GWLW Rep ColTotal : Set as : $$Total:GWLWRepColTotal
    Border : Thin Top

    ;; Collection Definition

    [Collection: GWLW Voucher]

    Type : Voucher
    Filter : IsSalesVT

    [Collection: GWLW Summ Voucher]

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

    [Collection: Smp Stock Item]

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

    [Collection: GWLW Party]

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

    ;; Variable Definition

    [Variable: PName]

    Type : String
    Repeat : ##DSPRepeatCollection

    ;; System Formula

    [System: Formula]

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

    ;; End-of-File
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    This is made by Goodwill Learning......... They are EXPERTS........ you must approach them for any help regarding this, since they have made this.
     
    Jaydeep Shah likes this.


Share This Page