Help required in Detailed stock item Report

Discussion in 'Tally & TDL Learning HUB' started by Ch Suresh, May 30, 2022.

    
  1. Ch Suresh

    Ch Suresh Member


    Dear Experts,
    I Created Commission Rates for Stock Items in Stock Item Master as below
    upload_2022-5-30_19-42-11.png
    and its UDF is STDCOMM
    now I would like to generate a detailed stock report including standard commission but std commission value is not getting, Please help me

    upload_2022-5-30_19-45-52.png

    Code is below
     


  2. Ch Suresh

    Ch Suresh Member


    [#Menu:Gateway of Tally]
    Add:Key Item:before:mad:@locQuit:Item List:I:Display:MSPItems

    [Report: MSPItems]
    Use : DSP Template
    Form : MSPItems
    [Form: MSPItems]
    Use : DSP Template
    Part : MSPItemsT, MSPItemsR
    Width : 100% Screen
    Background:white
    Bottom Part : LW Note
    Bottom Toolbar Buttons : BottomToolBarBtn8,BottomToolBarBtn9,BottomToolBarBtn10
    [Part : MSPItemsT]
    Line : MSPItemsT
    [Line : MSPItemsT]
    Use : MSPItemsR
    Local : Field : LWsrn: Set as : "Srn"
    Local : Field : LWItmName: Set as : "Stock Item Name"
    Local : Field : LWItmAlias: Set as : "Alias"
    Local : Field : LWItmGrp: Set as : "Group"
    Local : Field : LWItmUnit: Set as : " Unit"
    Local : Field : LWItmHSN: Set as : "HSN"
    Local : Field : LWItmGSTP: Set as : "GST%"
    Local : Field : LWPrCst: Set as : "STRD.COST"
    Local : Field : LWSlCst: Set as : "SELL RATE"
    Local : Field : STDCOMM: Set as : "STRD.COMM"
    Local : Field : LWMrp: Set as : "MRP"
    Local : Field : LWItmGstOP: Set as : "Opening Qty."
    Local : Field : LWOpValue: Set as : "Opening Value"
    Local : Field : LWClsQty: Set as : "Closing Qty."
    Local : Field : LWClsValue: Set as : "Closing Value"
    Border : Column Titles
    Option : Alter On Enter
    [Part : MSPItemsR]
    Line : MSPItemsR
    Repeat : MSPItemsR: MSPItemsR;STOCKITEM
    Scroll : Vertical
    Float : No
    Common Border : Yes

    [Line : MSPItemsR]
    Field : LWsrn,LWItmName,LWItmAlias,LWItmGrp,LWItmUnit,LWItmHSN,LWItmGSTP,LWPrCst,LWSlCst,LWMrp,STDCOMM,LWItmGstOP,LWOpValue,LWClsQty,LWClsValue

    [Field : LWsrn]
    Use : Short Name Field
    Set as : $$Line
    Style : Normal
    Width : 4
    Align : Centre
    [Field : LWItmName]
    Use : Name Field
    Set as : $NAME
    Width : 40
    Style : Normal Bold
    Border : Thin Left
    Alter:StockItem
    [Field : LWItmAlias]
    Use :Name Field
    Set as : $OnlyAlias
    Style : Normal
    Width : 15
    Align : Centre
    Border : Thin Left
    [FIELD:LWItmGrp]
    USE:Simple Field
    SET AS:$Parent
    Width : 10
    Style : Normal
    Border : Thin Left
    [FIELD:LWItmUnit]
    USE:Simple Field
    SET AS:$BaseUnits
    Width : 8
    Style : Normal
    Border : Thin Left

    [FIELD:LWItmHSN]
    USE:Simple Field
    SET AS:$GSTDetails[Last].HSNCode
    Width : 8
    Style : Normal
    Border : Thin Left
    [FIELD:LWItmGSTP]
    USE:Simple Field
    Set as:$(StockItem, $Name).GstDetails[Last].STATEWISEDETAILS[1].RateDetails[1, @@IsIGST].GSTRate
    Width : 8
    Style : Normal
    Border : Thin Left

    [FIELD:LWPrCst]
    USE: SIMPLE FIELD
    SET AS: $STANDARDCOST
    Width : 12
    Style : Normal
    Border : Thin Left
    [FIELD:LWSlCst]
    USE: SIMPLE FIELD
    SET AS: $STANDARDPRICE
    Width : 12
    Style : Normal
    Border : Thin Left
    [FIELD:LWMrp]
    Use : Name Field
    Set As : $MRPDetails[Last].MRPRateDetails[Last].MRPRate
    Width : 12
    Style : Normal
    Border : Thin Left
    [FIELD:STDComm]
    Use : SIMPLE Field
    Set As : $Stdcomm;:KGNSwIwRptCmsnRatePricexx;:Last:KGNSwIwRptCmsnRateDate
    Width : 12
    Style : Normal
    Border : Thin Left
    [Field : LWItmGstOP]
    Use : Simple Field
    Set as : $OpeningBalance
    Width : 12
    Style : Normal
    Border : Thin Left
    [Field : LWOpValue]
    Use : Simple Field
    Set as : $OpeningValue
    Width : 12
    Style : Normal
    Border : Thin Left
    [Field : LWClsQty]
    Use : Name Field
    Set as : $ClosingBalance
    Width : 12
    Style : Normal
    Border : Thin Left
    [Field : LWClsValue]
    Use : Name Field
    Set as : $ClosingValue
    Width : 12
    Style : Normal
    Border : Thin Left
    [Part : LW Note]
    Line : LW Note

    [Line : LW Note]
    Field : LW Note

    [Field : LW Note]
    Set as : "Ctrl+Enter to Edit Item"
    Color : Red
    Style : Large bold
    Fullwidth : yes
    Align:Center
    Border:Thin box
    [ Collection : MSPItemsR]
    Source Collection : Stockitem
    Type:StockItem
    Compute:StdComm:$KGNKEMStkItmCmsnRate
    Fetch:*
     


  3. Mahesh Sethi

    Mahesh Sethi Member



    Add This ....
    In Item Master add new field

    [System : UDF]

    Stdcomm : Amount : 18018
     


  4. Ch Suresh

    Ch Suresh Member


    Already field is there in Item Master and UDF is also Amount
    but not getting value
     


  5. Ch Suresh

    Ch Suresh Member


    I got the solution sir, Thankyou

     


Share This Page