Godown Transfer Column in stock Summary Required.

Discussion in 'Tally Developer' started by zakirhossain_diu, May 16, 2019.

         

  1. Dear Sir,
    I am just trying to get a new column in Stock Summary Report for Godown Transfer Qty. Can Someone Please check followings How Can i Get Qty only from Godown transfer Journal only.

    [#Menu:GateWay of Tally]
    Add: Item:Spectra Report:Display:Spectra Report

    [Report:Spectra Report]
    ;Use:Godown Summary
    Use :Stock Summary
    Local : Field : DSP QtyOneTitle : Delete: Fields ;: After:DSP QtyOpTitle: Spectra Stockin,Spectra SR
    Local : Field : DSP QtyOneTitle : Add : Fields:DSP QtyOpTitle, DSP QtyInTitle, Spectra Stockin, DSP QtyOutTitle, DSP QtyClTitle;: After:DSP QtyOpTitle: Spectra Stockin,Spectra SR
    Local : Field : DSP QtyTwoTitle : Delete: Fields
    Local : Field : DSP QtyTwoTitle : Add : Fields: DSPQ OpTitle, DSPQ InTitle, SpectraQ Stockin, DSPQ OutTitle, DSPQ ClTitle
    Local : Field : DSP StkInfo : Add : Fields: After : DSP StkIn : Spectra StockinD
    Local : Field : DSP StkInfoTotal : Local : Field : DSPInQtyG : Set as : $$Total:DSPInQtyG ;Add: Fields: After:DSP StkIn:Spectra Stockin
    Local : Field : DSP StkInfoTotal : Local : Field : DSPInAltQtyG : Set as : $$Total:DSPInAltQtyG
    Local : Field : DSP StkInfoTotal : Add : Fields: After : DSP StkIn : Spectra StockinD

    [Field:Spectra Stockin]
    Use : DSP ColTitle
    Set as : $$LocaleString:"Godown Transfer"
    Style : Small Bold
    Invisible : NOT ##DSPShowOpening ;OR NOT $$IsCurrentVarSPOrderCombo
    SubTitle : No
    Width : @@DSPWithAltQtyWidth + @@DSPWithQtyWidth ;+ @@DSPWithRateWidth + @@DSPWithAmtWidth
    SpaceLeft : 0
    SpaceRight : 0
    Cells : @@OpCellTotalVal

    [Field:SpectraQ Stockin]
    Use : DSPQ InTitle
    Delete : Fields
    Add: Fields : DSPQ QtyTitleG, DSPQAltQtyTitleG ;, DSPQ RateTitle, DSPQ ValueTitle
    Invisible : NOT ##DSPShowInwards OR NOT $$IsCurrentVar:DSPOrderCombo
    Border : Thin Left : (##DSPShowOpening OR @@DSPShowOutwards OR ##DSPShowClosing) AND ($$NumSets = 1)

    [Field: DSPQ QtyTitleG]
    Use : DSP QtyTitleTemplate
    Info : $$LocaleString:"Quantity"
    Style : Small
    Align : Centre
    Invisible : @@QtyInvisible

    [Field: DSPQ AltQtyTitleG]

    Use : DSP QtyTitleTemplate
    Info : $$LocaleString:"(Alt. Units)" ;;; Stock Reports - Show Qty in Alternate Units??
    Style : Small Italic
    Align : Centre
    Invisible : @@QtyInvisible OR NOT ##DSPQtyAlternate


    [Field: Spectra StockinD]
    Use : DSP StkIn
    Delete : Fields
    Add : Fields: DSPInQtyG, DSPInAltQtyG ;, DSPInRateG, DSP DrAmtA
    Invisible : NOT ##DSPShowInwards OR NOT $$IsCurrentVar:DSPOrderCombo
    Border : Thin Left : ##DSPShowOpening OR @@DSPShowOutwards OR ##DSPShowClosing
    Width : @@DSPWithAltQtyWidth + @@DSPWithQtyWidth ;+ @@DSPWithRateWidth + @@DSPWithAmtWidth

    [Field: DSP InQtyG]
    Use : DSP QtyTemplate
    Set as : if ($IsOpLine) then 0 else $$AsOutQty:$TrSaleQty ;TrPurcQty ;$StkInQty
    Inactive : ##DSPShowMonthly AND NOT ##DSPAverage AND ($$DateFrom > $LastVoucherDate:Company:##SVCurrentCompany)
    GraphValue : NOT ##GraphByValue

    [Field: DSP InAltQtyG]
    Use : DSP AltQtyTemplate
    Set as : #DSPInQtyG;if ($IsOpLine) then 0 else $$AsInQty:$StkInQty
    Inactive : ##DSPShowMonthly AND NOT ##DSPAverage AND ($$DateFrom > $LastVoucherDate:Company:##SVCurrentCompany)


    ;;;;;;;;;;;;;;
    /*
    [#Field: DSPS StkOp]

    Add : Fields :After: DSP StkOp:Spectra StockinD,Spectra SRD


    [#Field: DSPS StkOut]

    Add : Fields :After: DSP StkOut:SpectraQ StockoutD,SpectraQ PRD



    [Field:Spectra SRD]
    Use : DSP QtyTemplate
    Set as : if ($IsOpLine) then 0 else $StkOpBalance;;------Stock in through Sales Return
    Background: Red

    [Field:SpectraQ StockoutD]
    Use : DSP QtyTemplate
    Set as : if ($IsOpLine) then 0 else $StkOpBalance;;-----Stock out through Stock Journal
    Background: Yellow

    [Field:SpectraQ PRD]
    Use : DSP QtyTemplate
    Set as :if ($IsOpLine) then 0 else $StkOpBalance ;;--------Stock Out Through Purchase return
    Background: Red
     
    Last edited: May 16, 2019


Share This Page