Price list rate column in stock report

Discussion in 'Tally.ERP 9' started by Hasan@123, Apr 28, 2020.

    
  1. Hasan@123

    Hasan@123 Member


    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
     

    Attached Files:

    Last edited: Apr 28, 2020


  2. Damodaran

    Damodaran New Member


    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
     
    Hasan@123 likes this.


  3. Hasan@123

    Hasan@123 Member


    Thanks a lot.. i want to add a button here to hide cost column. How can it be done?
     


  4. Damodaran

    Damodaran New Member


    invisible the filed using variable
     


  5. Hasan@123

    Hasan@123 Member


    Can it be done like... If I press Alt+F1(Detailed), then Cost column appears?? And Hides when I make it condensed??
     


  6. Damodaran

    Damodaran New Member


    Yes, the same way you can control through a button
     


  7. Hasan@123

    Hasan@123 Member


    Can you show me by modifying my code?
     


Share This Page