closing stock button

Discussion in 'Tally Developer' started by shreyas, Feb 5, 2022.

    
  1. shreyas

    shreyas New Member


    i have written code to find closing stock from any screen. But i am facing some issue. if item code is changed by using back space closing stock qty does not changed. also not able to see the description. Please help

    ;;---------------stock item button -------------
    [#Menu:Default]
    ToolBar Button:StockCheck
    [#Form:Default]
    ToolBar Button:StockCheck
    ;Add: Toolbar Buttons: before : HelpButton : StockCheck
    [Button:StockCheck]
    Title:"Item Stock"
    Key:alt+I
    Width : 5% Screen ;6.5% Screen
    Height : 80% Screen
    Background : "White, ReportTitle Color"
    Key Color : "Black, Cyan Blue"
    Color : "Black, Nero Shadow"
    ;Action:Display Collection:Monthly Stock Item
    Action:Alter:SSDStock
    [Report:SSDStock]
    Form:SSDStock
    Title: "Item Stock Balance"
    [Form:SSDstock]
    No Confirm: yes
    Part:SSDStock
    Option:Normal size form
    [Part:SSDStock]
    Line:SSDStock,SSDStockDesc
    [Line:SSDStock]
    Field:Short Prompt,SSDStockselect,Short Name field
    Local:Field:Short Prompt:Set as:"Item Code"
    Local:Field:Short Name field:Set as:$closingbalance:StockItem:#SSDStockselect
    [Line:SSDStockDesc]
    Field:Name field
    Local:Field:Name field:Set as:STKI Desc:StockItem:#SSDStockselect
    [Field:SSDStockselect]
    Use: Short Name field
    Table:Stockitem
    Show Table:Always



    ;;----------collection to show cl stock and open order qty ----------------

    [Collection: SSDStockItem]

    Type:Stock Item
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    $Description:StockItem:#SSDStockselect

    Also fetch the description in your collection
     


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    USE ----- Set always: yes in your qty field, so it will refresh on every changes.
     


  4. shreyas

    shreyas New Member


    Thanks sir.

    Still there is one help needed. When i enter item first time it shows closing stock and description correctly. but if i change the item using back space and enter another code still the closing qty and description is shown of first item . it does not get refresh.
    Can you please help with code
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    I have given the solution above....follow the same.
     


  6. sivam

    sivam Active Member


    Use $$Table:<Main Field>:<Collection Object>
     


  7. Mohan.S

    Mohan.S Member


    I need Closing stock available godown
     


  8. Mohan.S

    Mohan.S Member



Share This Page