Show Mrp in Stock Summary Report

Discussion in 'Requests' started by JAYRAM96A, Mar 18, 2019.

    
  1. JAYRAM96A

    JAYRAM96A Member


    Dear Sir
    Please Help to Create Code
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Try to make some efforts in making a code.............

    you will learn better once you start making...........we will help if you are stuck.
     


  3. JAYRAM96A

    JAYRAM96A Member


    [#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 PACKING : Set as : "PACKING"
    Local : Field : SD COST : Set as : "COST"
    Local : Field : SD SALE RATE : Set as : "SALE RATE"
    Local : Field : SD MRP : Set as : "MRP"
    Local : Field :SD Closing Qty : Set as : "Closing Qty"
    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 PACKING,SD COST,SD SALE RATE,SD MRP,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 PACKING]
    USE:name FIELD
    SET AS:$BASICUSERDESCRIPTION
    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 MRP]
    USE: SIMPLE FIELD
    SET AS: $MRP RATE
    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
     


  4. JAYRAM96A

    JAYRAM96A Member


    DEAR SIR
    PLEASE CHECK ABOVE CODE AND SUGGEST HOW TO COMPLETE .
    ERROR 1. NOT SHOWING MRP FIELD
    2. NOT SHOWING PACKING FIELD (DESCRIPTION)
    3. HOW TO CHECK CATEGORIES WISE
     


  5. JAYRAM96A

    JAYRAM96A Member


    [#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 PACKING : Set as : "PACKING"
    Local : Field : SD COST : Set as : "COST"
    Local : Field : SD SALE RATE : Set as : "SALE RATE"
    Local : Field : SD MRP : Set as : "MRP"
    Local : Field :SD Closing Qty : Set as : "Closing Qty"
    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 PACKING,SD COST,SD SALE RATE,SD MRP,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 PACKING]
    USE:name FIELD
    SET AS:$DESCRIPTION
    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 MRP]
    USE: SIMPLE FIELD
    SET AS: $MRP RATE
    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
     


  6. JAYRAM96A

    JAYRAM96A Member


    DEAR SIR
    PLEASE CHECK ABOVE CODE AND SUGGEST HOW TO COMPLETE .
    ERROR 1. NOT SHOWING MRP FIELD
    2. HOW TO CHECK CATEGORIES WISE
     


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    [FIELD:SD MRP]
    Use : Name Field
    Set As : $MRPDetails[Last].MRPRateDetails[Last].MRPRate
    Width : 25
    Style : Normal
    Border : Thin Left
     


  8. ONKAR

    ONKAR Active Member


    Dear Sir I have little Changes According To mine , SEE THIS IMAGE I HAVE ADDED BARCODE NUMBER

    STOCK REPORT.JPG
     


Share This Page