I am not getting the amount i have defined in Price list in Price column. please check my code.. [#Menu: Gateway Of Tally] Add : Item : After : ~Balance Sheet : STOCK REPORT: Menu : STOCKREPORTMenu [Menu: STOCKREPORTMenu] Add : Item : STOCK REPORT : Display : RDDSTOCKREPORT [Report: RDDSTOCKREPORT] Use : DSP Template Form : RDDSTOCKREPORT [Form: RDDSTOCKREPORT] Use : DSP Template Part : RDD STOCK REPORT Title, RDD STOCK REPORT Width : 100% Screen [Part : RDD STOCK REPORT Title] Line : RDD STOCK REPORT Title [Line : RDD STOCK REPORT Title] Use : RDD STOCK REPORT Local : Field : SD Sr No : Set as : "SNo" Local : Field : SD Item Name : Set as : "Item Name" Local : Field : SD COST : Set as : "COST" Local : Field : SD SALE RATE : Set as : "SALE RATE" Local : Field : SD Price List : Set as : "Price" Local : Field :SD Closing Qty : Set as : "Closing Qty" Local :Field : Default : Style : Small Bold Border : Column Titles [Part : RDD STOCK REPORT] Line : RDD STOCK REPORT Repeat : RDD STOCK REPORT: STOCKITEM Scroll : Vertical Common Border : Yes [Line : RDD STOCK REPORT] Field : SD Sr No, SD Item Name,SD COST,SD SALE RATE,SD Price List,SD Closing Qty [Field : SD Sr No] Use : Short Name Field Set as : $$Line Style : Normal Width : 3 Align : Centre [Field : SD Item Name] Use : Name Field Set as : $NAME Width : 25 Style : Normal Border : Thin Left [FIELD:SD COST] USE: SIMPLE FIELD SET AS: $STANDARDCOST Width : 25 Style : Normal Border : Thin Left [FIELD:SD SALE RATE] USE: SIMPLE FIELD SET AS: $STANDARDPRICE Width : 25 Style : Normal Border : Thin Left [FIELD:SD Price List] Use : SIMPLE FIELD Set As : $$GetPriceFromLevel Width : 25 Style : Normal Border : Thin Left [Field : SD Closing Qty] Use : name field Set as : $ClosingBalance Width : 25 Style : Normal Border : Thin Left [ Collection : RDDSTOCKREPORT] Type : Stockitem
You need to mention the price level Name from which the price should be fetched Try as like this [FIELD:SD Price List] Use : SIMPLE FIELD Set As : $$GetPriceFromLevel:$StockItemName:"A":##SVCurrentDate:$ClosingBalance ;;;; sys funcation to fetch the rate: for the stockitem: Name of price list:applicable date: for the qty
Can it be done like... If I press Alt+F1(Detailed), then Cost column appears?? And Hides when I make it condensed??