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 New 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 New 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 New Member


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


  5. Ch Suresh

    Ch Suresh New Member


    I got the solution sir, Thankyou

     


Share This Page