Godown Summary Report

i design a report for Godown Summary Report.
Such as Opening Qty, Stock in through stock journal,Purchase, Sales Return, Sales, Stockout through Stock journal, Purchase Return & closing Stock.

HTML:

[#Menu:GateWay of Tally]
Add:Key Item:Spectra Report:Risplay:Spectra Report
 
[Report:Spectra Report]
Use:Godown Summary
 
 
[#Field: DSP QtyOneTitle]
 
add: Fields : AfterSP QtyOpTitle: Spectra Stockin,Spectra SR
Add:Field: AfterSP QtyOutTitle:Spectra Stockout,Spectra PR
Border : Full Thin Top : NOT $$IsFirstInPart
 
[#Field: DSP QtyInTitle]
 
Use : DSP QtyOpTitle
Set as : $$LocaleString:"Purchase"
Invisible : NOT ##DSPShowInwards OR NOT $$IsCurrentVarSPOrderCombo
Cells: @@InCellTotalVal
 
[Field:Spectra Stockin]
Use : DSP ColTitle
Set as : $$LocaleString:"Stock Transfor"
Style : Small Bold
Invisible : NOT ##DSPShowOpening OR NOT $$IsCurrentVarSPOrderCombo
SubTitle : No
Width: @@DSPWithAltQtyWidth + @@DSPWithQtyWidth + @@DSPWithRateWidth + @@DSPWithAmtWidth
SpaceLeft: 0
SpaceRight: 0
Cells: @@OpCellTotalVal
Border:Thin Left right
 
[Field:Spectra SR]
Use : DSP ColTitle
Set as : $$LocaleString:"SReturn"
Style : Small Bold
Invisible : NOT ##DSPShowOpening OR NOT $$IsCurrentVarSPOrderCombo
SubTitle : No
Width: @@DSPWithAltQtyWidth + @@DSPWithQtyWidth + @@DSPWithRateWidth + @@DSPWithAmtWidth
SpaceLeft: 0
SpaceRight: 0
Cells: @@OpCellTotalVal
 
 
[#Field: DSP QtyOutTitle]
 
Use : DSP QtyOpTitle
Set as : $$LocaleString:"Sales"
Invisible : NOT @@DSPShowOutwards OR NOT $$IsCurrentVarSPOrderCombo
Width: @@DSPWithAltQtyWidth + @@DSPWithQtyWidth + @@DSPWithRateWidth + @@DSPWithAmtWidth + @@DSPWithGPWidth
Cells: @@OutCellTotalVal
 
[Field:Spectra Stockout]
Use : DSP ColTitle
Set as : $$LocaleString:"StockTransfor"
Style : Small Bold
Invisible : NOT ##DSPShowOpening OR NOT $$IsCurrentVarSPOrderCombo
SubTitle : No
Width: @@DSPWithAltQtyWidth + @@DSPWithQtyWidth + @@DSPWithRateWidth + @@DSPWithAmtWidth
SpaceLeft: 0
SpaceRight: 0
Cells: @@OpCellTotalVal
Border:Thin Right
 
[Field:Spectra PR]
Use : DSP ColTitle
Set as : $$LocaleString:"PReturn"
Style : Small Bold
Invisible : NOT ##DSPShowOpening OR NOT $$IsCurrentVarSPOrderCombo
SubTitle : No
Width: @@DSPWithAltQtyWidth + @@DSPWithQtyWidth + @@DSPWithRateWidth + @@DSPWithAmtWidth
SpaceLeft: 0
SpaceRight: 0
Cells: @@OpCellTotalVal
 
 
 
[#Field: DSP QtyTwoTitle]
Add:Fields:AfterSPQ OpTitle: SpectraQ Stockin,SpectraQ SR
Add:Field: AfterSP QtyOutTitle:SpectraQ Stockout,SpectraQ PR
 
[Field:SpectraQ Stockin]
Use : DSP ColTitle
Set as : $$LocaleString:"Quantity"
Style : Small Bold
Invisible : NOT ##DSPShowOpening OR NOT $$IsCurrentVarSPOrderCombo
SubTitle : No
Width: @@DSPWithAltQtyWidth + @@DSPWithQtyWidth + @@DSPWithRateWidth + @@DSPWithAmtWidth
SpaceLeft: 0
SpaceRight: 0
Cells: @@OpCellTotalVal
Border:Thin Right
 
[Field:SpectraQ SR]
Use : DSP ColTitle
Set as : $$LocaleString:"Quantity"
Style : Small Bold
Invisible : NOT ##DSPShowOpening OR NOT $$IsCurrentVarSPOrderCombo
SubTitle : No
Width: @@DSPWithAltQtyWidth + @@DSPWithQtyWidth + @@DSPWithRateWidth + @@DSPWithAmtWidth
SpaceLeft: 0
SpaceRight: 0
Cells: @@OpCellTotalVal
 
 
[Field:SpectraQ Stockout]
Use : DSP ColTitle
Set as : $$LocaleString:"Quantity"
Style : Small Bold
Invisible : NOT ##DSPShowOpening OR NOT $$IsCurrentVarSPOrderCombo
SubTitle : No
Width: @@DSPWithAltQtyWidth + @@DSPWithQtyWidth + @@DSPWithRateWidth + @@DSPWithAmtWidth
SpaceLeft: 0
SpaceRight: 0
Cells: @@OpCellTotalVal
Border:Thin Right
 
[Field:SpectraQ PR]
Use : DSP ColTitle
Set as : $$LocaleString:"Quantity"
Style : Small Bold
Invisible : NOT ##DSPShowOpening OR NOT $$IsCurrentVarSPOrderCombo
SubTitle : No
Width: @@DSPWithAltQtyWidth + @@DSPWithQtyWidth + @@DSPWithRateWidth + @@DSPWithAmtWidth
SpaceLeft: 0
SpaceRight: 0
Cells: @@OpCellTotalVal
 
;;-------------------------------------------------------------The above part for Column heading
 
[#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 StockinD]
 
Use : DSP QtyTemplate
Set as : if ($IsOpLine) then 0 else $StkOpBalance ;;Stock in through Stock journal
 
 
[Field:Spectra SRD]
Use : DSP QtyTemplate
Set as : if ($IsOpLine) then 0 else $StkOpBalance;;------Stock in through Sales Return
 
[Field:SpectraQ StockoutD]
Use : DSP QtyTemplate
Set as : if ($IsOpLine) then 0 else $StkOpBalance;;-----Stock out through Stock Journal
 
[Field:SpectraQ PRD]
Use : DSP QtyTemplate
Set as :if ($IsOpLine) then 0 else $StkOpBalance ;;--------Stock Out Through Purchase return
 
 
 
;;-------------------------The Above part for Qty Details....................
 
 
How to Pull the value from The above field
If anybody have Idea Please Share This.
 
Please Go to the Report & Press F12 and Configure as
Set Opening Quantity Yes.
Set Inwards is to be yes
Set outwards is to be yes
Set Closing Is to be yes
Only Quantity Field.

Please.

 

Good Report!

 

that is the report which everyone needs..... sales and purchase return separately shown

 

how can we get print

 

great

 

not work why ?

 

TDL is loaded successfully but not display any option to open Godown summary report.
Please sir Tell me
this report in which path open...........???

 

is

 

can we filter stock journal by godown, and print inventory particulars such as godown, stock journal no, item, qty, rate, value

 

how i can display stock summary without stock journal
i want to remove stock journal in inward and outward and profit
sir i want inward and outward without stock journal
pls help me this is big problem to me

 

[#Menu:GateWay of Tally]
Add:Key Item:Spectra Reportisplay:Spectra Report
Chang Risplay to Display

 

i have not any option show to godown summary. please reply how show report.

 

above code how to field tally pls teach me or give hines....
i have tally developer9-and how to insert code and run